Dec 2016 – James King – Service Broker: A conceptual approach

When: Thursday, Dec 8th
Networking at 5:30 PM
Meeting at 6:00 PM

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

Come hear James King talk about SQL Server Service Broker, a conceptual approach.


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

Nov 2016 – Jason Wood – PowerBI Tips, Tricks, and Traps

When: Thursday, Nov 10th
Networking at 5:30 PM
Meeting at 6:00 PM

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

Come hear Jason Wood as he talks about PowerBI Tips, Tricks, and Traps.


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

Oct 2016 – Brad Feaker – Latest features of SQL Server 2016

When: Thursday, Oct 13th
Networking at 5:30 PM
Meeting at 6:00 PM

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

Come hear about the latest features of SQL Server 2016! This presentation will be delivered by Brad Feaker – Senior Database Architect


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

Sept 2016 – Kevin Kline Part 2!

When: Thursday, Sep 8th
Networking at 5:30 PM
Meeting at 6:00 PM

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

Kevin Kline Part 2!

We are lucky enough to have Kevin speak twice at MEMPASS in the same year.

Topics:
Top 10 DBA Blunders
SQL Server Internals & Architecture


Top 10 DBA Blunders

Abstract:

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?

This session will answer questions like:
* What’s the most common Transact-SQL programming mistake and how do I fix it?
* How do database designers cause problems for future generations of application developers and database administrators?
* Why do inexperienced database administrators make their own job more difficult and less efficient?

There is a short list of mistakes that, if you know of them in advance, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

Prerequisites: Basic understanding of SQL Server architecture, development, design, and administration.


SQL Server Internals & Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.

This session will answer questions like:
* What are the various areas of memory inside of SQL Server?
* How are queries handled behind the scenes?
* What does SQL Server do with procedural code, like functions, procedures, and triggers?
* What happens during checkpoints? Lazywrites?
* How are IOs handled with regards to transaction logs and database?
* What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and 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 RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/233825160/

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/