Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts

Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts
English | Size: 549.17 MB
Category: Programming


Get up and running with accessing SQL Server from PowerShell Core. By the end of this video you’ll have learned how to issue Transact-SQL statements and get results back, how to insert, modify, and delete data in the database, and how to import and export data to and from SQL Server. You’ll be equipped to automate database administration and other maintenance tasks through using PowerShell to automate the execution of Transact-SQL scripts that are stored in files that you can easily edit to keep up with changing business needs. [Read more…]

Pluralsight – Raising The Bar Again For Azure Sql Database With Centrally Managed Encryption

Pluralsight – Raising The Bar Again For Azure Sql Database With Centrally Managed Encryption-NOLEDGE
English | Size: 193.91 MB
Category: Tutorial


Notes: Microsoft Ignite 2019 | Raising the Bar Again for Azure SQL Database with Centrally Managed Encryption | Jakub Szymaszek, Joachim Hammer Customers are increasingly asking for better controls to secure their data as it moves across platforms and organizational boundaries. [Read more…]

Pluralsight – Azure Sql Data Warehouse Query Performance Tuning

Pluralsight – Azure Sql Data Warehouse Query Performance Tuning-NOLEDGE
English | Size: 118.88 MB
Category: Tutorial


Notes: Microsoft Ignite 2019 | Azure SQL Data Warehouse: Query Performance Tuning | Chris Testa-O’Neill
Over the course of this experience, look for inefficiencies that are causing sub optimal performance [Read more…]

Lynda – Advanced SQL Window Functions

Lynda – Advanced SQL Window Functions-APoLLo
English | Size: 372.71 MB
Category: Tutorial


Window functions are one of the most radical, fundamental enhancements to modern SQL. They allow access to neighboring rows without using subqueries, thus enabling amazing opportunities for concise, elegant, high-performing solutions. [Read more…]

Lynda – SQL Server Machine Learning Services R

Lynda – SQL Server Machine Learning Services R-APoLLo
English | Size: 266.61 MB
Category: CBTs


SQL Server now includes support for direct execution of R code. This integration allows complex data science analyses to be performed quickly in a secure environment, without having to export data sets first. In this course, database expert Adam Wilbert walks through the steps of enabling the required components-including Machine Learning Services for R-and writing basic R scripts. He also shows how to retrieve and work with data stored in SQL Server tables, create data visualizations with external R libraries, and package scripts as stored procedures. At the end of the course, traditional SQL Server users will be able to dive deeper into using R and traditional R developers will be able to take advantage of using SQL Server as the source of data to create higher-performing analyses. [Read more…]

PluralSight – SQLAlchemy Core In Python Getting Started

PluralSight – SQLAlchemy Core In Python Getting Started-REBAR
English | Size: 119.87 MB
Category: Tutorial

As a Python data professional, integrating databases into a Python application has traditionally been a tedious and challenging task. In this course, SQLAlchemy Core in Python: Getting Started, you will learn foundational knowledge to query data from a database using SQLAlchemy Core. First, you will learn the core principles of SQLAlchemy Core. Next, you will discover the advantages of SQLAlchemy Core. Finally, you will explore how to effectively and meaningfully query data leveraging SQLAlchemy Core, and that will eventually lead you to solve a fun challenge on your own. When you are finished with this course, you will have the skills and knowledge of SQLAlchemy Core needed to integrate a database into your next Python application. [Read more…]