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

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

Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.  Read more...

This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.  Read more...

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...

I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...  Read more...