June 2015 – Adam Belebczuk – Availability Groups 101: An Introduction

When: Thursday, June 18th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, June 18th, as Adam Belebczuk helps us learn about SQL Server’s AlwaysOn Availability Groups.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Abstract

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.

Bio

Adam Belebczuk is a Consultant, Accidental DBA, and Developer with over 10 years of experience in IT, ranging from customer service to server/network administration to software and database development. Adam holds the MCSE: Data Platform and MCITP DBA 2005/2008 certifications, is a frequent speaker at SQL Server Users Groups and SQL Saturday events, and specializes in SQL development, performance tuning, high availability, & disaster recovery.

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220193017/

May 2015 – See y’all at the BBQ Fest

We will not be having our normal monthly meeting in May. Instead, you’re all invited to come sample some of the best BBQ on earth.

This is by invitation only so don’t forget to click one of the links below for your invitation, or by clicking here.

See you there. Don’t forget to bring your appetite. 😉



image002

May 14-15, 2015
By Invitation ONLY!

Presented by:
1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital

Register now to reserve your space!

Questions?

Contact Aimee Howell @ 901.375.1533 or email @ ahowell@nhmemphis.com.


As a valued customer, we have your tent waiting…

Please join us in the Smoke Masters Championship BBQ Team Tent (#R-130-131) at the 2015 Memphis in May – World Championship Barbecue Cooking Contest. Presented by 1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital.

This event is by INVITATION ONLY, so we encourage you to reserve your seat today.

Dates & Times:

Thursday, May 14 Lunch: 11:30 am – 2:00 pm
Dinner: 4:30 – 7:30 pm
Friday, May 15 Lunch: 11:30 am – 1:30 pm

 

Location:

R130-131 Tent #130 and 131

 

General Information:

Admission to Memphis In May is FREE from 11:00 AM to 1:00 PM. Single Day Tickets are $8 (after 1:00 PM) – Children 6 and under are Free.

Admission to the Smoke Masters tent is free to invited guests.

Apr 2015 – DBA to Data Scientist

When: Thursday, Apr 9th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Apr 9th, as Cherie Sherriff, helps us learn more about the migration from DBA to Data Scientist.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/221087006/


DBA to Data Scientist:

Data Science is one of the technology hot topics and growing career fields. How does the journey start from being a DBA to following a path of data analytics to the point where you become a Data Scientist? What do you need to know and where can you find that information? If you have ever wondered what the difference is, how to get there, what you might need to learn, or even IF you want to go that route, this session will cover the key points to all of these questions and provide you with ample resources to make this journey.

Mar 2015 – A Window into Your Data: Using SQL Window Functions

When: Thursday, Mar 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Mar 12th, as Steve Hughes from Pragmatic Works, helps us learn more about SQL Server’s Window functions.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220657051/


Abstract:
Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.

Bio:
Steve Hughes is an Architect at Pragmatic Works. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered multiple presentations on SQL Server and data architecture over the past six years.

Feb 2015 – Tips and Tricks for Planning a Data Warehouse

When: Thursday, Feb 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Feb 12th, as we take a look at Tips and Tricks for Planning a Data Warehouse.

Do you have a new, or on-going, Data Warehouse project but are not sure how to proceed? Planning the design of a Data Warehouse can be a daunting task and overall these projects have a low success rate. Join us as we see what Brian Knight help us learn tips and tricks for planning the design of a data warehouse as well as walk through the actual implementation of dimensional model.

We’ll be review a recent webinar from Pragmatic Works where Brian Knight covers a number of items to keep in my as you plan, or implement, your data warehouse project.

Do you have any tips and tricks, best practices, or horror stories, you’d like to share with us? Join us and hopefully you’ll learn a few things that can help make your data warehouse project successful.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220131618/

January 2015 – Autogenerate a Dimensional Data Warehouse from Metadata

When: Thursday, Jan 15th, 2015
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Most data warehouse design efforts produce a large amount of metadata in the form of handwritten documentation. If done properly, this documentation provides everything the development team requires to build the dimensional data model and load that model with transformed data using the patterns and best practices that were also specified as part of the warehouse design. Unfortunately, the process of translating requirements to T-SQL scripts and SSIS packages requires tremendous effort and creates assets that are expensive to maintain.

Join us this Thursday, Jan 15th, as we take a look at one of the sessions from the 2014 PASS Summit where Scott Currie will show how to use a metadata database to store the requirements information, and then use this metadata to automatically generate EVERYTHING you need for your data warehouse project: documentation, schemas, SSIS packages, deployment scripts, etc. The code for the solution, which is presently in use in production data warehouses in major international companies, will be provided for all attendees to freely use.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#