There are no dumb questions, only dumb decisions. Whoever designed the MSDB job activity tables didn't make the temporal columns as user friendly as they could be.

Here are a couple...

webrunner (8/31/2016)

---

Eric M Russell (8/29/2016)

---

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

Unless you're using a 3rd party product like Melissa, then attempting to auto-magically identify and recode mistyped company names is probably beyond the level of effort you would be willing...

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