Procure SQL - the importance of SQL Saturday

The Importance of SQL Saturdays

, ,
I had the distinct honor of helping John Sterrett (t/b) and Dolph Santorine (t) organize and run SQL Saturday #717 in Wheeling, West Virginia on April 28, 2018.  It was a chance meeting at the event that drove home to me why we invest so much…
Procure SQL Validating SQL Server Backups

Validating SQL Server Backups

,
      You have your SQL Server Backup Plan and your Database Recovery Model set.  How do you know if your Backups are good?  TEST!  Validating SQL Server Backups will ensure that you are in a good place when it…

Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th

Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was to remix the song I would just change the word “Havana” to “Wheeling, WV” because…
procure SQL Free SQL Education!

Free SQL Education!

, ,
What is the best way to learn?      The best way to learn is directly from industry professionals!  We are thrilled to be helping the SQLSaturday Wheeling organizers put together a great SQLSaturday, April 28, 2018.  The schedule is packed…
Procure SQL Procure SQL welcomes Jay Falck!

Procure SQL welcomes Jay Falck!

 Procure SQL is proud to announce that Jay Falck has joined our team!  Jay brings a wealth of knowledge, wisdom, experience, and levity to our group. How it all started. Jay’s love of all things computer started his sophomore year in high…
Procure SQL SQL Saturday Chicago

SQL Saturday Chicago

,
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends.  My talk was on Automating the Pain Away with Query Store and Automated Tuning.  I hope this…

Finding Top Offenders with Extended Events

,
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get…

SQL Server Recovery Models

, ,
In my last post (A Beginner's Guide to SQL Server Backups) we discussed the basics of SQL Server Backups.  As Backups are the foundation for Recovery, the next logical discussion should be Recovery Models.  For reference, I have included this…

A Beginner’s Guide to SQL Server Backups

, ,
As was discussed in a previous blog, (The Most Important Role of a SQL Server DBA) Backups and Recovery are the cornerstone of all successful SQL Server DBA careers.  Exactly how much attention is paid to backups until something drastic…

Where is my Availability Group Primary Replica?

In SQL Server 2012 we got this new high availability feature called availability groups. With readable secondaries under the covers, it can be harder to figure out the answer to the following two questions. When did the availability group failover?…