Azure SQL Database for the SQL Server DBA

Azure SQL Database for the SQL Server DBA
English | Size: 428 MB
Category: Video Training


Azure SQL Database is Microsoft’s Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. [Read more…]

SQL Server Learning Pack

SQL Server Learning Pack
English | Size: 10.57 GB
Category: Video Training


Learn how to use a Microsoft SQL Server to install, build, and design databases. Our SQL Server tutorials can help you understand database administration, including creating indexes and backing up and restoring the database. [Read more…]

SQL Server: Index Fragmentation Internals, Analysis, and Solutions

SQL Server: Index Fragmentation Internals, Analysis, and Solutions
English | Size: 277 MB
Category: Video Training


Index fragmentation is an inescapable part of any SQL Server environment, no matter which version of SQL Server you’re using or what hardware or I/O subsystem you have, and this comprehensive course will give you all the information you need to properly understand and deal with it, applicable to anyone responsible for SQL Server, from SQL Server 2005 onward.
[Read more…]

SQL Server: Advanced Corruption Recovery Techniques

SQL Server: Advanced Corruption Recovery Techniques
English | Size: 566 MB
Category: Video Training


Database corruption happens all the time, all over the world, and sometimes it’s not so simple to deal with. In this follow-on course from SQL Server: Detecting and Correcting Database Corruption, you’ll learn the more advanced techniques that can lead to success in the most challenging corruption scenarios, applicable for more experienced SQL Server professionals, from SQL Server 2005 onward. [Read more…]

SQL Server: Benchmarking and Baselining

SQL Server: Benchmarking and Baselining
English | Size: 336 MB
Category: Video Training


When you experience a performance problem, how can you easily tell where the problem is without being able to compare against a known-good set of measurements? This course explains how to create a performance baseline for a SQL Server instance using benchmarking techniques. [Read more…]

Lynda – Querying Microsoft SQL Server 2016 Databases

Lynda – Querying Microsoft SQL Server 2016 Databases
English | Size: 756.69 MB
Category: Tutorial


SQL Server is Microsoft’s de facto relational database software. While you can build a simple database relatively easily straight out of the box, most administrators need to know how to take advantage of more advanced features in the latest release, SQL Server 2016, to give their clients everything they’ve come to expect in an enterprise database. In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database. Learn how to create data tables, including temporary tables and tables with variables, and schemas. Find out how to enforce data integrity with constraints and secure your database at the user level. Then discover how to create indexes to optimize performance, work with functions, and make sure your SQL database is as fast and secure as possible. [Read more…]

SQL Server Installing and Configuring SQL Server 2016

SQL Server Installing and Configuring SQL Server 2016
English | Size: 249.2 MB
Category: E-learning | Microsoft


Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. [Read more…]

Pluralsight – SQL Server Installing and Configuring SQL Server 2016

Pluralsight – SQL Server Installing and Configuring SQL Server 2016
English | Size: 252.05 MB
Category: Tutorial


Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance. [Read more…]

Pluralsight – Azure SQL Database for the SQL Server DBA

Pluralsight – Azure SQL Database for the SQL Server DBA
English | Size: 428.59 MB
Category: Tutorial


Azure SQL Database is Microsoft’s Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. You will get to see the differences in management, high availability, performance, and monitoring of this cloud-first solution. [Read more…]

SQL Server 2016 New Features for Developers | Pluralsight

SQL Server 2016 New Features for Developers | Pluralsight

English | Size: 737.22 MB (773,033,451 Bytes)
Category: CBTs


This course teaches the new developer features added in SQL Server 2016, including Drop If Exists (DIE), SESSION_CONTEXT, dynamic data masking (DDM), row-level security (RLS), Always Encrypted, stretch database, temporal data, and more.
[Read more…]