Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...
2018-12-26 (first published: 2018-12-05)
7,348 reads
Advent of Code 2018 – Day 5 (Alchemical Reduction)
A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...
2018-12-05
34 reads
Advent of Code 2018 – Day 5 (Alchemical Reduction)
Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-05
862 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,447 reads
Basic Sequences–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-27 (first published: 2018-12-05)
2,501 reads
Flagrantly ignoring the 10% rule
My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over...
2018-12-05
223 reads
UDL files and connection strings
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
7,426 reads
Enabling Query Store
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
1,249 reads
SQL Data Discovery and Classification in SSMS 17.5
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
941 reads
Managing Logins and Users Across An Availability Group
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,286 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I