Nice article and interesting script.

Your description of MAPS is totally wrong though.

I will not only find any instance of MSSQL with Browser turded off, but with the right...

Good question but your script needs the ";" replaced with GO in spots. 😎

L' Eomot Inversé (7/24/2013)

---

..... Of course for people who spend most of their time in Excel spreadsheets, presumably doing arcane things with visual basic, almost anything will look like a...

sneumersky (7/24/2013)

---

Agree. PowerView is a DAX client. DAX is a query language for business/power users coming from an Excel background. There is also a DAX to SQL...

Hugo Kornelis (7/24/2013)

---

L' Eomot Inversé (7/24/2013)

---

PHYData DBA (7/23/2013)

---

L' Eomot Inversé (7/22/2013)

---

I suppose I ought to install BIDS and learn to use it on 2008R2 and install SSDTBI on my win...

Great Question. Another reason I like being able to use Truncate Table and not DELETE when trying to empty a table and reset the Identity.

L' Eomot Inversé (7/22/2013)

---

I suppose I ought to install BIDS and learn to use it on 2008R2 and install SSDTBI on my win 8/SQL 2012 machine and learn that too,...

Great Question and clean code.

Your explanation is very brief but understandable considering the behavior of Triggers. Keep it Super Simple! 😉

Nice and easy relational theory question.

Can not even begin to count the times were this basic piece of relational set logic has not been understood.

:w00t:

Rafael A. Colón (7/17/2013)

---

Hi Steve:

I certainily like this idea however it also concerns me that data is a double edge blade it can be use for good or bad purposes...

lshanahan (7/17/2013)

---

This could eventually turn from "you should share your data" to "you MUST share your data". Some of the comments in the data philanthropy link are downright scary....

http://en.wikipedia.org/wiki/Pruitt%E2%80%93Igoe

Be careful when mixing Philanthropy, Technology, and Sociological reform.

The real danger comes after you have succeeded.

These things cost real honest money to do correctly.

Unfortunately, history is filled with...

karl 70050 (7/17/2013)

---

I think most of the things that you envisioned are already covered by the requirements of the FCC

http://www.fcc.gov/guides/wireless-911-services

and

http://www.fcc.gov/guides/voip-and-911-service

There is a FAQ by Verizon concerning...

L' Eomot Inversé (7/11/2013)

---

It's an interesting theory, but I don't think the author's of BOL are quite clever enough to play that trick. I could be wrong, of...

L' Eomot Inversé (7/11/2013)Yes, but the wording of the BOL page is really confusing, in fact it could reasonably be thought bad enough to be either incorrect English, or technically...