SQL Server 2012

SQL Server 2012 Window Function Basics

  • Article

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.

2013-04-04

5,033 reads

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

  • Article

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

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery

  • Article

The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.

4.46 (13)

2012-07-13

2,415 reads

Blogs

Daily Coping 14 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Daily Coping 13 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

PIVOT table with more than one aggregate and for only weeks with data.

By kat35601

I need help to pivot my sql output for Class with aggregates of QTY...

SSIS - How to convert DateTime from ISO format

By sabarishbabu

Hello, In my source file having DateCreated column as ISO format string like '2020-08-05T05:50:49.844Z'....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers