Display SSIS package version on the Control Flow design surface (SQLServerCentral 4/28/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Display SSIS package version on the Control Flow design surface]( - [SQL Clone Trivia Quiz - win a $10 gift card every weekday in April]( - [Getting Started with Azure SQL Data Warehouse - Part 3]( - [Book Review – The Truthful Art]( (From the SQLServerCentral Blogs) - [Using Twitter with VS Code]( (From the SQLServerCentral Blogs) Featured Script - [Find and Replace a value across all tables in database]( The Voice of the DBA Starting to Use SQL Server 2017 We'll have a new version of SQL Server this year. If you missed the [Data Amp keynote](, in it Scott Gu announced the name as SQL Server 2017, which I assume means we'll have installable RTM bits sometime this year. Maybe in June, maybe August, maybe later. In any case, there are some interesting changes coming, though not a ton. We will get a new platform (Linux) and certainly [some nice improvements in a few areas](, but overall a limited release. Given this will be a year or so after the last one, that's not surprising. This rapid release cycle means that all of us [will support more versions of SQL Server](. I don't know many organizations that wholesale upgrade all their servers. The last time I saw that at any size was in SQL Server 2000, and even then it was painful. Since then it seems many organizations will add some instances of new versions, but continue to support old versions. The more people I talk to, the more I think the ten year rule does exist in many companies. I met someone years ago that said their company (Fortune 100) expected any server installed to run for ten years. Period. That seems to be the case. Lots of people still have SQL 2005, or at least SQL 2008 instances. A few SQL 2000, and certainly newer versions, but a mix. Keep that in mind, as most of your companies will move forward with new work even as you support old server. This week I wanted to ask, when do you think you'll have SQL Server 2017 in production. Realistically, when will you have a 2017 platform running a live workload. I don't care how big or small, Windows or Linux, bare metal or in a container. When will you start to use resumable index rebuilds, graph structures, adaptive query processing or more? Will it be in 2017? 2018? For budget or other reasons, later than that? I'm at an interesting place. We still run SQL 2008 at [SQLServerCentral](, and it works fine. The site needs a basic relational system, though certainly some of the T-SQL changes in 2012+ would be welcome and make some code easier to write. The thing is, code is already written and most things work. We're debating going to 2016, but I wonder if we shouldn't just aim at 2017, get one more version ahead, and delay the next upgrade for another decade. I'm certainly tempted as most of the work we through at the database is simple relational work that really would run on SQL 2000 if it had to. Regardless of when you might upgrade, are you interested in doing so? Anything catch your eye in the new version? Or have you not even bothered to pay attention? All valid answers, and I'm interested in your view of the new platform. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [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]( State of Database DevOps Report Learn how teams are extending DevOps practices to SQL Server databases. [Get the report.]( Featured Contents  [] [Display SSIS package version on the Control Flow design surface]( Herman van Midden from [SQLServerCentral.com]() In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.[More »](Services+(SSIS)/127927/) ---------------------------------------------------------------  [] [SQL Clone Trivia Quiz - win a $10 gift card every weekday in April]( To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.[More »]( ---------------------------------------------------------------  [] [Getting Started with Azure SQL Data Warehouse - Part 3]( Additional Articles from [Database Journal]() Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Book Review – The Truthful Art]( Koen Verbeeck from [SQLServerCentral Blogs]( I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Using Twitter with VS Code]( Rob Sewell from [SQLServerCentral Blogs]( So today I saw this tweet from Mathias in reply to Stefan and Amanda  That looks cool. Twitter in VS Code, one...[More »]( Question of the Day Today's Question (by Ben Kubicek): When Redgate Data Tools are installed in Visual Studio 2017 Enterprise, what key combination can you use to auto format SQL statements? 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: auto format sql. 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 [T-SQL Querying (Developer Reference)]( Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. [Get your copy from Amazon]( today. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I am creating a Database Encryption Key for use in TDE. What are the options for an algorithm in SQL Server 2016? Answer: Triple-DES or AES (128, 192, 256) Explanation: The algorithm options are: Triple-DES or AES (128, 192, 256) Ref: Database Encryption Key - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Featured Script [Find and Replace a value across all tables in database]( Devendra Thakur from [SQLServerCentral.com]() 1. Copy and Paste the script. 2. Update the values @SearchThis='goodmorning' @ReplaceWith='good morning' 3.Execute the script. [More »]( 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 - Development and T-SQL]( [Extract only the filename from a file path]( - Hi Folks, is this really the best way to extract the file name from a file path? select replace( reverse( left( reverse(physical_name)  , charindex('\', reverse(Physical_Name))  )  )  , '\', ''  ) as... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Best monitoring tool]( - Hi ! I´ve searched the forum for tips on monitoring tools for SQL servers and found one topic that hasn´t have... [Script to restore production database to test server]( - Is there a simple and clean script that can copy a full backup of a database and restore the database to  a... [Query Performance Standards - Overall Per DB]( - Good morning fellow SQL server folks! I have a general question regarding Query Performance standards. If you have them, what... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [DMV sys.dm_db_index_physical_stats: Detailed vs. Limited]( - When I run the following two queries. I get drastically different results.  I don't understand why. select o [Function return values]( - I have a function that returns a table of values and i like a way to list those values in... [Selecting all text between a distinct path]( - Hi, Im trying to get all the text between the third backslash and fourth backslash based on a select query - can anyone... [SQL Agent job intermittently fails to execute SSIS package]( - I need some suggestions for troubleshooting this issue. I have the following setup:  Application T-SQL I have SQL code in an... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [SQL SERVER 2012 Best Practice regarding Web apps connecting to SQL Server]( - With regards to security, what is the best practice regarding Web Applications connecting to SQL Server 2012 Databases. Thanks in advance! [TEMPDB log growing HUGE]( - Running SQL 2012 SP3 CU6 AlwaysOn.... we had an issue two nights ago with the tempdb log filling the log disk.... [Stored Procedure for Dynamic Query in Sql server]( - I need procedure for below dynamic query.In that procedure f_id and value is input parameters. f_id and value is collection of... [unexplainable perfomance]( - We are currently experiencing  some strange phenomenons, and I am hoping that someone may be able to shed some light... [creating new partition files on table]( - hello all,  I have a table that has 2,948,231,398 billion rows...I know...last week I had to figure out how to... [SQL Server core usage]( - Hi all I've been doing a bit of a check on some our servers and found something odd in the logs. I've... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Query Help - For Duplicates]( - Hi I need to find duplicate AID will be unique base on Name so I need to find duplicates on KeyValue... [How to manage temporary tables]( - Dear MVPs I hope you are all doing great I am troubleshooting why my Transaction log for one application keeps... [Unpivot column to rows dynamic sql]( - Hello, I was tasked to move the following data to our database and visualize through Cognos, so the data is currently... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Are we doing something wrong in specifying how the user is to access our database, using different schemas?]( - I'm having problems making a test user account access the database for a new app we're writing. Whenever I try... [Querying NULL dates]( - Is it redundant to write something like this in the where clause............? where AdmitDateTime is not null and AdmitDateTime>='2016-04-01' --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [Attempted to perform an unauthorized operation]( - Hi, I'm installing SQL Server 2008 x64 developer edition on Windows Server 2008 x64. I installed the SQL Server 2008 many... This email has been sent to {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