How to Secure SQL Server

Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...

Yet another kind of orphan users in SQL Server

Yet another kind of orphan users in SQL Server

Or YAOU for short. (This silly acronym, I just made it up so don’t try...

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...

Nine chapters of my data architecture book are available

As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...

A Decade of Dedication – Celebrating 10 Years in Business

I am overjoyed to announce a momentous occasion – we have officially reached the remarkable milestone of being in business for 10 years! This incredible journey began with a...

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...

One job to rule them all

Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading

Getting list of protocols enabled in a SQL Server instance

protocols enabled in a SQL Server instance

There are number of ways you can find out what protocols are enable in a SQL Server...

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...

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...