Articles

  • Creating a Proxy User to run an SSIS package in SQL Server Agent
    There have been a number of times over the years when I have had to create a Proxy user in SQL Server in order to provide needed access to connections and locations being used in an SSIS package.  Sometimes the SQL Server Agent login account simply doesn’t and shouldn’t have ... read more
    Source: The Data QueenPublished on 2015-05-26By mrsmew
  • Promoting Excel Tabular Model to SSAS
    PowerPivot for Excel is a fantastic addition to Microsoft’s Business Intelligence offering.  It provides a self-service capability for users to mash-up huge amounts of data from multiple sources, create advanced calculations that get refreshed alongside their pivot tables and the ability to very easily publish workbooks as web applications.  Excel ... read more
    Source: The Data QueenPublished on 2015-02-23By Martina White
  • Promoting Excel Tabular Model to SSAS
    PowerPivot for Excel is a fantastic addition to Microsoft’s Business Intelligence offering.  It provides a self-service capability for users to mash-up huge amounts of data from multiple sources, create advanced calculations that get refreshed alongside their pivot tables and the ability to very easily publish workbooks as web applications.  Excel ... read more
    Source: The Data QueenPublished on 2015-02-23By mrsmew
  • SSIS Excel Refresh Task
    CodePlex has a great new toolbox item for SSIS projects in Visual Studio 2012.  It’s called the SSIS Excel Refresh Task. It allows you to refresh a whole Excel file or single queries of your Excel sheet.  It works for PowerPivot models as well. There isn’t a lot of instruction ... read more
    Source: The Data QueenPublished on 2015-01-10By Martina White
  • SSIS Excel Refresh Task
    CodePlex has a great new toolbox item for SSIS projects in Visual Studio 2012.  It’s called the SSIS Excel Refresh Task. It allows you to refresh a whole Excel file or single queries of your Excel sheet.  It works for PowerPivot models as well. There isn’t a lot of instruction ... read more
    Source: The Data QueenPublished on 2015-01-10By mrsmew
  • Microsoft MVP Summit
    Last month I had the great honour of winning a Microsoft MVP Award.  Most of my friends and family don’t really understand what a big deal it is to win this award.  I was over the moon.  This is an award that Microsoft gives to folks who have contributed their ... read more
    Source: The Data QueenPublished on 2014-11-05By Martina White
  • Microsoft MVP Summit
    Last month I had the great honour of winning a Microsoft MVP Award.  Most of my friends and family don’t really understand what a big deal it is to win this award.  I was over the moon.  This is an award that Microsoft gives to folks who have contributed their ... read more
    Source: The Data QueenPublished on 2014-11-05By mrsmew
  • Check if Stored Procedure is Running
    Here is a sweet little script that can check which stored procedures are running and perform an action.  In this case I need to update a configuration table if the stored procedure is not running. BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with ... read more
    Source: The Data QueenPublished on 2014-09-06By Martina White
  • Check if Stored Procedure is Running
    Here is a sweet little script that can check which stored procedures are running and perform an action.  In this case I need to update a configuration table if the stored procedure is not running. BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with ... read more
    Source: The Data QueenPublished on 2014-09-06By mrsmew
  • Querying XML in SQL
    I like to use my blog as a library for myself, to be able to easily find solutions I have used before.  Here is a simple example of querying an XML string using SQL.  In this example I have inserted one XML string into a temporary table, with two ... read more
    Source: The Data QueenPublished on 2014-08-26By mrsmew
  • Querying XML in SQL
    I like to use my blog as a library for myself, to be able to easily find solutions I have used before.  Here is a simple example of querying an XML string using SQL.  In this example I have inserted one XML string into a temporary table, with two ... read more
    Source: The Data QueenPublished on 2014-08-26By Martina White