T-SQL Tuesday #096: The Group Who Changed My Career Forever!

T-SQL Tuesday #96: Folks Who Have Made A Difference Today’s blog post is about T-SQL Tuesday.  If you haven’t seen T-SQL Tuesday before its a great monthly call for all SQL Server bloggers to write about one topic that always changes…

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.  Today,…

Come See Us at Houston TechFest 2017!

,
ProcureSQL is proud to be a first-time sponsor for Houston Techfest 2017.  We would love to see you at this years Houston Techfest!  The admission is FREE!  You can register here.  The complete agenda is posted on their facebook page here. What…

Speaking at Microsoft Ignite 2017

,
We are proud to announce that John Sterrett will be speaking at Microsoft Ignite. This will be John's first time speaking at the Microsoft Ignite conference. John will be talking about migrating existing databases over to Azure.  If you are…

Does Automation Kill the DBA “Store”?

,
  In my opinion, automation will enhance DBAs.  It will allow DBAs to provide more value to the business.  Good DBAs will be fine.   If you are a DBA with ten years of DBA experience who just repeats year one ten times, this might be a…

Should We Compress SQL Server Backups?

Last week we covered five reasons why log shipping should be used.  I got a great question that I thought should be answered here in a short blog post.  The question is "how do you configure transactional log shipping to include compression…
Automatic Tuning: Execution Plan Correction

Five Reasons Why Log Shipping Should Be Used

SQL Server comes with several options to keep your data highly available. Today we are going to cover five different reasons why Transactional Log Shipping should be one of your best tools in your SQL Server DBA Toolbelt.  Validates Transactional…

Want to Learn which SQL Server High Availability Features Are For You?

,
Curious about the basics of SQL Server High Availability?  Please join our founder and MVP, John Sterrett, where he will be presenting SQL Server High Availability 101 on Tuesday, July 18th, 2017 at the North Austin SQL Server User Group.…

Meet us at SQL Saturday Houston

,
Procure SQL is a proud sponsor of PASS SQL Saturday Houston, June 17, 2017! This is a free event for you, your employees, teammates or anyone interested in learning SQL Server for free. Make sure you sign up and come on down.  Please stop…

Resources for Performance Tuning Article

,
The following are some resources that are included in John Sterrett's Introduction to Performance Tuning with Azure SQL Databases Idera Geek Sync. Performance Root Cause Analysis Toolkit Calculate DTU on Your Own  Benchmark Azure SQL Database…