Hurricane Harvey’s Extended Reach
25 Aug 2017

Even though Harvey’s impact will be felt mainly in Texas, it has been having a big effect on my life here in the Beautiful Pacific Northwest today. I was planning on traveling to Houston next Monday, the 28th, and then on to Austin and Dallas, for a series of workshops, which I was calling my Texas Tour. The worst of the storm might be over by Monday, but I am well aware of potential flooding problems in Houston post-storm. And if the storm moves further inland, the other cities could also be impacted. So, with regret, I need to announce that DB Best is cancelling my Texas Tour next week. Hopefully, we’ll be able to reschedule in the not ...

Migration Project for A Global Leader in Security Technology
Migrate Sybase ASE databases to SQL Server for a security technologies company
25 Aug 2017

DB Best recently completed a project to migrate Sybase ASE databases to SQL Server for a global leader in security technology. Faced with skyrocketing license costs with SAP to renew their out-of-support server instances, our customer needed a way to migrate hundreds of Sybase ASE databases. To make matters worse, our customer faced upgrading their out of support PowerBuilder applications. By migrating to SQL Server on commodity Intel based servers, our customer found that they could exceed their performance needs and lower overall licensing costs. Check out the video below to see how we approached the project to migrate Sybase ASE databases ...

Using Mobile Applications for Augmented Reality Art Buying
23 Aug 2017

One of our clients was looking to create a new business model of selling digital art using an augmented reality art mobile app solution. They identified that the biggest roadblock to selling digital art was that a customer often returned the art piece because it didn’t look right in their home or place of business. We developed the Art for Places and Spaces AFPAS application which allows customers to explore how a certain piece of artwork looks in the intended room before buying it. Watch the following video to learn more technical details augmented reality art buying works. (more…)...

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 Platform 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, as well as the set of best practices and suggestions on how to upgrade it. Watch the following video to learn more about the technical approach we used. (more&...

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! (more…)...

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. (more…)...

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 this post.  In addition, looking at index pages can also be quite educational, but I’ll have to save that for another time. And remember that if the table has a clustered index, the data pages are also technically index pages, but as far as the...