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 2 (12 total posts) < 1 second(s)
  • SQL Saturday #35 - Dallas

    I had intended to post this weeks ago.&nbsp; I guess I'm still postponing my New Year's resolution to stop procrastinating. We're organizing our first SQL Saturday event in Dallas on May 22nd, hoping to make it an annual event.&nbsp; It will be held at the Region 10 Education Center in Richardson, and we currently have 4 tracks slated:&nbsp; ...
    Posted to Erin Welker (Weblog) by ErinW on January 17, 2010
  • Automating UBO

    I was preparing for my presentation at PASS and wanted to show some code for automating usage-based optimization.&#160; This is the process that allows for creating aggregation designs based on past query activity.&#160; I was surprised to find that there were no code examples posted on the web on how to do this, at least none that I could ...
    Posted to Erin Welker (Weblog) by ErinW on November 15, 2009
  • Using SSAS 2008 tools with SSAS 2005 cubes

    It's been awhile since I've blogged.&#160; Every time it seems I'll get some spare moments, something comes up to direct my attention elsewhere.&#160; My current engagement keeps me busy and embedded in SQL Server 2005.&#160; Though I've presented on some of the cool features of SQL Server 2008, I feel I have very little new insight to publish on ...
    Posted to Erin Welker (Weblog) by ErinW on February 8, 2009
  • Analysis Services Performance Whitepaper - a little light reading

    The SQL Server 2008 version of the Analysis Services Performance Guide was published last month.&#160; I've yet to read it - it's 80 pages (which is actually less than its 2005 predecessor).&#160; I'm sure there's some overlap with that one but, since it has different authors, the information is presented differently.&#160; And, of course, it has ...
    Posted to Erin Welker (Weblog) by ErinW on December 1, 2008
  • re: See you at Tech Ed? Or other places?

    Sorry I'll miss meeting you, Louis. &nbsp;I'll be at Tech Ed week 2. &nbsp;Guess I'll see you at PASS! Erin
    Posted to Louis Davidson (Weblog) by ErinW on June 2, 2008
  • Trials in reporting on cubes

    I'll admit that I haven't spent a lot of time in Reporting Services.&#160; And it's been quite awhile since I've written a report against an Analysis Services cube - since SQL Server 2000, in fact.&#160; I was kind of looking forward to using the MDX designer in Reporting Services 2005 but soon found it's limitations (which are ...
    Posted to Erin Welker (Weblog) by ErinW on April 30, 2008
  • ETL World Record!

    I just heard about this from Len Wyatt, who's a Principle Program Manager on the SQL Server Performance team.&#160; Microsoft and Unisys announced a record for loading into a relational database, using SSIS (SQL Server 2008) to load over 1 TB of data in under 30 minutes!&#160; The previous known record-holder was Informatica, who reported loading ...
    Posted to Erin Welker (Weblog) by ErinW on February 27, 2008
  • Partitioning enhancements in SQL Server 2008

    Horizontal partitioning can be a great benefit to data warehouses, as it greatly facilitates the management of very large databases. Of course, querying on partitions can also have performance benefits, especially when only a small percentage of the database is queried and partition elimination can occur. SQL Server 2005, however, can have some ...
    Posted to Erin Welker (Weblog) by ErinW on February 10, 2008
  • re: My Top 10 list for SQL Server 2008

    Thanks, Aaron - I thought I might receive one or two &quot;you left this out&quot; comments. :-) I am glad you bring up DMF (I understand they've renamed this to &quot;Policy-based Framework&quot;?) &nbsp;The ex, multi-server DBA in me finds the DMF feature to be beyond awesome! &nbsp;However, this is a personal list of features that are highly ...
    Posted to Erin Welker (Weblog) by ErinW on January 23, 2008
  • My Top 10 list for SQL Server 2008

    Long gone are the days when you can reasonably expect to know all aspects of SQL Server at a deep level.&nbsp; When a new version starts to emerge, I try to put some scope around the features that I will dive more deeply into.&nbsp; I'm publishing my list here so that like-minded SQL Server enthusiasts may become aware of a feature or ...
    Posted to Erin Welker (Weblog) by ErinW on January 20, 2008
1 2 Next >
Privacy Statement