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/

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!