SQLSaturday #40 Announced
SQLSaturday #40 will be held July 31st, 2010 in Miramar, FL. This is the second annual SQLSaturday organized by Scott...
2010-01-28
607 reads
Blog Posts
The Black Art of PowerShell V2 Version Numbers
Last week while helping someone in the SQLPSX forums having an issue importing modules I suspected they had a CTP...
2010-01-28
827 reads
The Little Stick
In the end, that was what made the difference. I was typing along one night on my spare Acer and...
2010-01-28
869 reads
The Predictioneer
I’m not sure how this book got on my radar, but it turned out to be fairly interesting. It’s written...
2010-01-28
812 reads
What the Exec?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-01-28
677 reads
Cleaning up sys.dm_exec_cached_plans
Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...
2010-01-27
1,135 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,467 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
994 reads
Identity Values – Dropouts and Spaces
Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...
2010-01-27
998 reads
Lenovo W510
I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510,...
2010-01-27
938 reads
Blogs
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...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
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
The Service Name
Comments posted to this topic are about the item The Service Name