How to deploy and execute an SSIS package from the SSISDB catalog (SQLServerCentral 12/24/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [How to deploy and execute an SSIS package from the SSISDB catalog]( - [SQL Prompt Code Analysis: Table does not have clustered index (BP021)]( - [Building Better HTML Forms in Vanilla-JS]( - [How Much Volunteer Time Per Year is a Good Goal?]( (From the SQLServerCentral Blogs) - [Indexing In Memory OLTP Tables]( (From the SQLServerCentral Blogs) The Voice of the DBA Christmas DevOps Twas the night before Christmas, when all through the place, Not a server was stirring, ‘cept the database, The DBAs sat in dim light, typing with care, In hopes of how well the deployment would fare. Their developers were nestled all snug in their beds, Whilst visions of non-clustered indexes danced in their heads, And low user traffic, connections, activity of all kind, Gave the DBAs plenty of confidence in mind. When all of a sudden there arose such a clatter, One DBA sprung from their chair to see what was the matter, To SSMS they flew like a flash, To find what had caused the poor DB to crash. The gath’ring of multiple changes to make, Had led to a rather ginormous mistake, When what to their wond’ring eyes should appear through the smoke, But several Stored Procs, which appeared to have broke, Dependencies thrown like caution to wind, A deadline appeared, and none of them grinned, Deadlocks and latches too were plaguing this night, It seemed SQL Server was up for a fight. They worked and they worked, all through the night, Weary and exhausted, no one knew of their plight, ‘til ping went the inbox, and again and again, It seemed also users were feeling the pain. “That’s it”, said one DBA, who had had quite enough, “I gave up cookies and warm milk, to have it THIS rough!?” So, with a face quite contorted by strain, They started to roll-back, but that was also pain. Trying to find who had changed what, when and why, Had them verging on madness, and shouting out “why!?!” But then, in a flash of red and green light, A man in red coat had appeared from the night. “Ho Ho Ho” he bellowed, stomach jiggling along too, “It seems at this point there’s just one thing to do!” So with a flick of his wrist and a jingle of bells, Santa highlighted the errors and all the code smells. “You see poor DBAs, you needn’t be pained!” “You just need to be agile, there’s much to be gained” “Big Bang deployments are dangers you see” “Like leaving for too long, the lights on your tree!” And like that, as if all’d been a dream, The DBAs awoke away from their screen, Twas Christmas once more and now they knew why, In the new year perhaps, we should give DevOps a try. by Chris Unwin, Sales Engineer at Redgate. You can also listen to Chris on [the DBAle podcasts](, which has this poem read aloud in [episode 7](. Site Owners 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.5MB) 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. ADVERTISEMENT [SQL Monitor]( The 4 pillars of SQL Server Monitoring 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution. [Download your free copy now]( [SQL Prompt]( Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. [Download your free trial]( Featured Contents  [] [How to deploy and execute an SSIS package from the SSISDB catalog]( Stan Kulp from [SQLServerCentral.com]() Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages. [More »]( ---------------------------------------------------------------  [] [SQL Prompt Code Analysis: Table does not have clustered index (BP021)]( With a few exceptions, every table should have a clustered index. However, they are not always essential for performance. The value of a clustered index depends on the way a table is used, the typical pattern of queries, and how it the table is updated. More important for a table is that it should have an appropriate primary key. If you cannot explain a good reason for avoiding a clustered index on a table, it is far safer to have one. Good reasons are hard to come by unless you know exactly how the table will be used.[More »]( ---------------------------------------------------------------  [] [Building Better HTML Forms in Vanilla-JS]( Additional Articles from [SimpleTalk]() Creating forms is one of the most basic skills for a web developer. It’s easy to, do but achieving the best user experience takes some work. In this article, Dino Esposito demonstrates how to improve the usability and functionality of web forms.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [How Much Volunteer Time Per Year is a Good Goal?]( Andy Warren from [SQLServerCentral Blogs]( Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Indexing In Memory OLTP Tables]( Gavin Draper from [SQLServerCentral Blogs]( Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables… In Memory Differences… There is no...[More »]( Question of the Day Today's Question (by Steve Jones): I have a data set of Christmas tree purchases by year and source location. The data is in three columns, with a sample shown below: PurchaseYear PurchaseSource PurchasePercent 2006 Farm 29 2007 Nursery 21 2008 Chain Store 31 2009 Retail Lot 32 2010 Farm 33 I want to get the changes in percentages purchases from year to year, but only among each source type. What should I add to my query below in the space where there is "xxx"? SELECT ctp.PurchaseYear, ctp.PurchaseSource , ctp.PurchasePercent - xxx AS PurchaseChange FROM dbo.ChrismasTreePurchases AS ctp WHERE ctp.PurchaseYear > 2006 ORDER BY PurchaseChange DESC 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: window functions. 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 [Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2]( Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. Pick up your copy of this great book today at [Amazon]( today. Yesterday's Question of the Day Yesterday's Question (by Kendra.Little): Which view in perfmon.exe shows you a printed list of the perf counters you are collecting along with the counter values from the most recent sample? Answer: Report view Explanation: "Report view" gives a textual listing of the counters you've selected in perfmon, with the most recent values sampled. This is useful for viewing a snapshot of a group of counters at once, but does not show you the maximum, minimum, or range of values collected over a wider period of time. --------------------------------------------------------------- [» 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]( [Problem for changing the endopoint SQL server]( - Hello everyone I configured my mirroring production server through an account that privileges sysadmin now I want to decrease the right of... [Decode waits on Object resource]( - Hello everyone, One of our servers is experiencing locks on particular objects of a production database, like for an example OBJECT: 7:480772820:27.... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [fetch multiple rows with single string]( - Hello friends, I am having table which contains data stdentname,teachername,subjectname as below. Studentname           Teachename         Subject Atish                --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Parsing Nested XML file]( - Hi , can someone please help me in getting the simple method of parsing the XML file in SSIS. I was... --------------------------------------------------------------- [SQLServerCentral.com]( : [Articles Requested]( [Article Review]( - If you are willing to review articles for others, leave a note here and others can PM you articles. Leave a... 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com