However, I'm not sure we'll ever get rid of "notes" fields.

*groan*

Data Driven, announcing SQL 2016, going on now: https://www.microsoft.com/en-us/server-cloud/data-driven.aspx

Data Driven going on now: https://www.microsoft.com/en-us/server-cloud/data-driven.aspx

Completely agree. However, when the data is in there, even if you have modified and built a good data model, this is one way you might move that data...

By default, the DAC isn't available remotely, so you need to be on the console of the host: https://msdn.microsoft.com/en-us/library/ms189595.aspx

The DAC doesn't fire logon triggers: https://www.mssqltips.com/sqlservertip/1631/connecting-to-sql-server-with-a-bad-logon-trigger/

Are you using the DAC locally? Maybe show the connection string so we can be sure this is working?

In a cluster, you might need to log onto the node,...

PATINDEX is powerful, without a doubt. I have more of a fondness for charindex, mostly because I can indicate a start position. However, as Luis showed, you can get around...

Thanks for the catch. I updated the math to get the PO.

I wonder which of these works better in complex queries. It's worth some performance testing to see. I hadn't...

Sergiy (2/2/2016)

---

Editor: Comment removed

Don't you really know that pre-soring anything in Excel or any other external application does not guarantee that the set will be imported into a SQL Server...

Eric M Russell (3/9/2016)

---

It sounds similar to Microsoft Lync / Skype. It's useful for those situations where you need a quick ad-hoc group conversation between team members. A lot of...

Japie Botma (3/9/2016)

---

Personally I found multiple communication tools distracting. I like organisation, so if I could do everything with one tool, it would be nice. If I could...

I haven't worked on in terms of admin/dev work, but I have worked with a few mainframes over the years, including 370s.

My comments on stability certainly applied for me. The...

I may have to try AtBat. Listening in the background is something I've enjoyed, and I certainly like listening while driving or traveling out of town. Wonder if it works...

Good to see RC0 out. I saw the BOL page last week, but no download.

We're getting close.