If this is how landlords want to be, then when checking into a rental, I'm temporarily pulling the plug on the internet router, except maybe for the couple of hours...

I'm surprised that Microsoft hasn't invested in the development or acquisition of a good basic ERD tool over the years. It wouldn't need to be anywhere near as robust as...

It is frustrating that the diagramming tool built into SSMS hasn't evolved in any significant way since 2005.

One thing you can do is print to diagrams to PDF documents or...

There have been so many new database engines introduced over the past decade, I don't see the need for a new one. When building out an enterprise scope solution, the...

About all I've seen in the past is where date/time columns are updated with the database server's GETDATE(), and the local time on the server is set to corporate headquarter...

Years ago, you could google "filetype:config +uid +password" and get links to 100s of config files located on ftp or even live web servers where the admin didn't properly setup...

With 30 feet of printed manuals, I'm guessing a moderate sized IT department had something like a technical reference librarian who could research stuff and keep it organized.

At least in my observable universe, most limitations that developers struggle with daily are at the logical level of SQL coding or at the physical modeling level, rather than being...

No doubt widespread traffic congestion would occur on highways and inner city streets globally if a technical glitch (or hack attack) disrupted smartphone GPS capability. Imagine it's 4:00pm mid week...

On those occasions the query produces a skewed execution plan, see if you can correlate the point in time with your index and statistics maintenance window. I know that maintenance...

It's unclear if you're asking a modeling question or a security question. For example, are you asking how grant DW users access only to financial data but not HR ?

Maybe add the proxy account to one of the other server roles.

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-2017

For example:

"dbcreator: Members of the dbcreator fixed server role can create, alter, drop, and restore any database."

Rather than dropping the table, I'd reccomend denying select permission, and then wait at least 45 days before dropping it.

As a DBA and developer, I personally don't need an AI to help me write my code. However, I could really use an AI to monitor my servers, maybe even...

Do we really need AI driven application development?

Just like AI driven cars, it's an interesting concept, and I'm sure it's in our future, but at least here an now, there...