SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,205 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,718 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,119 reads
SQL Server Trivia
Think you know SQL Server past and present? Here are the next-to-impossible questions I asked at the SQLSaturday #51 Stump...
2010-08-23
678 reads
N Things Worth Knowing About SELECT
SELECT is this kind of Swiss Army Knife
SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the...
2010-08-23
1,231 reads
Fall Speaking Schedule
I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write...
2010-08-23
811 reads
Looking at the Numbers
Andy Leonard has done an awesome job collecting information and putting the numbers together for the recent candidate decision for...
2010-08-23
1,889 reads
PASS Elections
There are a lot of things I’d like to say about the PASS elections. I was on vacation last week...
2010-08-23
687 reads
Last Place? Doesn’t Matter.
As the debate rages on about the PASS election I want to share my thoughts about being a candidate that...
2010-08-23
445 reads
Incremental Load - TSQL
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,041 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers