Using PowerShell to clone production SQL Server databases in non-production

We all know how to restore SQL Server databases from a backup but being the automation fanatic that I am, I wanted a method in PowerShell to quickly build a "clone" instance with all the databases as backed up from production. I wanted to do this with minimal number of parameters possible. The criteria that … Continue reading Using PowerShell to clone production SQL Server databases in non-production

Advertisements

Download Genius Scan for iPhone documents with PowerShell

I love Genius Scan for iPhone. It basically lets you take pictures of anything (like receipts, printouts of actual documents etc.,) and convertsĀ it to a .pdf and stores it within the app. A .pdf document can be made up more than one image (multi-page document). You can even use existing images in your photo stream … Continue reading Download Genius Scan for iPhone documents with PowerShell

Use PowerShell to work with files at folder level

I can think of so many scenarios where people need to work with files at the folder level. The get-childitem cmdlet is indeed very powerful but it does not work at the folder level without any additional work. Here is what I mean: Let us say that you have a folder structure like this to … Continue reading Use PowerShell to work with files at folder level

Quick Tip: “Paste” shortcut key + why is copy/paste so hard in the PowerShell command line?

Technorati Tags: PowerShell If you wanted to paste text into the PowerShell command line console, you can right-click. That is great but command line people usually try to avoid the mouse and stay with keyboard shortcuts whenever they can. Having said that, to paste with keyboard short-cut, you need to do this ALT+SPACE ALT+SPACE+E (follow-up … Continue reading Quick Tip: “Paste” shortcut key + why is copy/paste so hard in the PowerShell command line?

Quick Tip: No connection could be made because the target machine actively refused it

Your users get the below error when connecting to SQL Server that has been running fine all along.Reason:What could be the reason? Quite simple. Check to see if the service is running and start it if it is not!StackOverflow always has the answers for all the other kinds of configuration issues that might cause this … Continue reading Quick Tip: No connection could be made because the target machine actively refused it