Run DBCC CHECKDB regularly to ensure database integrity. Set up a swift alert using SQL Server Agent to notify you of potential SQL database corruption before it's too late to rectify.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database.

Joey on SQL Server Top Tips To Make SQL Server Run Faster on Azure VMs Storage and performance can be quite different in the cloud.

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

Limitations aside, this tool provided with SQL Server is an excellent starting point for anyone wanting to get up and running quickly with data profiling.

Microsoft’s announcement that it was bringing its flagship SQL Server database software to Linux came as a major surprise when the company first announced this in March. Until now, the preview ...

Joey on SQL Server Top Tips To Make SQL Server Run Faster on Azure VMs Storage and performance can be quite different in the cloud.