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 114 (1,134 total posts) < 1 second(s)
  • re: How Many SSIS Packages Should I Create?

    Hi Vikas, &nbsp; Did operations and support, yep. Create a package for each data flow. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on October 7, 2015
  • Relaunch!

    The website has been redesigned and relaunched by the good people at Varigence! The new site includes learning paths and tests. Its almost as awesome as Biml. Go check it out today! :{&gt; Bonus check out the new BimlScript commercial!
    Posted to Andy Leonard (Weblog) by andyleonard on October 6, 2015
  • Seeing Sharply

    My technology career began as a curiosity in 1975. I was 11 years old and living next door to an elderly couple. Their son returned from an engineering career in the Air Force and began tinkering with a microprocessor kit. I was curious and he taught me Motorola 6800 machine language. After that, 40 years ago at the time of this writing, he taught ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 5, 2015
  • re: SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions

    Greg, Steve, Kevin, and Shaun, &nbsp; Those are excellent thoughts, and solid limitations to using temporal tables to manage Type II data warehouse dimensions. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on September 25, 2015
  • re: SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions

    Hi Greg, &nbsp; I usually (not always) push application time zone management into the reporting solution. In the US, this solves issues with time zones and those pesky switches between Daylight Savings Time. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on September 20, 2015
  • SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions

    SQL Server 2016 introduces temporal tables, an interesting and data warehouse-y addition to the relational database. So how do temporal tables work? They add a couple columns to a table that are used to track the date a row is inserted or last updated, based on the primary key. Suppose you have a row that looks like this: If you begin ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 18, 2015
  • re: SSIS Design Pattern - ETL Instrumentation, Part 3

    Hi Vlad, &nbsp; If your field names are the same in the source and destination, SSIS will pick one of the fields and append &quot; (1)&quot; to the name. I hate that. I would rather alias the column names using a prefix like &quot;Dest_&quot;. Hope this helps, Andy
    Posted to Andy Leonard (Weblog) by andyleonard on September 16, 2015
  • Presenting at SQL Saturday 431–Spartanburg 26 Sep!

    I am honored to present two sessions at SQL Saturday #431 in Spartanburg, SC on 26 Sep 2015! I will be delivering: Designing an SSIS Framework in 2015 Using Biml as an SSIS Design Patterns Engine SQL Saturday #431 also features two stellar precons: Transforming and Visualizing Data with Power BI by Patrick LeBlanc and Getting the New ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 12, 2015
  • Opinions Change

    Opinions change, and they should change as more and better evidence surfaces. There are words for this: learning and growing are but two of them. Communication plays a key role in changing opinions. Ive been studying communication recently and Ive decided its a miracle anyone is ever able to communicate with anyone else. There are ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 26, 2015
  • While You Have It…

    I remind my children who live at home - the &quot;junior engineers&quot; - to deal with the things they have in their hands while they have them in their hands. Why? Because its inefficient to put something down only to pick it up later and put it where it belongs. Like all rules, there are exceptions to this. I also tell them to spend an extra ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 26, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement