The Importance of SQL Saturdays
Community, DBA 101, EducationI 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…
Validating SQL Server Backups
DBA 101, Disaster Recovery or High Availability 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
Data ArchitectureSome 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…
Free SQL Education!
Community, Education, UncategorizedWhat 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 welcomes Jay Falck!
Announcements 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…
SQL Saturday Chicago
General, Performance TuningLast 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
General, Performance TuningThis 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
DBA 101, Disaster Recovery or High Availability, EducationIn 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
DBA 101, Disaster Recovery or High Availability, EducationAs 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?
Disaster Recovery or High AvailabilityIn 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?…