10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-06
717 reads
Service Broker Basics
I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not...
2010-01-06
536 reads
PASS Summit Evaluations
The big day has arrived and all the speakers are poring over their PASS Summit 2009 evaluations, me included. These...
2010-01-06
699 reads
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
2010-01-06
1,182 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
3,520 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-06
2,202 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
532 reads
Picking a Blog Platform
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,152 reads
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me...
2010-01-05
720 reads
How to obtain RecordCount (or Number of cases) from a DMX query
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
2010-01-05
2,635 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