Mastodon
SQL Performance Tuning in Bulk in AWS

SQL Performance Tuning in Bulk in AWS

My company recently moved to AWS, so I’ve been looking for more information specific to SQL Server performance tuning in AWS. Unfortunately, a lot of what I’m finding is marketing copy devoid of technical detail. Apparently, moving my data to the cloud is great for...

Pull the restore chain from MSDB

What files do I need to restore this database to a point in time? You might know this off the top of your head, especially if you set up the backups or if you don’t have a lot of backups, but just in case you’re panicking, ask MSDB.  MSDB knows all…...

SQL Server Express Maintenance

Don’t you love looking at your old scripts? I’ve rewritten all of our maintenance jobs, including the jobs in task manager that handle SBSMonitoring.  I’ve rid myself of Windows Internal Database, but was still using the script I wrote for it.  Not...

Pin It on Pinterest