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

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