A Microsoft SQL Server community of 1,705,730 DBAs, developers and SQL Server users

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...

We have a SQL Failover Cluster Instance in our primary data center, and want to implement a second two node Failover Cluster Instance in our secondary data center. A new two node cluster located in our secondary data center was setup, but I could not create a new High Availability Group between the two failover cluster instances. What went wrong?  Read more...

SQL Saturday is coming to Denmark on March 29, 2014. This a free event of SQL Server training and networking. The full schedule is up (and it's full of great speakers) on the SQL Saturday site and make sure to say hello at the Red Gate booth while you're there.  Read more...

This is Part 2 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...

If we want to incorporate big data into our enterprise, it's crucial to know how to integrate it with our existing data.  Read more...

Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in...  Read more...

If you work in IT, the office becomes your second home.  It’s where we make a living, and most of...  Read more...