T-SQL Tuesday #096: The Group Who Changed My Career Forever!
Data ArchitectureT-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!
Disaster Recovery or High AvailabilityIn 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!
Announcements, Community
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
Announcements, CommunityWe 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”?
Cloud, Community
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?
Disaster Recovery or High Availability
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…
Five Reasons Why Log Shipping Should Be Used
Disaster Recovery or High AvailabilitySQL 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?
Community, Disaster Recovery or High AvailabilityCurious 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
Community, UncategorizedProcure 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
Education, Performance TuningThe 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…