SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

Click to viewBacking up your data on a regular basis is important, and turning a spare computer into a backup server is often the best way to make sure it gets done. But most methods require either a ...

Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 seconds each time, but it is long enough that ...

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape even ...

While the cloud continues to grow in popularity for many, if not most, enterprise applications, IT departments remain reluctant to trust public clouds, including the Google Cloud Platform, for ...