A Microsoft SQL Server community of 1,875,811 DBAs, developers and SQL Server users

A short story on using the mod function to a shifting query.  Read more...

Erin Stellato discusses the types of performance data needed to help with capacity planning.  Read more...

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.  Read more...

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.  Read more...

One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.  Read more...

This article shows how to reduce the periodic spikes in the CPU that are caused by the periodic-executing jobs. There is a good reason to make some changes for dismissing them.  Read more...

Even a database development framework like Sql Server Data Tools (SSDT) doesn't get it right all the time, and there are ten deployment 'gotchas' in particular that can cause some head-scratching amongst developers to get right. From his unique perspective of creating a tool to make such deployments in SSDT less stressful, Dan Nolan discusses each pitfall and how to avoid it, whether you have ReadyRoll or not.  Read more...

This article shows a few techniques that help in capturing deleted records.  Read more...

Sometimes, it's necessary to have different versions of a database running in production. But how do you establish a single source of truth in source control? Alex Yates from DLM Consultants shows how to use object filters in SQL Compare to build multiple database versions from the same source.   Read more...

Colleague: I think I just encountered my first Right join *shocked* Me: huh. weird. a rare Right Join has appeared!Colleague: catch it!Me: You use ON. It's...  Read more...