On vs. Where

Does it matter if you put your criteria in the ON clause or the WHERE clause?  Well, as with most...

Pre-Compiled Stored Procedures: Fact or Myth

There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...

Referral Contest for PASS Summit

Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...

SQLSaturday #21 Update

We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...

TechEd Online Interview

Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for...

The old INNER JOIN syntax vs. the new INNER JOIN syntax

I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...

Winding Down

I'm trying to finish up the last few things here at work before taking the weekend off. I scheduled off...

Impact of uninstall instance on replication.

Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...

Jack Corbett Now Co-President of oPASS

I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...

Midlands PASS Chapter October Meeting

Next Meeting - October 6, 2009

 Speaker - SQL Server MVP Brian Kelley

Trigger Happy Database Security
In this presentation we'll look at the use...