I think most seasoned DBAs, those of us who have been in the industry for more than a decade, can tolerate variations in naming conventions, even multiple conventions being used...

This seems like a discussion from just the other day - but it was actually six years ago!

Here is my thinking about it:

Some tables represent entities that are "top level"...

Necessity is usually the mother of IT consulting.

There is nothing "heroic" about establishing yourself as a lynchpin, keeping your co-workers in the dark about how things work, and then bailing one day for a better job.

Of course,...

Fortunately for the DBA, because SQL is a high level declarative language, releasing modifications to a stored procedure (so long as it  also doesn't involve changes to shared objects like...

It would be nice to have the humble PRINT statement support %s and %i arguments similar to RAISERROR and also support the NOWAIT and LOG options.

Also, it would be nice...

If I'm on an airplane or Zenning out in the middle of nature without internet connectivity, then it's either a weekend or I'm on PTO, in which case I'm not...

If you're asking me, it's just Visio.

Keeping corporate data on your laptop or phone is an accident waiting to happen. Aside from the creeps who lurk around food courts waiting for you to refill your drink,...

Here is my first draft.

I call it the UEvent (Universal Event) data model, because it is abstract enough to accommodate anything from IT conferences,  university classes, webinars, book club meetups...

Redgate SQL Prompt has several features that are useful for code reviews, automated static code analysis, and refactoring.

First, there is the 'Code Analysis' feature.

https://documentation.red-gate.com/codeanalysis/code-analysis-for-sql-server

Then there is the feature to...

For those Azure customers with zone-redundancy enabled, it would be interesting to know how much loss of availability they experienced. Theoretically, it should be been a couple minutes at most...

You know, there are a lot of conversations about how AI will replace jobs. Particular industries like manufactoring, marketing, customer service, and IT be disrupted more than others. But I...

I've always thought that Microsoft's investment in Linux had more to do with the technicals of making SQL Server run more efficiently on Docker containers and expanding it's footprint into...

Maybe the most efficient way to mockup 100 million rows of randomized test data would be to leverage PowerShell or Python to create text files and then BCP them into...