Thanks for your help. That's exactly what I was looking for.

Unfortunately, the script button is not enabled in that window. That was the first thing I looked at.

I included a screenshot of where I would need to add checks in the checkboxes. I only included a portion of the fields in the table, but there are others...

@Jeffrey,

Good points. In our case, the reporting system queries are severely constrained, so we have less opportunity for runaway processes. That said, it's important to take that possibility into consideration,...

Thanks ratbak,

Sounds like it's more the normal things to worry about in terms of sizing and less any specific settings in SQL. Our primary CPU & memory use are definitely...

Do either of you know any consultants in the Seattle, WA area that could help us get started so that we can incorporate best practices from the start?

Those suggestions are making the Hallengren scripts look better all the time. I'll see if I can get approval to use those. I was hoping for a better understanding of...

I'm working on integrating them. I've gotten permission to include the indexing and statistics portion. But not the backup maintenance one (yet). So, I need a solution for today 😎

Best...

Thank you!

Can you include your function (obviously substituting <username> for the username and other sensitive information)? I'm new to scripting outside SSMS and new to PowerShell, so any information you...

It looks like DBGhost is more of a source management tool than a deployment tool. It also uses VSS, which we're moving away from.

It looks like the Packager Plus...

How do you log errors?

ie: If a script #6 dies on database #20, how do you know that?

Can I do the following:

Setup:

Create a share on my server

Add a T-SQL script "UpdateDB" that is empty

Set up an agent that runs "UpdateDB"

When I need to deploy scripts:

Copy scripts in...

SQL Compare looks like a great tool.

But, assuming I now have a script I can run on all my databases, I'd like to schedule it during off hours. The...

Thanks. I'll give them a look.