Automatic Tuning in the Real-World
Performance Tuning
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster. Microsoft’s marketing team even jumped on…
GroupBy Conference Resources: demos and source codes.
Performance TuningI hope everyone enjoyed my session on Making Your Queries Go Faster as much as I did planning and delivering it. If you would like to replay the demos on your time you can grab the slide and code . When you go through the demos, if you have…
September 2018 Training Opportunities
Announcements, Community, EducationThe Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars! We are very proud of our team and their efforts to share knowledge and experiences. Be sure to say hello and…
What is RPO/RTO?
DBA 101, Disaster Recovery or High AvailabilityTime is money!
Your boss keeps talking about RPO (Recovery Point Objective) and RTO (Recovery Time Objective). Do you just nod your head like you know what he/she is talking about? Maybe that scenario just…
Does Your Database Have any Integrity?
DBA 101, Disaster Recovery or High Availability, Health Checks, UncategorizedCorruption. We know it is everywhere. It is surely a hot-button issue in the news. If you haven’t given much thought to database integrity, now is the time to sit up and pay attention. Corruption can occur at any time. …
Deep Dive into Bulk Logged Recovery Model
DBA 101, Disaster Recovery or High Availability Full disclosure time: Bulk Logged Recovery Model is quite confusing to me. And as it seems, to many others. I wrote a bit about it in SQL Server Recovery Models and decided that it was so complex, I really wanted…
Demystifying System Databases
DBA 101, Design, Disaster Recovery or High Availability Recently I have heard a lot of people discussing SQL Server System Databases. The topic of system databases seems to be a deceptively basic one. But how many people truly take the time to understand what system databases are and what purpose…
SQL Saturday Houston 2018
Announcements, Community, Education, General
We are back this year! Not only are we sponsoring SQL Saturday Houston, we are also speaking! All three of us are presenting! Go here to see the full schedule.
What is SQL Saturday?
SQL Saturday is a free training event for Microsoft…
Four Tips for Entry-Level and Experienced IT Professionals
CommunityJohn Sterrett shares his thoughts on successfully transitioning to an entry-level IT job.
Recently, I worked with AITP to share some tips that helped me successfully transition from a Computer Engineering student at the University of Oklahoma…
My SQL Saturday Firsts
CommunityIn October 2011, after working with SQL Server since 1998, I discovered something called SQL Saturday and PASS. For those unaware, these are local events, setup and run by volunteers. Speakers come in from all parts of the country to share,…