Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
610 reads
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,344 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
489 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
424 reads
Microsoft Offers New Certification Exam Discount
If you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced...
2010-08-28
1,270 reads
MDX Puzzle #6 - Solution
Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER...
2010-08-27
499 reads
SSC Editorial – What Superhero Would You Be?
This was written for something fun on a Friday, but it’s still interesting for coffee talk anytime – what superhero would...
2010-08-27
617 reads
Furniture Grade PVC – What Will You Make?
Ran across this in my weekly browsing, Formufit sells furniture grade PVC. I think I’m not quite clear on the...
2010-08-27
1,167 reads
Presenting at Jacksonville Code Camp
I’m leaving later today for the not too bad drive to Jacksonville for the sixth annual Code Camp. I’ve got...
2010-08-27
552 reads
Kent SqlServer UserGroup
I am now in the process of arranging the 2nd meeting of the kent sqlserver user group. This will be...
2010-08-27
428 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