Congrats, Gail. I've been waiting for the news for quite some time now. Glad it finally came.

Glad you were here to answer questions while I was away

I tend to agree with Jeff, and others, but XML isn't a bad or good thing. Storing data in XML is great for interchange, and allows for flexibility in format,...

Jeff Moden (7/12/2015)

---

Steve Jones - SSC Editor (7/12/2015)

---

I thought so too, after banging my head on the wall for a day and a half. Eventually found that there are some...

Eric M Russell (7/9/2015)

---

IceDread (7/9/2015)

---

Last report in Sweden is that we need more IT-staff, developers of all sorts. In the coming few years there is a report that the banks...

mitchellcstein (7/9/2015)

---

SSC Veteran, I think what you point out is that SQL Server is not a version, but a wave. Being a great DBA is like surfing. There are certain...

Eric M Russell (7/7/2015)

---

You'd think that parsing records and columns in a CSV file would be a function of the provider library; the same library used by SSIS, Excel, and...

I'm in. Already getting excited. The TV trucks are setting up at Dove Valley for training camp. Hopefully I'll get to a Saints camp as well.

ZZartin (7/7/2015)

---

Well in all fairness any flatfile format that isn't properly generated on the source side is going to break your dataflow. As for why csv are more popular...

Thanks for the document, and that works, but starting from a command line also works. If it doesn't work, I suspect you don't have rights or you needed to specify...

There is no complete list of all the details. Really for a cluster you need to respond just like any other instance failure. However what you do will be different...

Answer is corrected.

Stephen Hirsch (7/6/2015)

---

The problem is that the people who use the tools aren't the ones who buy the tools. People who use tools aren't nearly as important to MS (and...

chrisn-585491 (7/6/2015)

---

Yes, but wouldn't they be more productive if Microsoft listened to the...

The Xp_cmdshell account, which is the SQL service account or proxy, likely doesn't have rights to grant permissions.

What you should do is have the account that runs the job be...