Loading Events

Past Events › Webinars

Events Search and Views Navigation

October 17, 2017

Webinar – SQL Server Internals Episode 4

October 17, 2017 @ 9:00 am - 10:00 am

We’re starting a new topic in this next episode: Physical Storage Come hear the first webinar on this topic, from Kalen Delaney, based on her SQL Server Internals books and classes. In this installment, Kalen will tell you about basic disk storage, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Heaps and B-Trees Tools for examining…

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinar Episode 5

October 24, 2017 @ 9:00 am - 10:00 am
SQL Server Internals Webinar Episode 5

We are continuing the topic of Physical Storage. Part 2 of this section is Allocation. Come hear the second webinar on this topic, from Kalen Delaney, based on her SQL Server Internals books and classes. In this installment, Kalen will tell you about extents and allocation, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Types of…

Find out more »

November 7, 2017

Webinar – Kalen Delaney’s SQL Server Internals Webinars Episode 6

November 7, 2017 @ 9:00 am - 10:00 am

We're continuing the topic of Physical Storage. Part 3 of this section is Large Object Storage. Come hear the third webinar on this topic, from Kalen Delaney, based on her SQL Server Internals books and classes. In this installment, Kalen will tell you Large Object storage, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Restricted variable…

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinars Episode 7

November 14, 2017 @ 9:00 am - 10:00 am

We are continuing the discussion of Physical Storage with Part 4 of this topic. In this installment, Kalen will tell you about Clustered Index storage, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Heaps vs B-Trees Clustered index leaf level Uniqueifiers Upper levels of clustered index

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinars Episode 8

November 21, 2017 @ 9:00 am - 10:00 am

We 're continuing the discussion of Physical Storage with Part 5 of this topic. In this installment, Kalen will tell you about Nonclustered Index storage, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Heaps vs B-Trees review Nonclustered index leaf level Nonclustered index upper levels What is the key column Composite indexes Covering indexes Other nonclustered…

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinars Episode 9

November 28, 2017 @ 9:00 am - 10:00 am

We are continuing the discussion of Physical Storage with Part 6 of this topic. In this installment, Kalen will tell you about Fragmentation, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Fragmentation Basics DMV to report fragmentation Fragmentation and performance Reorganization (defrag)

Find out more »

December 5, 2017

Webinar – Kalen Delaney’s SQL Server Internals Webinar Episode 10

December 5, 2017 @ 9:00 am - 10:00 am

We are continuing the topic of Physical Storage with Part 7 of this section. In this installment, Kalen will tell you about Partitioning, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Why and when you should consider partitioning Defining a partitioning scheme Switching partitions Partitioning metadata

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinar Episode 11

December 12, 2017 @ 9:00 am - 10:00 am
SQL Server Internals Webinar Episode 11

We are continuing the topic of Physical Storage with Part 8 of this section. In this installment, Kalen will tell you about Data Compression, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: When and why is compression useful Row compression details Page compression details Recompression

Find out more »

Optimizing your SQL Server upgrade process with DB Best Technologies

December 14, 2017 @ 12:00 pm - 1:00 pm

Over 60% of all SQL Server databases are running SQL 2008 R2 or older. DB Best has developed technology and methodologies to reduce the cost and time of upgrading to the latest versions of SQL Server by up to 90%. In this webinar, you learn: How to upgrade your databases with minimal changes to your applications. Tools from Microsoft and DB Best Technologies to speed up the upgrade process. Automate to scale the upgrade of production databases. How to identify…

Find out more »

Webinar – Kalen Delaney’s SQL Server Internals Webinar Episode 12

December 19, 2017 @ 9:00 am - 10:00 am
SQL Server Internals Webinar Episode 12

We  are continuing the topic of Physical Storage with Part 9 of this section. In this installment, Kalen will tell you about Columnstore Indexes, using examples from SQL Server 2016 and SQL Server 2017. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: When and why are columnstore indexes useful? Nonclustered columnstore indexes Clustered columnstore indexes Columnstore index metadata

Find out more »
+ Export Events