A DMV a Day – Day 16
We have two DMVs for Day 16. The first one is sys.dm_exec_cached_plans, which is described by BOL as:
Returns a row...
2010-04-16
668 reads
Blog Posts
Book Review – SQL Server Integration Services: Problem – Design – Solution
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I...
2010-04-16
2,161 reads
Confio Ignite: Part II
I’m continuing to evaluate Confio’s Ignite database monitoring tool. I’ve had it collecting data on a couple of production servers...
2010-04-16
1,816 reads
My Idea for the PASS Summit 2010 Opening Night Reception
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,119 reads
Powershell SMO Problem
We’ve been running the Enterprise Policy Management tools available from Codeplex for a few months now (Thanks to Buck Woody’s...
2010-04-16
719 reads
SQL Server 2008 R2
The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May...
2010-04-16
624 reads
SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
On Aprill 2010 is available the SQL Server 2008 R2 Update for Developers Training Kit. This training kit inlcudes:
Presentations (22)Demos...
2010-04-16
720 reads
Visiting Chicago
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
954 reads
A DMV a Day – Day 15
The DMV for Day 15 is sys.dm_os_performance_counters, which is described by BOL as:
Returns a row per performance counter maintained by...
2010-04-15
1,481 reads
Checklist for having a Remote Presenter at your User Group
After having a bit of a tough time in the April OPASS meeting (read about it here), due to not...
2010-04-15
301 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
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
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...