My PowerShell Usergroup: As I said before, I am a regular at my local PowerShell user group. I keenly look forward to our monthly meetings. We share a lot of PowerShell code/tips/tricks among ourselves. It is a small but close-knit group. Yesterday, one of the members, Jason Walker came up with coding puzzles for the group. This blog … Continue reading PowerShell: Puzzle Night At the User Group!
Recently, I received a request to backup a dozen tables or so tables out of 12 thousand tables. I had to retain all the indexes, statistics etc. The goal was to hand this over to the vendor for analysis as a database backup. I could have copied the selected tables over to a new database … Continue reading SQL Server: DROP All But A Few Tables With PowerShell (or DROP ALL)
I was looking for a solution to automate SSAS backups using PowerShell. By "automate", I mean the following: Backup one or more SSAS databases in an SSAS instance to a network location Automatically cleanup backups that are older than [x] days Schedule the backups via SQL Server Agent with minimal overhead Backup multiple host instances/databases … Continue reading SSAS: Automate SSAS Backups With PowerShell
This is one of those extremely simple posts where everyone who does PowerShell knows how ridiculously simple it is to do and you will too today. You will look like a magician to the uninitiated. Today, I had about 5 hosts running 4 instances of SQL Server each and I had to Stop all SQL … Continue reading PowerShell: SQL Server Services Startup Mode Change
Recently, I changed my Windows password and that started a chain of events. My account would get locked out because an invalid password was used and I started getting weird errors in various programs when using the account even after getting it unlocked several times. Restarting my own PC did not help. Then, it occurred … Continue reading PowerShell: Invoke-RDPLogoff – Logoff From Windows Servers In Parallel