Do you know what’s going on in your database?

What if you get audited? Who will take the blame?

Don’t get caught with mystery changes.

Somebody’s doin’ stuff in your environment…but who is it?

You gotta know what’s going on. Use sp_whoisactive.


Use the sp_whoisactive script

Instructions

  1. Click Get The Script below and download the file.
  2. Upload
  3. Figure it out

Did did did you see that?

People are sneaky. Don’t let them wreck your life.

convertkit form

VIDEO HERE

What happens if you don’t know what’s up

  • more good points
  • even more good points

You gotta know who’s making those changes

  • some good point
  • another good point

We leverage community proven scripts to help ensure you  know who to blame when everything goes belly up.

Maybe you don’t care?

Oh, you will.

One-Time Setup Help

$399

  • - Discussion on your recovery needs
  • - Implement the backup process
  • - Verify backups function properly
  • - Provide training
Get Started
On-going Backup Support

$150 /month

  • - Monthly Service
  • - SQL Server backups available locally and offsite
  • - Stored in Azure blob storage
  • - Very Secure
  • - Ongoing monitoring of the backup process
  • - Your team can request a backup at any time
Get Started

Frequently Asked Questions

  • Why does my backup location look like a code?

    This normally means you are writing to tape or a network location using third party software. You will need to verify with your software the location of your backups.

  • I use Veeam or VMWare for backups. Isn't that enough?

    If it is set up correctly, these types of backups can be sufficient; however, we normally see they are not correctly configured and leave you vulnerable. We recommend taking SQL Server backups AND Veeam/VMWare backups to eliminate the chance of issues when you need to restore.

  • Why use SQL Server backups?

    As long as you have a backup file, the database can be restored–sure there are rare exceptions to this; however, a backup file reduces the reliance on other software to restore data.

  • My Differential backup is from the past.

    There are many different backup options and we don’t consider differential backups mandatory, so we only suggest you review your plan if the differential backup is more than 30 days old.

Don’t take excuses.

Get sp_active.

convertkit form


The real cost of not knowino’

You gonna be in trouble if you dinna know who’s doin’ stuff

Neither is data loss
Verizon’s annual data breach investigation report indicates the cost to business for ‘small’ amounts of data loss average $25,000 per incident.  Calculating data loss varies from organization to organization, but when data is unavailable–especially unplanned unavailability, two general areas to consider include lost productivity and lost sales. Think about what downtime will cost you and it doesn’t take long to recognize you lose more than data when your data is unavailable.
Ransomware attacks cause an average of 16.2 days of downtime
96% of business experienced an outage in a 3-year period
“The true cost of the data breach was much higher than what we projected.”
Data breaches are becoming more common; however, data loss can occur by hardware failure, theft, lost, negligence, malware and even accidently destroyed.
Businesses can significantly mitigate the impact and cost of data loss with a data backup solution. As a enterprise level tool, SQL Server requires special attention.
One-Time Setup Help

$399

  • - Discussion on your recovery needs
  • - Implement the backup process
  • - Verify backups function properly
  • - Provide training
Get Started
On-going Backup Support

$150 /month

  • - Monthly Service
  • - SQL Server backups available locally and offsite
  • - Stored in Azure blob storage
  • - Very Secure
  • - Ongoing monitoring of the backup process
  • - Your team can request a backup at any time
Get Started
I feel much more comfortable knowing SQL Data Partners helped set up my backups correctly.
Kyu Cho - Printing Center USA
I can finally have a use case for cloud services–Backups!
Jim O'Shea - Maracle

Found a bug or issue with our report? Let us know.

Listen to our SQL Server maintenance episodes.

Our SQL podcast keeps you easily informed and entertained.

Episode 252: The Cumulative Update Dilemma

 Episode 252: The Cumulative Update Dilemma 720 540 Carlos L Chacon

Episode 236: Database Monitoring with SQL Sentry

 Episode 236: Database Monitoring with SQL Sentry 560 420 Carlos L Chacon

RPO and RTO

 RPO and RTO 560 420 Carlos L Chacon

Episode 230: Recovery Time Objective & Recovery Point Objective

 Episode 230: Recovery Time Objective & Recovery Point Objective 560 420 Carlos L Chacon
Episode 172: Power BI Monitoring

Episode 172: Power BI Monitoring

 Episode 172: Power BI Monitoring 560 420 Carlos L Chacon
Episode 163: Very Large Databases

Episode 163: Very Large Databases

 Episode 163: Very Large Databases 560 420 Carlos L Chacon
Episode 133: Shrinking Files

Episode 133: Shrinking Files

 Episode 133: Shrinking Files 560 420 Carlos L Chacon
Episode 112: Keeping up with patching

Episode 112: Keeping up with patching

 Episode 112: Keeping up with patching 560 420 Carlos L Chacon
Episode 102: Monitoring Availability Groups

Episode 102: Monitoring Availability Groups

 Episode 102: Monitoring Availability Groups 560 420 Carlos L Chacon
Episode 90: DBCC CheckDB

Episode 90: DBCC CheckDB

 Episode 90: DBCC CheckDB 560 420 Carlos L Chacon
Episode 04: Advanced Backup Techniques with Tim Radney

Episode 04: Advanced Backup Techniques with Tim Radney

 Episode 04: Advanced Backup Techniques with Tim Radney 560 420 Carlos L Chacon
Episode 03: Backup and Recovery

Episode 03: Backup and Recovery

 Episode 03: Backup and Recovery 560 420 Carlos L Chacon

Backup History

 Backup History 560 420 Carlos L Chacon

The Importance of Backups

 The Importance of Backups 560 420 Carlos L Chacon
Back to top