Processing Data from XML Files, Analyze Historical Stock Data, Power Apps Development, Automate Index Rebuilds and more (MSSQLTips 9/2/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [How to operationalize data from multiple sources to deliver actionable insights at scale]( [Editing Power Apps Outside of Power Apps Studio]( [Editing Power Apps Outside of Power Apps Studio]( Learn how to use simple ALM (built-in versioning) and enterprise ALM (full Azure DevOps integration) when working with Power App source files for editing and versioning.... [Download and Analyze Stooq Historical Stock Price and Volume Data in SQL Server]( [Download and Analyze Stooq Historical Stock Price and Volume Data in SQL Server]( In this article we look at T-SQL code you can use to load historical stock prices into SQL Server for analysis using Stooq as the data source.... [How to operationalize data from multiple sources to deliver actionable insights at scale]( [How to operationalize data from multiple sources to deliver actionable insights at scale]( Learn how to blend various datasets together from top data providers in AWS Data Exchange like Safegraph, Facteus, and SimilarWeb with internal data to innovate and make smarter decisions at scale. Data and analytics specialists from AWS Data Exchan... [Importing and Processing data from XML files into SQL Server tables]( [Importing and Processing data from XML files into SQL Server tables]( In this tip we look at how you can parse an XML file and load into relational tables in SQL Server.... [Get to SQL Server Storage Performance Problems Quickly]( [Get to SQL Server Storage Performance Problems Quickly]( My organization has multiple storage solutions with different models for the same vendor, and different models across different vendors. Each product has its own set of tools for monitoring and managing. However, this is a headache because we have to... [Tutorial - Machine Learning with SQL Server 2017 and R]( [Tutorial - Machine Learning with SQL Server 2017 and R]( In this tutorial, we will learn the basics of machine learning where we will learn the necessary data science to examine data in relevance to machine learning model development. We will be using R in SQL Server 2017 to apply machine learning related ... [Monitoring and Improving SQL Server Performance in the Cloud]( [Monitoring and Improving SQL Server Performance in the Cloud]( [Webinar] As databases move into the cloud, you may encounter different sets of performance challenges than you see in a traditional on-premises environment. You may also have fewer or different tools to use in order to gather performance information... [SQL Server script to rebuild all indexes for all tables and all databases]( [SQL Server script to rebuild all indexes for all tables and all databases]( In this tip we look at a simple script you can use to rebuild all SQL Server indexes for all specified databases.... [Powerful SQL Server Data Cleansing and Processing]( [Powerful SQL Server Data Cleansing and Processing]( The constant data management moving target tends to overwhelm the SQL Server DBAs and Developers with the need for immediate response of updating the validation and import code to then load the data to meet the business requirements between the organ... [By Greg Robidoux -]( [SQL Server Clustered Tables vs Heap Tables]( One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.... [By Aaron Bertrand -]( [Use Caution with SQL Server's MERGE Statement]( SQL Server 2008 introduced the MERGE statement, which promised to be a simpler way to combine insert/update/delete statements, such as those used during ETL (extract, transform and load) operations. However, MERGE originally shipped with several wrong res... [By Aaron Nelson -]( [PowerShell Commands for SQL Server Reporting Services]( In this tip we look at PowerShell commands you can use to manage SQL Server Reporting Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Our Privacy Policy]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com