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’s Information on Parallel Thread Usage

  • Article

In the SQL Server 2012 execution plan we can see better the true thread reservations for a query and not just information on the maximum degree of parallelism and row distribution across parallel threads; thanks to the new parallel thread usage information.

4.47 (17)

You rated this post out of 5. Change rating

2012-08-09

5,573 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)

You rated this post out of 5. Change rating

2012-07-13

2,581 reads

SQLServerCentral Article

Simplified Restores with SQL Server 2012 Recovery Advisor

  • Article

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.

4.33 (12)

You rated this post out of 5. Change rating

2012-06-27

2,915 reads

Blogs

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

The Importance of Patch Management to Avoid Downtime

By

A recent Microsoft outage caused by a bad patch pushed out to Windows instances...

Friday Flyway Tips–Comparison Defaults

By

One of the little details that I find matter more and more in enterprises...

Read the latest Blogs

Forums

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers