Videos
DB Best’s principal solutions architect Rick Heiges delivered a webinar on migrating Oracle to SQL Server. Rick covered the following topics: Migration process and tools Data deployment Cloud migration Tool support Many Oracle customers are concerned about being locked into a single vendor with high licensing costs. There is often a fear that comes about when it comes time to upgrade or modernize their environment. Or worse yet, the dreaded Oracle license audit. Discover how migrating Oracle to SQL Server can help customers achieve […]
In this 9-minute snack bite video, Bill Ramos talks about the top three reasons why you’d want to consider moving from existing versions of SQL Server running on the Windows platform to SQL Server 2017 on Linux.
In this 52-minute webinar recording, Bill Ramos talks about the top three reasons why you’d want to consider moving from existing versions of SQL Server running on the Windows platform to SQL Server 2017 on Linux. You’ll learn how SQL Server 2017 on Linux meets your enterprise high availability, performance, and security requirements with minimal disruption to your development team. Oh, and it cost significantly less than running SQL Server on Windows. Allow DB Best to send you updates about […]
Running on an older version of SQL Server and worried about not meeting compliance or falling out of support? We’ve seen that around 60% of existing SQL Server databases are running on versions of SQL Server that are out of support or extended support. Upgrading to the latest version of SQL Server not only ensures you can take advantage of Microsoft support, but it’s also an opportunity to save money and reduce server hardware resource requirements. Consolidating multiple SQL Server […]
We’re 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 For those who miss the live webinar, we’ll be […]
We’re 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 For those who miss the live webinar, we’ll be providing a recording […]
We’re 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 For those who missed the live webinar, we’re providing a recording […]
We’re 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) For those who missed the live webinar, we have a recording for free! We’d just […]
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 index […]
We’re 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