Blogs

March 2007 - Posts

• Online Index Operations

  How quickly a week goes by... minute by minute... get a little busy and no blogs. Well, here's a quick link to a white paper on Online Index Operations in 2005. A very nice 2005 Enterprise feature that allows building and maintaining of indexes without Read More... Posted Monday, March 26, 2007 1:10 PM by Jason | 0 Comments Filed under: SQL 2005

• Default Trace

  A quick link to a blog I read today on the default trace and determining what is in it. It's cool that we can get to all of this information in SS2005. Read More... Posted Monday, March 19, 2007 2:16 PM by Jason | 0 Comments Filed under: SQL 2005

• IIF(IsEasier(Many-to-Many Dimensional Modeling) = TRUE, JOYFUL, CRY)

  In a former life on a SQL Server 2000 project with I had the immense joy of building a few cubes in Analysis Services that took advantage of many-to-many relationships. At the start I was thrilled to be trying something new and by the end I was cross-eyed Read More... Posted Friday, March 16, 2007 2:39 PM by Jason | 0 Comments Filed under: SSAS

• SSIS Naming Conventions

  Jamie Thompson posted some best practices and naming conventions for SQL Server Integration Services a bit back. Interesting ideas and for some reason I hadn't ever really thought about naming conventions within SSIS until I read these articles. Read More... Posted Thursday, March 15, 2007 4:46 PM by Jason | 0 Comments Filed under: SSIS

• SQL Server 2005 Performance Dashboard Reports

  There's a new download from Microsoft that I am a little excited to take a look at... <begin fanfar> <queue flashy lights> The... SQL Server 2005 Performance Dashboard Reports I've downloaded them but haven't had a chance to really look at Read More... Posted Wednesday, March 14, 2007 1:22 PM by Jason | 0 Comments Filed under: SQL RS, SQL 2005

• Monitoring Report Performance

  Nothing really new with the link I am posting today. If you've looked at the samples included with SQL Server 2005 Reporting Services you've likely seen the Execution Log Reports . And for those that weren't aware, these reports are a nice little addition Read More... Posted Tuesday, March 13, 2007 12:06 PM by Jason | 0 Comments Filed under: SQL RS

• XML Datasources

  A "neato' technical article from last fall on using XML and Web Services as data sources in SQL Server Reporting Services . Not sure how I feel about the XML but I had been wondering how to access certain values in SSRS in a web.config type fashion. For Read More... Posted Monday, March 12, 2007 2:25 PM by Jason | 0 Comments Filed under: SQL RS

• The 2-for-1 Special in Excel

  It inevitably happens when building SQL Server Reporting Services reports that someone will have desire to export the beautifully created report out of SSRS and into some other format. And sometimes that format just happens to be Excel. *Presto Change-O* Read More... Posted Friday, March 09, 2007 2:04 PM by Jason | 0 Comments Filed under: SQL RS

• Parameter Feature… Not A Bug

  Often times I’ve placed default values into my reports when designing them to aid in developing the report without having to constantly fill out the parameters while testing them. To my chagrin I’ve run into a number of problems when I update deploy these Read More... Posted Thursday, March 08, 2007 2:24 PM by Jason | 0 Comments Filed under: SQL RS

• Because One Service Pack Wasn't Enough

  It looks like the release of Service Pack 2 for SQL Server 2005 wasn't quite "perfect". So there's been a critical hotfix already and a republishing of the SQL Server SP2 install. To add confusion to the situation, instead of creating an "SP2a" page for Read More... Posted Wednesday, March 07, 2007 11:49 AM by Jason | 0 Comments Filed under: SQL 2005

• SQL Server 2005 Best Practices Analyzer

  Microsoft has updated and released the Best Practices Analyzer for SQL Server 2005. I ran it against my laptop and found some interesting results. Nothing too out of the ordinary. Mostly user account related items that get setup that way on laptops during Read More... Posted Tuesday, March 06, 2007 11:05 AM by Jason | 0 Comments Filed under: SQL 2005

• Minnesota BI Special Interest Group (BI-SIG) - March Meeting

  BI-SIG - Q1 2007 Meeting Wednesday, March 14th / 3:00 - 6:30 Microsoft Bloomington Offices Intelligent Business With Business Intelligence The inaugural meeting of the Microsoft Business Intelligence Special Interest Group (BI-SIG) in December was a huge Read More... Posted Monday, March 05, 2007 3:11 PM by Jason | 0 Comments Filed under: SSAS, SSIS

• Connectivity and SSIS

  There is a new white paper out regarding connectivity with SSIS to various data sources. These include connections to SQL Server, DB2, Oracle, Access, Excel, and other file-based database systems. There is some nice information in there. The summary from Read More... Posted Friday, March 02, 2007 2:36 PM by Jason | 0 Comments Filed under: SQL 2005, SSIS Attachment(s): http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc

• Reporting Services & Sharepoint

  I've been working a side-project that involves tieing in Sharepoint with Reporting Services. One of my wise co-workers managed to point some of the benefits and constraints that Microsoft has found in using the Reporting Services add-in for Sharepoint. Read More... Posted Thursday, March 01, 2007 10:39 AM by Jason | 1 Comments Filed under: SQL RS, Sharepoint