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/

August 2014 – How to be a great DBA?

When: Thursday, Aug 14th
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, August 14th, as we take a look at the presentation from a recent Database Administration Virtual Chapter presentation dealing with the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication. Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

We’ll follow it up with a discuss of the ideas presented and what else we can do.

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

July 2014 – SQL Server licensing overview and practical approaches

When: Thursday, Jul 10th
Pizza at 5:00 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, July 10th, as Dan Evans and Rob DeMotsis help us learn how to save time and money with SQL Server licensing.

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

Abstract

Starting with SQL Server 2012, the software licensing model made significant changes from a per processor to per core model. This conversion process allows for greater flexibility in deployment but has come complexities in the conversion process. Come learn some of the key points in this license model change along with some free tools to help you manage your database environment. A great case study will also be used to illustrate how you can not only gain control over your environment but also benefit from a more strategic approach to leverage the investment in SQL Server.

Bios

Rob DeMotsis is the Database Manager for Baptist Memorial Hospital and has several years of experience architecting, developing and implementing enterprise scale SQL Server solutions for large organizations in the Mid-South.

Dan Evans is a Senior Technical Solution Professional for Microsoft focused on data architecture, data governance, Big Data, Business Intelligence and Analytics and Azure for Tennessee.

Memphis PASS Chapter June Meeting

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

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

Our next meeting is just a few days away. Come join us on Thursday, June 12th, as we take a quick look at what PASS has to offer it’s website via the virtual chapters and other resources. After that we’ll launch one of the recorded presentation and follow it up with an open discussion.

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