Password encrypting backup files can actually be useful in some scenarios, like for organizations that copy their backups to cloud storage or removable media, so why not just fix the...

Many of the unit tests performed in DEV and QA are also useful for post-deployment testing in Production, and this can include a schema comparison of Production versus QA looking...

So some folks are driving around town with a cone on their car - to protest other people's use of their car? Are they protesting congestion (which makes no sense)...

We considered using the Stretch Database feature a while back, but the service was too costly. This isn't documented by Microsoft, but Stretch Database (I have deduced) actually uses Azure...

When it comes to advice or programming code, we should treat ChatGPT and other AI platforms as if they are an 'idiot savant' with an extremely large knowledge base and...

T-SQL is a very high level and declarative language, so when I'm searching for code on the web, what I'm looking for is a brief and to the point example...

The 'tag cloud' of skills often seen on resumes or LinkedIn profiles may not be necessary and can even come across as cluttered and pretentious - but it's still an...

Eric, my experience has been that spinning rust and 256GB of RAM remains plenty for most applications and customers.

There's need, and then there's want.  No-one needs a Porsche, a...

Do we really need to keep the entire database in memory? It depends on what problem you're trying to solve.

We already have in-memory option for tables, which is good for...

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