Definitely have a profile on LinkedIn and read matching job descriptions that land in your email - even if you are in no way considering a move. Do this to...

Daylight Savings Time makes winter days extra short and summer days extra long. Aside from traditional farming, that's also useful for the construction and vacation industry.

Yes, TLS enabled on the client by itself will encrypt the data and SQL commands sent between client and server. SQL Server at install time will automatically create a certificate...

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