Perf Tune Your Life with Atomic Habits155 DownloadsIn the database of life, we often get fixated on the end result, forgetting the SQL syntax that gets us there. We obsess over the desired output (goals) but overlook the input and transactions (habits) required for success. This session, inspired by ‘Atomic
Using dbachecks to Validate Your SQL Server Estate241 DownloadsChecking that all your SQL server instances are in compliance with your standards can be a tedious task if you have to do it manually. Well, that is where dbachecks comes in. This open-source PowerShell community-written module makes this task easy. It
Mental Health and Wellness in IT: Safeguarding our most precious resource440 DownloadsOne in four Americans suffers from a mental health challenge each year. In the tech community, this number rises to 42%. In the UK that is 48%. This is a worldwide problem in the IT field. The stigma associated
SQL Server Configuration with dbatools and dbachecks541 DownloadsAutomating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to
Azure SQL Database Maintenance and Automation755 DownloadsAzure SQL Database is a Platform as a Service that provides DBAs with a SQL Server instance in the cloud with the latest features. But many DBAs walk into the Azure SQL Database not sure how to perform the normal maintenance tasks or even
Monitoring Availablity Groups1060 DownloadsSummary Define and cover important metrics and alerts you need to manage a database in an Availability Group. Abstract Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We
Disaster Recovery Where To Begin1767 DownloadsSo you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your
Does This Look Weird? The Importance of Baselining2137 DownloadsSummary Collect a baseline for a SQL Server instance and analyze it against current stats to tell if something abnormal is going on with your SQL Server. Abstract How do you know when your server is on fire? Without a set of
Tips on Managing Lots of SQL Servers778 DownloadsSummary To gain tips to be able to easily manage a lot of SQL Servers. Abstract When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers
Intro to Query Store786 DownloadsIn this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.