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

Log Shipping By Abi Chapagai (Revised)

Log Shipping  By Abi  Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...

Pesky Protected Mode

How many of you keep falling for this one…You open up Report Manager for a user that you know you...

Poor Little Misunderstood Views

Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...