The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.
Tue, Sep 05 2017 11:00 Central Daylight Time
RSVP: None
SQL Server Management Studio is so full of tiny buttons and different options that it can be hard to know what to do. Learn tricks to make using SSMS easier and more fun.
Kendra Little teaches people to architect and tune SQL Server for performance. She is a Microsoft Certified Master in SQL Server, a Microsoft MVP, and one of the few artists in the world to draw both dinosaurs and databases.
Tue, Sep 12 2017 11:00 Central Daylight Time
RSVP: https://attendee.gotowebinar.com/register/4117932011900835841
The world’s fastest growing job is that of the data scientist. Many believe the career is out of reach without a PhD. While many job requirements list a PhD as preferred it’s not a necessity. The good news for database professionals is that we can leverage our skills and experience to enter the machine learning space without the advanced education requirements. There’s a learning curve but it doesn’t require a master’s or PhD. In the real-world companies need data scientists who specialize in applied machine learning. Machine learning is a type of artificial intelligence that provides computers with the ability to learn without being explicitly programmed. Applied machine learning is using existing algorithms to build predictive models at the expense of understanding how the under lying algorithms are written. In this session I’m going to discuss the move from the DBA role to that of the Machine Learning Engineer. We will learn about applied machine learning. In addition to discussing machine learning we will build a predictive model in Python and Azure Machine Learning Studio. We are about to witness an explosion in applied machine learning and I’m going to show what you’ll need to do to get started.
Mike West brings over 23 years of IT experience, including expertise in network administration and SQL Server. Prior to becoming a database consultant, Mike worked as a senior level SQL resource for Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. Mike’s technical expertise for the last 20 years has centered on databases. For the last 18 years Mike’s sole focus has been on SQL Server. Mike is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) Born in Ohio, raised and educated in Pennsylvania, he currently resides in Atlanta.
Tue, Sep 12 2017 12:30 (UTC+10:00) Brisbane
Topic: T-SQL's Hidden Support Feature Description: 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, Sep 19 2017 11:00 Central Daylight Time
RSVP: https://attendee.gotowebinar.com/register/9016254114803772419
This session is about performance tuning your day. We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier. Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use. I am a SQL Server DBA and Microsoft Data Platform MVP that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. Since 2003, I have been supporting high-volume, highly-available OLTP environments with demanding performance needs.
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 13 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy is also co-organizer of SQL Saturday events in Boston, and the founder of the BostonSQL User Group
Tue, Oct 03 2017 11:00 Central Daylight Time
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.
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, 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.