SQL University – Other Capacity Issues

This is the final lecture this week at SQL University. We are covering the topic of capacity planning this week...

SSC Editorial: Becoming Highly Productive

This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us...

Ambiguities and the wild object.oriented brigades

--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...

Checking Users AD Groups Using Windows CMD

Blog Title: Checking Users AD Groups Using Windows CMD

Depending on your role in the organization, there may be a time...

Commenting TSQL Scripts

If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...

Finding Key Lookups In Cached Execution Plans

Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...

Help Build the SQLRally Speaker/Topic Selection Process – Part 1

Last week we announced PASS SQLRally, the new event that we’ll be holding in May 2011 in Orlando (aka the...

Indexes and their Effect on Query Performance

Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...

Interviewed by Andy Leonard

Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty...

Introduction to Parallel Data Warehousing

What are we talking about?
Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition....