by Katherine Villyard | Feb 26, 2024 | sql
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... by Katherine Villyard | Feb 19, 2024 | sql
Mostly so I can link it to a post that’s getting traffic… Declare @DBname varchar(255), @SQL nvarchar(max), @today nvarchar(50), @servername nvarchar(50) set @today = convert(nvarchar,GETDATE(),12) set @servername =... by Katherine Villyard | Jun 2, 2016 | scripting, sql
I set this up to be modular and reusable, because I like reusing things. This doesn’t actually move your system databases. It just outputs a change script and a revert script. You still have to run the generated script, then log on to your server and restart... by Katherine Villyard | Feb 9, 2016 | scripting, sql
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…... by Katherine Villyard | Feb 2, 2016 | scripting, sql
Google informs me that my post on Windows Internal Database Maintenance is popular. It’s not what I’m currently using, however. I’ve switched over to Ola Hallengren’s scripts. If you download and run the installer script, it creates a series... by Katherine Villyard | Jan 12, 2016 | monitoring, powershell, sql
Or, Log-Shipping over 1200 databases automagically. The Problem Question: How many SQL Server databases can you put on one server? Answer: It depends on how fast you need them restored if something terrible happens. Because Dude, if your server crashes most heinously,... by Katherine Villyard | Apr 22, 2014 | sql
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...