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

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

Here are a couple...

webrunner (8/31/2016)

---

Eric M Russell (8/29/2016)

---

You'll need to create this database on another instance for which you are the only SYSADMIN. Also, you'll need to enable transparent database encryption (TDE) on...

Unless you're using a 3rd party product like Melissa, then attempting to auto-magically identify and recode mistyped company names is probably beyond the level of effort you would be willing...