Performing a comprehensive SQL Server Database Health Check
Getting the most out of a comprehensive database health check for SQL Server
22 Aug 2017

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we found several high priority issues which required immediate actions. In addition, we provided the customer with detailed information on their existing database system, […]

Free Summer Workshops!
17 Aug 2017

Over the next month, I’ll be presenting a free workshop in seven cities in the U.S. The workshop will include hands-on labs that allow you to explore new features of the relational engine for both SQL Server 2016 and SQL Server 2017.  For more details, and to register, check the links below. Remember, the workshops are FREE and include both breakfast and lunch!

A Visit to the ‘Other’ Washington
15 Aug 2017

Last week I had a terrific opportunity to give a few SQL Server presentations in the Washington, DC area. I stayed in Reston, Virginia, and spoke at the Microsoft office in Chevy Chase, Maryland. On Tuesday evening I was able to take the metro into DC itself and spend several beautiful hours walking around the National Mall.

Looking Inside Your Database Pages
07 Aug 2017

As I promised a couple of weeks ago, this post will show you how to look inside a page to see what is actually stored there. I’ll just be looking at data pages, and only a very basic example, just so you get the idea. But once you get familiar with looking inside pages, there are many mysteries about SQL Server data storage that you can solve on your own. I’ll mention a few of them at the end of […]

Virtualization and consolidation of SQL Servers during a complex database system upgrade
31 Jul 2017

One of the largest US national energy suppliers wanted to upgrade their SQL Server system and deploy it on VMware. As a consulting partner, we offered a new architecture for their virtualized system. In addition, we found some server consolidation opportunities which would improve the overall system’s performance. As a result, we helped our customers deploy the newly created system in production. Moreover, we delivered a comprehensive list of best practices for evident and accessible management of their environment. Learn more […]

SQL Server 2017 Workshops and the SQL Pass Summit
28 Jul 2017

I’ve been heads-down updating Microsoft’s Hands-on Labs, originally written for SQL Server 2016 CTP3, into something that showcases not only the SP1 release of SQL Server 2016, but also some of the new SQL Server 2017 features. One of the most exciting new features is Adaptive Query Processing, not to be confused with another awesome new feature called Automatic Query Tuning! So I will not be able to continue my blog series on Clustered Indexes this week. (Don’t worry, it’s […]

Finding My Pages
18 Jul 2017

In a post from two weeks ago, I told you that this week I would show you how to look inside pages to see the NEXTPAGE and PREVPAGE pointers. When I started to write this, I realized that before I can show you how to look inside the pages, I need to show you how to find out what pages to look at. So I’m going to juggle this blog schedule a bit, and this week I’ll show you how […]

Increase database performance while migrating to SQL Server
Increasing database performance by migrating from Ingres to SQL Server
18 Jul 2017

One of our customers needed to migrate their Ingres Database system to Microsoft SQL Server wanting to improve the performance of their system. We came up with a migration solution and updated the business logic module of their application. As a result, the customer achieved a sufficient performance increase, improved the database system security, and got an optimized business logic architecture. The video below depicts the migration process in details:

Architecting highly available and scalable system when migrating to SQL Server
Architecting highly available and scalable system when migrating to SQL Server on AWS
12 Jul 2017

Our customer needed to reduce the licensing costs of their Oracle database. We came up with a comprehensive solution by migrating their database to SQL Server platform. We also remediated all affected application components. As a result, our customer benefited from obtaining higher value SQL Server platform with enhanced scalability and high availability approaches.

What Makes an Index Clustered?
10 Jul 2017

In my previous post, I told you about what it meant for an index in SQL Server to be ‘clustered’. Usually, when we talk about SQL Server indexes, we are talking about indexes organized as B-trees (or technically, B+-trees, but we won’t go into the difference here.) For these indexes there are two basic properties that set clustered indexes apart from nonclustered. First, the index leaf level IS the data. It is not a copy of the data or pointers […]