I knew that R is going to be in the new SQL 2016, but I didn't know that JSON was also going to be in it. Very interesting. Thanks for...

There were, but I think I've handled them all.

I hadn't thought of renaming the foreign key constraints. That's an interesting idea. However, even if I did rename the foreign key constraints they're definition would still be looking for...

Eric M Russell (9/18/2015)

---

.. Staying or going isn’t about loyalty, it’s about what is best for you and you can measure that in any way you want – money, vacation,...

Excellent follow-up article, Andy.

Jeff Moden (9/16/2015)

---

I've always thought this whole process was a bit, um... well... stupid. If you're not happy with your job, etc, yadda, yadda, then you should be talking...

Wayne West (9/15/2015)

---

Rod at work (9/15/2015)

---

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone...

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone came out with a source...

I'd like to know how people save the stored procs, views, triggers, etc. in a VCS? Whenever I've used SSMS there wasn't any integration I could see with anything like...

OK I've found out what a format file is, and have created it using the bcp utility. (Never done that before.)

Now what I don't know how to do is not...

Would that format file be my .CSV file? And the source and destination columns would be the first row of the .CSV file? If so, then I'd better go back...

Ok Ed, I've got a question and an observation.

First the observation. I didn't know it when I wrote the SQL BULK INSERT script, but that must be run on the...

Ed Wagner (9/11/2015)

---

If this is a one-time activity, you can query the rows in SSMS and save them as a CSV file by right-clicking the results pane...Save As and select...

I believe we do have an ER diagram somewhere, but I don't maintain it. I'm a part of a bigger IT/dev group now, with more specialization. The tool they're using...

Wayne West (8/31/2015)

---

Wow, a 35,000 word article? That's a short story! It took me pretty much a full day to read it! (don't tell my boss)

It had a...