How to Schedule T-SQL Statements to Run with Azure Functions (MSSQLTips 04/26/2018)

[MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [Manual monitoring? It’s costing your business. Find out how much with a free personalized ROI guide.]( [How to Schedule T-SQL Statements to Run with Azure Functions]( Check out this tip to learn how you can use and setup Azure Functions to schedule T-SQL statements to run on a set schedule.... By John Miner - [Learn More]( [Importing Complex JSON files using SQL Server Integration Services]( In this tip we look at how we can use SQL Server Integration Services to import complex JSON file formats.... By Nat Sundar - [Learn More]( [SQL Server Performance Advanced Monitoring and Best Practices]( Improving SQL Server performance by using advanced monitoring and best practices is key to ensure you rollout and maintain the best possible database solution. Continuing to use poor practices and a lack of monitoring is a sure way to eventually crea... [Learn More]( [Create a High Performance SANLess SQL Server Cluster]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Learn More]( [SQL Server 2016 Analysis Services Tutorial]( SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack to develop Online Analytical Processing (OLAP) solutions. Over the years SSAS has evolved and has emerged as a leader in the area of analytical solut... [Learn More]( How much could your business save with SQL Server monitoring? [Find out now]( What is the ROI of a monitoring tool? As the size and complexity of your SQL Server estate increases manual monitoring can become inefficient and you need to consider alternatives. With Redgate’s monitoring ROI calculator you can work out how much you currently spend on manual monitoring, and what you could save by switching to SQL Monitor. [Calculate and download your free personalized guide now.]( [Avoid using NOLOCK on SQL Server UPDATE and DELETE statements]( Occasionally I come across UPDATE and DELETE statements where the target table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case? In this tip we cover whether this hint is useful or if it should be removed from your ... By Aaron Bertrand - [Learn More]( [Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions]( You work in a shop that puts business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual for companies that use the SQL Server layer to perform... By Derek Colley - [Learn More]( [Using hash values in SSIS to determine when to insert or update rows]( When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update – a historical change – or an insert, which is a new occurrence of a record. In this tip we show how... By Koen Verbeeck - [Learn More]( [Twitter]( [Facebook]( [LinkedIn]( [GooglePlus]( You are receiving this email as a subscriber of MSSQLTips.com. If you do not wish to continue receiving email from MSSQLTips.com, 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 this e-mail address: {EMAIL}