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#

Nov 2014 – Enterprise Information Management using SQL Server 2014

When: Thursday, Nov 13th
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, Nov 13th, as we take a look at some of the Enterprise features offered by the latest version of SQL Server.

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

Enterprise Information Management (EIM) is a growing priority for organizations that want to gain a competitive advantage by basing key business decisions on credible, consistent, data.

Some of the challenges involved in implementing an effective EIM solution include:
• Integrating data from an increasing number of diverse sources and in a growing number of formats into a common platform for decision making
• Empowering information workers who understand the business to manage data governance, while ensuring IT maintain control

SQL Server provides a comprehensive platform for EIM, which makes it possible to:
• Integrate any data from applications and systems across the enterprise
• Make trusted decisions based on cleansed and standardized data
• Empower business users to manage data governance and easily gain insights from data

Come see how to quickly implement your own EIM environment and learn from industry experts around best practices from the field.

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/215104672/

Oct 2014 – Addressing Trends In Big Data with APS

When: Thursday, Oct 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, Oct 9th, as Anthony Mattas, helps us learn more about big data and the capabilities of Microsoft’s Analytic Platform System’s Parallel Data Warehouse.

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

Big Data is a concept frequently talked about, but often misunderstood. This session aims to peel back the covers on “Big Data” by talking about industry trends and focusing on the capabilities of Microsoft’s Analytic Platform System’s Parallel Data Warehouse workload.

Bio

Anthony Mattas is a Pre-sales architect with Microsoft. He has a bachelor’s degree in Computer Science Theory and Analysis from Western Michigan University. Prior to joining Microsoft Anthony worked as a Business Intelligence consultant for a Microsoft Partner, and before that as the Technical Lead for a Fortune 500’s the Microsoft Business Intelligence platform.


For those that might be arriving after 5:30, the door and elevator code will be posted here as soon as it becomes available.

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/210401212/

You’re invited: Drive business in real-time with your data, big and small – Memphis, TN

A great opportunity to attend one of Microsoft’s SQL 2014 Launch events in Memphis, Tennessee.

Learn how to drive real-time business, from apps to insights, through a deeper look into the comprehensive in-memory technologies in Microsoft SQL Server 2014, Power BI for Office 365, SQL Server Parallel Data Warehouse, and Windows Azure HDInsight. More details in the invitation below.

Please feel free to share this invitation with others in your organization, who might be interested in attending.

image002

When: September 30, 2014 – 8:30 am – 12:30 pm
Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417
(901) 271-3704
(View Map)

Join us.

Big data. Small data. All data. You have access to an ever-expanding volume of data inside the walls of your business and out across the web. The potential in data is endless – from predicting election results to preventing the spread of epidemics. But how can you use it to your advantage to help move your business forward?

Data is growing exponentially and it’s now possible to mine and unlock insights from data in new and unexpected ways. Empower your business to take advantage of this data by harnessing the rich capabilities of Microsoft SQL Server and the familiarity of Microsoft Office to help organize, analyze, and make sense of your data—no matter the size.

Want to learn more? Join us at a SQL Launch Event near you and see how to drive real-time business, from apps to insights, through a deeper look into the comprehensive in-memory technologies in Microsoft SQL Server 2014, Power BI for Office 365, SQL Server Parallel Data Warehouse, and Windows Azure HDInsight. Attending this one-day event will allow you to get a running start on understanding the extensive innovations we’re delivering around data that will empower your business with the tools you need to quickly uncover business insights and make smarter business decisions.

Space at these exclusive events are limited so please reserve your spot today.

AGENDA:

8:30am-9:00am Breakfast and Device Bar
9:00am-9:45am Cloud OS Introduction with New Hybrid Cloud Scenarios in SQL Server 2014
9:45am-10:15am Breakthrough Data Performance with SQL Server 2014
10:15am-10:30am Mid-Morning Break
11:15am-12:00pm The Modern Data Warehouse using the new Analytics Platform System (APS)

REGISTER:
Register Here

LEARN MORE:
Learn more about Data Insights
Learn more about Cloud OS

Sept 2014 – SQL Tips and Tricks – (Rescheduled)

The cancelled Sept 11th meeting as been rescheduled for Thursday the 18th.

When: Thursday, Sept 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 on Thursday, Sept 18th, as we take a look at few tips and trick that could make your life as a SQL developer of DBA easier.

Do you have any tips and tricks you’d like to share? If so, please be prepared to share them with us. The more people participate, the better the meeting can be.

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/201634452/