| A community of more than 1,600,000 database professionals and growing |
| | | 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.comJoin 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. 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 |
| | | | 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 |
|
|
|
| | | | | 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 » |
| | 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 » |
| | 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 » |
| | 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 » |
|
|
| | | 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. |
|
|
| |
| 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 |
| 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) AS (SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT null)) FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) ) SELECT * FROM myTally
Answer: FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) a(n) Explanation: 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. Help me in designing table and its indexes - 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... 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... 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... 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... 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... 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... ssrs 2010 iif statement - In an existing ssrs 2012 report, I need to modify the iif logic of the same line in a tablix.... 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... 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 [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
