 | A community of more than 1,600,000 database professionals and growing |
| | | Voting for Change 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. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.2MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | 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 |
|
|
|
| | |  | Jeff Reinhard from SQLServerCentral.com 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 » |
 | Additional Articles from SimpleTalk 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 » |
 | Mala Mahadevan from SQLServerCentral Blogs I am still trying to get up to speed on blogging after a gap. Today I managed to push myself... More » |
| | Daniel Janik from SQLServerCentral Blogs For those that don’t know, I live in Texas. Been here all my life. There are two main things north... More » |
|
|
| | | Today's Question (by Steve Jones): I have created a list in Python like this: >>>mylist = [] I want to add an element to the list. What syntax will add the string, "Porsche", to the list? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Python. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | 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 |
| | |
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Best way to keep users/logins/mappings syncrhronized in HAG between primary and secondary replicas? - We recently had a network issue and the availability groups failed over from the primary to the secondary. The next...
Convert Teradata CASE to t-SQL CASE with CAST and an Operator - Hello, I've got a Teradata Case statement, and I'm trying to convert it to a T-SQL Case statement, and I... ssrs 2016 pivot capability over tabular models - Hi, my tabular model has survey data with various dims including interviewer (employee), form, study, case #, questions etc. And the core...
Unable to restore the DB. - I am creating a new database from the backup I have. It has been running for half an hour now... High Memory consuming by Database - Hello Everyone, I have a database which size is 250 GB and it contains the information about 70 Lak users with...
Can't connect to SQL Server via IP - Have SQL Server installed on a Windows 7 machine which is being used as a server (not my idea). Company...
Creating a table from existing table. - I have a table which is 175GB in size. I am working on getting only the data from August and... best data modeling tool - Hello, I am looking for a cheap and highly efficient data modeling tool for my SQL server 2008 r2 and 2012...
No Data in a table when database is restored - Got a bit of an unusual one that's got me scratching my head. I'm covering a colleague while they are on... How does a integer/any data record store in SQL Server page - Hello Experts, I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page architecture in SQL Server....
Occasional mysterious time outs on SQL Server db table - Hi there, We have users in the field who use a mobile web GIS application (using Java) which use forms to edit/update spatial... Determining Memory Pressure - Dear Experts, I'm trying to figure out if my SQL server is facing any memory pressure . Its a 64 GB memory...
Date Causing Problem - I've got an interesting one with a date in a query. The first where clause in the query runs in 30...
Error: 18056, Severity: 20, State: 46. - Hi Everyone, i am getting the following error message in sql server error log. Error: 18056, Severity: 20, State: 46. The client was...
Cannot remote connect report server outside virtual Machine using ssms 2016 -
Need to create a "done" file step. - Hi, I've created a package that copies two flat files from a remote location to a standard ssis flat file network... New company use c# code instead of SSIS - Joined this new company which does ETL using c# code instead of SSIS. They said they did this because it's... Integrating SSIS with Google Adwords and Big Query - Hi All, We are working on some project, wherein we have to integrate SSIS packages with Google Adwords and Big Query. As...
Basics of Statistics (data distribution) - I would like a basic article to explain how statistics are captured for SQL Server tables and updated (auto/manual). A...
how to convert seconds to time in sql - hi, Could you please give any formula for that to convert seconds to time... Thanks, Giri |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| 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.
| This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|