Aug 2016 – Dan Evans – Power BI – Reflecting one year later

When: Thursday, Aug 18th
Networking at 5:30 PM
Meeting at 6:00 PM

Where: FedEx Institute of Technology, 2nd Floor – Room 227
356 Innovation Drive
Memphis, TN 38152
(View Map)

Please note date and location change.

Power BI – Reflecting one year later

Power BI is one of the fastest growing capabilities from Microsoft with over 5M subscribers across 200k companies in over 200 countries. This global phenomenon allows anyone to visualize and analyze data with greater speed, efficiency, and understanding. Power BI connects users to a broad range of live data through easy-to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life. Looking over the past year some lessons learned and best practices emerged to make the experience even better. Come learn about the different ways Power BI can make an impact on your organization by observing the most recent updates to Power BI Desktop, Power BI Service (.com) and Power BI Administration. New licensing models have emerged with Power BI Embedded and Power BI Publish to Web to extend the capability to external and public audiences. Come see how you can benefit from others regarding large-scale deployments and overall analytics governance as you move your organization into the data-driven era.

BIO

Technology consultant with over 20 years’ experience in applying innovative solutions to business needs. Key focus areas are Business Intelligence, Enterprise Performance Management and Data Strategy. Work heavily in promoting technology across North America through involvement with regional user groups (.NET, PASS) and industry-recognized organizations (TDWI, DAMA).

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 RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/232478271/

July 2016 – Kevin Kline – End-to-End Troubleshooting for SQL Server

When: Tuesday, July 12th
Networking at 5:15 PM
Meeting at 6:00 PM

Where: FedEx Institute of Technology
365 Innovation Drive
Memphis, TN 38152
(View Map)

End-to-End Troubleshooting for SQL Server: Ten Query Tuning Techniques Every SQL Programmer Should Know

Kevin Kline is a renowned database expert and software industry veteran currently serving is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. A Microsoft SQL Server MVP since 2004, Kevin was a founding board member and former president of PASS. He has written or co-written eleven books including the best-selling SQL in a Nutshell. Kevin contributes monthly columns to SQL Server Pro and DBTA magazines. Kevin is a noted trainer and thought leader on IT leadership skills, database management technology and practices, and SQL Server performance tuning and optimization. Kevin is a top-rated speaker at conferences worldwide such as Microsoft TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and SQL Connections. He tweets at @kekline and blogs at http://KevinEKline.com.

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 RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/231960807/

Microsoft SQL Server Developer Edition is now free

Great news, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members. Visual Studio Dev Essentials also offers some interesting free benefits for developers.

For more information see:

Microsoft SQL Server Developer Edition is now free

Visual Studio Dev Essentials

June 2016 – Louis Davidson – OLTP Read and Write Operations

When: Thursday, June 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, June 9th, as Louis Davidson talks to us about read and write operations for OLTP databases.

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 1925#

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 RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/231265440/

Summary:

Let Me Finish…

Isolating Write Operations OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

Bio:

Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

24 Hours of PASS 2016 – Evolution of the Data Platform

Evolution of the Data Platform

Register now for 24 Hours of PASS: Evolution of the Data Platform!

From May 25-26, 2016 starting at 12:00 GMT, 24 one-hour webinars will be presented live back-to-back for you to enjoy from the comfort of your home or office!

This edition will showcase cutting-edge technologies presented by a diverse mix of community speakers, MVPs, and Microsoft speakers. The areas of focus will include SQL Server 2016, Cortana Intelligence, Azure ML, R, Azure HD Insight, Hadoop and more.

Don’t miss this excellent training opportunity. Reserve your spot today! Register now!

Apr 2016 – The Future of the Mem-PASS User Group

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


As some of you may have heard, I, Alvin Ramard, am planning on stepping down as leader of the user group. We need to take the time for a serious discussion about new leadership for the group and how we will handle the transition. This is an opportune time to think about how the group can best serve the local community. I hope that several members will volunteer to become the new leadership team.

If you know anyone interest in our group, or interested in SQL Server and/or Microsoft BI, please invite them to our meeting. The more interested people attend the meeting the better. A few members have indicated an interest in getting involved. I hope others will offer to support them.

Join us Thursday, Apr 14th, as we discuss the future of the Memphis PASS Chapter and Power BI User group.

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 1925#

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 RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/229263957/

Summary