Scripting Environments in SSIS (SQLServerCentral 3/2/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Scripting Environments in SSIS]( - [SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python]( - [The top 7 benefits of DevOps for CEOs]( - [Distributing SSH User Keys via PowerShell]( (From the SQLServerCentral Blogs) - [Using a gMSA with SQL Server]( (From the SQLServerCentral Blogs) The Voice of the DBA Data Decisions or Instinct? This editorial was originally publiched on July 24, 2014. It is being republished as Steve is out of town. Most of us that are data professionals think the best way to make decisions is to use data to justify some course of action. We look for patterns in data, some guidance that the information we have will lead us to make the best choice for our organization. Google has talked about [making data driven decisions]( as a part of their success and they think more organizations should do this. Any number of other companies also use data to power their BI systems and dashboards that help their employees make better choices. That seems in contrast to [this piece from the Harvard Business Review]( that says that great decisions don't start with data. It talks about using stories and emotions, with a few key facts sprinkled in, to help sell ideas and get decisions made. On one hand I agree that stories help to sell decisions, but I often have found that successful salespeople use this technique to deceive and convince by plucking emotional heartstrings, and using relatively little data. In my mind, the best way to make decisions is to go with your instincts, but while examining and understanding the data. You can't discard data, especially when it presents strong patterns. However data can be deceiving when we don't carefully examine the ways in which it's put together. An average doesn't always reflect the actual value of a set of numbers, especially when we don't also understand the range, standard deviation, and count of values. We also have to realize where we do and don't have experience and expertise in some subject. We should certainly look to data to guide us and perhaps even justify our decisions, but we can't forget that the human brain is still an important part of any computational exercise. We need employees that you use their judgement, in collaboration with data, to make the best decision for our organizations. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [Database DevOps]( Continuous Delivery for SQL Server Databases Spend less time managing deployment pain and more time adding value. [Find out how with database DevOps]( [SQL Monitor]( Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. [Download SQL Monitor now and get a 14 day free trial]( Featured Contents  [] [Scripting Environments in SSIS]( Jeff Jordan from [SQLServerCentral.com]() Demo and script on how to script out SSIS Environments and their associated variables[More »](Services+(SSIS)/135173/) ---------------------------------------------------------------  [] [SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python]( Additional Articles from [SimpleTalk]() Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.[More »]( ---------------------------------------------------------------  [] [The top 7 benefits of DevOps for CEOs]( If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and here’s the thing – what if the person down the corridor was asked the same question? Someone who works in the same place, but does a different job.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Distributing SSH User Keys via PowerShell]( Anthony Nocentino from [SQLServerCentral Blogs]( Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Using a gMSA with SQL Server]( Wayne Sheffield from [SQLServerCentral Blogs]( As you already know, SQL Server runs as a service. And services require a service account to run under. While...[More »]( Question of the Day Today'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 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: Table Value Constructor (TVC). 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 [SQL Server Query Store In Action]( The Query Store changes the way you monitor performance on your databases and the way you tune the performance of those same databases. This book represents a deep dive into a large number of topics in and around the Query Store. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I've got some data that contains US postal codes. This data is stored in a numeric field. If I use the FORMAT() function, what format string should I use to ensure that any leading zeros are replaced with a real 0 and the rest of the numeric values are returned correctly? What string is the second parameter of the FORMAT() function. Same data: WITH myvalues AS ( SELECT n FROM ( VALUES (123) , (80138) , (2910) ) AS a (n) ) SELECT TOP 10 FORMAT(myvalues.n, ?) FROM myvalues; Answer: 'nnnnn' Explanation: The formatting string of 0 with n's will return a leading zero to pad the length if there are not enough digits and the actual digit otherwise. Ref: FORMAT - [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 2017]( : [SQL Server 2017 - Administration]( [How would you lock down a SQL DBA to have local admin on the SQL box]( - I would like to know if we can create a separate group or what permissions on the server should be... --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Development]( [CTE Crazy: Sums, Counts and Pivots I'm missing something here]( - I've not had to use SQL for a while and I'm having trouble getting to grips with aggregates again. In the... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [DTSX Pkg From Stored Procedure (completely frustrated)]( - Help please!! I am bruised and bloodied from mashing my head, for two weeks now, against stuff I do not... [Best way to handle moving data in a varchar(max) field?]( - Any ideas how to efficiently move a lot of rows from a table in the OLTP to an archive on... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [How does SQL Server handle concurrent operations?]( - Hello, We are having an issue which I suspect is database related. We have a web application on which we can... [AVG a range of dates while grouping them by supplier]( - I have multiple suppliers with a purchase order date. I'm trying to calculate the average time between purchase orders but... [SSRS Report: Any way to copy or download either an RDS file or the text needed to create one?]( - It's been a while since I dealt with SSRS.  Am hoping to find an easy way to either download a... [SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ?]( - Hi everyone, I am experiencing a performance issue with one process in our system. The performance issue is intermittent, the users... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [SQL Server 2012, update Stats and Index Organize taking 16 hours for execution??]( - Hi, We have SQL Server 2012, On production database SQL job update Stats and Index Organize taking 16 hours for execution. Size... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Rounding issue]( - How do I round 0.85415 to 1 ? I am getting a 0 instead . Thanks, [How to handle very large dataset]( - I need to find the most recent post date for all the invoices in my table. There are millions of... [finding the right index]( - We use a program for EDI in our company. One of the screens shows us a list of sent documents. ... --------------------------------------------------------------- [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... [DBase DBF files import, but having trouble with DBV Memo files]( - Hi guys, I am trying to convert an old Dbase application to .NET / MS SQL. I had no problems getting a linked... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [removing dups for update]( - This is the temp table I have ID   empnum   email   fName   lname 1   123           a@a.com   tim   slim 2   124          & [union with constant values]( - Hello, I'm doing this: ... union select  'EVY', 'Everyone', ... from  ... where  ... and @Grouping = 'false' That @Grouping = false still returns the row if the value is true.... [Assistance with fixing the output of a query to be used for a datafeed.]( - I have written the query below which returns the data in format shown in the screenshot shown below. For the... [Splitting a Full Name]( - I'm trying to split a full name column up into First / Middle / Last....but some of the names are like "Joe... --------------------------------------------------------------- [Data Warehousing]( : [Strategies and Ideas]( [Data Warehouse automation tool suggestions?]( - I'm looking into the available tools in preparation to develop a first data warehouse, if you've used a Data Warehouse... --------------------------------------------------------------- [SQL Server 2005]( : [T-SQL (SS2K5)]( [Find birthdays of a week]( - Hi, Assuming that the week starts from Sunday and ends on Saturday,can anyone provide me with a query to find all... 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