SQL SERVER 2012 - How to get a value from previous result row effectively

Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...

10 signs you're not talking to a developer

Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same...

SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...

Order of a Result Set in SQL

I have seen people build procedures that rely on a result set being returned in a certain order.  This is...

Windows Azure Service Dashboard – Checkout the health of Azure Services

Windows Azure Service Dashboard is an excellent way to know the health/availability of your Windows Azure Services.

You might always want...

Reblog: September 6 to September 12

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with a crazy schedule and we now have a SQL...

Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with...

Are Foreign Keys Better Than Indexes?

When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...

Q&A From “5 Ways to Improve Performance through Indexing”

A few weeks back spoke at a Pragmatic WorksTraining on the T’s on indexing that was titled 5 Ways to Improve Performance through...