Azure Data Lake Analytics (MSSQLTips 02/11/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Get Started with Just the Essentials - SentryOne - Click to Learn More]( [Azure Data Lake Analytics using U-SQL Queries]( This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files. ... [Study material for exam AZ-400 Microsoft Azure DevOps Solutions (beta)]( If you are preparing for Microsoft AZ-400 Exam Microsoft Azure DevOps Solutions take a look at these list of resources to get you prepared.... [SQL Server Auditing Best Practices]( Attend this free webinar to see what built-in SQL Server auditing tools are available and begin or improve your current SQL Server auditing procedures.... [SQL Server Backups Tutorial]( One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. Become an expert on SQL Server Backups.... [Get the facts - Is SQL Server HA and DR just too expensive?]( Understand the costs associated with high availability and disaster protection in a SQL Server environment. Learn about the changes in SQL Server 2012 that have nearly doubled the cost of licensing... MSSQLTips Week In Review [Azure Data Factory Overview]( In this tip we get an overview of Azure Data Factory which is similar to SSIS, but used in Azure for data movement and transformations.... [Contingency Table Analysis via Chi Square using T-SQL: Part 1]( This tip compares SQL and R for performing multiple steps in a data science project from accessing a dataset, to performing exploratory data analysis, to computing a contingency table, to computing a Chi Square statistic.... [Continuous SQL Server Database Integration with Visual Studio and Azure DevOps]( In this tip we learn about how we can do continuous SQL Server Database integration using Visual Studio and Azure DevOps.... [Introduction to Bash Scripting: Pipes and Redirections]( Learn about pipes and redirection when developing bash scripts when working on Linux to support SQL Server.... [Is Your Interview Process Turning Off Top Candidates?]( Learn the top reasons why candidates are put off during the interview process, as well as some tips to mitigate this happening to you and your organization.... [Power BI Drill Through Example]( Learn how to create drill through functionality for your Power BI reports.... [Reverse Engineer SQL Server Databases with Visual Studio]( I this tip we learn how can we transform an existing SQL Server database into a Visual Studio 2017 project.... [Scale SQL Server Bulk Loading On a Budget - Part 1]( In this tip we cover how to improve bulk loading data into SQL Server without the need to spend money on more hardware.... [SQL Server Database Mirroring Status Check and Manual Failover PowerShell Scripts]( In this tip we have a PowerShell script that can be used to check the status of SQL Server database mirroring as well as generate the code need for a failover of the databases.... [SQL Server T-SQL Alerts for Standard and Custom Errors]( In this tip we look at some approaches and queries you can use to log error messages and then use these scripts to find and send custom notifications based on the errors.... [Transfer Files from SharePoint To Blob Storage with Azure Logic Apps]( In this tip we will use Azure Logic Apps to fetch files from SharePoint, dump them into Azure Blob Storage and then copy the data into the database using the Copy Activity in ADF.... [Twitter]( [Facebook]( [LinkedIn]( [Google+]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}