THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 2 of 135 (1,349 total posts) < 1 second(s)
  • Why Automate?

    Because, as Jen Underwood (jenunderwood.com | 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
  • Parsing SSIS Catalog Messages for Lookup Performance, v2

    A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups. Ive updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalogs default Logging Level). Some smart data integration people recommend setting the SSIS Catalog Logging ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2017
  • re: Biml Express Metadata Framework

    I know the good people at Varigence are working hard on the next release. Like Earnest and Julio Gallo, they will release no software before its time. Hang in there, sir. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on March 6, 2017
  • Use Amazon’s Alexa to Create a Copy of a Database Using Redgate SQL Clone…

    and win an Amazon Echo Dot and one lucky winner will score a free SQL Clone license! About SQL Clone I can hear you thinking, Whats SQL Clone, Andy? Im glad you asked! SQL Clone is a database provisioning tool that removes much of the time and disk space needed to create multiple database copies. With SQL Clone, database copies can be ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 6, 2017
  • re: An Example of Data Integration Lifecycle Management with SSIS, Part 3

    Hi Tom, &nbsp; Great question, sir! &nbsp; The example that leaps to mind is SSIS developed for regulated industries. I've built a lot of SSIS for government, medical, and financial-related enterprises (sometimes all three at once). It's common for agencies and enterprises in these fields to audit the software for regulatory compliance. ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 2, 2017
  • re: The Recordings for SSIS Academy: Using the SSIS Catalog are Available

    Hi Scott, &nbsp; I just verified all three links work. &nbsp; The video was not recorded for the first 4:15 of the first webinar. There's audio, but no video. Apologies for that. Andy
    Posted to Andy Leonard (Weblog) by andyleonard on March 2, 2017
  • Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!

    Im honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday Richmond 18 Mar 2017! The Biml Express Metadata Framework is the sample code for this presentation. Its part of the DILM Suite. I hope to see you in Richmond! :{&gt; Learn More: SSIS Design Patterns and Biml: A Day of Intelligent Data Integration Boston ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 22, 2017
  • Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!

    Im honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday Raleigh 11 Mar 2017! You can download the sample code for this presentation at the DILM Suite website here. I hope to see you in Raleigh! :{&gt; Learn More: SSIS Design Patterns and Biml: A Day of Intelligent Data Integration Boston SQL Saturday precon, 24 ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 21, 2017
  • Creating SSIS Packages with the SQL Server Import and Export Wizard

    This material was originally posted on the Linchpin People blog. In this post, I demonstrate how to use the SQL Server 2012 Import and Export Wizard to create a SQL Server 2012 Integration Services (SSIS 2012) package. The demo is created on a virtual machine running Windows Server 2012. You can use the SQL Server Import and Export Wizard to ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 20, 2017
  • Long Poles and Critics

    As a consultant, I get calls to complete projects started by someone else or extend projects completed by someone else. When I look at someone else's work it's sometimes tempting to say, &quot;Wow - they did that wrong.&quot; But I don't. Instead I say, &quot;I'm not sure why they built it this way.&quot; That may sound back-handed but I make sure ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 18, 2017
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement