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