November 21, 2017

 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 fracti...

September 19, 2017

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...

August 30, 2017

 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...

August 8, 2017

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 mainten...

June 27, 2017

 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 th...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle
  • Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle