A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much smaller.
Tag: Database Maintenance
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part to me rushing around trying to […]
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Broken Broker […]
Day 11 – Purging syspolicy
This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Broken Broker […]
Day 10 – Retention of XE Session Data in a Table
Gathering event information is a pretty good thing. It can do wonders for helping to troubleshoot. What do you do if you need or want to be able to review the captured information in 3 months or maybe 12 months from now?
Day 9 – Queries Going Boom
This is the ninth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Broken Broker […]
Day 7 – Command ‘n Conquer
This is the seventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Broken Broker […]
Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Broken Broker […]