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 were drafted before Sony invented the Walkman, he espouses misconceptions about actual vendor implementations in very […]

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 have a few issues that I want to point out: ==================== More disclosure in sys.dm_exec_requests Erland […]

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 pages in memory' privilege for all the lowly peons running Standard Edition.  Currently this has only […]

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 like I am choosing between mom and dad or between Kirby and Quigley.  The reality is […]

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 ignored.  Saturday is probably my best opportunity to do this, especially ones like today where the […]

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 which is slightly more informative than the release notes). Microsoft today released a post-SP1 cumulative update […]

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, the rest of you will get a good preview of these features that will show up […]

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. On smaller databases it ran quite quickly and with the correct and desired effects.  On larger […]

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 technology to an audience (because friends and co-workers don't count), there seemed to be much more […]

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: http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 Cumulative Updates 1, 2 and 3 are included in this service pack, as well as […]