If you've enabled login auditing, and you've confirmed no logins for past month, then should do it. At this point disable them and have an email alert notify you in...

Still there is the issue that two words sounding alike are completely different.

SELECT[dbo].[DoubleMetaPhone]('Pheasant');

FSNT FSNT

SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');

FSNT FSNT

By default, VIEW DEFINITION (access to DDL text of an object) is denied. You can grant this a user at the server, database, schema, or object level. The following article...

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