Code Camp will be March 28th, 2020 at Seminole State College. The fifteenth consecutive year! They are definitely interested in developer/end user SQL content and would like at least...
2020-01-07
44 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-01-07
9 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-01-07
119 reads
Most recent transaction log backup in always on availability groups
I should mention outright...
2020-01-06
85 reads
I should mention outright that this post applies to SQL Server version 2016 and up.Over the years I have relied on the backup history tables in msdb to check...
2020-01-15 (first published: 2020-01-06)
1,043 reads
A wonderful reader of my blog sent me a note (thanks Jess!) about a single line notation in the latest SQL Server release notes. The notes is as follows....
2020-01-15 (first published: 2020-01-06)
864 reads
The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...
2020-01-14 (first published: 2020-01-06)
533 reads
This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...
2020-01-06
43 reads
If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries ... Continue reading
2020-01-13 (first published: 2020-01-06)
639 reads
We’re pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of...
2020-01-06
30 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Hub Via Wa:628217555651 Alamat Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kab. Tasikmalaya, Jawa...
I wrote a recursive CTE to determine employee levels... but what if I wanted...
Hub Via Wa:628217555651 Alamat Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung,...
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