Charlotte, NC has a dynamic, growing business environment filled with opportunities for Microsoft SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of that environment by providing a venue for user education and peer collaboration.
We meet once monthly for 2 hours for friendly networking and expert training sessions covering a variety of Microsoft SQL Server topics. Stay in touch to learn when the next meetup is planned, by signing up for our email announcements. It’s free and food is provided. RSVP is required for each meeting using the email links provided monthly.
Check below for our upcoming meetings and announcements:
======================
March 2014 Meeting
Posted on: March 2nd, 2014Please join us Wednesday, March 12th, 2014 for the Charlotte SQL Server User Group meeting at the local Microsoft campus (directions below).
Please RSVP here so we may plan enough food for the event. You do not have to print the eventbrite .pdf ticket however. Only RSVP if you will attend.
The event is free, so bring a friend and network with Charlotte’s finest SQL Server experts. If you can attend, please make an effort to introduce yourself to newcomers and welcome them to the group.
Food usually starts at 5:30pm and the presentations start at 6pm and usually last until 7:45pm at the latest.
Please sign in and make a name tag when you arrive so we may verify attendance and encourage networking.
Agenda
5:30 PM Networking with Food & Refreshments
6:00 PM Technical Presentation ~ “Data Marts for Everyone” by Joseph Lax
7:30 PM Meeting End
===========
“Data Marts for Everyone”
Learn The Basics of Building a Data Mart by Designing a SQL Performance Warehouse
by Joseph Lax
For simple reporting needs, it’s ok to simply whip up the necessary SQL to provide the necessary data. But more complicated requirements require a different approach; building a data mart. In this session, I’ll demonstrate the techniques of using a data mart on something that is near and dear to all DBA’s – properly tracking the performance of the systems they are responsible for. We’ll start by designing a data model to answer important questions about SQL Performance, we’ll then load SQL Trace data into it and demonstrate how the data mart allows us to answer complicated questions in a much easier fashion. We’ll also use analysis services to demonstrate why a cube built on top of a data mart can answer questions that SQL itself finds difficult.
Joseph Lax is the founder and President of DB Directions, Inc., a company specializing in all aspects of database administration, architecture, design, and implementation. Joe has spent the last eighteen years providing his expertise to clients in the areas of: Performance optimization, Scalability issues, Disaster recovery strategies, & Data modeling. He has managed mission critical systems for banks, telecommunication firms, and manufacturing companies. http://www.dbdirections.com/
Upcoming Meetings 2014
Posted on: February 6th, 2014We are planning meetings one per month. We will provide an RSVP invitation and additional details as the dates approach
- April – The Scripting Guy
- May – Grant Fritchey, SQL Server MVP
PASS Business Analytics Conference coming up
Posted on: February 6th, 2014
The PASS BA Conference brings together analysts and IT pros from the world of BI and analytics to connect, share experiences, and learn more about the power of data to transform business. This year’s conference is happening for 3 days on May 7-9th, 2014 at the San Jose Convention Center in San Jose, California, US. http://www.sqlpass.org/bac/2014/Home.aspx
