DBA Tracy Hamlin Wins the 2010 Exceptional DBA of the Year Award
Tracy Hamlin (Twitter) has been voted as the 2010 Exceptional DBA of the Year by the SQL Server community. The...
2010-08-20
1,053 reads
PASS Update #41 (Elections)
In 2009 we had a contentious election cycle at PASS, and I won’t go through the details again, but because...
2010-08-20
654 reads
I’m Attending SQLSaturday #51 in Nashville
I’ll actually be going up a couple days early for a PASS Board meeting, then shifting to speaker/attendee mode Friday...
2010-08-20
503 reads
How Many Columns In Table and Which Have Identity Columns
I recently had to find a way to look up how many columns were in a table and which of...
2010-08-20
435 reads
Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.Continue reading ?
The post Great News! SSMS Tools Pack 1.9 is...
2010-08-20
8 reads
Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Continue reading ?
2010-08-20
14 reads
Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic (Blog|Twitter) recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Why...
2010-08-20
539 reads
A Lesson from My Air Force Days
Yup, you guessed it, another post about the nominations for the PASS Board of Directors. If you're tired of reading...
2010-08-19
1,006 reads
Hunting down those expensive SPs
A query to find out which Stored Procedures are taking the longest to run ( in this example – the Top 10).
I’m sure there are...
2010-08-19
695 reads
Undocumented Stored Procedures
Just a quick list of undocumented SPs, many of which are deprecated.
Note, use caution using some of these ! But others...
2010-08-19
2,155 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