Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-23
1,951 reads
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-02-23
3,095 reads
You Can’t Disable the CLR in SQL Server – MCM Prep
At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even...
2011-02-23
934 reads
Who’s My Agent?
Alright, I’m not famous, even though I share the name of a famous Jazz pianist. So, obviously I am NOT...
2011-02-23
713 reads
FileSystemHelper Update and Release
About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As...
2011-02-23
488 reads
New SQL Server 2005 Cumulative Updates
Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14,...
2011-02-23
583 reads
PASS Election Review Committee: NomCom Process
Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like...
2011-02-23
604 reads
SQLskills Immersion Event on Internals and Performance – Day 2
Overview
Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again,...
2011-02-23
709 reads
PowerShell Script for Paul’s Survey: how is your tempdb configured?
Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a...
2011-02-23
747 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
4 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers