North Texas SQL Servers Users Group

Next Meeting

Thursday,

July

19

NTSSUG - JULY 2018

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

RSVP Here: None

MONTHLY NEWSLETTER
JULY 2018 USER GROUP MEETING

Topic: Getting started with Azure SQL DB: What you need to know

Abstract: Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease. 



Speaker: Jim Donahoe

Meeting starts:6:00 pmwith food and Mingling
Announcements & Ask the Experts:6:30 pm to 7:00 pm
Presentation:7:00 pmto 7:45 pm

When:Thursday, July 19, 2018

Address:
Microsoft Las Colinas Offices
7000 North Highway 161 , Building LC-1
Irving Texas 75039
Map:https://goo.gl/maps/h9aWDZ6Z3wK2

Our meeting this month is sponsored by SentryOne!

Featured Presentation:

The Case for Change: Identifying and Remedying Bad Code

Amy Herold, Sr. Database Administrator One Technologies

There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance. How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

About Amy:
Amy Herold is currently a Sr. Database Administrator with One Technologies in Dallas, specializing in PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

Getting started with Azure SQL DB: What you need to know

Jim Donahoe, Cloud Solutions Architect RDX

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

About Jim:
Jim is a Cloud Solutions Architect with RDX. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids