SQL Server Blogs

Recently, I’ve helped several customers with Kerberos authentication problems with Reporting Services and Analysis Services, so I’ve decided to write this blog post and pull together some useful resources in one place (there are 2 whitepapers in particular that I found invaluable configuring Kerberos...

I’m going through my precon for PASS and there is some great stuff in here that addresses many of the failings of reporting services.   Ever wanted to have a report remember the last parameter values you specified for a report. What about being able to indicate to a procedure the user selected ALL...

If you want the buttons from the Reporting Services Slicers demos I did last week then here they are. You can get the presentation and code on putting slicers in reporting services here ( http://sqlblogcasts.com/blogs/simons/archive/2011/09/09/adding-slicers-to-reporting-services-downloads.aspx ).

I promised to have my presentation available online. Here is the presentation and and the projects. I will be provided details of how to deploy the assembly and do the drag and drop slicer functionality over the weekend. You can download the presentation here http://sqlblogcasts.com/files/folders/reporting_services_presentations_and_demos...

Here are the files from my Advanced Reporting Services 24 Hours of PASS session on how to put slicers in reporting services. Here is a screen shot of what is possible. One filters the data (Excel style) and the other greys unselected data out (Crescent style) ps the files will be posted after the session...

We had an interesting problem while I was on holiday. (Why doesn't this stuff ever happen when I'm there?) The sysadmin upgraded our Exchange server to Exchange 2010 and everone's subscriptions stopped. My Subscriptions showed an error message saying that the email address of one of the recipients...

Day 5 Pretty easy thing to setup, but can look very effective in a report, you can use gauges but I wanted fore some Health check reports to go for the old traffic light system. To help the Management at work to easily digest if their SQL servers are Critical (Red) Nearly there (Amber) or running ok...