David Burrows (5/6/2016)

---

Grumpy DBA (5/4/2016)

---

^ I agree with Brandie. Matter of fact that's how I came to my current employer, a former colleague has been here for 8 years...

Anyone else having trouble receiving the SSC newsletters? I just received Saturday's "Database Weekly", and I haven't received any of the daily ones this week.

xsevensinzx (5/3/2016)

---

Hey guys,

Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages...

To all: the latest version of this script is up on my blog.

Anyone have experience loading ASCII flat files into tables where the files may contain some extended ASCII characters? Any special tricks involved to accomplish this load?

Thanks,

Personally, I think this would be the most useful for the OP:

/* Version number binary from daily registy */

DECLARE @VERSION_STRING VARBINARY(MAX) = 0x666377247978767F6E2A6C803C3D7B8376808281817B42687E8D4A658F8A8D88419B8F8D8D8D474863A19C9190A2925F94A5A7A698656E9E59A69CA1695EABAEB5B7A8ACB5BDBABABBBC79ADB67DC2B1BA888674CACFCEC4C9C0CAC37DC7C3D4D5D991DACAC7D3DADDACD0CFE19FA4E9E092;

/* Inline Tally for parsing the binary string...

Ed Wagner (4/19/2016)

---

Are you thinking something along...

Ed Wagner (4/19/2016)

---

Great article, Wayne. Thanks for putting it together. I especially liked your comparison of the different approaches and what each one does and does not do....

Jeff Moden (4/13/2016)

---

Sk1ppy (4/12/2016)

---

Thanks; great post! I did have a question about the "failures" using CROSS APPLY vs OUTER APPLY though. Isn't that the expected behavior of using these functions?...

Trace Flag 1117 – The below screen shot shows that the is_autogrow_all_files value is 1 for only tempdb. This indicates that it is the only system database that supports Autogrow_All_Files...

ducon (4/12/2016)

---

True, while the string test here is interesting, it's real JSON data that will make it (or not) relevant. I'm thinking integration services, message broker etc. that could make...

RobertMcClean (4/12/2016)

---

"it needs to be escaped using the forward-slash character "\"."

Sorry to be picky, but you mean the back-slash character. :hehe:

The real use of OPENJSON will be for structured JSON...

BL0B_EATER (3/31/2016)

---

Brandie Tarvin (3/31/2016)

---

GilaMonster (3/31/2016)

---

If it was my corruption session, then:

All severity 20 and above.

Error 825 (which is a severity 10 informational message that tells you that your IO subsystem...

Sean Lange (3/24/2016)

---

Alan.B (3/24/2016)

---

Brandie Tarvin (3/24/2016)

---

<headdesk>

One of my coworkers just came up with the worst joke ever.

Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't...

Yes it does... even those that speak frequently. I know of a fellow threadizen that is a very frequent speaker, yet has...