Advent of Code #3 – Part 1
Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying...
2015-12-23
1,012 reads
Blog Posts
Advent of Code #3 – Part 2
Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding...
2015-12-23
707 reads
Back to Basics: Why not parameterize?
I think sometimes those of us that have been doing database administration/development for a while take it for granted that...
2015-12-23
264 reads
CISL Roadmap
The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL...
2015-12-23
441 reads
The Writeable Warm Standby
I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log...
2015-12-23 (first published: 2015-12-14)
1,759 reads
$10 to Support Wikipedia Too
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
570 reads
Benefits from Data Lifecycle Management
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,749 reads
CISL 1.0.4 is released
I am glad to share that the latest version of CISL – Columnstore Indexes Scripts Library 1.0.4 is finally released.
By all...
2015-12-22
468 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
547 reads
How to use CISL – the Columnstore Indexes Scripts Library
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes...
2015-12-22
878 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers