Are you sure you're using the right account?

Many DBAs disable the SA account. If yours is disabled, then using that in your connection string is always going to end in...

Why can't you create a server-level role that uses a SQL Login to access each DB with the ALTER INDEX permissions?

Yes, initial setup will require you to touch each database,...

It sounds like an IIS or certificate issue.

I vaguely remember seeing this before, but other then the above conjecture, I couldn't tell you where to start. My encounter with the...

HookSqlDba7 (9/29/2016)

---

We are running SQL Server 2012 EE SP3.

I have set up a single job with 3 steps. Each step executes a different ssis package. Each step has it's...

You can do it in the GUI by using Control Panel -> Programs and Features. Choose the Microsoft SQL 2012 instance and click "Uninstall". Yes, I know. Panic-inducing moment here,...

Check the Failover Cluster Management tool. See if the server you're on is indeed part of the cluster. Also, are you sure you set up the SQL instance as a...

Well I just verified with a brand new package and a brand new config file that it's still happening. I narrowed down when it happens too. If I open the...

So what's the question?...

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

GilaMonster (9/28/2016)

---

Reposting from twitter:

"I'm looking for examples of extremely big or extremely busy relational database systems doesn't have to be SQL Server."

Case studies or similar, don't need detail, just

It's...

J Livingston SQL (9/27/2016)

---

drew.allen (9/27/2016)

---

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime....

Ha. He just...

SET RANT Brandie ON;

I just spent the past week working on a bug fix to get into our production systems before month end. Last night, after I leave for the...

Microsoft seems to be adopting the attitude of "one size fits all" OS management. If they worried about their marketshare before, they're really going to be worrying about it now....

Jeff Moden (9/22/2016)

---

I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View...