Yes, we can get plan from either...

This is an interesting discussion in the context of database object deployments.

SQL Server will take schema stability locks when running a SELECT query (or a DML, DDL, etc operation) which...

A Computer Science or Engineering degree definitely gives someone an advantage when they are starting a career in IT - not just from the perspective of looking good on paper...

Elon Musk says the universe we live in is a computer simulation. If that's true, then God would be the SYSADMIN ?

Steve, your point about keeping a copy of the incident response letter offline reminded me of something I read a while back. It's a lot easier to apologize for a...

"..I'm especially surprised how many have performed lift-and-shift migrations to IaaS services after a mandate by management. I'm also not surprised that many customers find they're spending too much, and...

".. However, using data to try and improve your efficiency has a downside. It can lead you to a very narrow focus in your approach .."

A good example of this...

I think folks are learning that 99.999 uptime is expensive, and even if you pay for it, there are operational reasons why the database will be offline on occasion anyhow.

I've used INSERT.. DELETE.. OUTPUT.. in the past to implement archival of log tables. A daily scheduled job simply deletes where datetime < X days, and the deleted rows are...

I remember back when LINQ and Entity Framework were going to write all our queries for us, but it didn't pan out that way.

It's sort like saying that self serve...

At this point, ChatGPT answers a broad range of questions based on the vast public domain of information and consensus of opinion that exists in the internet. It is impressive,...

I didn't realize this is President's Day until you mentioned it - it's not a holiday I typically get off from work. Actually this week will probably be more busy...

So, the cloud is like a super buffet where every type of food imaginable is right there for the taking at a price point that's less than you would spend...

We used to use magnetic tape for arhiving data and avoided needing to delete it OR to pay ongoing costs for online storage.

...

And another thought about this, we...

A useful feature would be declaration of user defined global constants at the server or database level.

For example:

DECLARE CONST @@PI NUMERIC(12,10) = 3.1415926535;
DECLARE CONST @@StatusInProcess TINYINT =...