THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Server » denali   (RSS)
Showing page 1 of 2 (12 total posts)
  • Confirmed: Juneau is in the next version of Visual Studio

    Its no great secret that Juneau, a collection of features in the forthcoming SQL Server codenamed Denali, will be in the next version of Visual Studio but its nice to have it confirmed all the same. I have installed the first publicly available drop of that next version (known as Visual Studio 11 Developer Preview, download from here) that was ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 20, 2011
  • SSIS Reporting Pack v0.2 now available

    In December 2010 I announced in a blog post Introducing SSIS Reporting Pack for SQL Server code-named Denali that I planned to provide a series of reports that visualised information held in the SSIS Catalog in SQL Server Denali – I called these reports the SSIS Reporting Pack. At that time SSIS Reporting Pack was a precursor to what I really ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 4, 2011
  • Debunking Kimball Effective Dates part 2 – Windowing Functions

    Reigniting the [SCDEndDate] debate In November 2009 I wrote a blog post entitled Debunking Kimball Effective Dates where I stated that I was against the Kimball-recommended practice of maintaining a StartDate & EndDate value for every record in a type 2 slowly changing dimension (SCD) table (i.e. the values highlighted in blue in the ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 13, 2011
  • SSIS enhancements in Denali CTP3

    The third Community Technology Preview (CTP3) of SQL Server code-named Denali is upon us and, although you would never guess from the official announcement, there is a whole raft of enhancements to SQL Server Integration Services (SSIS) and in this blog post I will take you on a tour of some of them. I must stress that nothing here is finalised ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 12, 2011
  • New SSIS features and enhancements in Denali – a webinar on 28th June in association with Pragmatic Works

    Tomorrow I shall be presenting a webinar entitled “New SSIS features and enhancements in Denali”. The webinar is being hosted by Pragmatic Works and you can sign up for it at Pragmatic Works webinars. The webinar will start at 1930BST and you can view the time for your timezone at this link: ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 27, 2011
  • SQL Server Development Tools Advisory Program

    You may have heard that the next version of SQL Server (code-named Denali) will include a new tool (code-named Juneau) that is intended to bring a first-class development experience for T-SQL developers. Juneau is not yet available for us, the general public, to try out so in an attempt to get some early feedback Microsoft have launched the “SQL ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 13, 2011
  • Required Parameters [SSIS Denali]

    SQL Server Integration Services (SSIS) in its 2005 and 2008 incarnations expects you to set a property values within your package at runtime using Configurations. SSIS developers tend to have rather a lot of issues with SSIS configurations; in this blog post I am going to highlight one of those problems and how it has been alleviated in SQL Server ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 20, 2010
  • Introducing SSIS Reporting Pack for SQL Server code-named Denali

    In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali The SSIS Catalog is responsible for ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 8, 2010
  • The new Execute Package Task in SSIS in Denali

    In my blog post of 10th November Introduction to SSIS projects in Denali I spoke of how, in Denali, SSIS packages can collectively be distributed as a single unit called a Project. I want to start digging into the advantages that Projects bring and the first such example is the new Execute Package Task. If we compare the old and new then the ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 12, 2010
  • Introduction to SSIS Projects in Denali

    The next version of SQL Server has been unveiled and it has a codename of Denali (aka SQL11, not aka SQL2011). SQL Server Integration Services (SSIS) is receiving quite an overhaul in Denali and over the next few days I’m going to outline some of the changes. Today? Projects! In SSIS today (i.e. prior to Denali) we build these things called SSIS ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 10, 2010
1 2 Next >
Privacy Statement