Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SSWUG Vconf – Day 3 Links and Tidbits

Posted by Tom On October - 23 - 2009

Keynote

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.

Read the rest of this entry »

Popularity: 2% [?]

SSWUG Fall 2009 Virtual Conference Plan

Posted by Tom On October - 21 - 2009

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. ;)

Read the rest of this entry »

Popularity: 1% [?]

Data validation for datetime parameters in SSRS

Posted by Tom On July - 6 - 2009

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% [?]

SSRS 2008 Data Driven Subscriptions and Alerts

Posted by Tom On June - 16 - 2009

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% [?]

Christian Non-Profit Seeks DBA/Developer/Report Writer

Posted by Tom On April - 23 - 2009

logoHey 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% [?]

SSWUG vConf – Agile Business Development

Posted by Tom On April - 22 - 2009

2513682441_b2beea0d6bAgile 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% [?]

Flow ControlBelow I am posting some of my notes from the various sessions, along with comments, observations and occasional odd humor. ;)

The Accidental Business Intelligence Administrator

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% [?]

Run (final editing)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% [?]