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

August 3, 2017

I couldn't find a relevant photo for this post. But you can enjoy a nice cup of coffee in the morning when you automate stuff. 

As always, a great way to save time is to automate SQL Server installs. If you're in a situation where you have to install SQL Server on...

August 1, 2017

 My war torn copy. 

I spent the last few months looking like a total dork reading this book on the train. But I'm a rockstar when I get to my client's office thanks to much of the information found in this resource. 

The book doesn't just give you scenarios and how...

July 24, 2017

Azure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database.

Geo-Replication

Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replicati...

July 18, 2017

So here's a scenario. You have a client that has implemented SAN storage for your SQL Servers (could be virtual or physical). Your manager tells you that ever since the SAN team got involved things are running slower! And He's sure it's a SAN problem. 

However, the SAN...

July 12, 2017

How to go about dropping less than ideal clients in your practice.

July 10, 2017

One of the great things about Azure is that backups are automated as part of the service.  Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region". 

The backup schedule is as follows:

Full: Weekly

Differential: Hourly

Transacti...

June 30, 2017

Going to the Azure Portal, creating our first SQL Database.

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

June 21, 2017

 Not always optimal...

What is it?

Let’s say you have a parameterized proc, and it creates and caches an execution plan based on certain values for said parameters. It “sniffs” the parameters and uses that for cardinality estimation.

Then you run this stored proc again, b...

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