Also if you are forced to comply with an unreasonable request, then give them the bare minimum required. For example, keep in mind that the 'SA' account and SYSADMIN are...

When dealing with unreasonable requests coming from a position of higher authority, your first response should be to object. But remember to do it in a friendly and helpful way,...

Properly commenting code blocks that were modified in a branch is essential. All of my comments will contain a change tracking number, so it even if my one sentence explanation...

Avalin (5/18/2016)

---

I have a select-query using the WITH(NOLOCK) hint to ignore locks. The problem is that when the query is executed it get timed out because it's waiting for a...

I'll be at SQL Saturday Atlanta this weekend.

ColumnStore is another feature that has matured between 2012, 2014, and 2016. For example, only in 2016 do ColumnStore tables support primary keys.

Aside from comparing the execution plan generated by the two scripts, the following can be used to return usage stats (pages inserted/update, last update time, row counts, etc.) at the...

Here is the concept behind AD authentication: Users should belong to AD groups depending on what broad level of access they need to database servers (ie: MyCorp\Developers, MyCorp\QA, MyCorp\DBA). Within...

Steve Jones - SSC Editor (5/16/2016)

---

Eric M Russell (5/13/2016)

---

Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to...

Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to face with the employer. I also don't like...

It seems that sometimes the same spam gets posted days or weeks later. If a distinct message was previously delisted, then it should be auto-delisted if it turns up again.

In my last two jobs, which covers a span of ten years, we've used AD domain group authentication. For example MYCORP\DBA_Production, MYCORP\StoreOpsQA, MYCORP\MarketingBI. As employees are hired (or switched between...

sestell1 (5/12/2016)

---

Eric M Russell (5/12/2016)

---

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to...

Sean Lange (5/12/2016)

---

I am clearly in the minority here. For me the IT world IS my second career. I spent a decade as a chef prior to going back to...

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a...