Finding the Next Sequence Value: #SQLNewBlogger
I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I...
2026-04-15 (first published: 2026-03-30)
196 reads
Blog Posts
The OneLake catalog in Fabric: Explore, Govern, Secure
Once your Fabric tenant grows past a few workspaces, data discovery gets weird fast. Duplicates multiply. People stop trusting what they find. And security teams start hearing things like,...
2026-04-14
43 reads
The Rise of “Post Regret”: Why More Teams Are Regretting Their SQL Server to Postgres Migration
As a data nerd who’s spent the last 25+ years helping organizations keep their databases running smoothly, I’ve had this conversation more times than I can count: “We’re moving...
2026-04-14
49 reads
Monday Monitor Tips: A New Analysis Page
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard Edition, a few on the Enterprise Edition, and others handling core work, like the Linux/PostgreSQL...
2026-04-13 (first published: 2026-04-06)
212 reads
SQL Server Security: Always Encryption
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE which is introduced on SQL Server 2008, TDE is at rest has limitation as data...
2026-04-13 (first published: 2026-04-04)
290 reads
Advice I Like: Rewards from Work
The greatest rewards come from working on something that nobody has words for. If you possibly can, work where there are no names for what you do.” – from...
2026-04-10
35 reads
Finding Balance: Things Will Come Up
I have a presentation on finding balance in your career that got quite a few people thinking and commenting on their own experiences. I decided to write a few...
2026-04-10 (first published: 2026-04-01)
203 reads
Who Are You Doing It For?
But as I've matured over the years, I came to realize that I needed to ask a critical question, "Who am I doing this for?" When I agree to...
2026-04-10 (first published: 2026-03-30)
229 reads
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but I’ve also watched teams stumble during adoption. FinOps sounds simple in theory: collaborate, track costs,...
2026-04-09
878 reads
Announcements from the Microsoft Fabric Community Conference
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Atlanta 26) last week (see the FabCon keynote here). There were 8000 attendees! Here...
2026-04-08 (first published: 2026-03-26)
1,507 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers