Here’s a cute little piece of code to add up the sizes of all your DBs on a server. It comes in handy when you’re trying to see how much space you’ll need to duplicate the server either for DR, or reporting, or even just to see how much backup space you’ll need. Make sure … Continue reading Get DB sums with Powershell
Hey guys, I posted a new video. It’s based on the blog post I did the other day. I got a couple requests to make it into a video so here it is. Click here to watch vid.
I thought I’d kick off the week with a useful little PS script I wrote last week. It happens from time to time where you need to find out what AD accts your SQL boxes are running on. It could be that you simply want to see how diverse they are or maybe you want … Continue reading Audit service accounts with Powershell
I’m having big fun with PS today because I’m installing several new R2 boxes on Windows Server R2. Where does PS come into play you ask? Well, good question… I only wish I had a good answer. Ok, I do. In order to install SQL Server R2 on Windows 2008 R2 you have to first … Continue reading Today’s Powershell Fun
Here’s a really good one. I noticed that very few of my boxes had a job to recycle the sql error logs. This is important because unless specifically done, the error log will only recycle when the service is burped in some way. For those of you who aren’t up on the lingo, recycling the … Continue reading Powershell to recycle error log
here’s a cool scenario where you need to set all of your DBs to simple mode and then back again. Let’s say that you have a bunch of DBs on your server that are all in full mode and you’re setting up new backup routines on the server and you want to start everything from … Continue reading Cool Powershell Scenario
Here’s the situation… You get a call from one of your customers saying that the log has filled up on the DB and they can’t do anything any more. So you connect to the server and find out that the log backups haven’t been running. So you run the backup and everything is hunkydory. But … Continue reading How to Monitor SQL Services with Powershell
…at my last gig where I had these scripts running and accidentally dropped all the SPs in our prod DB.
The other day I blogged on a cool way to alter database file properties. And I promised I would film the solution for you. Well, I got home that night and started filming but when I pulled up sqlps I was stopped dead in my tracks by something I couldn’t explain. The methods to get … Continue reading Powershell 2.0 Get-Member Enhancements
Man, I still just get so jazzed when I work with powershell. Every time I need to do something long and hard(that was for you Buck), I look in powershell and it lets me just lay back and enjoy the long and hard. So this time we’ve got like 85 DB files for our main … Continue reading Powershell to Alter Database File Properties