A DMV a Day – Day 2
The DMV for Day 2 is sys.dm_exec_sessions, which is described by BOL as:
Returns one row per authenticated session on SQL...
2010-04-02
415 reads
Blog Posts
Book Review: Where Have All The Leaders Gone
It had been a long while since I listened to an audio book, found it while browsing at the library....
2010-04-02
379 reads
Goals for 2010 – Q1 Review
Here were the goals I posted for 2010 on the last day of December:
Continue managing the forums, but at a...
2010-04-02
498 reads
Speaking Seven Times in April
April will be a busy month for me as I will be speaking seven different times, on seven different topics,...
2010-04-02
446 reads
The Best vs. The Good Enough
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
448 reads
The Way - The Reason
This is one thing outside the SQL World, but it has very strong place in every aspects, it is one...
2010-04-02
615 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...
2010-04-02
18 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...
2010-04-02
19 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,464 reads
Winner of the March SQL Aloha Contest
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
422 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
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...
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