THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 138 (1,377 total posts) < 1 second(s)
  • re: Secure Connections Management in SSIS, Part 2

    Hi Ben, &nbsp; I usually store the Connection String property of the Connection Manager - *as shown in the Properties of the Connection Manager* - in an external store (a Config file for non-Catalog deployments, a Catalog Environment for Catalog deployments). For SQL Server Logins, I externalize the Password property separately. &nbsp; If ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 30, 2017
  • re: Secure Connections Management in SSIS, Part 2

    Hi Ben, &nbsp; When you change the ProtectionLevel to EncryptSensitiveWithPassword, you need to supply a password and then redeploy the package. Hope this helps, Andy
    Posted to Andy Leonard (Weblog) by andyleonard on June 28, 2017
  • Almost…

    This is my 899th post at And my last. I made it to almost 900 posts and to almost 10 years. Blogging at SqlBlog has been an honor. Ive described the site as a bunch of really smart bloggers. Plus me! Id like to thank Adam Machanic for inviting me way back in July 2007 and for putting up with my shenanigans all these years. ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 21, 2017
  • New Article: Help for DBAs Who Support SSIS at SQL Server Central

    My latest article, Help for DBAs Who Support SSIS is now live at SQL Server Central! In this article I share some tips and tricks for using SSIS Catalog Compare for surfacing SSIS Catalog metadata, comparing SSIS projects deployed to different SSIS Catalog, and Scripting SSIS Catalog configurations metadata (such as Environments, Environment ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 20, 2017
  • New Data Driven Episode: Rimma Nehme on CosmosDB, Planet-Scale Applications, and Selling Door-to-Door

    This week on Data Driven, Frank and I are honored to interview Rimma Nehme, CosmosDB Architect at Microsoft. We had a fantastic time chatting about CosmosDB, open-source, reading, and what (or whom, rather) Dr. Nehme finds really important. As always there are movie references: Blues Brothers and Spiderman are quoted this week. Notable Quotes ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 20, 2017
  • We Are Part of an Awesome Community

    As I type, SQL Saturday-Dublin 2017 is winding down for me. Theres a Viking Splash Tour planned for tomorrow but Im off to London to deliver some Biml Training and will have to miss the fun. Reflecting on my first trip to Ireland, it occurs to me that we are part of an awesome community. #SqlFamily is often used to describe the SQL Server ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 17, 2017
  • Announcing Data Science Daily

    At Data Driven were experimenting with new show formats especially what we call mini-shows. Earlier this week we started a new feature called Data Science Daily. Frank has done an outstanding job on these first three installments! Wed love your feedback. What do you think of the shows so far? If youre so inclined, please leave a review ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 15, 2017
  • re: The SQL Hall of Shame

    My friend Kevin Hazzard refers to JSON as &quot;hipster XML.&quot; ;{&gt;
    Posted to Adam Machanic (Weblog) by andyleonard on June 15, 2017
  • re: The SQL Hall of Shame

    Hi Adam, &nbsp; Interesting list! &nbsp; I can't speak much to the Integration Services connection via SSMS - I don't use it. I haven't needed it for SSIS development or administration. It could be that it's useful and I'm just unaware of how... :{&gt;
    Posted to Adam Machanic (Weblog) by andyleonard on June 15, 2017
  • New Data Driven Episode: Mark Tabladillo on Data Science Teams, Bots, Personhood, and Dancing

    This week on Data Driven, Frank and I are honored to interview Mark Tabladillo, Lead Data Scientist for Microsoft Services: Data Insights Domain Center of Excellence. We talked about lots of stuff including Data Science teams, bots, personhood, and dancing. Notable Quotes No brakes on the F train. (2:10) On data munging (15:00) On MS ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 13, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement