Videos
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 about 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 […]
We’re continuing the topic of Physical Storage. Part 2 of this section is Allocation based on Kalen Delaney’s 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 allocation pages Allocation basics Allocation architecture Extent management We’d just like […]
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 […]
Come hear the third in our series of webinars from Kalen Delaney, based on her SQL Server Internals books and classes. In this installment, Kalen will tell you about two features of metadata internals, and illustrate them 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: • Overview of the Dedicated Administrator Connection (DAC) • DAC Best […]
Come watch the second in our series of webinars from Kalen Delaney, based on her SQL Server Internals books and classes. In this installment, Kalen will talk about SQL Server Dynamic Management Objects, 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: • What are Dynamic Management Objects? • Information about sessions and requests • DMVs for […]
Today, DB Best hosted the first in a series of SQL Server Webinars presented by Kalen Delaney. The topic of the webinars will be focused on SQL Server Metadata, using examples from SQL Server 2016. Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well. Specific topics include: Why we need to understand metadata Metadata overview Metadata security Metadata objects For those who missed the live webinar, we’ll be providing a […]
SQL Server 2016 has been released, and it is already making waves as a big step up from previous versions. Naturally, upgrading to SQL Server 2016 has appeal that is growing with each passing day. But how can you be sure that your databases are ready to make the move without breaking? Enter SQL Server 2016 Upgrade Advisor.
Support ends April 12 for SQL Server 2005. Do you have an upgrade plan in place to make sure you are getting the latest security patches? If not, this webinar is for you! You will learn: What’s new with SQL Server 2016 Strategies for archiving, upgrading, and migrating to Azure Where you can find additional resources for upgrading instances
The new SQL Server 2016 Upgrade Advisor has undergone major changes, and it’s about more than helping you upgrade databases from prior versions of SQL Server to the latest version. In this webinar, you’ll learn how Upgrade Advisor can help you: Migrate a SQL Server database to Azure SQL Database Determine which tables in a database are candidates for in-memory OLTP and columnstore indexes Determine readiness of a database table for using the new SQL Server 2016 stretch table capability […]
Cortana Analytics is a fully managed big data management and advanced analytics suite that enables you to transform your data into intelligent action. So, what does that really mean to you? In this webinar, we’ll go over the services that constitute the Cortana Analytics suite of tools and how they can be used to expand the way you think about business analytics within your organization.