North Texas SQL Servers Users Group

Dallas SQL Saturday 2019 Info

     4 Full Day Sessions for Ridiculously Low prices. One of them has already sold out. Tell your boss, "Hey, I can get a $1200 class for only $139!". Seriously, it's that much of a steal! And these speakers are
Internationally Known, Book Authors, and Respected Authorities. Good gracious folks, what's holding you up? Can't miss that Friday meeting?


 

  More than 60 Sessions throughout the day, 10 different sessions to choose from in any particular hour. Absolutely FREE. What's to lose? Register now!

 


 

   The MAY 2019 meeting is sponsored by Red Gate. We will have 1 big raffle prize and many smaller raffle items to give out. We will also announce their upcoming SQL in the City, taking place next week in Austin, TX. Thank you Redgate!


Next Meeting: Thu, Jul 19 2018

NTSSUG - JULY 2018

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVP URL: 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!

When

iCal
UTC : Thu, Jul 19 2018 23:00 - 01:00
Event Time : Thu, Jul 19 2018 18:00 - 20:00 Central Daylight Time
Your Local Time: Thu, Jul 19 2018 23:00 - 01:00

Where

7000 North Highway 161
Irving, Texas

Direction: None

Featured Presentation

The Case for Change: Identifying and Remedying Bad Code

Speaker: Amy Herold, Premier Field Engineer Microsoft

Summary: 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 Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on 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

Speaker: Jim Donahoe, Cloud Solutions Architect RDX

Summary: 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.

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