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/

May 2014 – See y’all at the BQQ 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 15-16, 2014
By Invitation ONLY!

Presented by:
Microsoft, New Horizons, SoftChoice, Core BTS, Aptera, Aspect, Vitalyst, Intel, HP, Avanade and Certified Security Solutions, Inc (CSS).

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-123) at the 2014 Memphis in May – World Championship Barbecue Cooking Contest. Presented by Microsoft, New Horizons, SoftChoice, Core BTS, Aptera, Aspect, Vitalyst, Intel, HP, Avanade and Certified Security Solutions, Inc (CSS).

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

Dates & Times:

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

 

Location:

R123 Tent #123

 

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.

Upcoming SQL 2014 Launch Events

Now that SQL 2014 has been release, Microsoft is hosting a number of launch events.

Tune in April 15 at 10 AM PDT to hear from CEO Satya Nadella, COO Kevin Turner and CVP Quentin Clark.For more information, visit:
http://www.microsoft.com/en-us/server-cloud/new.aspx#fbid=GVtPb6B7ejx

If you prefer a live event, on Wednesday, April 30th, you can attend a live Accelerate Your Insights event in Franklin, TN. For more information, visit: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032583476&Culture=en-US&community=0

If you haven’t done so already, subscribe to this blog to receive notifications of new events as we post them.

Apr 10 – Dan Evans – SQL Server 2014 Launch – Accelerate Your Insights

When: Thursday, Apr 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)


Update: The “deck” from Thursday’s meeting can be downloaded from here: SQL Server 2014 Overview with Data Insights – Memphis PASS April 2014k


On April 1st, Microsoft released SQL Server 2014 and it was no joke. Join us Thursday, April 10th, as Dan Evans takes us through our first look at SQL Server 2014.

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

For those arriving after 5:30, the door code will be posted here as soon 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/175483982/

Abstract:
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 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 and Power BI for Office 365. Attending this 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.

Bio:
Dan Evans is a Senior Technology Solution Professional on the BI and Analytics platform at Microsoft. He brings over 20 years’ experience developing and delivering innovative analytic solutions on the Microsoft platform. Dan has presented at numerous regional and national conference including TechEd, PASS, DAMA, and TDWI, regarding best practices and architecture utilizing both on premise, cloud and hybrid solutions. He now supports many regional user groups including PASS, DAMA, TDWI, and the newly formed Modern Excel User Group (MEUG).

2014-Mar 13th – Sathya Nekkanti – SQL 2008 Data Structures

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

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

Join us on Thursday, Mar 13th, as Sathya Nekkanti, from FNC Inc., talks to us about SQL 2008 structures.

Please Note: Those arriving after 5:30 PM will need the door code to get in. Be sure to RSVP if you plan to attend so you will receive the code. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/169874692/

Abstract:
Sathya Nekkanti will discuss SQL server 2008 data structures, specifically covering Data Compression, Sparse columns and Filestream. Sathya will discuss how the Data compression works in SQL server 2008 and how to understand the data structure of the compressed data. He will talk about when to use sparse columns, how the data structure looks internally with sparse columns, some of the traditional alternative ways of storing heterogeneous data instead of sparse columns, and their benefits and pitfalls. Finally, he will dive into the FileStream feature in SQL server and its data structure.

Bio:
Sathya Nekkanti is a Microsoft certified IT Professional for SQL server 2008 for development and DBA as well. Currently working for FNC Inc. for the past 13 years in the role of Senior Manager/Database Architect, primarily focusing on several banking FNC systems Database Architect Design and maintenance. Before joining FNC Sathya worked for PlanetRX.com where he worked on design and work flow engine for retail and prescription orders. Prior to PlanetRx Sathya worked on several Banking applications for international transactions applying SWIFT(Society for Worldwide Interbank Financial Telecom) principles.

Memphis Technology User Groups

The Memphis PASS Chapter has now joined other technology user groups in Memphis under the umbrella of the Memphis Technology User Groups.

The Memphis PASS Chapter will no longer be using EventBrite for sending out invitations to its monthly meetings. All future event notifications will be done via the Memphis Technology User Groups Meetups group. To be sure you get notified about our future events, please go to Memphis Technology User Groups Meetups and register. By registering, not only will you be notified about all the Memphis PASS Chapter events, but you will also be notified about other technology related events in Memphis.

Please pass the message along to other group members you know, or to others interested in finding out about other user groups in the Memphis area.

Hope to see many of you at future events in Memphis.

2014 – Jan 9th – Dan Evans – Deep Dive into BI on the Fly

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

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Happy New Year everyone.

Join us on Thursday, Jan 9th, for the chapters first meeting of the new year. We’ll begin the meeting with some important news regarding Memphis PASS Chapter and then a short discussion about the future of the group. After that Dan Evans will take us for a deeper dive into BI on the Fly.

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

Abstract:

BI on the Fly – With Excel as the predominant data analysis tool, all users can perform deep, rich data location, integration, delivery, and visualizations using everyday tools. Excel has the ability to quickly locate data with Data Explorer and structure information in PowerPivot to create strong correlations between items and create a foundation for further analysis. Come hear more about combining PowerPivot for self-service BI reporting with GeoFlow for 3D visualizations to provide a comprehensive and compelling view of information to engage others in true collaborative BI.

Bio:

Dan Evans is a senior Technical Solution Professional (TSP) with Microsoft focusing on Business Intelligence and Data Analytics.  Dan builds trusted relationships with accounts in the Heartland District to advise customers on the benefits of using the Microsoft Data platform by growing awareness and supporting adoption.   He holds several technical and professional certifications (MCP, MVP, CBIP) in the industry and has presented at national conferences like TechEd, PASS and TDWI.

 

Eventbrite - Memphis PASS - Dan Evans - Deep Dive into BI on the Fly