I've used SSMS 2012 to connect. Just need to not allow the OE to connect and put ADMIN in the query connection dialog.

Glad it's working.

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...