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.


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


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 16, 2017

This past Tuesday I had the privilege of attending the NJ SQL PASS Group meeting in Wayne, NJ. It's typically held at the Microsoft Store in the Willow brook Mall. In the back, they have a huge screen which lends itself nicely for presentations. 

This week Justin D...

June 13, 2017

 Not quite...

The OVER clause was first introduced to us in SQL 2005. It is often used as a supplement to other functions to provide which rows from a particular query are applied to a function. It is usually presented as part or in addition to an existing result set. 


June 7, 2017

What does the performance of SQL Server mean to you and your company?

What are the benefits? How is the value perceived? Is it in dollars saved? Dollars earned?

How about concepts that do not involve money? Peace of mind? The fact that the server will process these impor...

May 30, 2017

So let's jump right in and see if we can't make some of the In-Memory OLTP features work. Then I can work on elaborating the details.

Create Memory Optimized Filegroup

I’m going to go through a process of creating a memory optimized filegroup, then we'll add a container...

Please reload

Please reload




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