mjh 45389 (9/6/2016)

---

Many years ago I volunteered for redundancy (it was a case of that if you volunteered you got a fairly generous payoff but if did not you would...

'ABC Lickers' is probably an entirely different business.

Here in the US, local state laws can limit non-compete agreements or subject them to a restricted interpretation. Whether a court will uphold a disagreement depends on whether the NCA...

PowerShell is essentially a system integration tool. It needs to be: robust in terms of features, portable, easy to use, and broadly accepted (a large user base). It seems to...

There are plenty of good high paying DBA opportunities out there. Reading the original post, it seems like you are primarily a DBA who moves between contract assignments. It's possible...

If we're talking about error logs, then one major issue with containing the log records within the database is that, if the database is down, then you don't have access...

I was in the market last year. There are positions open that, at least based on job description, could only be filled by a senior level DBA / Datbase Developer,...

The following will tell you who and what is currently in TEMPDB and has contributed to it's growth. You'll have to dig deeper to determine why.

USE TEMPDB;

-- TEMPDB allocated...

2,000+ small remote retail POS instances get transactionally replicated to four larger on-presises replicas, which get consolidated into one big ODS, which gets partially replicated for reporting purposes to various...

ChrisM@Work (9/2/2016)

---

GilaMonster (9/2/2016)

---

Abort reason is "Good enough plan found" (properties of the SELECT). Optimisation has multiple phases, "Good enough plan found" means that at the end of one phase the...

We use Thycotic SecretServer as our enterprise password and key vault solution. It supports domain and two-phase authentication. Looking at this architecture document, it appears the product does use SQL...

ThomasRushton (8/31/2016)

---

Eric M Russell (8/31/2016)

---

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

Talking about users creating databases, I assume we're really just talking about the development envrironment here, and when it comes time to deploy to production, you can adust the file...

I've never used it, but there is this Enterprise feature called 'Policy Based Management' whereby you can setup rules that govern things like server and database settings or even object...

Sean Lange (8/31/2016)

---

Eric M Russell (8/30/2016)

---

Personally, I dislike coding CRUD procedures, because it turns into busy work and becomes a distraction with all the numerous tasks that have to...