For key value pairs, this is typically what you want. If name exists (@@rowcount = 1), then it's value is updated. If name doesn't exist (@@rowcount = 0), then it...

Although you can technically store unstructured data in SQL Server, the question is: Why would you?

If you're ultimately trying to import facts and dimentions (as properly defined by the business)...

Oh, I'd never earn MY paycheck offering emotional support. If that's what they...

Beatrix Kiddo (7/6/2016)

---

😀 I...

tezsb (7/6/2016)

---

thanks to all for your replies, I appreciate the additional insight and view from an alternative perspective. Rightly or wrongly, I assumed the CIO knows what a DBA does...

If you use a continuous integration tool like TeamCity or an automated deployment tool like DbUp, then it's entirely possible for unexpected object or securoty related DDL operations to get...

leehbi (7/4/2016)

---

I'm starting to see more data sources from JSON based API's (mostly 3rd party). JSON must make the app developers life easier but it makes my life...

tezsb (7/4/2016)

---

Hello all,

I am looking for help to justify my access to Production to my CIO. Sounds strange, doesnt it?

Well, it is, and I am at wits end here and...

If you're going to have a national holiday, it should commemorate an event or concept that practically all citizens can rally behind. Commemorating the outcome of a recent partisian referendum...

Using a 3rd party to manage user identities make sense for many reasons, and the most compelling reason is that you own your identity and it can be reused...

As a side note, in Oracle a NULL and an empty string '' are equal, which means that:

'' IS NULL, the expression '' = '' would always evaluate False,...

Rod at work (6/29/2016)

---

Eric M Russell (6/28/2016)

---

While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

How to Snare Millions of...

Phil Parkin (6/28/2016)

---

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source...

Check your maintenance plan. Often times it will contain truncate job and backup history.

There is a function called object_definition() that accepts object_id and then returns the T-SQL of object like stored procedures, UDF, or views. When combined with sp_msforeachdb, you can leverage it...