Powershell Backups and Post Frequency Change

It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these...

Review of Change to PASS Bylaws

As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly...

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...