If Microsoft does intend to stick with a new release every two years, just for the purpose of introducing new features to market and maintaining competitive advantage, then it should...

I agree that DBAs need to expand their skillset into development. However, instead of a .NET language, I'd suggest T-SQL (obviously and essentially), PowerShell, SSIS, and maybe SSAS/SSRS if that's...

Even if 2016 Standard Edition now supports some of the Enterprise features, that doesn't mean that SharePoint leverages them. The deciding factor should still be which Edition leverages your server's...

The problem is that you are converting the date to DD/MM/YYYY format, and that doesn't work properly with range logic. You need to use YYYY/MM/DD format or don't convert at...

On a medium powered OLTP database server, I would consider 100,000 rows or less to be a small amount of data. However, to understand the potential for blocking and duration...

Robin35 (12/9/2016)

---

Eric M Russell (12/9/2016)

---

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

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