Thanks to DevOps tools like DbUp and Octopus, less of my day is spent running "DBA, can you please deploy ..." type scripts.

Also, scripts for doing things like checking disk...

When I think of a data-warehouse, I'm thinking OLAP, meaning data is updated on a schedule, contains versioned history of changes, and probably summarized as well for fast reporting and...

".. For very large deletions, consider disabling indexes and constraints before deleting, then rebuilding them after: .."

Dropping non-clustered indexes and constraints can improve performance of bulk deletes - but you...

For years, I've been getting that same error every time I submit, but it still creates the post.

Because it wasn't being...

...

The last one is VB6. Microsoft came up with Visual Basic to help those developers who had a hard time grokking C++ for Windows development. I don't know what...

If you are designing a new object with DML triggers, especially nested or recursive enabled triggers, then you should take a step back and consider if there is a better...

Yeah, automatic touchless transactions can make your life easy - until you have to deal with fraud. It could spoil someone's vacation or holiday.

Perhaps we could design tap cards in...

Historians in the future, who look at archival copies of today's "news" websites, will laugh at all the stupid memes and click bait ads appearing in the margins. Also, what's...

The fact that most input parameters are defined as NVARCHAR (4000) is evidence that the original code was generated by an ORM.

My guess is that the developers were instructed to...

We have about 900 Point Of Sale locations across the US running SQL Server Express on workstations and SSD drives. So, the disks are not invisible. If the event of...

This thing about asking for an improbable mix of skills seems far more common for third party recruiters. Not only do these shops pad job descriptions, but they pad resumes...

Another suggestion is: don't the table accumulate 10s or 100s of millions of rows. Use a job to truncate off-hours on a daily or weekly schedule.

For example, on some servers,...

I leverage partitions to truncate data on large tables as well,...

Steve, I was just thinking yesterday that I want to know more about Kafka. It's leveraged by one of the application teams to replicate a subset of tables, columns, and...

Even with the rise of cloud hosting and AI, my belief is that junior level developers and database/server administrators will always be in demand - but just not in the...