I did not need actual data; an empty copy of the latest database would suffice. I could easily add a few test records for the demonstration after installing the database on my laptop. I created a copy ...

One-Stop Shop for SQL Server Scripts. Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in ...

If you’ve the database backup available and know the time of data deletion, you can use the transaction log with Log Sequence Number (LSN) to recover the deleted data from SQL Server. However if you ...

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

Ignite 2019: Microsoft's flagship OLTP database releases in new version that aims to bring databases, data lakes and remote data sources together as one. SQL Server 2019 reaches general ...