The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.
Tue, Oct 03 2017 11:00 Central Daylight Time
RSVP: None
If you have high availability and disaster recovery solutions in place for your SQL Server instances, proper planning and considerations have to be made to upgrade to SQL Server 2016. In this session, we will look at high availability options in previous versions of SQL Server, including database mirroring, failover clustering, log shipping and replication. We will also learn how to upgrade to SQL Server 2016 with minimal downtime when SQL Server high availability and disaster recovery features are part of the existing configuration. This session will focus on: - The considerations for performing an in-place upgrade versus a side-by-side migration - How to prepare for the upgrade in order be successful - How to upgrade to SQL Server 2016 with existing database mirroring, failover clustering, log shipping and Availability Group configuration - How to reduce your downtime and level of effort associated with upgrading SQL Server
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery & system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional & organizational development,leadership & 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 as God has planned for them."
Tue, Oct 10 2017 12:30 (UTC+10:00) Brisbane
Have you experienced slow down in your application because of blocking and wondered what you can do? This talk will cover the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity and deadlocks. We will follow thru this with diagnosing and troubleshooting the blocking issues and will conclude with general guidelines in designing application(s) for maximum concurrency. Session Goals: (1) Overview of blocking and concurrency in SQL Server. This is more of refresher to bring everyone on the same page. (2) Use demos to show blocking including lock escalation and steps you can do minimize or eliminate blocking without any changes in the application. (3) Use demos to show deadlocks and waits induced thru page latches and show how to monitor and troubleshoot.
A seasoned professional with 30+ years of industry experience in databases, Sunil has worked as a lead developer for relational database engine solutions, as a tool designer for backup and restore technologies and as a development manager for B2B commerce and e-learning solutions. He has been in his role as a Principal Program Manager for SQL Server for the last 12+ years. Sunil has authored many technical white papers and blogs, and has co-authored two books on SQL Server and has presented database technologies in numerous national and international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.
Tue, Nov 14 2017 11:00 (UTC-06:00) Central Time (US & Canada)
The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments". In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology virtual chapter.
Tue, Nov 14 2017 12:30 (UTC+10:00) Brisbane
SQL Server instance running on Azure VM is similar to running it on-premises in terms of functionality and application compatibility but there are certain administrative configurations, best practices and optimizations specific to Azure platform which every DBA, database consultant and architect needs to be aware of to improve the performance, reliability and availability of their SQL Server instance in Azure. The session aims to cover the following topics for the attendees: • Common scenarios where running SQL Server on Azure VM is beneficial. • Optimal Azure VM configuration settings for SQL Server. • Understanding storage considerations, limits and configuration settings impacting the performance of SQL Server in Azure VM. • How to tune and optimize SQL Server when running on Azure VMs. • High Availability considerations in Azure. • Backup\Restore options in Azure. • Network and firewall configuration settings in Azure. • Best practices for running SQL Server in Azure VM. • DBA checklist to migrate your existing on-premises SQL Server workload to Azure VM. At the end of the session, attendees will go back with a playbook with all the know-how for optimizing and successfully running their SQL Server on Azure VMs.
Parikshit Savjani is a Senior Program Manager with Microsoft SQL Server Product Group, working on making the customers and SQL community successful on Microsoft Data platform. He has more than 9 years of experience with Microsoft and SQL Server. He started with Microsoft CSS providing support assistance to Premier customers of Microsoft and then moved on to become Premier Field Engineer (PFE), working with large enterprise customers providing best practice guidance, performance tuning, consulting, and proactive assistance to improve the overall health of SQL Server deployments. He contributes to the community via his blog, slideshare & by presenting in various SQL community events.
Tue, Nov 21 2017 11:00 (UTC-06:00) Central Time (US & Canada)
SQL Server 2016 announced many new features like in- Memory OLTP, Live Query statistics, Temporal tables and enriched the existing features Encryption to Always Encryption, High Availability Enhancements, Replication Enhancements etc. which make DBA lives easier. Let's flavor for a while handful of different SQL features. In this session, Microsoft Certified SQL DBA Padma Achanta will demonstrate numerous features of SQL Server 2016. Attendees will learn what’s different in SQL Server 2016 and handful of important concepts which are beneficial in day to day DBA life, along with very good examples, SQL Server Architecture and beyond.
Padma Achanta is a Microsoft Certified SQL Server Database Administrator. She is an enthusiastic participant in SQL sessions and relishes learning about Technologies and educating associates. Padma initiated working on SQL online Video exercises. She gained many rewards for her contribution in SQL Server in her working and worked companies and now she volunteered in Women in Technology.
Tue, Dec 05 2017 11:00 (UTC-06:00) Central Time (US & Canada)
Part 2 of SSIS 2016
Virginia Mushkatblat is currently a founder of Hush-Hush, a data masking company. She wrote her first computer program at the age of 14 and has been in technology ever since, progressively rising through the ranks and trying on different hats including database architecture, development, security and operations. She has worked for Startups and Fortune 100 companies in finance, entertainment, e-commerce, internet advertisement, manufacturing, and communications industries and dealt with both heavily transactional and BI applications.She holds Masters Degrees in Engineering and in Computer Science and currently teaches databases to graduating seniors in CSUN, her Alma Mater.
Tue, Dec 12 2017 11:00 (UTC-06:00) Central Time (US & Canada)
Description
Sanjay Nagamangalam is a Principal Program Manager Lead in the SQL Server division at the Microsoft India Development Center where he helps champion world-class developer & manageability experiences for SQL Server. Before this, Sanjay was responsible for the developer & tools experience for the ADO.NET Entity Framework and helped create the ADO.NET Entity Designer. Prior to joining Microsoft, Sanjay lived in the Bay Area where he co-founded a technology consulting firm (EM3Systems.com) and served as VP technology in a leading online textbook retailer (BIGWORDS.com). Sanjay spent several years at Corel Corporation (Canada) where he headed the Corel WordPerfect and Corel Ventura development teams and shipped several successful releases of both products. Before Corel, Sanjay was Chief of R&D at a security company in Bangalore (India).
Tue, Jan 09 2018 11:00 (UTC-06:00) Central Time (US & Canada)
Squat, deadlift, overhead press, and bench press. In the gym, it's easy to figure out what you need to be doing to get stronger. When you show up to work, you're overwhelmed by all the things happening on your server(s), and you can't figure out where to begin. In this session, we'll talk about building a strong knowledge foundation to help you powerlift your career, without having to clean and jerk or snatch and grab your way to the top. For free.
Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's been a developer at a market research company and a DBA for an eDiscovery shop. He enjoys arguing with the Optimizer and contributing to the First Responder Kit.
Tue, Jan 23 2018 11:00 (UTC-06:00) Central Time (US & Canada)
Secret agents have it all: fun code names, cool gadgets, and fast cars. SQL Server Agent has operators, jobs, and alerts. These features will turn your database server into a well-tuned machine that can warn you of errors, alert you to approaching problems, and run tasks on a schedule. Learn how to increase your automation capabilities and take your notifications to a new level!
Jes Borland is a SQL Server Premier Field Engineer at Microsoft. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is a user group founder, a blogger, and a frequent speaker. In her free time, she runs, cycles, and cooks.
Follow @DBAFundVC
JOIN PASS then add our Virtual Chapter to your list
Please join our chapter by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Present to our Chapter
* Send us an abstract, and your biography to DBAFundamentals@sqlpass.org
* Put Speaker Request in the Subject
* Be patient and we will get back to you. We get a lot of emails.