call us toll-free +1 855 855 3600
 
DB Best Chronicles
 
Talks on Managing Data and Applications Anywhere

Webinar #2.1 Followup (Episode 4)

Posted by | On October 18th, 2017 | In Kalen's Continuum, Webinar
 

Thanks to everyone who attended! You can get the slides, demo and homework files here:
Webinar 2.1 — Tables, pages and rows

If you missed the session, and/or would like to watch the recorded version, you can get a link to the recording here.

DBCC PAGE

Expand capacity with an IBM DB2 SQL Azure SQL Database migration

Posted by | On October 9th, 2017 | In Customer Story, Database Migration, IBM DB2, Microsoft Azure, Move to Cloud, SQL Server | Tags: , , , ,
 

One of the world’s largest distributors of non-food consumable products wanted to rationalize their data platform and business intelligence strategy. Their current IBM DB2 database system lacked repository to host historical audit related data, so they could hardly retrieve data from past years. Then we came up with an Azure cloud database solution that could store all the historical data and created Power BI reports on top of it. We performed the IBM DB2 Azure SQL Database migration as a part of the proof of concept, showing the benefits of the cloud solution to the customer.

As a result, we helped our customer craft a new cloud database system that meets their requirements and the latest industry standards. Learn more about our technical approach from the following video.

Read the rest of this entry »

Developing Access modernization roadmap for highly outdated environment

Posted by | On October 5th, 2017 | In Customer Story, Database Migration, Database Upgrades, Microsoft Access, Microsoft Azure, Move to Cloud, SQL Server | Tags: , , , , , ,
 

A major Health Department was running data system that has been expanding over the years. Eventually, they ended up with highly outdated and inefficient environment with thousands of Microsoft Access and SQL Server databases. Such outdated system presents a number of risks such as performance, scalability, manageability, security issues and frequent database corruptions. This leads to revenue losses because of poor performance. Moreover, such environments are usually not cost-effective with increased operational expenses due to a great number of unnecessary licenses. So, our customer decided to modernize their system, and they turned to DBBest to analyze their complex system and build the most effective Access modernization roadmap.
Let’s see how we helped our customer to improve operational efficiency and performance with reduced ownership costs and minimized business risks.

Read the rest of this entry »

Webinar #1.3 Metadata Internals Follow-up

Posted by | On October 3rd, 2017 | In Kalen's Continuum, SQL Server, Training
 

Thanks to everyone who attended! You can get the slides and demo files here:
Webinar 1.3 — Metadata Internals

If you missed the session, and/or would like to watch the recorded version, you can get a link to the recording here.

resource db files

Thank you, SQL Saturday Holland!

Posted by | On October 2nd, 2017 | In Kalen's Continuum, SQL Server, Training
 

The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon!

SQLSatHolland

Slides and scripts can now be downloaded:

Locking Session

Statistics Session

I’m Leaving on a Jet Plane

Posted by | On September 27th, 2017 | In Kalen's Continuum, SQL Server, Training
 

I’m taking off tomorrow for a three-and-a-half-week adventure, representing DB Best Technologies in four different countries.

In addition to some customer visits, and a week’s vacation with my daughter and grandson in Stuttgart, I’ll be presenting at the following four PUBLIC events.
Read the rest of this entry »

Webinar #1.2 SQL Server DMVs Follow-up

Posted by | On September 26th, 2017 | In Kalen's Continuum, SQL Server, Training | Tags: ,
 

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 1.2 — SQLServer DMVs files

If you missed the session, or would like to watch the recorded version, here’s the link.
(Once you complete the registration information, you will get an email with a link to the webinar. Yes, it’s a little tedious, but the marketing team says I have to use this link.)

Following are solutions to the homework exercises for Webinar 1.2:

Read the rest of this entry »

Webinar #1.1 SQL Server Metadata Overview Follow-up

Posted by | On September 22nd, 2017 | In Kalen's Continuum, SQL Server, Training | Tags: ,
 

The link to watch Webinar #1.1: Metadata Overview can be found here: Webinar #1 – SQL Server Metadata Overview
Once you complete the registration information, you will get an email with a link to the webinar. Yes, it’s a little tedious, but the marketing team says I have to use this link. 🙂 The zip file that includes the presentation and demo scripts is located at Webinar 1.1 — SQL Server Metadata Overview files.

As I mentioned when telling you about my webinar series, I will be giving out homework. Of course, it is totally optional, but the problems give you an opportunity to put into practice some of the concepts discussed in the webinar. Here are the problems from the first webinar: Metadata Overview.

 

  1. List the names of each database that is in SIMPLE recovery mode
  1. In the current database, list the name of each user table along with the number of indexes it has.
  1. In the current database, list just the catalog views.

 

Here are my solutions. As with most queries, there may be more than one way to write a TSQL statement to get the desired results.

Read the rest of this entry »

SQL Server Internals: the Webinar Series

Posted by | On September 22nd, 2017 | In Kalen's Continuum, SQL Server, Training
 

Internals book cover      New book cover

 

This past Tuesday, the 19th of September, I started broadcasting a series of webinars which cover all the material in my SQL Server Internals classes that I’ve been delivering around the world for almost 20 years. I’ll even be able to add additional information not included in the classes because our time constraints are not quite so strict. As Microsoft added new features to the SQL Server product, I had to remove some still relevant content to make room for the new information, and now, I’ll be able to put that content back in. In addition, you won’t be sitting just listening to me for 5 days straight. We’ll take it a bit at a time, in manageable chunks, and if your brain goes sideways, you’ll be able to rewatch later. You’ll still be able to ask questions, just like in my regular classes.

Teaching in British Manor House

Read the rest of this entry »

Configuring a Database

Posted by | On September 19th, 2017 | In Kalen's Continuum, SQL Server
 

Before SQL Server 2016, configuration referred to instance-wide settings. But with Azure SQL Database not giving us access to any instance-level information or giving us any instance-level control, we only can see information and control settings for a specific database. So now, a new SQL Server 2016 feature allows us to have a bit more control of individual databases. And once a feature gets tested and verified in Azure, it’s ported to the SQL Server on-premises code. We now have ALTER DATABASE SCOPED CONFIGURATION which does not take a database name and always only applies to the current database.

Some of the settings available with this command were not configurable from any kind of normal command or procedure prior to the addition of this new command, and some were undocumented. For example, clearing the plan cache was a DBCC command. Changing the cardinality estimation model and opting to use optimizer hotfixes were trace flags.

So far, there are only six options available, but I’m going to guess this number will increase in the next version, if not the next service pack.

The option I’ve used the most often is

ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE

Read the rest of this entry »