Packt Publishing – Getting Started with SQL Server on Linux

Packt Publishing – Getting Started with SQL Server on Linux
English | Size: 501.31 MB
Category: CBTs

This course follows a step-by-step approach to teach you SQL Server concepts on Linux, using the bash command line and SQL programming language, via examples that can easily be adapted and applied in your own solutions.
[Read more…]

Pluralsight – SQL Server – Analyzing Query Performance for Developers

Pluralsight – SQL Server – Analyzing Query Performance for Developers
English | Size: 785.49 MB
Category: Tutorial

This course will teach you everything you need to know as a developer to start making sense of query plans and improving query performance. Apart from developers, this course is also applicable to anyone who is responsible for SQL Server performance.

Developers are sometimes charged with fixing performance issues, and they have no idea where to start. They’ve never seen a query plan, or when they look at one they’re not sure what it *really* means. The developers know how long it takes for a query to execute, but they don’t know how to see how much IO, CPU, or memory it uses. And sometimes they just create an index and that seems to fix the problem (even though they have no idea why!). [Read more…]

Livelessons – SQL Server 70-761: Querying Data with Transact-SQL


Livelessons – SQL Server 70-761: Querying Data with Transact-SQL
English | Size: 18 GB
Genre: eLearning

[Read more…]

Pluralsight – SQL Server Upgrading and Migrating to SQL Server 2016

Pluralsight – SQL Server: Upgrading and Migrating to SQL Server 2016
English | Size: 328.73 MB
Category: Tutorial

When moving to a new version of SQL Server, it’s important to plan and test the upgrade process and use a risk-free migration approach that limits application downtime. In this course, SQL Server: Upgrading and Migrating to SQL Server 2016, you’ll learn how to do all of these things. First, you’ll discover how to choose the correct Edition of SQL Server 2016, install it correctly, and how to use various tools to find upgrade blockers and breaking changes.
[Read more…]

Pluralsight – SQL Server: Upgrading and Migrating to SQL Server 2016


Pluralsight – SQL Server: Upgrading and Migrating to SQL Server 2016
English | Size: 329 MB
Genre: eLearning

[Read more…]

Lynda – New Features in SQL Server 2016 for Developers

Lynda – New Features in SQL Server 2016 for Developers
English | Size: 236.52 MB
Category: CBTs

Are you curious about upgrading to Microsoft SQL Server 2016, but aren’t sure if it’s worth it to make the switch? In this course, join Anton Delsink as he highlights his favorite new features for developers. Anton covers several different areas-including deploying SQL Server on Linux, using new functions such as STRING_SPLIT, and exploring the new JSON query syntax. While you can work through the entire course in order, you can also start with whichever video piques your interest, as each video stands on its own. Upon completion of this course, you’ll know how to leverage new and enhanced features in SQL Server 2016 that can help you write less code and bring increased security, performance, and reliability to your applications. [Read more…]

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…]