Unused Heaps? - Quick Tips: Day 10

Don't forget! This coming Monday is the last Monday to win a free month of Pluralsight! All it takes is...

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar series this year.  Over the next 12 days, I...

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar...

Christmas Day Winner and RDC Clients: Day 13

Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free...

Powershell in a Month – Day 6 The Pipeline

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...

Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it contains...

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....

Active Directory and SQL Server Questions Answered

I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can...

Holiday Greetings!!!

HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1

Originally posted on SQL DBA learning curve:
Hey ALL, if you are looking forward to set-up a test server for playing...