November 2008 - Posts

SQL Server 2008 Features by Edition Breakdown
25 November 08 11:28 AM | Steve Carroll | 1 Comments   

I've been helping people with SQL Server for quite a while now, and I continually hunt for information regarding what features are available in which edition of SQL Server. Well, SQL Server 2008 has improved in many ways, including new edition packages Read More...

Filed under: SQL Server 2008

Report Builder Gotcha'
18 November 08 03:17 PM | Steve Carroll | 0 Comments   

Using SQL Server 2005 sp3, running on 32bit Vista with sp1. I'm creating report models using Business Intelligence Development Studio and as I go to edit an expression I find that I get a message "Access to the path 'C:\Windows\system32\config' is denied." Read More...

Filed under: Reporting Services, SQL Server 2005, SP3, Business Intelligence Development Studio

Best Practice Guidance
17 November 08 01:15 PM | Steve Carroll | 0 Comments   

Ok... more often than not, I'm asked about best practices for SQL Server. I figured I'd share my best practices bookmarks in no particular order to hopefully give you a new resource to find these. I'd love to hear from you on what you use and what you Read More...

Filed under: SQL Server 2005, Best Practices

SQL Server 2005 SP3
13 November 08 11:04 AM | Steve Carroll | 1 Comments   

Patch time for SQL Server... Well almost. SP3 for SQL Server 2005 has been in CTP for a while now (10/27/08) and all is appearing to be really good. I finally got around to installing the beta patch the other night on my home servers and experienced no Read More...

Filed under: Announcement, SQL Server 2005, Service Pack, Patches, SP3

Changes in SQL Server 2008 Clustering
07 November 08 09:29 AM | Steve Carroll | 0 Comments   

First and most important thing to remember when working on designing a SQL Server cluster is it is entirely dependent upon the underlying base architecture that you choose to implement for the operating system. Here, it really pays to do your homework Read More...

Filed under: SQL Server 2008, Clustering, High Availability

Embrace the use of Conditional Formatting
04 November 08 11:31 AM | Steve Carroll | 0 Comments   

One of the most underused functions I have found in Reporting Services is the use of conditional formatting. Lets face it, in today's Ridilin influenced ADD society, we need to draw attention to significant events. Lets face it, Outlook, pops up alerts Read More...