SQL Server 2012

External Article

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

External Article

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

SQLServerCentral Article

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,523 reads

Blogs

Daily Coping 6 Feb 2023

By

Today’s coping tip is to get back in contact with an old friend. This...

Rotating a Certificate Used by TDE

By

In terms of encryption, Key Rotation is the process of replacing your encryption keys...

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Read the latest Blogs

Forums

Group by issue

By pedroccamara

Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...

Ownership chaining

By Duncan Lawrence

Hi, I have four views on one database to which one sql authenticated user...

Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers