Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,614 reads
Blog Posts
A Swing and a Miss by PASS
On Saturday my son had his second baseball game. When it was his turn to hit I reminded him to...
2010-03-08
573 reads
It’s Like the MVP Summit
I missed the 2010 MVP Summit, which is disappointing. There were a lot of SQL 11 talks and I was...
2010-03-08
422 reads
MacGyver?
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...
2010-03-08
683 reads
Notes from SQLSaturday #33
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
303 reads
OPASS March Meeting with David Pless
March 9 6-8:30pm
This month's meeting sponsored by
Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=QFG3GW&role=attend
Speaker: David Pless
David has been a Senior Premier Field Engineer with...
2010-03-08
1,389 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
625 reads
SQL Server Locking & Block Scripts
A couple of weeks ago, I gave a presentation to the PASS DBA Virtual Chapter on SQL Server Locking & Blocking...
2010-03-08
551 reads
T-SQL Tuesday #004 Hosted by Mike Walsh
I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need...
2010-03-08
557 reads
Alpha Split in SSIS, Redux
So I’ve discovered another benefit of being a technical blogger. Not only do you get some kudos when you write...
2010-03-07
889 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