The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Jul 11 2017 11:00 Central Daylight Time


SQL Server Performance Tuning Made Easy

RSVP: https://attendee.gotowebinar.com/register/4566824126635228417

SQL Server Performance Tuning Made Easy

SQL Server Performance Tuning is still a mystery to many. Quite often even an experienced SQL Server DBA, often gets confused as to how to figure out where to start with this entire process. In this module we are going to learn about how to get started with SQL Server Performance Tuning. We will go over some very important scripts which will help us to get started with the SQL Server Performance Tuning exercise. At the end of the session the author will share his three important scripts which he uses at his customer sites all the time.


Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 18 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 15+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).

Meeting Detail

Tue, Jul 11 2017 12:30 (UTC+10:00) Brisbane


DevOPs and the DBA

RSVP: None

DevOPs and the DBA

You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration & Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team. It also involves automating tests around the integrated work. Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery. Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.


Hamish is a Systems Management Specialist with a passion for efficient database & application deployment using DevOps methodologies. He has 19 years IT experience in managing large scale databases on SQL Server & JADE technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic architectural design is his main focus at Jade Software. Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university.

Meeting Detail

Tue, Jul 18 2017 11:00 Central Daylight Time


Extending DevOps to SQL Server

RSVP: None

Extending DevOps to SQL Server

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.


Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Meeting Detail

Tue, Aug 08 2017 11:00 Central Daylight Time


Azure SQL Data Warehouse for the SQL Server DBA

RSVP: https://attendee.gotowebinar.com/register/7531614349923626755

Azure SQL Data Warehouse for the SQL Server DBA

The power of cloud storage and compute power has made data warehousing possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured data sources. With a full T-SQL interface and compatibility with the rest of the Microsoft data stack, Azure Data Warehouse can fit transparently into your business data strategy and leverage already existing and familiar development and management skills. In this session we will look at the main concepts of the Azure SQL Data Warehouse service, how it's different than SQL Server and the advantages it provides to an on-premises solution.


Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.

Meeting Detail

Tue, Aug 08 2017 12:30 (UTC+10:00) Brisbane


SQL Server 2017 - What's New

RSVP: None

SQL Server 2017 - What's New

I would like to show you the most interested features you can find in SQL Server 2017. I will briefly talk about SQL Server on Linux (Security), how to use Python scripts, Adaptive query processing and many more. I will do a lot of demos and almost no slides.


SQL Server MVP & MCT Software engineer with 15+ years of professional experience in all aspects of software development. Damian participated in a number of projects in international environments and possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects. Now he focuses on building solutions based on Microsoft SQL Server environment (including complex database driven systems, database tuning and optimization).

Meeting Detail

Tue, Aug 22 2017 11:00 Central Daylight Time


Not So Secret: Get To Know SQL Server Agent

RSVP: None

Not So Secret: Get To Know SQL Server Agent

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.

Meeting Detail

Tue, Sep 12 2017 11:00 Central Daylight Time


From DBA to Data Scientist

RSVP: https://attendee.gotowebinar.com/register/4117932011900835841

From DBA to Data Scientist

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.

Meeting Detail

Tue, Sep 12 2017 12:30 (UTC+10:00) Brisbane


T-SQL's Hidden Support Feature

RSVP: None

T-SQL's Hidden Support Feature

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.

Meeting Detail

Tue, Sep 19 2017 11:00 Central Daylight Time


Shortcuts From an Impatient DBA

RSVP: https://attendee.gotowebinar.com/register/9016254114803772419

Shortcuts From an Impatient DBA

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

Meeting Detail

Tue, Oct 03 2017 11:00 Central Daylight Time


Upgrade Strategies for Highly Available SQL Server Environments

RSVP: None

Upgrade Strategies for Highly Available SQL Server Environments

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."

Meeting Detail

Tue, Oct 10 2017 12:30 (UTC+10:00) Brisbane


Strategies to get maximum concurrency for your workload in SQL Server:

RSVP: None

Strategies to get maximum concurrency for your workload in SQL Server:

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 developer/lead in the relational database engine technology, a tool designer/lead building backup/restore tools, and as an application developer/manager enabling B2B commerce and e-learning. 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/blogs and has co-authored two books in SQL Server and presented database technologies in numerous national/international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.

Meeting Detail

Tue, Nov 14 2017 11:00 (UTC-06:00) Central Time (US & Canada)


T-SQL's Hidden Support Feature

RSVP: None

T-SQL's Hidden Support Feature

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.

Meeting Detail

Tue, Nov 14 2017 12:30 (UTC+10:00) Brisbane


Optimizing your SQL Server for Azure VMs

RSVP: None

Optimizing your SQL Server for Azure VMs

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 their SQL Server deployment. He contributes to the community via his Blog, Slideshare & by presenting in various SQL Community Events.

Meeting Detail

Tue, Dec 05 2017 11:00 (UTC-06:00) Central Time (US & Canada)


SSIS 2016 - Intermediate

RSVP: None

SSIS 2016 Intermediate

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.

Meeting Detail

Tue, Dec 12 2017 11:00 (UTC-06:00) Central Time (US & Canada)


SQL Tiger Team (TBD)

RSVP: None

SQL Tiger Team (TBD-Later)

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).

Meeting Detail

Tue, Dec 26 2017 12:30 (UTC+10:00) Brisbane


Test to see if Warrick can start a session

RSVP: None

teste

test


Warwick Rudd is a SQL Server MVP, Microsoft Certified Master - SQL 2008, Founder and Principal Consultant at SQL Masters Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5 he has worked in both Australia and England from small start-ups to Multi-National Corporations. Warwick predominantly specialises in designing and implementing HA / DR solutions. He is a frequent speaker at local SQL User groups & SQLSaturday events, Ignite in Australia and New Zealand.

Meeting Detail

Tue, Jan 09 2018 11:00 (UTC-06:00) Central Time (US & Canada)


The Jr. DBA Workout Plan

RSVP: None

The Jr. DBA Workout Plan

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.

Back to Top