Monthly Archive: April 2009

To err is Celko, but vendor implementations may vary

To err is Celko, but vendor implementations may vary

While nobody can question that Joe Celko's online attitude borders on the criminal can be quite abrasive, his answers are often correct.  The problem is, while he might be well-versed in ANSI standards that...

It's Saturday, are you ready to vote?

It's Saturday, are you ready to vote?

I'm going to try to do this weekly; bring attention to some Connect items that I or colleagues nearby think are important but could use a nudge toward greater visibility.  This week I only...

Big News : Lock Pages in Memory for Standard Edition

Big News : Lock Pages in Memory for Standard Edition

After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki), Microsoft's Bob Ward just announced at the European PASS Conference that they are going to allow the 'lock...

Negative sentiment

Negative sentiment

A brief selection of twitter threads expressing negative sentiment over the recent MSDN blog migration, where they left redirects intact for some moved content, but "orphaned" much more – those all return 404, say...

Another index maintenance script update

Another index maintenance script update

As I have blogged about before, I use index maintenance scripts from two very capable contributors: Ola Hallengren and Michelle Ufford (a.k.a. @sqlfool).  Sometimes when I talk about one or the other, I feel...

Come on, it's Saturday, get out and vote!

Come on, it's Saturday, get out and vote!

I was encouraged by some fellow MVPs (well, mostly Alexander Kuznetsov) to periodically post a set of Connect items to encourage voting for items that I found relevant but that are maybe being largely...

SQL Server 2008 SP1 Cumulative Update 1 is available!

SQL Server 2008 SP1 Cumulative Update 1 is available!

If you were among those who installed CU4 for SQL Server 2008, then installed SP1, you may not know that you lost some of the fixes that came with CU4 (see Bob Ward's post...

Two connectivity features you may not have known about

Two connectivity features you may not have known about

I just wanted to relay some information about connectivity options for SQL Server 2008 that may be useful but are not currently documented.  While I know several of my readers already know about these,...

Working with SQLFool's Index Defrag Script

Working with SQLFool's Index Defrag Script

Last week I decided to play with SQLFool's Automated Index Defrag Script and found it very usable and worthwhile.  Terrific work Michelle!  The script rivals Ola Hallengren's broader maintenance scripts that I use often....

Correcting DATETIME values (and Agent!) due to an incorrect system date

Correcting DATETIME values (and Agent!) due to an incorrect system date

So my Saturday was basically ruined by the following: sys admin makes a minor adjustment to the system clock on the data center's domain controller, Friday @ 6 PM. while correcting the time, said...

I talked about Resource Governor (again)

I talked about Resource Governor (again)

Last night I gave my Resource Governor spiel at the New England SQL Server User Group meeting in Waltham, MA.  About 60 people were in attendance.  Unlike the last few times I've presented this...

SQL Server 2008 Service Pack 1 is now available!

SQL Server 2008 Service Pack 1 is now available!

No, this is not a late April Fool's joke; SQL Server 2008 Service Pack 1 is finally gold.  The final release of SP1 is build 10.00.2531.00, and is available from the Microsoft Download Center:...