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

Limiting Table Access for Reporting Part 1

End users may have a need to do some form of reporting of data from source systems. Opening up the...

Limiting Table Access for Reporting Part 2

Blog Title: Limiting Table Access for Reporting Part 2

In the first blog post of this series, I showed you how...