The SOUNDEX hashing function is primitive and will result in many false matches when comparing strings of multiple words, even if they are very dissimilar. Basically, it retains the first...

I would say that's generally true. SQL Server, or relational database engines in general, are ideal for applications where the entities are normalized tables and data access patterns are predefined....

SQL_Student (8/30/2016)

---

Thanks that seems interesting, have never used that before... Will that encryption allow the database to be accessed remotely (eg allowing other instances to write into that db with...

We're perhaps just kicking a dead horse. I still freshly remember this topic when it was originally published four years ago, and it has come up again numerous times long...

Define "better".

Azure SQL and SQL Server 2016 also have a new feature called Always Encrypted, which in a nutshell is a combination of TDE and transparent column level encryption where the...

You'll need to create this database on another instance for which you are the only SYSADMIN. Also, you'll need to enable transparent database encryption (TDE) on this database to prevent...

But you probably know that db_ddbadmin will grant them...

Granting developers and other users membership in the SYSADMIN role is like planting a Tree Of Good And Evil in the middle of the Garden If Eden and then commanding...

After reading up on the process of how 'Lutefisk' is prepared, I'm left with the impression that it's nothing like the popular Spanish dish 'Ceviche'.

http://mylittlenorway.com/2009/12/lutefisk/

xsevensinzx (8/25/2016)

---

Hope you enjoy Oslo, Norway. I was able to relocate there for the company I worked for 4 years ago. It was also my longest business trip before I...

Federal contractors, at least within the realm of IT, farm the actual work out to sub-contractors anyhow, and I can tell you that those sub-contractors are no more skilled than...

Matt Miller (#4) (8/25/2016)

---

SQLBill (8/25/2016)

---

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original...

Markus (8/25/2016)

---

Gary Varga (8/25/2016)

---

Changing for sure. That's nothing new. The change might be new but that it is...

An organization can spend millions on infrastructure, fancy BI tools, and contractors, but it will collapse like a house of cards unless they have a team of solid DBAs and...