There are at least 2 big advantages to using a Central Management Server instead of locally managed Registered Servers.

1. The central repository is shared with your colleagues
2. Its getting backed...

I think you forgot to include an error handling routine. Here is an example.

begin try
select 1/0
end try
begin catch
raiserror ('April fools!',0,1)
end catch

You're a day early if this is an April Fools day joke.

Unless the DBs need FULL recovery model for something, just change them to SIMPLE. Do you need point-in-time recovery,...

• This reply was modified 1 year, 8 months ago by  chuck.hamilton. Reason: spelling correction
• This reply was modified 1 year, 8 months ago by  chuck.hamilton.

I know this is an old post but wouldn't you want to patch the async secondary availability replica first like Ant-Green suggested? That primary replica regardless of which node it's...

Check out Invoke-WebRequest.Links. I'm using PoSH 7.2.1 and I think it's a fairly new cmdlet.

(Invoke-WebRequest biblegateway.com).Links

I'm not an html coder but it might provide what you want.

• This reply was modified 2 years, 11 months ago by  chuck.hamilton. Reason: spelling

"clip" works but is actually invokng clip.exe which means your going outside of PoSH to save results to the clipboard. You can also do it completely within PoSH with this...

I'v not done much in the cloud because of all the crippling restrictions it imposes on SQL Server. Especially Azure SQL.  Are you saying that the backend storage in Azure...

In the old days before we were using SANs there were several advantages. Performance was improved by spreading the data over many spindles and even over multiple interfaces. Also if...

The idea is to restore a production msdb on a non-production system so you can copy the job back to the production system. I've used this technique before.

You could actually...

• This reply was modified 3 years, 10 months ago by  chuck.hamilton.

Here's a mostly point and click method involving little coding.

1. Restore msdb to a non-production server as msdb_backup
2. Stop the agent on that server
3. Swap the msdb and msdb_backup database...

So why did 90% of the SPNs need to be re-registered? Do you have a network with a lot of domain controllers? If so we've seen a problem where it's...

• This reply was modified 4 years, 3 months ago by  chuck.hamilton.

EXEC () as written in the example is also susceptible to SQL injection attack. Consider the case where @lstChngDt (which based on the example is likely a varchar or nvarchar)...

Very sneaky. And even worse, it leaves an open transaction! Please put a ROLLBACK in that CATCH block before someone walks away from their keyboard and starts triggering alerts! (You...

I know this 5 years old but if Steves going to resurrect it, I'll update it. I still have working SQL 2000 databases as old as 17-Dec-2002. Next year it'll...

It depends. 🙂

Is there a PK on the table on the pharmacy and/or claim no. If so you'd get one row inserted and 4 PK constraint violation errors.