SQL Rockstar
I was scanning blogs the other day, and noticed Tom LaRock's new image on Twitter. He's SQLRockstar after a little...
2009-05-29
2,007 reads
Changing Server Default Collation
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...
2009-05-29
1,617 reads
The Conference ROI
I saw recently that Brent Ozar wrote a blog about justifying the cost of attending the 2009 PASS Summit. I...
2009-05-29
3,373 reads
Book Review: Real Leaders Don't Do Powerpoint
I bought Real Leaders Don't Do Powerpoint by Christoper Witt ($15 at Amazon) on a trip, Powerpoint catching my eye...
2009-05-28
1,746 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,185 reads
Why I Say Something about Running as Administrator
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start...
2009-05-28
2,168 reads
Good Article on Data Warehousing Best Practices in SQL Server 2008
If you are involved data warehousing, or even if you are just a beginner, you may want to check out...
2009-05-28
1,508 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,950 reads
I Can Run Hyper-V!
I noted recently that I purchased a new desktop with the intention of moving to Windows 2008 and Hyper-V. That...
2009-05-28
1,646 reads
Minimalist Design - Part 3
One of the labs I frequently do with students is to design a database for a training business, something which...
2009-05-27
1,453 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries