Why Learn About SQL Server Internals?
30 Oct 2017

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 sto...

Webinar #2.2 Follow-up (Episode 5)
24 Oct 2017

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

Webinar #2.1 Follow-up (Episode 4)
18 Oct 2017

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.   Here are solutions to the homework: (more…)...

Expand capacity with an IBM DB2 SQL Azure SQL Database migration
09 Oct 2017

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 ...

Building Microsoft Access modernization roadmap
Developing Access modernization roadmap for highly outdated environment
05 Oct 2017

A major Health Department was running a data system that has been expanding over the years. Eventually, they ended up with a highly outdated and inefficient environment with thousands of Microsoft Access and SQL Server databases. Such an 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 operating expenses due to a great number of unnecessary licenses. So, our customer decided to modernize their system, and they turned to ...

Webinar #1.3 Metadata Internals Follow-up
03 Oct 2017

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. Related posts Why Learn About SQL Server Internals? Webinar #1.1 SQL Server Metadata Overview Follow-up Webinar #2.1 Follow-up (Episode 4) Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)...

Thank you, SQLSaturday Holland!
02 Oct 2017

The first event on my Fall tour is behind me now. I had a wonderful time at SQLSaturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be downloaded: Locking Session Statistics Session...