Where I work, we use Octopus and Chef for automated deployments. If what you need is an account that can create a database, create objects within that, and then assign...

Adding all these features to Standard Edition is great.

But having these new features like encryption, data masking, and compression in Express Edition also presents some interesting opportunities. We have...

Hi Jim,

Most DBAs live lives of quiet desperation and go to the grave having never called folks out on their bull$hit.

Keep us posted on your story and good luck...

Gary Varga (12/9/2016)

---

Eric M Russell (12/8/2016)

---

Regardless of whether we're interviewing for a DBA or a developer who will code SQL, one question I ask is:

"For the next 15 minutes, explain...

Regardless of whether we're interviewing for a DBA or a developer who will code SQL, one question I ask is:

"For the next 15 minutes, explain everything you know about locking,...

That comes...

I try not to be too stingy when it comes to reserving memory for Windows OS. Even if there are no other major services like SSIS running in the background,...

Ooops, Friday is coming up. You know what happens on Friday's in corporate America, especially when the screws have been tightened on access security ...

jim.powers (12/8/2016)

---

It is a tiny little database that has absolutely no impact. It will hardly be noticed and again, I even had permission from his junior network admin whom he...

Maybe stretching into Amazon or GoDaddy is an option?

... If you stretch a sales database, say a 100GB database and want to move 60GB of that data away, you're going to pay at least US$930/month for the compute...

Jeff Moden (12/7/2016)

---

Eric M Russell (12/7/2016)

---

alex.sqldba (12/7/2016)

---

Hi Eric,

Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would...

jim.powers (12/8/2016)

---

...

I did speak with my boss this morning. He said that permissions were taken away from all users because I created a tiny little database for another web developer...

Just out of curiosity, give us a little background information about this situation. For example, are you primarily in an IT support or DevOps position within a small company and...

By lock, you probably mean decrypt. 7Zip uses AES256 encryption. My advice would be to download the command line version of 7Zip and then write a PowerShell script to perform...