DBAs always have a collection of queries that they need to run periodically to find out information on the databases they manage. Sometimes this information is requested by management or other IT colleagues. In this session, we'll talk about setting up SSRS for delivering reports, then I’ll show you how to create your first report. We’ll talk about data sources, parameters and internal functions. We’ll add data to tables, commonly referred to as Tablixes and group the data by column fields. We’ll also talk about how to leverage templates so that you can kick-start your report creation. Finally, we’ll see how to quickly publish reports to a SSRS Report Manager.
Mickey Stuewe is a Database Architect. Her focus is on database modeling, T-SQL optimization, and report design using the SQL Server stack. She is the recent recipient of the “Best New Community Voice” Tribal award from Red Gate. She blogs regularly and co-authored her first book, SQL Server 2012 Reporting Services Blueprints. She has spoken at Dev Connections, SQL in the City for Red Gate, and various SQL Saturday Events. She is also the president of the BIG PASS Community user group.
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.
She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQL Saturdays, User Groups and other events.
When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.