A Microsoft SQL Server community of 1,706,057 DBAs, developers and SQL Server users

In this next stage of the Stairway to Integration Services, Andy Leonard looks at how you can manage multiple source locations in a flexible way.  Read more...

Survey - The DBA-Team wants to hear about your worst day as a DBA. Did a database restore fail due to corruption? Did you accidentally connect to Prod instead of Dev and truncate a table? Anonymity available. The best story will win a $50 Amazon voucher.   Read more...

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...

The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.  Read more...

If you need to architect a multi-tenant Analysis Services project, what are your options? This piece from Sean Woehrle shows four options and explains why he picked a particular one.  Read more...

This free event is coming to Boston on March 29, 2014. Grant Fritchey and many others will be speaking, so make sure you register soon while spots are available.  Read more...

With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software.   Read more...

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...

This is the story of how a free addin for SSMS, SQL Code Guard, was created and joined the Red Gate SSMS Ecosystem project.  Read more...

A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.  Read more...

I’m a bit late getting this posted, so to the two of you waiting to see it, I apologize. Back...  Read more...

  Recently I was working on a task that needs to handle various datetime calculations, and it is really fun. Usually...  Read more...