From a DBA’s perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
(2017-2022)
Browsing Posts in SQL
Next, Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing the challenges in T-SQL. In case you don’t know what “Advent of Code” is, Eric Wastl (t) created it for the purpose of, as Eric describes […]
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a physical tally table.
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a recursive case-sensitive string replacement.
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a virtual tally table and getting data from prior rows.
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a virtual tally table and pivoting data
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a running total calculation and duplicating a result set
Exploring how a parent-child relationship was implemented by a third-party software vendor improperly.
Understanding the relationship between statistics, indexes and constraints in SQL Server. What meaning does stats_id of 1 mean?
Performance testing various methods for removing the time element from the datetime data type. While they all execute quickly, one method is faster than the others.
