A New Word: desanté
desanté – n. the brooding delirium of being sick, which makes time slow to a trickly and turns even the most pathetic of tasks into monumental struggles, until the...
2024-05-31
21 reads
The Voice of the DBA
Copilot Reminded Me How To Find a File Handle
Recently I was trying to delete a folder and kept getting the “something is using this, try again” dialog. It was annoying, but I couldn’t figure out what process...
2024-06-17 (first published: 2024-05-27)
582 reads
Friday Flyway Tips–State-based Deployments
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar to SQL Compare deployments, but with your code source control, which is where you want...
2024-05-24
32 reads
A New Word: Insoucism
insoucism – n. the inability to decide how much sympathy your situation really deserves, knowing that so many people have it far worse and others far better, that some...
2024-05-24
57 reads
Using Flyway with Feature Flags
There is a nice article at Harness.io on their use of feature flags and how they deployed their next generation experience. It’s worth a read if you want to...
2024-05-22
46 reads
Writing Parquet Files – #SQLNewBlogger
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it, and perhaps building a data warehouse of sorts. The modern view of data warehousing seems...
2024-06-14 (first published: 2024-05-20)
352 reads
A New Word: Flichtish
flichtish – adj. nervously aware how much of your self-image is based on untested assumptions about yourself – only ever guessing how you’d react to a violent thread, a...
2024-05-17
19 reads
The Ireland and UK DevOps Roadshow
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate DevOps Roadshow comes to Ireland and the Northern UK in June. We’ll be in these...
2024-05-16
20 reads
T-SQL Tuesday #174 – My Favorite Interview Question
This month is a great topic to me. I think growing and improving your career is a skill that most of us could improve, especially in our younger years....
2024-06-07 (first published: 2024-05-14)
638 reads
Reading JSON Data with Python
Recently I’ve been looking at archiving some data at SQL Saturday. As a start, I needed to read some of the archive data I have in Python. This post...
2024-05-24 (first published: 2024-05-12)
455 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers