In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...

It’s not April 1. Scott Guthrie, executive vice president of Microsoft’s Cloud and Enterprise Group, announced today that next year Microsoft will be releasing a version of SQL Server that runs on ...

You will fail to connect to your database if the SQL Server service is not running. If you try running the SQL Server service from the Services.msc app, you will ...

Native support for JSON in the upcoming SQL Server 2016 was buried among the many goodies announced earlier this month for the flagship RDBMS, but it's clearly an important feature for data developers ...