Stephen Wynkoop
Demo: Capture perfmon counters to binary logs and at the same time capture SQL Profiler. Then you can load both into profiler and see both at the same time. Great for troubleshooting what might be causing a problem or what is happening at a particular point in time.
Popularity: 2% [?]
So the SSWUG Fall 2009 Virtual Conference begins today. I’ve setup at home to hibernate for hours watching the live and pre-recorded sessions on a wide range of SQL Server and business intelligence topics. An extra LCD monitor brought home, the trackball mouse from the office, headphones and webcam. The kitchen is stocked for my “conference” meals and snacks thanks to my lovely bride. I am ready!
Oh yeah, the sessions. I almost forgot. 
Popularity: 1% [?]
Data validation for datetime parameter in SSRS.
Came across this piece of code for ensuring the end date comes after the start date. Just what I was about to write but a quick Google search saved a bit of time. Yay! Read the rest of this entry »
Popularity: 15% [?]
A use case has been presented where users wish to receive email notification of certain records matching various criteria. Additionally, the notification subscription should only notify the user if records exist matching the criteria. The notification via subscriptions should only happen once for any given record. Read the rest of this entry »
Popularity: 21% [?]
Hey there everyone. Have I got a treat for someone out there.
Are you a SQL Server DBA, Developer, Report Writer?
Do you align with a desire to spread God’s Word?
Do you love working in an evolving/energetic environment? Read the rest of this entry »
Popularity: 9% [?]
Agile Business Intelligence – Proven Techniques that move BI Development into the Agile World
Presenter: Ted Malone
http://portal.sqltrainer.com
Gotta love Ted. He’s been with SQL Server since Beta v1.0 on OS/2.
Ted’s presentation is about Agile development method using Visual Studio Team System. Hoping some methodologies can apply using other tools. Read the rest of this entry »
Popularity: 4% [?]
Below I am posting some of my notes from the various sessions, along with comments, observations and occasional odd humor.
This session is designed for SQL Server DBAs who find themselves having to support SQL Server Business Intelligence projects using Reporting Services, Integration Services or Analysis Services. We’ll talk about the lifecycle of projects using these tools, how they impact your SQL Server infrastructure, and what adaptations you might need to make as a production DBA in order to maintain and secure them. Along the way, you might just learn what all those “other†services do that are listed in the SQL Server Configuration Manager. Read the rest of this entry »
Popularity: 5% [?]
While working with time series charts in SQL Server Reporting Services, I ran across a particular need to show cumulative aggregation of income over time by fiscal year. Yup, that’s a mouthful eh? I initially thought great, I’ll just make the Y-axis value be the running total of the !Fields:Total.Value for the fiscal year series grouping using the RunningValue() function. This worked great with the exception of the current fiscal year. Read the rest of this entry »
Popularity: 34% [?]
