• 5 Critical Considerations When Moving to the Cloud

    Online event

    Join Kevin Kline as he talks to the Auckland SQL User Group about "5 Critical Considerations When Moving to the Cloud." **RSVP to get the Teams Live Event details** Migrating an existing on-premises SQL Server application to the cloud can be a daunting task that consists of many complicated steps. In this webinar, we will focus on what is perhaps the MOST important step of the process – those that lead up to the actual move to the cloud. We will dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider. We will cover: • The importance of cleansing your data before a major migration • Fully documenting your data sources and metadata • Choosing from many different tools and techniques to actually move data • How to test data for fidelity • How to maintain parallel systems during transitional phases We'll also share demos and overviews of native features within SQL Server that enable you to move data, as well as show powerful tools from the SentryOne product set that can make data migrations painless. Join us for this informative panel discussion with some of the industry’s top experts! ____________________________ Kevin Kline Principal Program Manager Kevin (@kekline) is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. Currently, Kevin is responsible for SentryOne's technical sales and marketing initiatives and is also heavily involved in product design activities.

    2
  • Modernizing SQL Server the Right Way - Test & Optimize

    Microsoft

    -- Watch the live event in Microsoft Teams http://bit.ly/2IsuR5Z -- End of support for SQL Server 2008 is here (ends in July!), which means you should have already implemented your migration strategy. But, what if you didn't? What approach should you take to ensure a rapid and smooth transition? To guide you through these questions, PASS and Microsoft have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. This session focuses on Database Experimentation Assistant - A/B testing - Compatibility execution errors - Degraded queries - Workload comparison - Hardware comparison - Configuration setting comparison We’d like to thank our sponsors PASS, Microsoft, and Lexel for their support. We look forward to seeing you there! Auckland SQL User Group Speakers: Adrian Sullivan: Consultant - Modern SQL Architecture at Lexel Systems. Adrian helps companies through their SQL data estate and digital workplace journeys. As the Modern SQL Platform principal at Lexel, Adrian's focuses on Data Platform design and implementation, Always On Availability Groups and Performance tuning. Zoran Barac: Senior DBA at Cin7. Zoran is a big data enthusiast with more than 10 years of hands-on experience in database administration. Zoran is a Certified Microsoft Trainer (MCT) and Certified Microsoft Database Administrator (MCSA, MCSE) with a Master‘s degree in Information Technology.

    1
  • Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity

    Microsoft New Zealand Ltd

    15C Managing Director, Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Edwin M. Sarmiento is coming to Auckland on August 8th to deliver a session in front of our Auckland SQL User Group! Topic: Designing a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity Agenda: Arrival @11:45 to 12:00 Start and short intro @ 12:00 to 12:10 Edwin's Session @ 12:10 to 1:10 Questions & Answers @ 1:10 to 1:30 Food and drinks will be provided. _____________________________________________________________________________________ Designing a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements. You will learn: - Common design patterns and guidelines that you need to consider when building your architecture - Proper selection of quorum configuration - Network configuration for local and geographically dispersed replicas - Combining SQL Server Failover Clustering with AlwaysOn Availability Groups Duration: 60 minutes Level: Advanced _____________________________________________________________________________________ SQLSATURDAY 866, Auckland, New Zealand Do not miss Edwin's whole-day workshop on 9th August. The topic will be "The SQL Server DBA’s Guide to DevOps and Docker Containers", workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling and management of containerized applications. Learn more about his Pre-Con and register here: https://www.eventbrite.com/e/sql-saturday-pre-con-the-sql-server-dbas-guide-to-devops-and-docker-containers-by-edwin-m-sarmiento-tickets-62239861100 Biography Edwin M Sarmiento is a Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential.“ https://www.edwinmsarmiento.com/about/

    2
  • Modernizing SQL Server the Right Way - Assess & Convert

    -- Watch the live event in Microsoft Teams http://bit.ly/2XmkwR3 -- End of support for SQL Server 2008 is here (ends in July!), which means you should have already implemented your migration strategy. But, what if you didn't? What approach should you take to ensure a rapid and smooth transition? To guide you through these questions, PASS and Microsoft have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. This session focuses on Data Migration Assistant - Assess Compatibility Issues - Discover new features - Perform Migration “Upgrade readiness assessment was delivered with the help of Database Migration Assistant which helped us analyze our template databases to identify potential pitfalls and suggested automated remediation for our development teams to act on.” - Salesforce – PASS Summit 2017 We’d like to thank our sponsors PASS, Microsoft, and Lexel for their support. We look forward to seeing you there! Auckland SQL User Group Speakers: Adrian Sullivan: Consultant - Modern SQL Architecture at Lexel Systems. Adrian helps companies through their SQL data estate and digital workplace journeys. As the Modern SQL Platform principal at Lexel, Adrian's focuses on Data Platform design and implementation, Always On Availability Groups and Performance tuning. Zoran Barac: Senior DBA at Cin7. Zoran is a big data enthusiast with more than 10 years of hands-on experience in database administration. Zoran is a Certified Microsoft Trainer (MCT) and Certified Microsoft Database Administrator (MCSA, MCSE) with a Master‘s degree in Information Technology.

    2
  • Modernizing SQL Server the Right Way - Discovery

    Microsoft

    -- Watch the live event in Microsoft Teams http://bit.ly/2x6nomu -- End of support for SQL Server 2008 is here (ends in July!), which means you should have already implemented your migration strategy. But, what if you didn't? What approach should you take to ensure a rapid and smooth transition? To guide you through these questions, PASS and Microsoft have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. This session focuses on Discovery. - Which SQL Server versions do I have? - Which Editions am I running? - Which SQL Server components are installed? - How many cores are on each server? - How many databases are in each instance? - What are the sizes of all my databases? - What are the settings for each instance and database? We’d like to thank our sponsors PASS, Microsoft, and Lexel for their support. We look forward to seeing you there! Auckland SQL User Group Speakers: Adrian Sullivan: Consultant - Modern SQL Architecture at Lexel Systems. Adrian helps companies through their SQL data estate and digital workplace journeys. As the Modern SQL Platform principal at Lexel, Adrian's focuses on Data Platform design and implementation, Always On Availability Groups and Performance tuning. Zoran Barac: Senior DBA at Cin7. Zoran is a big data enthusiast with more than 10 years of hands-on experience in database administration. Zoran is a Certified Microsoft Trainer (MCT) and Certified Microsoft Database Administrator (MCSA, MCSE) with a Master‘s degree in Information Technology.

    5
  • Deploy cloud services in Azure SQL with PowerShell

    Microsoft

    Learn from Zoran how to use PowerShell (One script) to deploy cloud service with Azure SQL Database with good resilience to outages (GEO Replications, Failover Groups). From connecting to Azure Accounts to creating fail-over Groups and Avialbility Groups Learn how to configure and use Azure SQL Analytics monitoring solution for monitoring performance of Azure SQL databases. Create Azure SQL Analytics solution in workspace; Enable Azure Diagnostics for your Azure SQL database; Configure Azure SQL Databases to stream diagnostics telemetry; Viewing and Interpreting Azure SQL Analytics data. Agenda will look a lot like: 11h45. Arrival 12h00. Intro 12h15. Session starts - Adrian .......... Join Skype Meeting https://meet.lexel.co.nz/adrian.sullivan/MPLHF4R6 Join by phone [masked],,66627# (Auckland) Conference ID: 66627 Find a local number https://dialin.lexel.co.nz/?id=66627

    4
  • Push Your App to Enterprise Scale with Advanced SQL Server Features

    SentryOne Principal Program Manager, renowned database expert, founder and former president of PASS, and Microsoft SQL Server MVP, Kevin Kline, will share his deep SQL knowledge and best practices at a series of SQL Saturdays and SQL Server User Group meetings all around the world. As a part New Zealand Down Under Tour, in association with SQLMasters Consulting, Kevin Kline is coming to Auckland on June 4th to deliver a session! Topic: Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features Agenda: Arrival @11:45 to 12:00 Start and short intro @ 12:00 to 12:10 Kevin's Session @ 12:10 to 1:30 Questions & Answers @ 1:30 to 1:45 Food and drinks will be provided. ______________________________________________________________________________________ Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users. Here’s what you’ll learn in this session: - Goal 1: Learn how to plan, prepare for, and implement advanced features on SQL Servers, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. - Goal 2: See the performance impact of each of the major feature implementations as they relieve performance bottlenecks. - Goal 3: Learn about the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications. Level: 300 Prerequisites: Intermediate experience with Microsoft SQL Server administration, application architecture, and SSMS. _______________________________________________________________________________________ Biography Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft SQL Server MVP and leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a long-time veteran of the database tools market and serves as Principal Program Manager at SentryOne, makers of popular SQL Server tools like Plan Explorer. Kevin is a top-rated speaker at industry trade shows worldwide. He is on social media (LinkedIn, Twitter, and Facebook) at kekline and blogs at https://blogs.SentryOne.com/author/kevinkline

    10
  • LIVE performance tuning on a production SQL Instance. FREE tools only.

    Microsoft New Zealand Ltd

    Come watch Adrian Sullivan do some live SQL Instance performance tuning on a production SQL server. Adrian will step through a basic triage approach along with some common performance tuning steps for any SQL server. 1. Wait Stats. The instant benchmark. 2. Server configurations 3. How to interpret behavior 4. SQL Check, by Idera 5. sp_Blitz, by Brent Ozar Unlimited We'll provide some drinks and pizza as well. Want to join on Skype? ........................................................................................................................ Skype: https://meet.lexel.co.nz/adrian.sullivan/579LQNYD Skype Web App: https://meet.lexel.co.nz/adrian.sullivan/579LQNYD?sl=1 Join by phone [masked],,52133# (Auckland) English (United Kingdom) Conference ID: 52133 Find a local number https://dialin.lexel.co.nz/?id=52133 Photo by Oscar Sutton on Unsplash

    7
  • Migrating to Azure, and why should you backup LOG files

    Microsoft New Zealand Ltd

    We found a spot at Microsoft. Come join us for our first Meetup at Microsoft in 2018. We are having a free lunch time session where you can listen to Zoran Barac talk about migrating SQL to Azure, and Adrian Sullivan talk about LOG files. We'll even give some drinks and pizza to make it worth your while.

    3
  • Get started with Azure SQL DB, and, Office365 Flow to run SQL stored procedures

    SnapComms (Entrance on Como Street)

    Senior DBA, Zoran Barac, will talk to us about how to get your first Azure SQL Database instance up and running. Zoran will dive into some more advanced options and with a live example to cover the whole concept behind Azure SQL Database, including Azure SQL Server (Firewall Settings, Failover Groups, Secondary Server, Read/write listener, Read-only listener, SQL Elastic Pools) Azure SQL Database (Pricing tier, Geo Replication, Connecting Strings Settings, Query performance Insight, Performance Recommendation), SQL Consultant, Adrian Sullivan, will talk to us about Office365 Flow and interacting with different data sources. Adrian will show us how to run a SQL stored procedure and interact with data tables using Flow. Pizza and drinks will be provided. Agenda: Arrival @16:45 to 17:00 Start and short intro @ 17:00 to 17:15 Zoran's Session @ 17:15 to 17:45 Adrian's Session @ 17:50 to 18:20 PARKING: Parking on the street. Ideally in a parking bay, there might be parking available in the SnapComms parking lot, but we cannot guarantee this. SnapComms have been kind enough to provide us the use of their facilities for this Meetup. Physical: 7 Auburn Street (Entrance on Como Street), Takapuna, Auckland 0622 If the door is closed, just ring the bell. Yes, there is traffic, yes this is North Shore, so try to arrive 15-30 minutes before the event starts. When in doubt call Adrian Sullivan on[masked] about arrangements.

    3