Pratical Use of a SQL Server Database Snapshot

I was doing a database code deployment the other night and the first step in the release plan was “Take...

Predicate Order is Critical

I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...

Session Event Metadata

There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...

Deployed Session Settings

Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow...

PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)

The last week of October, we’ll be at the PASS Summit in Seattle, WA.  As some of you already know – and as I...

SQL Server – Various methods to generate unique number sequence

Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...

Table partitioning

What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's...