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 132 of 132 (1,320 total posts) < 1 second(s)
  • re: SSIS Design Pattern - Dynamic SQL

    Hi test, &nbsp; This works fine for others. I will be happy to work with you if you are experiencing an error / issue with the code. Please email me at :{&gt; Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 31, 2007
  • Iteration = Maturity

    Introduction&nbsp; I was recently reminded that iteration matures software. The History of Andy, Part 1&nbsp; Like many DBAs, I was a software developer in another life. I built web applications - working my way up from HTML through DHTML and finally to ASP - and could regale (and bore) you young whipper-snappers with war-stories of how things ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 31, 2007
  • re: Introduction

    Welcome Sarah! I look forward to learning some cool SQL Server tuning and corruption stuff from you! :{&gt; Andy
    Posted to Sarah Henwood (Weblog) by andyleonard on July 23, 2007
  • SSIS Design Pattern - Dynamic SQL

    Introduction I&nbsp;sometimes miss the ActiveX task in DTS. It was cool because ''if you could see it, you could change it.'' I used the ActiveX Task to generate dynamic SQL. When To Use Dynamic SQL In SSIS There are lots of uses for&nbsp;dynamic SQL in SSIS. If you find yourself using the same SQL statements over and over again with minor ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 22, 2007
  • PASS Webcast Thursday

    Although it doesn't mention my name on the PASS website, I'm presenting the PASS webcast tomorrow on Team Edition for Database Professionals. If you're interested you can sign up to attend at the PASS website. Hope to see you there! :{&gt; Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 18, 2007
  • re: SSIS Design Pattern - Incremental Loads

    Thanks Alberto! Checking it out now. :{&gt; Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 13, 2007
  • A Follow-up to Database Professionals: An Enterprise Requirement

    Eric Wise drew some heat from the developer community at with this post about the need for a DBA during development&nbsp;(see my post on the subject here). I think Eric makes a couple good points, one explicit, one implied: 1. (Explicit) A DBA - or Database Developer, more accurately (and there is a difference)&nbsp;-&nbsp;adds ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 13, 2007
  • Database Professionals: An Enterprise Requirement

    A friend (who shall remain nameless) recently told me his company interviewed a competent database developer and DBA. All seemed in agreement an offer would be forthcoming until the very end of the recruiting process. At that time, someone made the comment ''we don't need a DBA.'' It would be notable if this sentiment wasn't&nbsp;so widespread - ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 12, 2007
  • Which "flavor" DBA are you?

    This re-post from my&nbsp;Applied Team System blog (which was a repost from my old SQL Server Central blog)&nbsp;was inspired by James Luetkehoelter's Agile Development and the ''DBA''&nbsp;post a few days back. I'll have more to say about&nbsp;database developers, agile methodologies, and the need for a DBA in posts to ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 10, 2007
  • SSIS Design Pattern - Incremental Loads

    Update: For more up-to-date material on this topic, please see the&nbsp;Stairway to Incremental Loads&nbsp;at&nbsp;SQL Server Central&nbsp;for more information! (Free registration required).&nbsp;&nbsp;Introduction &nbsp; Loading data from&nbsp;a data source to SQL Server is a common task. It's used in Data Warehousing, but increasingly ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 9, 2007
Privacy Statement