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 126 (1,254 total posts) < 1 second(s)
  • RVA (Richmond) Code Camp is Back!

    Im excited to announce Richmond Code Camp is back! Weve rebranded to RVA Code Camp and our next event is scheduled for 22 Oct 2016 at ECPI in Glen Allen, VA. At the time of this writing: Registration and the Call for Presentations are both open. We hope to see you there! :{&gt; PS Are you interested in sponsoring the event? Contact us!
    Posted to Andy Leonard (Weblog) by andyleonard on July 25, 2016
  • Free Webinar: Loading Medical Data to the Cloud

    Join Andy Leonard and Kent Bradshaw of Enterprise Data &amp; Analytics 11 Aug 2016 at 1:00 PM EDT as we discuss and demonstrate strategies for loading medical data to the Microsoft Azure SQL DB with SQL Server Integration Services (SSIS). Register today! :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on July 25, 2016
  • Stop an SSIS Package

    There are several ways to stop and executing SSIS package. If the package is executing in the SSIS Catalog, you can use the SSISDB.[catalog].stop_operation stored procedure. Stop_operation has one parameter a bigint named @operation_id. You can execute the stored procedure thus: exec SSISDB.[catalog].stop_operation @operation_id = ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 25, 2016
  • Nine Years

    Exactly nine years ago I published my very first post here at titled SSIS Design Pattern - Incremental Loads. At the time I wrote this post, the last page of my blog dashboard appeared as shown in the screenshot above. It shows the Incremental Loads Design Pattern post has received over 230,000 views in the past nine years. Thats ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 9, 2016
  • Use Catalog Compare to Migrate to the SSIS 2016 Catalog

    I recently tried to use the SSISDB Upgrade Wizard to upgrade a restored SSISDB (backed up in an earlier version) to SQL Server 2016. It didnt go well. I decided to use SSIS Catalog Compare to generate the scripts and ISPAC files from the previous instance, and deploy them to the SSIS 2016 Catalog. You Can Do That? Yes. Yes you can. Heres ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 7, 2016
  • (Attempting to) Upgrade the SSIS Catalog to SSIS 2016

    A couple people have asked me about upgrading the SSIS Catalog from previous versions to SQL Server 2016 so I decided to blog about it. The SSIS Catalog is an SSIS Execution Framework that ships with SQL Server versions starting with 2012. To execute SSIS packages using the Catalog, the SSIS project must be built using the Project Deployment ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 7, 2016
  • re: Use Biml to Remove Spaces from Flat File Column Names

    Hi Thomas, &nbsp; Yep, that'll also work - and it's just a couple lines of code! :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on July 7, 2016
  • Use Biml to Remove Spaces from Flat File Column Names

    I hate a space in a database column name. Kent Bradshaw and I are updating our demo for loading National Provider Index (NPI) file data (We plan to present on this soon more later). The NPI files currently have 329 fields and almost every one of them contains spaces: I had 5 minutes, so I decided to fix it with Biml. I first created an SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 6, 2016
  • PASS Updates to Speaker Contracts

    Adam Jorgensen, PASS President, has posted an update about the PASS speaker contract: Contributions to the Speaker Contract. Included in the post are links to the updated versions of the Summit Speaker Contract and the Summit Pre-Conference Contract. PASS leadership has put more time into this issue than they planned to and I applaud their ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 5, 2016
  • PASS Summit 2016 Speakers

    I commend PASS, the PASS Board, and PASS leadership for all their hard work putting together this years PASS Summit. From the looks of the lineup of presenters and presentations the PASS Summit 2016 is going to be another awesome event! Allen White (@SQLRunr) serves as PASS Programs Director. Although Allen has been actively engaged in ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 23, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement