Choosing to not drive the Tesla
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla at home recently. A few people asked me about it, so I decided to do...
2025-02-14
38 reads
Blog Posts
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-02-14 (first published: 2025-02-05)
745 reads
How-To Convert Excel Date & Time to SQL
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,211 reads
The pros and cons of self-service BI: What every industry leader should know
Introduction Growing enterprises or businesses that want to remain competitive must make quick decisions daily. While experience and expertise are essential in that process, making those critical calls is...
2025-02-14
7 reads
Building Effective Data Governance Framework: Top Areas to Focus On
Introduction Building a practical data governance framework can feel like building a house: you need a strong foundation, reliable materials, and the right team to make it all work. Data governance is crucial for organizations to manage, protect, and utilize their data effectively. A well-defined framework...
2025-02-13
15 reads
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to it. I had to go fishing to find all the grants to...
2025-02-12 (first published: 2025-01-27)
227 reads
Microsoft Entra Authentication for Azure PostgreSQL
Straight from Microsoft’s documentation “Microsoft Entra authentication is a mechanism of connecting to Azure Database for PostgreSQL flexible server by using identities defined in Microsoft Entra ID. With Microsoft...
2025-02-12 (first published: 2025-02-03)
271 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-02-10 (first published: 2025-01-31)
272 reads
How to Protect Against Ransomware as a DBA
Over the years I’ve been called in to work with numerous clients that were hit with ransomware. Even the times that the customer paid the ransom to unlock their...
2025-02-10
23 reads
Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore
This is more complicated than using the Azure Migration method, but because it’s maxed out on resources for the last week in the east regions (and possibly central), and...
2025-02-10 (first published: 2025-02-09)
65 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers