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

Event Display
Meeting Detail

Tue, Oct 02 2018 11:00 UTC


Administering Beyond the Speed of Light : Managing SQL Server with Ansible

RSVP: None

Administering Beyond the Speed of Light : Managing SQL Server with Ansible

Ansible is open source software used for configuration management, server provisioning, application deployment and general automation tasks. It can be used to manage both Windows and Linux based systems, running on-premise or in the public cloud. Despite its ability to perform a vast array of tasks, Ansible is reliable, secure and easy to get up and running quickly. Thanks in part to its agentless architecture, Ansible scales effortlessly to hundreds or even thousands of servers. In this presentation we will walk through the basics of installing and configuring an Ansible server and using this server to administer SQL server instances running on Windows and Linux. No prior knowledge of Ansible is expected but an understanding of basic Linux administration will be helpful.


Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Site Reliability Engineering Manager on the DevOps team at Citrix ShareFile. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Cary, North Carolina. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

Meeting Detail

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


Let’s talk about Big Data using SQL Datawarehouse

RSVP: None

Let’s talk about Big Data using SQL Datawarehouse

Azure SQL Data Warehouse is a massively parallel processing (MPP) cloud-based, scale-out, relational database capable of processing massive volumes of data. SQL Data Warehouse: Combines the SQL Server relational database with Azure cloud scale-out capabilities. Decouples storage from compute. Enables increasing, decreasing, pausing, or resuming compute. Integrates across the Azure platform. Utilizes SQL Server Transact-SQL (T-SQL) and tools. In this session we will discuss about this awesome feature from Microsoft Azure and how we can use it to help on our day to day.


I'm a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I'm a speaker at various technology events such as SQL Saturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I'm the Chapter Leader of SQL Maniacs PASS chapter.

Meeting Detail

Tue, Oct 16 2018 11:00 Central Daylight Time


5 Shifts to Becoming a Rockstar Data Professional (Without the Stress and Burnout Caused by Being in

RSVP: None

5 Shifts to Becoming a Rockstar Data Professional (Without the Stress and Burnout Caused by Being in IT)

Do you struggle with stress and burnout due to working long hours and weekends handling oncall duties? Is work slowly taking over your personal life? Do you feel stuck in your job thinking that you can achieve more than just handling tickets and responding to incidents? Do you secretly wish that you could get fulfillment and satisfaction from the work that you do beyond just managing and analyzing data? This webinar is for data professionals who would like to become a rockstar and take control of their career. I'll show you my step-by-step strategy for becoming a rockstar data professional - DBA, database developer, BI professional, data scientist - without the stress and burnout that a lot of IT professionals experience. I've seen these strategies work for IT professionals who leveraged them to get a promotion, a raise or move on to better jobs.


Edwin M Sarmiento is a Filipino 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 as God has planned for them.”

Meeting Detail

Tue, Nov 13 2018 12:30 (UTC+10:00) Brisbane


Introduction and Use cases for working with Azure Databricks

RSVP: None

Introduction and Use cases for working with Azure Databricks

Worried about performance when processing a Data Lake or other large data store? Need to develop in a collaborative environment and visualize the results in Power BI? Azure Databricks, one of the newer components added to Azure, allows users to connect to data sources such as Azure Data Lake, Azure Blob Storage, Azure SQL DW, Cosmos DB, Azure DB, and SQL Server and stream the data using Apache Spark for processing data to create a machine learning [ML] solution and providing the data to Power BI for visualization. Azure Databricks can provide a very quick way of processing data by adding nodes increase performance for tasks, such as analyzing data for a ML solution from an Azure data store. Azure Databricks also includes a collaborative workspace so that using Azure Active Directory, teams of people can create code in a notebook in R or Python and implement the notebook as an Azure Databrick job. The step-by-step demos will include all you need to know to implement Databricks.


Ginger Grant provides consulting services in advanced analytic solutions, including machine learning, data warehousing, data visualization and cube development using the entire Microsoft Data Stack, including SQL Server, T-SQL, SSIS, SSAS, Power BI and Azure. Ginger started working with data to solutions across a wide range of industries including insurance, education, healthcare, finance and transportation. She is a prolific blogger at http://www.desertislesql.com and frequent speaker and as a MCT provides training for training courses, at conferences and events worldwide to introduce more people to current developments and future trends in data. Microsoft has awarded her an MVP in Data Platform since 2016.

Meeting Detail

Tue, Dec 04 2018 11:00 UTC


Data Compression 101

RSVP: None

Data Compression 101

Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free! We’ll cover the types of compression available and how they work, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!


Jess Pomfret is a SQL Server DBA at Westfield Group in Westfield, Ohio. She started working with SQL Server in 2011 and currently works as part of a team administering over 100 instances ranging from 2005 to 2017. She enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell. She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.

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