Welcome

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most sessions will have a presentation; however, throughout the year we schedule a few group sessions designed to provide a forum that allows attendees to discuss real-world SQL Server related questions, issues and concerns which are addressed 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


New Meeting Location:

We have a new meeting location as of October 2013:

Patrick Hays Learning Center
2700 Gateway Oaks Drive
Suite 2600
Sacramento, CA 95833

Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600.


View Larger Map

 

Next Meeting

Date Wednesday, December 3, 2014, 6:00 PM - 8:00 PM

Speaker: Mickey Stuewe

Topic: 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.

Sponsor:

Robert Half Technology.  Free food and raffle! 
RSVP:

If you plan to attend, please add a comment to the announcement for this meeting on LinkedIn.  Please join the LinkedIn group if you are not yet a member.  Your comment on the LinkedIn announcement will help us plan the food for the meeting.

 

Announcements

SQLSaturday #312: SQLSaturday 312 was held on July 12, 2014  http://sac.sqlpass.org/SQLSaturday/SQLSaturday312.aspx

PASS Summit 2013: Watch the Keynotes, select sessions, interviews and more from PASS Summit 2013 at the PASStv site: http://www.sqlpass.org/summit/2013/PASStv.aspx

SACSQLUG Meeting Archive: Our meeting archive pages have been revised:
http://sac.sqlpass.org/MeetingArchive.aspx

24 Hours of PASS: The Summer 2013 24 Hours of PASS session recordings are now available for viewing:
http://www.sqlpass.org/summit/2013/Sessions/SneakPeeks.aspx

SQLSaturday #222: Our second annual Sacramento SQLSaturday was held on July 27, 2013; more info, pictures, blog and tweet links:
http://sac.sqlpass.org/SQLSaturday/SQLSaturday222.aspx