Varying Results with Subquery, ORDER BY, MAXDOP

In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking...

A SQL Server Hardware Nugget A Day – Day 3

Lest anyone accuse me of ignoring AMD in this series, I will talk about the AMD Opteron 6100 series processors...

Powershell Day 3

Day 3 Programming in Powershell Part 1 Now you got some good basic information about Powershell, and some basic commands...

SQL Saturday #63 PPT

The PowerPoint deck from my presentation is here if you want it
http://www.sqlservercentral.com/articles/Presentations/70959/
- Posted using BlogPress from my iPhone

Filed under: Blog...

Tampa IT Camp 2011 Lessons Learned Part 2

In part 1 I provide an overview of concept of IT Camp, how the plan was developed by borrowing ideas...

View system object definitions

G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...

A SQL Server Hardware Nugget A Day – Day 1

Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV...

A SQL Server Hardware Nugget A Day – Day 2

For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...

If you fire that trigger, make sure you have the correct ID

G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...

Powershell day 2

Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...