"..Is it a big deal? I don’t know. Windows Server 2019 lists  with Datacenter at $6155 and Standard at $972. That means it will cost me $5,183 for Always Encrypted on...

A biometric ID is basically a "secret" hash, just like a password. Hackers can leverage network sniffing, spoofed login page, or some other man in the middle exploit to collect...

I see you have posted the original resultset, however, so we know for sure what the goal is, please post a sample of what the resultset should look like after...

My answer depends on the situation. If I'm at the bank applying for a car loan or enrolling my kids in school, and I'm asked about my occupation, then I'll...

• This reply was modified 6 years, 4 months ago by Eric M Russell.

The fact that the documents are contained inside a database column is actually working against you. If the documents were contained in a folder, then several options would be available...

In the early stage of developing on a new project, when I'm learning and creating, I don't mind working late and putting in more hours. In fact, I get a...

"..The problem is that at some point a state based deployment process won't work. It's actually impossible for a state based approach to work in all situations. Simple actions, like...

To reduce file size, MS Word documents are compressed using PKZIP format (a form of LZ compression). You can leverage BCP to export contents of a VARBINARY column to a...

Who else here will be at SQL Saturday in Atlanta tomorrow?

One caution I would add is that if you operate in a specialist area that only other DBAs will appreciate then you risk being invisible within your organisation except...

I believe that concerns about page buffer pool, plan cache, and latency are outside the intended use case for this type of serverless databases. It's definitely not for high volume...

I've never done this before, but assuming a scenario where you've lost the MASTER database, have no good backups, but do still have good user database (MDF) files, it may...

Microsoft's MSDN website has good documentation, and there are a couple of books by RedGate that might be useful.

Here are a few that I've bookmarked in the past to get...

• This reply was modified 6 years, 4 months ago by Eric M Russell.

The higher a DBA climbs up the mountain, the more he or she will realize how big the world is, and how many more mountains there are. Of course, if...

Perhaps it's a limitation of the GUI you're using to design your tables. T-SQL certainly allows for declaring the same foreign key in multiple tables.