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

May 23, 2017

I had the pleasure of attending SQL Saturday #588, in NYC at the Microsoft Building in Times Square, this past weekend. For those that don’t know it’s an entire day of free SQL Server training with presentations from professionals at the top of the industry. Yes, I sai...

May 11, 2017

In-Memory OLTP is new to me. I’m going to use this series of articles to gain a greater understanding of how it works and when/how to implement it.

What is it?

In Memory OLTP (aka Hekaton) was first introduced in SQL Server 2014. It has been touted to give great performa...

May 9, 2017

Hello all! Welcome to SQLEvo.  The intent of this site is to provide an overview of what I do and how I can be useful to organizations. And the Blog portion is to provide meaningful contribution to the SQL Community that has given so much to me!

Please bare with me as t...

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