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

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

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

SQLSaturday #40 is Almost Here – July 31, 2010

I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...

SQL Saturday Advice - Communicate Often

It seems that Thursdays are becoming SQL Saturday day here at my blog. I wrote a few posts about SQL...

Commenting TSQL Scripts

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

What Indexes are on My Table!

In this quick blog, I want to show you one way of how to find out what indexes you have on a table...

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

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

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