SQLServerCentral / Editorials / SQLServerCentral.com / Feedback is Encouraged / Latest Posts

RE: Feedback is Encouraged

Alexander Kuznetsov — Mon, 03 Dec 2012 21:00:38 GMT

Feedback is encouraged? Not very much IMO. The following two really efficient ways to communicate feedback are completely closed.1. Tools such as SSIS and SSMS are "free", which means that we pay for them whether we use them or not. This means that we cannot vote with our money. 2. Code review of closed source is not possible. This is a very common way of getting feedback in other environments.

RE: Feedback is Encouraged

Steve Jones - SSC Editor — Mon, 03 Dec 2012 16:52:23 GMT

[quote][b]chrisn-585491 (12/3/2012)[/b][hr]After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... :([/quote]I'm not sure I agree that Microsoft isn't listening. There are plenty of people that love the ribbon interfaces and many that like Win 8. It's a radical change from previous tries, and I like that.Users get an opinion, and I'm sure there is discord inside Microsoft as to how much that opinion matters, but I have seen changes come from Connect, and I have seen Microsoft implement new features based on user feedback.

RE: Feedback is Encouraged

Jeff Moden — Mon, 03 Dec 2012 16:37:06 GMT

RE: Feedback is Encouraged

TravisDBA — Mon, 03 Dec 2012 10:29:46 GMT

RE: Feedback is Encouraged

chrisn-585491 — Mon, 03 Dec 2012 08:22:16 GMT

After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft listens to many of the users... :(

RE: Feedback is Encouraged

Jeff Moden — Mon, 03 Dec 2012 06:15:39 GMT

[quote][b]fname lname-1111520 (12/2/2012)[/b][hr]I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything."Interoperability with non-MS tools? We sure won't make it easy!"Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files[/quote]+1000Ah... a kindred spirit! I agree... why bother with feedback if the answer to many of the things you'd like to see is a referral to a tool that you don't want to use or can't use because of some restriction within the company? And, it IS a standard answer. SSIS doesn't always represent the needs of someone doing even simple ETL/File Import/Export of data stored in SQL Tables.The other dangerous thing is that if they ever do an improvement based on feedback, they might deprecate something useful in the process. For example, I'm still scared to death that they'll deprecate xp_CmdShell in favor of the overcomplications of PowerShell. Don't get me wrong... PowerShell is a great tool for certain things. I just don't need it for simple file handling. I've still got lots of ETL code out there that keeps chugging away even though things like DTS went the wayside for SSIS, etc, ad infinitum.

RE: Feedback is Encouraged

fname lname-1111520 — Sun, 02 Dec 2012 18:56:32 GMT

I have not reported it. From briefly perusing the several thousand results on Connect for SQL Server and "csv", the standard cop-out for this issue seems to be "use SSIS import/export tools."The fact that there is an option in SSMS to "quote strings containing list separators when saving .csv results" says everything."Interoperability with non-MS tools? We sure won't make it easy!"Here is an amusing post on Connect regarding BCP: http://connect.microsoft.com/SQLServer/feedback/details/127032/bcp-utility-should-support-rfc-4180-csv-files

RE: Feedback is Encouraged

Steve Jones - SSC Editor — Sun, 02 Dec 2012 14:55:44 GMT

Interesting. Didn't know that was broken. I'm sure this isn't on purpose. Have you reported this on Connect?

RE: Feedback is Encouraged

fname lname-1111520 — Sun, 02 Dec 2012 14:04:36 GMT

SSMS 2012, results to grid, with the option to quote values containing the column delimiter. Why one wouldn't want to do that, among other things, is beyond me:[code="sql"]select',','"','',',"'[/code]Surely, this is by no means an important feature (although quick and useful), but correct CSV output is so dirt simple to implement (case when value like '%[,"]%' then '"' + replace(value,'"','""') + '"' else value end), it is very irritating that SSMS even has the option to save as (broken) CSV.If enough folks ask for it...Are there any other areas where SQL fails with CSV format? Bulk import?

RE: Feedback is Encouraged

Steve Jones - SSC Editor — Sun, 02 Dec 2012 13:02:09 GMT

What's broken? It seems to work for me.

RE: Feedback is Encouraged

fname lname-1111520 — Sat, 01 Dec 2012 12:51:08 GMT

CSV support in SSMS (saving result sets as...) is deliberately broken. Gee, I wonder why.

Feedback is Encouraged

Steve Jones - SSC Editor — Sat, 01 Dec 2012 11:03:16 GMT

Comments posted to this topic are about the item [B]Feedback is Encouraged[/B]