One way that I worked around this for Express instances was to run backup jobs on a server with SQL Agent. The job called a backup proc on the...

I've used it for databases and you can import all of the objects from an existing database and then go from there. I've also created new projects for new...

I don't think if you're moving primary key indexes to a new file group for replicated tables that you can avoid having to redo replicaton. We regularly move indexes...

You'd probably have to modify the report or develop a custom report. I've used this in the past, but used my own queries to look at the collected data. ...

I got my start by completing a vocational school for mainframe programming in the early 80s, but I had already attended college as part of an earlier career path. ...

This what we use to fix all SQL Server logins in a restored database, wrapped in a stored procedure. Run it in the restored database.

SET NOCOUNT ON

DECLARE CUSR CURSOR...

You can grant execute permissions on a schema to users or roles which would include all of the stored procedures and functions in the schema.

It may faster to restore a backup than to rebuild it, but I've never tested it with a large database. I just always figured that it couldn't hurt to...

You can add data viewers in the data flow, which can be somewhat helpful.

I recall looking into this once and there is a check subfolders ” check box that wasn’t checked in the clean-up task. That would only apply if you were...

We have this issue because of Commvault system backups that run at odd times. I added 2-3 retries to the backup job step with 15-30 minute retry increments. ...

Service Broker could be another option, though validation at an earlier point in the process might be good too.

To the best of my knowledge, VSS and SQL Server are integrated. They have Team Foundation platform, but that's a pretty big deal if you're a small shop.

This is good and simple too.

SELECT CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)

There's a discussion of this topic in the section titled DBCC CheckDB Causes Blocking section at

http://www.sqlskills.com/blogs/paul/category/CHECKDB-From-Every-Angle.aspx