Happy Thanksgiving! If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount of cmdlets is just staggering. These cmdlets can be used for so much more than migrations. But i'm going to share just a tiny fraction of what you can do. For me, this is like the "easy" button of migrations. I was looking to migrate a large database from one server to another. There are enough considerations to make when handling large amou

While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database. The first step allows you to login to your Azure account. It gives you a neat little prompt. Once logged in, the powershell window will provide you with some information regarding your subscription. The next two commands sections provide a w

We could use this sign when we have approved downtime for upgrades. So this isn't exactly just for SQL, this cmdlet can be used stop and start any clustered service. It proved especially useful for me since I am currently on a project that requires the systematic stoppage of clustered SQL Services so that the storage team can do their thing. As always, test this in a non production environment before implementing during a migration. Prerequisite: Import the failover clusters

Is this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize powershell. You can create a script and hand it over to the server team or you can schedule it. Most of the time certain cluster maintenance tasks take place after business hours. And if you've already worked a long day, it may free up a bit of your time and energy to use powershell. Now, the failover cluster module is only available if Failove

If only I could upload my brain to the cloud. BaaS anyone? What is Database as a Service (DaaS)? Azure SQL Database is Microsoft's version of DaaS. DaaS is a cloud service in which the service provider manages the operating system and database software. In addition to that, they may also relieve your IT staff of certain administration tasks such as backups, high availaiblity/DR, patching etc… Pricing. The users of such a service will most likely pay according to their usage.