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,949 reads
Blog Posts
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
486 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,093 reads
How Can I Help You Go To SQLRally?
I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...
2011-02-23
405 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
580 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
602 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
746 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
708 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
704 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
933 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers