I use Visual Studio or SSDT for SSIS package development and schema / data comparison. However, I find the UI too cluttered and AppDev centric for it to replace SSMS...

This is why so many folks are moving their databases to Azure. Instead of debating about VMs, Cores, and storage controllers, it's simply setting the right DTUs (database transfer units)...

A better term for "NoSQL" databases would be "ACID-ish" databases.

Here is one possibility. Back when we were upgrading servers from 2008 to 2014/2016, we encountered the issue described in the blog post below. Confirm that a SKU licensing misstep...

Today, the modern IT professional has to be more "cosmopolitan" in regards to knowledge and expertise. It's not like the old days where someone could spend a decade embedded in...

Another example of bad commenting in code are when the comments contain actual blocks of commented code with no explanation. Like, if someone tweaks a 100 line SELECT statement, there...

But, thanks to advancements in automation and the expanding pace of the IT ecosystem, we're all basically becoming a Jack Of All Scripts and Master Of None.

While I don't see biometrics as a complete identification solution or a replacement for passwords in all situations, I still think it could be a component of a more complete...

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