An excellent discussion by Gail Shaw has been posted on her Blog SQL in the Wild, regarding the ongoing debate surrounding the inherent adversity there seems to be between those two illustrious groups we know and love as Developers and DBA’s. I find it quite disheartening that there seems to be a presumption between these [...]
Posts from ‘April, 2009’
Reporting Services date control issue using Analysis Services data source
Here’s a solution to an issue that you may have come up against when designing a SQL Server Reporting Services (SSRS) report requiring Datetime parameters, that uses a SQL Server Analysis Services (SSAS) data source. What’s the problem? When you create a dataset from a SSAS data source, by default the date values returned from [...]
Whitepaper: Troubleshooting Performance Problems in SQL Server 2008
No doubt you already know that I love nothing more than getting my hands on excellent technical resources for SQL Server. Well hot off the press is the latest Whitepaper offering from Microsoft that looks at troubleshooting performance problems in SQL Server 2008. Naturally you may already be familiar with some of the techniques and [...]
