How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,148 reads
TechFuse 2011 – This Month
If you’re looking for a day of training in the Twin Cities, then check out Benchmark Learning’s2011 TechFuse event. The...
2011-03-02
617 reads
Make a Goal! Map it Out! And Go For It!
I can’t tell you that all of your dreams will come true. I won’t tell you that you will make...
2011-03-02
534 reads
SSRS – Creating and Using Shared Schedules – Part 2
In my previous post, I discussed what shared schedules were and how you could use them. With that knowledge under...
2011-03-02
1,927 reads
SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,076 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
8 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that...
2011-03-01
612 reads
Attending 2011 MVP Summit in Bellevue/Redmond, WA – Great Face-time with Fellow Speakers/Writers/Bloggers
The raincoast weather could be a little better, but so far, I am very happy with the brain-filling load of...
2011-03-01
916 reads
Rocky Mountain Tech Trifecta on March 5
I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This...
2011-03-01
500 reads
SQLDIY: Alert On Blocking Chains
Continuing the SQLDIY monitoring project we will take a look at tracking blocking events. I actually received a request to...
2011-03-01
2,866 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