Ian Beckett

RSS feed

    Recent comments

    Authors

    check if CDC is enabled in SQL 2008

    Change Data Capture (CDC) is disabled by default in SQL 2008.  To check if it is enabled for a given DB use this SELECT:

    -- if column is_cdc_enabled exists in the result, then CDC is enabled for the database

    select name, is_cdc_enabled from sys.databases


    Posted by ibeckett on Saturday, February 28, 2009 4:23 PM
    Permalink | Comments (0) | Post RSSRSS comment feed

    Week of Warehousing Webinar Series

    If you missed these, you can catch the recorded presentations here. 

    Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works. You may attend all five sessions if you wish or register for the sessions independently. Audio is provided either via a phone or over your computer speakers (voice over IP).

    In this week of warehousing, you'll learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox (some speakers will be announced next week). SQLServerCentral.com's last webinar series had nearly 15,000 registered so register quick for one the morning or afternoon session to claim your spot!

    Registration is open to the first 1,000 people in each session and seats are going fast. Registration is below:

    5 Days 5 DW Topics Topic Summary
    Monday Feb 23 9:30AM EST

    Register 
    Designing a Data Warehouse
    Featuring: Erik Veerman
    Improve the speed of your production can be as easy as giving your users a new place to report against. In this session, you'll learn from SQL Server MVP, Erik Veerman how a data warehouse can benefit your organization and how to design one for SQL Server. You'll also see at a high level how the data flows into the warehouse in a Microsoft data warehouse ecosystem.
    Monday Feb 23 1:30PM EST

    Register 
    Designing a Data Warehouse Featuring: Erik Veerman
    Improve the speed of your production can be as easy as giving your users a new place to report against. In this session, you'll learn from SQL Server MVP, Erik Veerman how a data warehouse can benefit your organization and how to design one for SQL Server. You'll also see at a high level how the data flows into the warehouse in a Microsoft data warehouse ecosystem.
    Tuesday Feb 24 9:30AM EST

    Register 
    Loading a Data Warehouse with SQL Server Integration Services (SSIS)
    Featuring: Brian Knight
    Now that you have a data warehouse designed, how would you go about loading the warehouse from your relational database that has been in production for years. Join Microsoft MVP and author Brian Knight in this session on how to use SSIS to load and synchronize a data warehouse.
    Tuesday Feb 24 1:30PM EST

    Register 
    Loading a Data Warehouse with SQL Server Integration Services (SSIS)
    Featuring: Brian Knight
    Now that you have a data warehouse designed, how would you go about loading the warehouse from your relational database that has been in production for years. Join Microsoft MVP and author Brian Knight in this session on how to use SSIS to load and synchronize a data warehouse.
    Wednesday Feb 25 9:30AM EST

    Register 
    Introduction to Analysis Services (SSAS)
    Featuring: Siva Harinath  
    Tired of having to write hundreds of one-off reports? SQL Server Analysis Services (SSAS) can help clear your report backlog by giving your users the ability to perform ad-hoc reporting with pivot tables. Learn how to create a SSAS cube, how to process it and finally view quick reports to answers questions you didn't even know you had about your business.
    Wednesday Feb 25 1:30PM  EST

    Register 
    Introduction to Analysis Services (SSAS)
    Featuring: Siva Harinath
    Tired of having to write hundreds of one-off reports? SQL Server Analysis Services (SSAS) can help clear your report backlog by giving your users the ability to perform ad-hoc reporting with pivot tables. Learn how to create a SSAS cube, how to process it and finally view quick reports to answers questions you didn't even know you had about your business.
    Thursday Feb 26 9:30AM  EST

    Register 
    Reporting against a Data Warehouse with SSRS
    Featuring: Paul Turley
    In this session, you'll learn how to report against your data warehouse and SSAS cubes by using Reporting Services 2008. Learn what's new and easy ways to visualize data warehouse data in this comprehensive session for beginners.
    Thursday Feb 26 1:30PM EST

    Register 
    Performance Tuning  and Scaling a Data Warehouse
    Featuring: JC Armand
    Some of the largest databases in the world are data warehouses, scaling to dozens (or hundreds) of terrabytes in some cases. In this session, you'll explore how to make your SQL Server 2008 database scale and easy ways to diagnose and troubleshoot problems. You'll learn how to performance tune and scale the hardware to the OS in this vital session for most organizations.
    Friday Feb 27 9:30AM EST

    Register 
    Performance Tuning and Scaling a Data Warehouse
    Featuring: JC Armand
    Some of the largest databases in the world are data warehouses, scaling to dozens (or hundreds) of terrabytes in some cases. In this session, you'll explore how to make your SQL Server 2008 database scale and easy ways to diagnose and troubleshoot problems. You'll learn how to performance tune and scale the hardware to the OS in this vital session for most organizations.
    Friday Feb 27 1:30PM EST

    Register 
    Reporting against a Data Warehouse with SSRS
    Featuring: Paul Turley
    In this session, you'll learn how to report against your data warehouse and SSAS cubes by using Reporting Services 2008. Learn what's new and easy ways to visualize data warehouse data in this comprehensive session for beginners.

    Posted by ibeckett on Saturday, February 14, 2009 6:16 AM
    Permalink | Comments (0) | Post RSSRSS comment feed

    Light weight photo shop... Paint.NET

    Lately I've been trying to improve my graphics skills but photoshop CS4 gives me a GUI headache.  I've ended up using Paint.NET (http://www.getpaint.net/download.html) a lot for simple web effects stuff.  It's nice to have an easy to use and powerful graphics program that will run swiftly even on a 5 year old lap top.

    Posted by ibeckett on Thursday, February 12, 2009 2:53 PM
    Permalink | Comments (0) | Post RSSRSS comment feed

    End of beta is in sight for Windows 7

    Microsoft has confirmed that it will not be releasing any more beta versions of Windows 7, with the next release likely to be the first release candidate of the eagerly anticipated operating system.

    The successor to Vista has been very well received since it arrived in beta, which will come as an almighty relief to Microsoft after the failure of Vista to hit the heights that were expected for it.....

    -http://www.techradar.com/news/software/end-of-beta-is-in-sight-for-windows-7-516516


    Posted by ibeckett on Monday, February 02, 2009 5:49 AM
    Permalink | Comments (0) | Post RSSRSS comment feed

    View a pivot table's underlying MDX query in Excel

    After running these scripts you can easily view the underlying MDX query for any pivot table that uses a SSAS cube for its datasource:
     

    Use the following script to add a show MDX Query option when you right click a pivot table in Excel 2007:

    Private Sub Workbook_Open()
       Dim ptcon As CommandBar
       
        Set ptcon = Application.CommandBars("PivotTable context menu")

    insertDisplayMDX:
       Dim cmdMdx As CommandBarControl
       For Each btn In ptcon.Controls
           If btn.Caption = "MDX Query" Then GoTo doneDisplayMDX
       Next btn
      
       ' Add an item to the PivotTable context menu.
       Set cmdMdx = ptcon.Controls.Add(Type:=msoControlButton, temporary:=True)
      
       ' Set the properties of the menu item.
       cmdMdx.Caption = "MDX Query"
       cmdMdx.OnAction = "DisplayMDX"
          
    doneDisplayMDX:

    End Sub 



    And put this in a seperate module:
    Sub DisplayMDX()
        Dim mdxQuery As String
        Dim pvt As PivotTable
        Dim ws As Worksheet
      
        Set pvt = ActiveCell.PivotTable
        mdxQuery = pvt.MDX
       
        ' Add a new worksheet.
        Set ws = Worksheets.Add
        ws.Range("A1") = mdxQuery
    End Sub

    Works great!

    The code comes from http://sqljunkies.com/WebLog/sqlbi/archive/2007/01/18/26875.aspx


    Posted by ibeckett on Sunday, February 01, 2009 6:04 AM
    Permalink | Comments (0) | Post RSSRSS comment feed