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 129 (1,281 total posts) < 1 second(s)
  • Agile or Waterfall?

    Waterfall project management is a serial approach to the phases of a project. Proponents of waterfall methodologies hold its best to plan: gather requirements, design the solution, develop it, test it, deploy and maintain it in discrete steps. Critics maintain it is impossible to know all of the requirements prior to design or development. ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 20, 2016
  • PASS Board Elections–Voting is Open!

    Update: Voting is closed and the winners have been announced! Whether you get an email from the PASS organization or not, voting is now open for the PASS Board. Visit the PASS website and log in. You should see the myPASS page: &nbsp; If youre eligible to vote, your page should appear similar to mine, shown above. Click the Vote Now button ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 5, 2016
  • Managing the SSIS Catalog

    The SSIS Catalog is surfaced within the SSISDB database. In this post I describe some tips for managing your SSIS Catalog database, named SSISDB. Create the SSIS Catalog To create the SSIS Catalog, connect to an instance of SQL Server using SQL Server Management Studio (SSMS). Open the Object Explorer and right-click the Integration Services ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 24, 2016
  • re: SSMS release 16.4 is now available For those looking: v16.4.1 is available at the link Dany provided (and I copied) above. Developing and testing software is hard. Thanks for fixing this release so quickly, SQL Server Team! :{&gt;
    Posted to Andrew Kelly (Weblog) by andyleonard on September 24, 2016
  • 2017 SQL Skills SSIS Immersion Events

    Im home after a day of travel that included waking up at quarter-til-early to catch a cab to SeaTac with Tim Mitchell [blog | @Tim_Mitchell], bumpy flights, and a two-hour drive back to Farmville. We had a fantastic time! Our students asked lots of interesting questions and Tim and I were, I believe, able to answer them all (with a little help ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 24, 2016
  • A New Version of SSDT is Available

    Microsoft released an update to SQL Server Data Tools (SSDT) 2016 on 20 Sep 2016 the tool used to design databases, SSIS, SSRS, and SSAS solutions. I can hear you thinking, How do I get the update, Andy? You can get version 14.0.60918.0&nbsp;here. If you have the installer for SQL Server 2016 handy, you can get to the download link very ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 21, 2016
  • I Was Wrong (About the SSIS Catalog)

    I apologize for misleading people who read my writings and have heard me speak on the topic of the SSIS Catalog. Heres what I recently realized: The execution_id is different from the operation_id in the SSISDB database. In the past, I complained about the execution_id and operation_id being the same value and meaning different things. To be ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 21, 2016
  • re: Value

    Agreed, Greg. It's an easy mistake to make (focusing on the costs of development instead of TCO). I understand it. I want to help people see the bigger picture. :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on September 20, 2016
  • Value

    One of our mottos at Enterprise Data &amp; Analytics is, Deliver Value. I can hear you thinking, Thats nice, Andy. What does that mean? Im glad you asked. !Value Lets start with what value is not, shall we? Value is not the least expensive. As a consultant, I often bid for consulting work, sometimes referred to as gigs. How does ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 20, 2016
  • re: PASS Summit 2016 Speakers

    Hi Davide, &nbsp; I requested to not be renewed as a SQL Server (now Data Platform) MVP in 2012 and have not sought the award since. It was truly an honor to be an MVP for five years. But, like speaking at the PASS Summit, being an MVP is also a zero-sum game. Although this wasn't my sole motivation, it *was* time to give someone else a ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 15, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement