Advent of Code 2018 – Day 3 (Slicing)
Advent of Code 2018 – Day 3
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-06
229 reads
Blog Posts
Advent of Code 2018 – Day 3 (Slicing)
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a physical tally table.
The post Advent of Code 2018 – Day 3 (Slicing) appeared...
2018-12-06
4 reads
Azure SQL Database “Step By Step” Tutorials
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
455 reads
Capture the Flag – The Trace Flag
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...
2018-12-06
91 reads
Live Query Stats of Running Queries
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-12-06 (first published: 2018-11-24)
3,454 reads
Notes from the December 2018 SQLOrlando Meetup
Notes:
19 attendees out of 44 registeredSQLGrease sponsoredSolid hour of networking before the meeting started, managed to get everyone talking to...
2018-12-06
289 reads
Pens
On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...
2018-12-06
248 reads
Running a custom SQL Server Docker Image in Amazon AWS
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-06 (first published: 2018-11-26)
2,293 reads
Speaking at SQL Saturday #782 Slovenia
In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it...
2018-12-06
219 reads
SQL Server Find Unused Data Files
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
664 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers