featured ebooks

Learn SQL Server Today!

Tuning SQL Server - eBook

tuning sql server

Now Out! (learn more...)

Administering SQL Server eBook

administering sql server

OUT ON JULY 5TH 2017! (learn more...)

Developing SQL Server eBook

developing sql server

Coming Soon! (learn more...)

Recommended SQL Server Tools

I have been working with SQL Server since 2000, that is more than 15 years of experience. In this section, I'm recommending different tools that can enhance your experience with SQL Server along with helping you perform complex tasks as easy as possible.

Recommended Articles

I have been writing books, articles and blog posts on different topics on SQL Server such as In-Memory OLTP, performance tuning, administration, development, etc. for over than 10 years. In this section I'm highlighting some of those articles and blog posts.

from our blog and friends' blogs

Friends Blogs SQLEBooks.com
March 7, 2017

Should Windows "Built-In\Administrators" Group be SQL Server SysAdmins?

If you worked -or still working- with SQL Server 2005 or earlier, you must have noticed that when you installed these SQL Server versions, the local Windows group "Built-In\Administrators" was automatically included in the SQL Server instance along with getting the role "SysAdmin" server role...

Featured article on SQL Server
February 1, 2017

Getting Started with SQL Server In-Memory OLTP – Part 2

In the previous article of this blog series, I introduced In-Memory OLTP and explained how it is possible to create an In-Memory OLTP - enabled database as well as memory-optimized tables (durable and non-durable). Today we are going to talk about naively-compiled stored procedures as well as see a full example of performance improvement when using In-Memory OLTP...

Featured article on SQL Server topics
January 16, 2017

Getting Started with SQL Server In-Memory OLTP – Part 1

In-Memory OLTP (codenamed “Hekaton”) is a powerful engine which is fully integrated into SQL Server’s Database Engine and introduces new data structures for optimizing the performance of OLTP workloads. So, you can have memory-optimized tables, natively-compiled stored procedures, memory-optimized table variables...

Spotlight

Featured article on SQL Server

DBA Security Advisor v2.0 is Now Out!

Dear friends, we are happy to announce the general availability of DBA Security Advisor v2.0!

With today's launch, we've reinvented the way that you interact with DBA Security Advisor and secure your SQL Server instances. With a brand new graphical user interface, the risk assessment process of your SQL Server instances has just became easier and faster...