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 5 of 137 (1,361 total posts) < 1 second(s)
  • Presenting Use Biml to Automate SSIS Design Patterns at #TriPASS 18 Apr!

    Im honored to present Use Biml to Automate SSIS Design Patterns at the Triangle SQL Server User Group in Raleigh, NC 18 Apr 2017! especially since I missed SQL Saturday Raleigh last month due to illness. Abstract Perhaps youve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, Why is everyone so excited ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 17, 2017
  • Quick Regions in SQL Server Management Studio (SSMS)

    There are a few tools and add-ins that support the creation of regions in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate sections of long-ish T-SQL scripts natively, by using begin/end: To demonstrate, start with a snippet of T-SQL that includes begin/end: If you click on the - highlighted above, the code will ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 14, 2017
  • Data Wrangling Concepts: Latency and Staleness

    Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterprise Data &amp; Analytics helps enterprise data integration teams reduce latency and staleness. ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 13, 2017
  • Big Data vs. Sampling

    Merriam-Webster defines sampling as: the act, process, or technique of selecting a suitable sample; specifically :&nbsp; the act, process, or technique of selecting a representative part of a population for the purpose of determining parameters or characteristics of the whole population a small part selected as a sample for ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 8, 2017
  • The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!

    The recording for the webinar Biml in the Enterprise Data Integration Lifecycle is now available (registration required). The password for the meeting is BimlRocks. You may be reading this post and thinking, But Andy, I dont recall seeing anything about this webinar until just now. Thats entirely possible. I advertised this webinar in ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 31, 2017
  • Changes to PASS Summit Program Selection Process

    Wendy Pastrick [Blog | @wendy_dance], (my friend) who leads the PASS Program effort on the PASS Board, recently wrote Changes to the PASS Summit 2017 Program, Pre-Conference Call for Interest, and a Community Survey. The PASS Summit 2017 Program will be somewhat different from previous years. Different in what ways, Andy? Excellent question, and ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 29, 2017
  • re: Intelligent Data Integration, SSIS Design Patterns, and Biml

    Hi Garry, &nbsp; &quot;Pipelines&quot; are created when an SSIS developer configures an adapter in a Data Flow Task. This happens when, for instance, you add an OLE DB Source adapter to a data flow and configure it to connect to a source database via an OLE DB Connection Manager. At that point, a data flow pipeline is created and configured to ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 28, 2017
  • Please Blog

    My name is Andy and Im a blogger. I encourage you to blog, too. Why? Because you know stuff. I need to learn some of the stuff you know. Youve experienced stuff. Id like to read your experiences again, to learn from them. Others feel the same way. I dont have anything to say. Thats simply not true. You have plenty to say. Maybe its ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 22, 2017
  • The Recording for the SSIS Catalog Compare Version 2 Launch Event is Available

    /The recording for the SSIS Catalog Compare Version 2 Launch Event is now available for viewing (registration required). Enjoy! :{&gt; Learn More: SSIS Catalog Compare Join the DILM Suite Mailing List
    Posted to Andy Leonard (Weblog) by andyleonard on March 14, 2017
  • Why Automate?

    Because, as Jen Underwood ( | LinkedIn | @idigdata) states in an upcoming podcast: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. Whats the long pole in data science? Data Integration is the Long Pole According to Lars Nielsen in his book ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 12, 2017
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement