Working with SQLSaturday SpeedPASSes – revamped!
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....
2019-05-21
2 reads
Wayne Sheffield
Creating a comma-separated list (SQL Spackle)
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2019-04-04 (first published: 2011-01-12)
36,647 reads
Scalar UDF Inlining in SQL Server 2019 – Simpler functions
I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...
2019-03-26 (first published: 2019-03-11)
590 reads
Scalar UDF Inlining in SQL Server 2019
How does Scalar UDF Inlining affect the performance of scalar functions?
SQL Server 2019 introduces a new feature called “Scalar UDF...
2019-03-14 (first published: 2019-02-25)
2,867 reads
What is your why? – T-SQL Tuesday #111
Would you believe that it is already the second Tuesday in February? Wow, this month is sure going fast. But...
2019-02-12
174 reads
CLR Strict Security in SQL 2017
Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...
2019-02-06 (first published: 2019-01-21)
2,148 reads
T-SQL Tuesday #110 – Automate All the Things
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
138 reads
Advent of Code 2018 – Day 4 (Repose Record)
Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-25 (first published: 2018-12-05)
2,415 reads
Advent of Code 2018 – Day 2 (Inventory Management)
Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...
2018-12-21 (first published: 2018-12-04)
1,814 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...
2018-12-12
150 reads
Blogs
The SQL Change Automation in SSMS Beta
By Steve Jones
Give it a try, as the beta is out. I’ve been watching this product...
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to...
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Dynamic query based of business rules
I hope you are well. I need your help and advice on a repetitive...
Transaction Log (Waitype=Replication)
Hello all, I have an issue with my growing transaction log. When I query...
Ask SSC