Additional Articles

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

by Additional Articles

Microsoft MSDN

SQL Server 2012

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.

2012-11-16

2,732 reads

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.

2012-11-15

3,038 reads

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.

2012-11-14

2,887 reads

Designing Databases for Rapid Resilience

by Additional Articles

SimpleTalk

Uncategorized

As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?

2012-11-13

2,996 reads

Viewing VMware Counters in PerfMon for SQL Server

by Additional Articles

MSSQLTips.com

Performance Tuning

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.

2012-11-12

3,272 reads

Script to create dynamic PIVOT queries in SQL Server

by Additional Articles

MSSQLTips.com

pivot

Pivoting is a common reporting requirement - data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don't always know all of the values you need to pivot on. This tip looks at how you can dynamically create the pivot command to handle these unknown values.

2012-11-09

5,308 reads

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

by Additional Articles

SimpleTalk

partition table

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.

2012-11-08

4,482 reads

SQL Server 2012: Installing Data Quality Services

by Additional Articles

Database Journal

Data Quality Services (DQS)

Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.

2012-11-07

2,181 reads

Using SQL Server Concatenation Efficiently

by Additional Articles

MSSQLTips.com

CONCAT()

This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.

2012-11-06

3,661 reads

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

by Additional Articles

SimpleTalk

Integration Services (SSIS)

The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.

2012-11-05

2,246 reads

All authors

Additional Articles

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

FileStream and FileTable in SQL Server 2012

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

Designing Databases for Rapid Resilience

Viewing VMware Counters in PerfMon for SQL Server

Script to create dynamic PIVOT queries in SQL Server

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

SQL Server 2012: Installing Data Quality Services

Using SQL Server Concatenation Efficiently

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

Stop Being Surprised by Your Azure Bill: Use Budgets

Resetting on the AI hype train

Forums

The Max PK Length

My experience using the GitHub Copilot in SSMS 22

The Microsoft SQL Year in Review

Question of the Day

The Max PK Length