SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

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

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

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Compare

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

Database DevOps Demo Webinar

Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now

Featured Contents


A Pattern for Email Address storage and retrieval

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 »


SQL Server R Services: Digging into the R Language

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 »


From the SQLServerCentral Blogs - What is networking, really?

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 »


From the SQLServerCentral Blogs - Offtopic: Lifehack: Old tech has many purposes

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 »

Question of the Day

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.


The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

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

Yesterday's Question (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

 - http://www.sqlservercentral.com/articles/Stairway+Series/134869/

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

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

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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

SQL Server 2014 : Administration - SQL Server 2014

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

SQL Server 2012 : SQL 2012 - General

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

SQL Server 2012 : SQL Server 2012 - T-SQL

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

SQL Server vNext : SQL Server 14 - Administration

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

SQL Server 2008 : SQL Server 2008 - General

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

SQL Server 2008 : T-SQL (SS2K8)

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

SQL Server 2008 : SQL Server 2008 Performance Tuning

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

Reporting Services : SSRS 2016

Cannot remote connect report server outside virtual Machine using ssms 2016 -

Data Warehousing : Integration Services

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

SQLServerCentral.com : Articles Requested

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

SQL Server 2005 : T-SQL (SS2K5)

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 {user_email}. 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