Microsoft does listen to us. They've made a number of changes in SQL Server 2016/2107 in response to community votes and requests. The main way to make these is through Connect, though keep in mind that lots of items get filed, and I don't know how much consideration is given to suggestions for improvements and enhancements. I'm sure a significant amount of time is spent tracking down bugs and attempting to reproduce them.
The best way to work for change is to advocate your request and get others to vote on items. I'm sure there are hundreds, maybe thousands of good requests out there, and most of us don't have time to review them. We'll often vote only when we hear about an issue from friends or on Twitter. Even then, many of us place different priorities on issues, and might not vote for suggestions that we don't find useful. However, attention does get votes, so let people know what you would like to see.
That being said, there are a few that I ran across and thought would be worth mentioning. One that I think is an easy choice, and should have been included a long time ago is the ability to increase the number of SQL Agent log files. Just as we can increase the engine log file count, we ought to be able to do the same thing for Agent logs. Auditing and proper security should ensure we have plenty of log files for busy systems. Plus, this should be easy to change. In line with that, why not more system health session files?
I like this one for hidden columns, which might be really handy for legacy code. What I'd really like is the string or binary data truncated error to be enhanced. I can't, for the life of me, understand why this hasn't gotten some sort of fix. It's been lingering for far too long, wasting countless development hours. Maybe they could fix it with new virtual tables.
There are plenty of other issues in Connect, some of which might be very useful, quite a few of which are silly. I still think shining light on some of these and getting more votes might change the future of the product. At least, that's what I'm optimistic about.
The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.
The industry standard for comparing and deploying SQL Server database schemas
Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial
Database DevOps Demo Webinar
Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now
Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently. More »
It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots. More »
The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
At which version of SQL Server did Extended Events (XE) include all the same events that are available in SQL Trace?
Answer: 2012 SP3
Extended events includes all events in trace as of SQL Server 2012, SP3. If you have a version more recent than this, you should be using Extended Events instead of trace.
Ref: Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.