Welcome to SQLSaturday #399

Click here to visit the SQLSaturday Sacramento 2017 event page

The Sacramento SQL Server User Group is hosting our fourth SQLSaturday this year!

When:
Saturday, July 25, 2015, 7:30 AM to 5:30 PM

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

What:
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, but we do charge a lunch fee of $5.00 so that we can provide a lunch. Please register soon as seating is limited, and let friends and colleagues know about the event.

Schedule:
Click here to see the schedule for this event.

Pre-Conference Seminars

We are pleased to offer two pre-conference seminars on Friday, July 24, 2015. Chose either Kalen Delaney's "Index Magic: Rowstore, Columnstore and NoStore" or Paul Turley's "Building a Business Intelligence Solution with Power BI Components in Excel 2013". Each pre-con is a full day of training available for purchase via the Eventbrite links below.

Pre-Con 1:
Kalen Delaney - Index Magic: Rowstore, Columnstore and NoStore

When:
Friday, July 24, 2015, 8:30 AM to 5:00 PM

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

What:
Index Magic: Rowstore, Columnstore and NoStore. Indexes allow SQL Server to access your data in the most efficient manner. In fact, indexes are the only tuning technique that can improve query performance by orders of magnitude, so that queries that might have taken hours to run can be reduced to sub-second execution time. Understanding exactly how your indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. SQL Server 2014 provides three very different kinds of index structures, useful for different purposes in different kinds of applications. Knowing how indexes are useful, and how each type is stored and managed can allow us to generalize some best practice recommendations.

For more information, or to register to join us for this precon event, please click here:

Pre-Con 2:
Paul Turley - Building a Business Intelligence Solution with Power BI Components in Excel 2013

When:
Friday, July 24, 2015, 8:30 AM to 5:00 PM

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

What:
This interactive workshop will show attendees how to use Business Intelligence tools to create a complete solution delivering dashboards, self-service and mobile BI. We will create a solution using a variety of data sources with the Power BI components that can be used on the desktop by Data Analysts, for group collaboration in on-premises SharePoint and in the Microsoft Cloud with Office 365 and the new Power BI Designer Preview. Attendees should have a basic knowledge of relational database concepts and should know how to use Excel 2013.

For more information, or to register to join us for this precon event, please click here:

SQLSaturday #399 Registration

To register for SQLSaturday #399 in Sacramento on July 25, 2015, click here: