Sacramento SQL Server User Group

Next Meeting

Wednesday,

December

03

Mickey Stuewe, "Techniques for Dynamic and Effective SSRS Reports" and "Keeping your SQL Objects Saf

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Presentation 1: Techniques for Dynamic and Effective SSRS Reports Do you need a navigation system within your reports? Do you suffer from report sprawl, having hundreds of reports written once and disappearing into the reporting services catalog never to be executed again? Would you like to see one report take the place of fifty?









If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we'll talk about providing different layouts to the data in the same report, minimizing data based on the user's credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero.








Presentation 2: Keeping your SQL Objects Safe In Development It has been a long established practice to maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer's computer won't turn on.








So, what about your SQL Objects? Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We'll be using Red Gate's SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL objects just like application code. 















About Mickey Stuewe: Mickey Stuewe is a Database Architect. Her focus is on database modeling, T-SQL optimization, requirements gathering, 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 at mickeystuewe.com and occasionally on other sites such as mssqltips.com. She recently 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 part of the committee that hosts the two Southern California SQL Saturday events each year. She is the President and Founder of a new user group in Irvine, CA called Business Intelligence Group, a PASS Community (BIG PASS Community for short). She makes her home with her husband Dan and their two girls in Southern California.

Featured Presentation:

Techniques for Dynamic and Effective SSRS Reports" and "Keeping your SQL Objects Safe In Development

Mickey Stuewe, Sr. Database Developer Quick Bridge Funding

Presentation 1: Techniques for Dynamic and Effective SSRS Reports Do you need a navigation system within your reports? Do you suffer from report sprawl, having hundreds of reports written once and disappearing into the reporting services catalog never to be executed again? Would you like to see one report take the place of fifty? If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we'll talk about providing different layouts to the data in the same report, minimizing data based on the user's credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero. Presentation 2: Keeping your SQL Objects Safe In Development It has been a long established practice to maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer's computer won't turn on. So, what about your SQL Objects? Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We'll be using Red Gate's SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL objects just like application code. About Mickey Stuewe: Mickey Stuewe is a Database Architect. Her focus is on database modeling, T-SQL optimization, requirements gathering, 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 at mickeystuewe.com and occasionally on other sites such as mssqltips.com. She recently 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 part of the committee that hosts the two Southern California SQL Saturday events each year. She is the President and Founder of a new user group in Irvine, CA called Business Intelligence Group, a PASS Community (BIG PASS Community for short). She makes her home with her husband Dan and their two girls in Southern California.

About Mickey:
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.

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Announcements

SQLSaturday Sacramento 2017 (SQLSaturday #650, #sqlsatsac):
SQLSaturday Sacramento 2017 (SQLSaturday #650) was July 15, 2017.
http://www.sqlsaturday.com/650/EventHome.aspx

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids