At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...

If you've worked in any data-centric role, you've probably experienced the effects of the proverbial "mandate from on high." Someone in the C-suite decides it's time to hop on the latest shift in the ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, ...

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

Do you need to find out where the location of your SQL Server's database is? Use this quick tip from Arthur Fuller to show you how. Sometimes your application needs to know the specific directory ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

One of the most fundamental aspects of computing infrastructure will play a key role in Microsoft’s Ignite 2018 pitch to developers and customers, with several new database features competing for ...