Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
(2017-2022)
Browsing Posts in SQL
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month.
You can now run SQL Server on Linux. With it being easy to install / update, and running exactly the same as in Windows, it is my choice for presentations.
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!). Today is even the National Corn on the Cob day. But perhaps the most important day in that, being that today is the 2nd Tuesday in […]
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes. SpeedPASS History According to the SQLSaturday FAQ, the SpeedPASS is your admission ticket to a SQL Saturday event. It contains a name badge, admission ticket, lunch […]
Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.
SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
In this T-SQL Tuesday post, I answer Andy Leonards question of “Why do you do what you do”? It comes down to I automate what I can so that I can be lazy.
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
