Who is your Fail-Safe Agent??
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
407 reads
Daily Coping 25 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-25
20 reads
Azure SQL Database – Read Only Endpoints
One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP...
2020-08-25
150 reads
New Pluralsight Course – Kubernetes Package Administration with Helm
My first course Kubernetes Package Administration with Helm has been published on Pluralsight and is now available! Check out the course overview here This course is aimed at anyone...
2020-08-25
60 reads
Recursively Querying Row Groups
Watch this week's video on YouTube
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to...
2020-08-25
26 reads
Recursively Querying Row Groups
Watch this week's video on YouTube
Recursively Querying Related Rows
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you...
2020-08-25
32 reads
Recursively Querying Row Groups
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
599 reads
Don’t Forget Unique with FILESTREAM–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing FILSTREAM with SQL Clone the other...
2020-08-24
19 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! ...
2020-08-24
14 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
14 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