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

Webinar 2.5 Followup (Episode 8 – Nonclustered Indexes)

Posted by | On November 21st, 2017 | In Kalen's Continuum, SQL Server | Tags: , ,
 

Thanks to everyone who attended! You can get the slides and demo files here:
Webinar 2.5 — Nonclustered Indexes

nonclustered index leaf

Because this week is a holiday week in the US, there is NO HOMEWORK!

If you missed the session, or would like to watch the recorded session, the recording is available through this link.

Don’t miss the next webinar on November 28th: Fragmentation! You can register here: https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-9-tickets-39714618493

In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months. I will be updating it periodically.

Webinar 2.4 Followup (Episode 7 – Clustered Indexes)

Posted by | On November 14th, 2017 | In Kalen's Continuum, SQL Server | Tags: , ,
 

Thanks to everyone who attended! You can get the slides and demo files here:
Webinar 2.4 — Clustered Indexes

Clustered index btree

If you missed the session, or would like to watch the recorded version,  here is the link to the video.

Don’t miss the next webinar on November 21st: Nonclustered Indexes!  You can register here. https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-8-tickets-39713832141

In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically.

Homework solution/discussion:

Read the rest of this entry »

Webinar #2.3 Follow-up (Episode 6)

Posted by | On November 7th, 2017 | In Kalen's Continuum, Webinar
 

Thanks to everyone who attended! You can get the slides and demo files here:
Webinar 2.3 — Large Datatype Storage

And here is the link to the video.

Pages for large datatypes

 

Don’t miss the next webinar on November 14th: Clustered Indexes! You can register here!

————————————–
Homework discussion for Webinar #2.2:
Calculate the maximum number of IAMs a single object, including its indexes, can have.

Read the rest of this entry »

How to Upgrade Microsoft Access 97 Jet Database Engine Applications – Part 1

Posted by | On November 1st, 2017 | In Customer Story, Database Modernization, Database Upgrades, Microsoft Access | Tags: , , ,
 

A leading provider of engineering software has a popular application deployed at thousands of customer locations. They have a plan in place to rearchitect the solution in a couple of years to use a modern application architecture with a SQL Server backend. The problem they faced was that the application used the Microsoft Access 97 Jet database engine. New customers who tried to deploy the solution on newer versions of the operating system were blocked from being able to install the software because of the inherent security risks using the old database technology. So we had to find the way of removing the dependency on the legacy data access technologies and upgrade Access databases to the latest version. In this video, we demonstrate our first approach on how to upgrade Microsoft Access 97 Jet database engine applications to the latest version of the Jet engine that runs on the latest versions of Windows.

Read the rest of this entry »

Why Learn About SQL Server Internals?

Posted by | On October 30th, 2017 | In Kalen's Continuum | Tags: ,
 

I’ve been writing and teaching about SQL Server internals for over 25 years. While there is usually a lot of interest in my books and classes, there are always people who ask, frequently after about the first day of my 5-day class, “What’s the point? Why is this information useful to know?”

What is “Internals”?

First of all, we need to answer the question “What is Internals?” For SQL Server, the short answer is “The way SQL Server works internally!” Internals education looks to answer some of these questions:
• How does SQL Server manage memory, processors, i/o and other physical resources?
• How is data physically stored, written, retrieved and cached?
• How are queries optimized and processed?
• How are query plans cached and managed?
• What is the transaction log used for and how it is managed by SQL Server?
• What does SQL Server do to protect data during concurrent access by multiple processes?

The diagram shown below is one I frequently use to show the various internal components of SQL Server. The engine is divided into four layers.

SQL Server Architecture
Read the rest of this entry »

Webinar #2.2 Follow-up (Episode 5)

Posted by | On October 24th, 2017 | In Kalen's Continuum | Tags: , ,
 

Thanks to everyone who attended! You can get the slides and demo files here:
Webinar 2.2 — Allocation Information

If you missed the session, or would like to watch the recorded version, you can get a link to access the video here.

Webinar #2.2 Homework:
Read the rest of this entry »

Webinar #2.1 Follow-up (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

 

Here are solutions to the homework:

Read the rest of this entry »

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