Jessica Moss Reports On SQL Server Reporting Services

In this RunAs Radio podcast, Richard and I talk to Jessica Moss about SQL Server Reporting Services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis Services to provide a deeper level of reporting.

Jessica M. Moss, a Microsoft SQL Server MVP and business intelligence mentor with Solid Quality Mentors, is certified as an MCDBA, MCTS: SQL Server 2005 BI, and an MCITP: SQL Server 2005 BI. She has been working with SQL Server 2005 and SQL Server 2008 since their releases and has participated in many warehousing and reporting solutions. Jessica enjoys working with the local community and is a regular speaker at user groups, code camps, and conferences. You can read about her work on her blog.

• Learnkey SQL Server 7.0 Data Warehouse Design and Implementation Course Exam 70-019 (complete set)
• 6TB NAS RAID 10 File/Mail/Database/Media Web Server - HP Pavilion Elite M9500T Desktop 2x Gigabit Backbone + 2x 3Gb/s Bandwidth Double SATA-300 Disk Transfer Rate 6TB RAID NAS (1~20x faster dual-Gigabit redundant Ethernet channels; 2.5GHz Intel Core 2 Quad Q8300 Processor overclocking to 3.5+GHz; 8GB dual-channel PC2-8500 DDR2-1066MHz SDRAM; 4×1.5TB fastest Seagate 7200RPM 32MB buffer NCQ RAID-ready hard drives on RAID 10 configuration both for fastest-performing Windows OS, which can keep server always running due to system mirroring, and for 2~8x faster chunk data storage like Mail Exchange or SQL database server; GDDR3 512MB nVIDIA GeForce 9500GS [DVI, HDMI, VGA] supporting dual-monitor mode, Blu-ray player and LightScribe SuperMulti drive, Vista Home Premium 64-bit upgradable to Windows Server 2008)
• 6TB NAS RAID 10 File/Mail/Database/Media Web Server - HP Pavilion Elite M9500T Desktop 2x Gigabit Backbone + 2x 3Gb/s Bandwidth Double SATA-300 Disk Transfer Rate 6TB RAID NAS (1~20x faster dual-Gigabit redundant Ethernet channels; 2.66GHz Intel Core 2 Quad Q9400 Processor overclocking to 3.5+GHz; 8GB dual-channel PC2-8500 DDR2-1066MHz SDRAM; 4×1.5TB fastest Seagate 7200RPM 32MB buffer NCQ RAID-ready hard drives on RAID 10 configuration both for fastest-performing Windows OS, which can keep server always running due to system mirroring, and for 2~8x faster chunk data storage like Mail Exchange or SQL database server; GDDR3 768MB nVIDIA GeForce 9600GS [DVI, HDMI, VGA] supporting dual-monitor mode, Blu-ray player and LightScribe SuperMulti drive, Vista Home Premium 64-bit upgradable to Windows Server 2008)
• 7.5TB Super Fast NAS RAID 5 File/Media/Mail/Database Web Server - HP Pavilion Elite M9600T Desktop 2x Gigabit Backbone + 3x 3Gb/s Bandwidth Triple SATA-300 Disk Transfer Rate 6TB RAID NAS (1~20x faster dual-Gigabit redundant Ethernet channels; 2.66GHz Intel i7-920 Processor with Intel most-advanced X58 chipset overclocking to 3.50+GHz and SLI-/CrossFireX-ready; 12GB up to 24GB super fast triple-channel PC3-15000+ DDR3-1866+MHz SDRAM; 5×1.5TB fastest Seagate 7200RPM 32MB buffer NCQ RAID-ready hard drives with 1.5TB for Windows OS, database backup and logs, and another 6TB on RAID 5 configuration for 2~8x faster write-heavy chunk data storage application like Mail Exchange or SQL database server; GDDR3 512MB ATI Radeon HD 4350 [DVI, HDMI, VGA] supporting dual-monitor mode, SupremeFX X-Fi HD 7.1-channel audio, Blu-ray player and LightScribe SuperMulti drive, Vista Home Premium 64-bit upgradable to Windows Server 2008)
• Microsoft® SQL Server(TM) 2000 DTS Step by Step (Step By Step (Microsoft))
• Microsoft® SQL Server(TM) 2000 Administrator’s Pocket Consultant (It-Administrator’s Pocket Consultant)
• Microsoft® SQL Server(TM) 2000 High Availability
• Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
• MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)
• Microsoft® SQL Server® 2008 Internals (Pro - Developer)
• PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 Certification Practice Exam
• Sybase SQL Anywhere ASA Server Networked Seat - ( V. 8.0 ) - License (M15984) Category: Data Management Software
• SQL Server Comparison Tool