SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Telemetry


SQL Server Telemetry

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62799 Visits: 19111
Comments posted to this topic are about the item SQL Server Telemetry

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86382 Visits: 41098
We're going through this with the new "Data Migration Assistant" (formally, "Upgrade Advisor"). There's no chance of opting out for the first part, which sends information about your system to MS. We've decided that we'll take our chances without it because of that. Upgrade Dev and test it. Upgrade Staging and test it. Upgrade Prod (with every kind of backup, including full disk backups for VM, you can imagine) and test it.

I think that MS has gotten a bit cocky. They have no right to such data / "telemetry" if we don't want them to have it. I also think that they have a hell of a nerve making the defaults in Windows 10 what they are.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32459 Visits: 18556
Jeff Moden - Monday, April 17, 2017 9:51 PM
We're going through this with the new "Data Migration Assistant" (formally, "Upgrade Advisor"). There's no chance of opting out for the first part, which sends information about your system to MS.

I was not a fan of Upgrade Advisor. I was optimistic about the upgraded version because supposedly it worked many times better. I was unaware of the telemetry data being shipped back to MS from the DMA. I think you should be able to opt out of it. Since you can't, I will continue to stick with my own methods and not rely on such a tool as this to upgrade databases.


I think that MS has gotten a bit cocky. They have no right to such data / "telemetry" if we don't want them to have it.

I would love to see an opt out for all products. I have clients that have trapped sensitive data at the firewall being shipped back up to MS. Due to that, they started blocking it at the firewall. They don't want to take any risk. An opt-out for telemtry would still give MS a good enough sample of feature use etc which can help them drive development efforts.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7623 Visits: 3286
All these systems are put together with the best and honourable intentions. The problem comes when they are exposed to people with the worse and malign intentions.

Data scientists can and do achieve incredible things with data that could benefit us all but they are also like the fat kid entrusted with the keys to the sweet shop.

There's lots of "I could do this" but very little "Should I do this"

LinkedIn Profile

Newbie on www.simple-talk.com
Sean Redmond
Sean Redmond
Mr or Mrs. 500
Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)

Group: General Forum Members
Points: 559 Visits: 736
DP» All these systems are put together with the best and honourable intentions.

Are they? Really?
Or could it be that an order has come down from on high in Microsoft that metadata is the new gold rush and that whatever can be collected must be collected.

What I don't really understand is why so many SQL Servers have Internet access. These servers should only be accessed internally or by their application servers. The idea that so many SQL Server installations are exposed to the Internet sends a shiver down my spine. Are you who is charged with the well-being of your DB-server up to speed with cybersecurity or do you hope that a virus-scanner and a religious devotion to updates and patches will keep it safe?
Gary Varga
Gary Varga
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16489 Visits: 6534
I like providing the data to Microsoft and other vendors as I believe that it can be valuable for me as a customer for my suppliers to be continually evaluating their products. For this they need data.

I do also agree that it should be optional as a given system might have sensitive data, as previously highlighted, or a very sensitive performance criteria.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86382 Visits: 41098
Sean Redmond - Tuesday, April 18, 2017 3:01 AM
DP» All these systems are put together with the best and honourable intentions.

Are they? Really?
Or could it be that an order has come down from on high in Microsoft that metadata is the new gold rush and that whatever can be collected must be collected.

What I don't really understand is why so many SQL Servers have Internet access. These servers should only be accessed internally or by their application servers. The idea that so many SQL Server installations are exposed to the Internet sends a shiver down my spine. Are you who is charged with the well-being of your DB-server up to speed with cybersecurity or do you hope that a virus-scanner and a religious devotion to updates and patches will keep it safe?


I agree. I don't know why our SQL Servers have internet access. My thought is that the OPS team has it that way to make monthly Windows Updates easier.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86382 Visits: 41098
David.Poole - Tuesday, April 18, 2017 2:39 AM


All these systems are put together with the best and honourable intentions. The problem comes when they are exposed to people with the worse and malign intentions.

Data scientists can and do achieve incredible things with data that could benefit us all but they are also like the fat kid entrusted with the keys to the sweet shop.

There's lots of "I could do this" but very little "Should I do this"

I'm pretty sure that because of the very people you speak of, there's little honorable to be had even at conception of a project. Even the release cycle for most software is built on greed. "We need to compete. Push something... anything.... out so we can say we have it and if anyone complains, then we'll fix it.". I'm convinced that continuous releases are necessary only because of that particular business model. They have to do continuous releases to continually fix errors caused by the rush.


--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12302 Visits: 10662
When Microsoft says that they're collecting data just for quality of service purposes and don't care who I am personally, I take them at their word. I'd trust Microsoft with my usage data more than I would Google or Facebook, because Microsoft are primarily technologists in the IT platform and services business.

However, Google and Facebook earn most of their revenue from aggregating and selling data to anyone willing to pay. They are essentially marketing companies with a veneer of sugar coated technology specifically designed to draw people in and leech as much data as possible from them.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86382 Visits: 41098
Eric M Russell - Tuesday, April 18, 2017 7:57 AM
When Microsoft says that they're collecting data just for quality of service purposes and don't care who I am personally, I take them at their word. I'd trust Microsoft with my usage data more than I would Google, because Microsoft is primarily in the IT platform and services business, while Google earns most of their revenue from aggregating and selling data to anyone willing to pay.


I have no such trust in any software vendor.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search