SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.

Day 6 of The OLAP Sprint

by Simon-E-Doubt

SQLServerCentral.com

OLAP

Day 6 brings security enhancements.

Failure Lessons

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones would like to see more disclosure about what works and doesn't work when deploying new systems and software.

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

by Jeff Moden

SQLServerCentral.com

T-SQL

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

FileStream and FileTable in SQL Server 2012

by Additional Articles

Database Journal

FILESTREAM

SQL Server 2012 enhanced the SQL Server 2008 FileStream data type by introducing FileTable, which lets an application integrate its storage and data management components to allow non-transactional access, and provide integrated SQL Server services. Arshad Ali explains how.

Day 5 of The OLAP Sprint

by Simon-E-Doubt

SQLServerCentral.com

OLAP

Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.

Stairway to SQL Dialects Level 2: Postgres

by Joe Celko

SQLServerCentral.com

Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.

The Future of DBAs

by Steve Jones

SQLServerCentral.com

Editorial

What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

While working with the Results to Text option in SSMS, you may come across a situation where the output from dynamically generated data is truncated. In this article I will guide you on how to fix this issue and print all the text for the Results to Text option.

Day 4 of The OLAP Sprint

by Simon-E-Doubt

SQLServerCentral.com

OLAP

Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

Day 6 of The OLAP Sprint

Failure Lessons

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

FileStream and FileTable in SQL Server 2012

Day 5 of The OLAP Sprint

Stairway to SQL Dialects Level 2: Postgres

The Future of DBAs

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

Day 4 of The OLAP Sprint

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

A Spread of Vacation

How AgentDBA Identifies Backup Failures

Forums

Have you done a Mid year check in?

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

Independence Day 2026

Question of the Day

Independence Day 2026