Voting for Change

Question

Voting for Change

Steve Jones - SSC Editor

SSC Guru

Points: 736270
More actions
September 14, 2017 at 9:15 pm

#323565

Comments posted to this topic are about the item Voting for Change

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

allinadazework SSCarpal Tunnel Points: 4506 More actions · Answer 1

I dutifully tried to upvote the "string or binary data truncated" on the link you gave in this article. You can't! It's closed for voting. So presumably that means it is now either well in hand or has been ignored?

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 2

Andy, I was just able to vote on the "Please fix the "String or binary data would be truncated" message to give the column name" item, and it still says "Active", so perhaps you were not signed in at the time you tried to vote?

One thing that I would like to see taken care of ASAP (and could use some support on :D) is:
Trusted Assemblies are more problematic yet less functional than Certificates - Please Remove

It concerns a recent change to SQL Server 2017 related to SQLCLR, which I realize is a niche topic, but this change is something that I see as being a (completely unnecessary) weakening of security, which is something that I would think would be of interest to (hopefully) the entire community. I have a more detailed explanation of the reasoning behind my request here:
SQLCLR vs. SQL Server 2017, Part 4: “Trusted Assemblies” – The Disappointment

The following request also concerns security, and is initially related to SQLCLR (and the issue noted above), but is more general as it would also help make module signing easier, as well as allow SSDT Database Projects to support Asymmetric Keys:
Allow Asymmetric Key to be created from binary hex bytes string just like CREATE CERTIFICATE (SQLCLR)

One thing that I think many / most can get behind is my request to have Microsoft identify in sys.databases the "type" of database that each one is, such as MS provided, system, user, demo, etc. This would mean that anyone who is writing automation scripts (and I think that covers most of us) wouldn't have to scan for names of databases to exclude:
Add "type" and "type_desc" fields to sys.databases DMV (to make life easier on EVERYONE)

And finally, this comes up every once in a while and is a pain to implement, yet it could be handled internally as the OS supports it:
Support "natural sorting" / DIGITSASNUMBERS as a Collation option

Thanks, Solomon...

SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 3

allinadazework - Friday, September 15, 2017 1:36 AM
I dutifully tried to upvote the "string or binary data truncated" on the link you gave in this article. You can't! It's closed for voting. So presumably that means it is now either well in hand or has been ignored?

Likely ignored 🙁

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

Solomon Rutzky - Friday, September 15, 2017 8:33 AM
One thing that I would like to see taken care of ASAP (and could use some support on :D) is:
Trusted Assemblies are more problematic yet less functional than Certificates - Please Remove

Voted for a few. Forgot about these.

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 5

Steve Jones - SSC Editor - Friday, September 15, 2017 8:48 AM
Solomon Rutzky - Friday, September 15, 2017 8:33 AM
One thing that I would like to see taken care of ASAP (and could use some support on :D) is:
Trusted Assemblies are more problematic yet less functional than Certificates - Please Remove
Voted for a few. Forgot about these.

Thanks :). I forgot to mention that my request to have "type" / "type_desc" columns added to sys.databases is similar in nature to your request for:
Add Is_MasterKey to sys.symmetric_keys
which I voted for a while ago :).

Also, my complete list of requests and bug reports can be found at:
https://SqlQuantumLeap.wordpress.com/connect-items/

SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

allinadazework - Friday, September 15, 2017 1:36 AM
I dutifully tried to upvote the "string or binary data truncated" on the link you gave in this article. You can't! It's closed for voting. So presumably that means it is now either well in hand or has been ignored?

Solomon's correct - you have to be logged in to vote. I just did and the vote is currently 1561 to 5. I don't know if that's lopsided enough for Microsoft to take action. It was created on 4/22/2008. On the bright side, only 7 more months before it's 10th birthday.

One of my favorite connect items is for a built-in table of numbers at https://connect.microsoft.com/SQLServer/Feedback/Details/258733 started by Erland Sommerskog on 2/18/2007. It'll have its 11th birthday in 5 more months. :crazy:

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

I've found that CONNECT is pretty useless for suggestions unless that suggestion can be used for serious marketing. It's a somewhat beneficial dictatorship. Considering some of the suggestions, that's not a bad thing but that seems to bleed over into some of the more useful, if not marketable, suggestions.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

x SSC-Insane Points: 23660 More actions · Answer 8

Regarding the connect item about truncations, its worth noting that a Microsoft person gave feedback in the thread in 2016. I think its worth noting this and giving credit that someone did show up in the thread and has also mentioned that there has been some difficulties in implementation.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 9

allinadazework - Friday, September 15, 2017 1:36 AM
I dutifully tried to upvote the "string or binary data truncated" on the link you gave in this article. You can't! It's closed for voting. So presumably that means it is now either well in hand or has been ignored?

I just up voted it so it's still truly active.... well... if you want to call no action taken so far and some year old excuse from MS "active". You DO have to be logged in.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)