Lynda – SQL Server 2017 Linux Docker And MacOS

Lynda – SQL Server 2017 Linux Docker And MacOS
English | Size: 229.44 MB
Category: Tutorial

SQL Server has traditionally run only on Windows. New for 2017 is the ability to install server instances and work with databases on Linux and in Docker containers, which opens the possibility of running SQL Server on macOS. With the extension tools now available as native Linux and macOS applications, users can capitalize on the variety of options available for running a database instance. This course shows how to install SQL Server on new platforms, and how to connect to it from a newly diverse array of environments. Instructor Adam Wilbert also shows how to use SQL Operations Studio to perform routine SQL Server maintenance tasks, such as backups, from Windows, macOS, and Linux. [Read more…]

Pluralsight – SQL Server: Building Multi-instance Asynchronous Applications

Pluralsight – SQL Server: Building Multi-instance Asynchronous Applications
English | Size: 448.23 MB
Category: Tutorial

Learn how to use Service Broker to send messages between databases in a single instance or between multiple instances. This course is applicable to all versions of SQL server and is aimed at application and database developers.
The Service Broker feature of SQL Server is transforming the way developers think about processing requests within the database and open new opportunities for scalable applications. This course builds on the basic concepts introduced in the SQL Server: Building Simple Asynchronous Applications course by introducing single-instance multi-database and multi-instance configurations for Service Broker. [Read more…]

Lynda – Learning SQL Server 2017

Lynda – Learning SQL Server 2017
English | Size: 177.13 MB
Category: Tutorial

Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works-which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. He introduces the main working environment-SQL Server Management Studio-and walks through how to start creating tables and manipulating data. [Read more…]

Packt Publishing – Administering SQL Server on Linux

Packt Publishing – Administering SQL Server on Linux
English | Size: 522.54 MB
Category: Tutorial

This course follows a step-by-step approach to teach viewers the concepts of SQL Server on Linux (using the bash command line) and the SQL programming language through examples that can easily be adapted and applied in your own solutions.

Microsoft’s launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.
[Read more…]

Pluralsight – SQL Server on Windows Azure IaaS – Optimizations & High Availability


Pluralsight – SQL Server on Windows Azure IaaS – Optimizations & High Availability[/b]
English | Size: 260.6 MB
Genre: eLearning

[Read more…]

Pluralsight – SQL Server Understanding, Configuring, and Troubleshooting Log Shipping

Pluralsight – SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping
English | Size: 267.99 MB
Category: Tutorial

SQL Server log shipping is a very useful technology for high availability and disaster recovery, as well for general purpose database movement, migration, and upgrades. In this course, SQL Server: Understanding, Configuring, and Troubleshooting Log Shipping, you’ll first learn the basics of log shipping, its capabilities, and its limitations. Next, you’ll learn how to prepare an environment for log shipping, and then how to configure log shipping, using either SQL Server Management Studio or T-SQL scripts. You’ll learn how to monitor a log shipping environment and troubleshoot common problems, and finally you’ll learn how to use log shipping for data migration and upgrading a database to a new version of SQL Server. When you’ve finished this course, you’ll have the skills and knowledge to start configuring, using, and troubleshooting log shipping. [Read more…]

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