Friday Flyway Tips: Visualizing Undo Scripts
One nice thing with Flyway Enterprise is that it will automatically generate the undo scripts for migration scripts. However, it used to be that finding these and seeing the...
2023-09-01
70 reads
The Voice of the DBA
A New Word: Merrenness
merrenness – n. the lulling isolation of driving late at night – floating through the void in an otherworldly hum, trailing red jewels in the darkness, your high beams...
2023-09-01
30 reads
Finding Analogies with AI
I saw this article on using AI to help that included a few prompts. I decided to try one. This is part of a series of experiments with the...
2023-08-31
887 reads
Restore with Standby–#SQLNewBlogger
A customer had a question about restoring with standby, so I wrote a quick post to explain how this works. Another post for me that is simple and hopefully...
2023-08-30
40 reads
Chicago Database DevOps in a Day Workshop
I’m heading to Chicago today for the Redgate Database DevOps in a Day workshops. This is the first of many on the US tour. I’ll be at 5 of...
2023-08-29
24 reads
Quickly Creating a tsqlt Test for a Query
One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...
2023-09-25 (first published: 2023-08-28)
393 reads
Friday Flyway Tips: More Config Options
Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...
2023-09-29 (first published: 2023-08-25)
146 reads
A New Word: mahpiohanzia
mahpiohanzia – n. the frustration of being unable to fly, unable to stretch out your arms and vault into the air, having finally shrugged off the burden of your...
2023-08-25
68 reads
ADS Copilot Experiments with XML
I sent some code to a customer recently to help them decrypt some stored procedures. I sent a quick and dirty set of code, noting at the bottom that...
2023-09-18 (first published: 2023-08-23)
238 reads
Decrypting Stored Procedures with SQL Compare
I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...
2023-08-21
261 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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