SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Decouple the Tools

For years, SQL Server included a complete set of add-ons with the main product. We got SSIS, SSRS, and more as part of an integrated installation. This also included things like Books Online and various tools, such as Profiler, bcp, and Management Studio (Enterprise Manager in earlier versions). Over the years, the number of tools has grown, but there has also been work to decouple some of these items from the installation media and allow them to be upgraded more rapidly. Books Online was the first to separate, though not without some pain for users that struggled to install the local help files.

Last year SSMS was decoupled from SQL Server, which I think is a great idea. The tools team at Microsoft moved to their own release schedule, getting SSMS onto the Visual Studio 2015 platform. This wasn't without some pain, and there were definitely some releases with issues, but overall the process has smoothed out and I've appreciated the updates. This separation has allowed new features to be added to the product without waiting for a new release. If you watch the changelog, you will see quite a few improvements and fixes being released, along with enhancements. SSMS is also free to download and install on workstations without SQL Server.

However, if you examine the installation for SQL Server, there are plenty of other products that could benefit from being decoupled. While bcp and sqlcmd don't change much, why are they a part of the server platform? These tools, along with others, are really client side tools, and would benefit from their own release cycles. Whether or not teams do significant work, or even if they only release updates when a new version of SQL Server comes out, having them as a separate set of tools, with a separate installer, means that fixes and enhancements could be sent out if there are issues. This seems especially important for security updates, which might be needed. In addition, maybe this would actually get teams to view any separate tools as worthy of new functionality if they see an opportunity.

I'd actually love to see some integrated installer for the SQL tools that would allow me to download and update them each as needed. Let me know when SSMS is out of date, along with any updates for sqlcmd, sqlmaint, tablediff, and other tools. They might not change often, but I'd rather not have to run the SQL Server installer for a CU on all my client workstations. Let me update those tools as needed, if there are changes or improvements.

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 ( 4.0MB) 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

Benchmark your Database DevOps maturity level

Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment

Featured Contents


Query to Excel Stored Procedure

Darko Martinovic from SQLServerCentral.com

Transform your query result into an Excel file using this technique. More »


Misuse of the scalar user-defined function as a constant

If you use an unverified scalar function, then the query will be grindingly slow because you will be executing it on every row whether it has a parameter or not. This post explains the issue in more depth, and shows how SQL Prompt code analysis rules can help you avoid it altogether. More »


Quality-Driven Software Development

Additional Articles from Redgate

While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle. More »


From the SQLServerCentral Blogs - STORPORT: Reading an ETL trace

Daniel Janik from SQLServerCentral Blogs

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it... More »


From the SQLServerCentral Blogs - Capture SQL Server Reported Errors using Extended Events

Dharmendra Keshari from SQLServerCentral Blogs

In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may... More »

Question of the Day

Today's Question (by Evgeny Garaev):

Which operating systems are supported for SQL Server 2017 on Linux installations? (choose 3)

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: SQL Server on Linux.

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):

I have this code, but it's giving me an error after my values clause. What should that line contain?

WITH myTally(n)
 FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10))
FROM myTally 

Answer: FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) a(n)


The VALUES clause will produce a Table Value Constructor, but for a SELECT query, I need to give this table a name and include a name for the column.

Ref: Table Value Constructor - click here

» 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

Help me in designing table and its indexes -

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

Parse SQL data and load into two different tables "Help" - Hi all, I couldn't figure it out how to parse the file and load into two SQL table. Source and destination are in...

Moving Annual Total cross tab by month with Difference in one column - Hi I'm trying to create the below without relying on Excel, but am struggling to get the difference value and % difference showing...

SQL Server 2014 : Administration - SQL Server 2014

FileTable issue - Hi Experts, I have created a filetable with full access and created a trigger on Filetable to insert the filename and...

Agent Jobs fail in time frame - Hello, My SQL Server Agent does not process any of my jobs between 12am and 2am.  The job runs for about...

SQL Server 2014 : Development - SQL Server 2014

query just runs; possible join issue? - This report used to run until i added the CTE to pull MAX Created date from the Broker Feed table. Now...

updates are not happening through ssms - hi, I have created after insert ,update,delete trigger for one of the table.The table does not have any primary key.When we...

SQL Server 2012 : SQL 2012 - General

Query Taking more time to Run - In this stored procedure, the query is taking a lot of time to return the results. Is there any way...

running total max value by group - Hi all, i want a running total but with 2 clauses for the counter, the counter restarts when the total is...

Huge table.and poor performance. - Hi I have one table with 800 million rows. Per month an extra 12 million records are added, all a summary...

SQL Server 2008 : SQL Server 2008 - General

How can I leave only only 10 days of SQl Server logs in sql server??? - Dear Fiends inside "Management> SQL Server Logs" I want to automatically delete old logs How can I leave only only 10 days...

SQL Server 2008 : SQL Server Newbies

How to bring database just before the delete occurred. - Good Morning Experts, We are taking full backup every saturday at 9PM, differential backup daily at 9PM and transaction log backups...

Reporting Services : Reporting Services

ssrs 2010 iif statement - In an existing ssrs  2012 report, I need to modify the iif logic of the same line in a tablix....

Data Warehousing : Integration Services

Need advice on how to process Access DBs with different table structures into SQL Server - I'm looking for some guidance on how to use SSIS to process Access database files into SQL Server.  I know...

SQLServerCentral.com : Articles Requested

Two SSRS articles - By request: There is a great need for a detailed article that shows how to install SSRS using SSL certificate, including...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com