Reminder: Midlands PASS Chapter Meeting Tomorrow Night

What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM

Speaker: SQL Server MVP...

Upgrade or Wait

Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...

SQL Server 2008

Just when I was about to start a pool for the release date, Microsoft announced today it will release on...

The Business of Publishing

Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...

CTEs and where have I been?

I haven't posted much lately, but it has been a busy few months with many family activities.  At work, I...

DDL Triggers and CREATE_LOGIN/ALTER_LOGIN

I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...

The Perils of NewID for Randomizing Results

NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...

Wiki For Books Online

Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...

Service Packs and Support

More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...

Cursors to Increase Performance?

I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...