Email Power BI Reports, SELECT INTO Examples, Calendar Table using Power Query and Max Value from Multiple Columns (MSSQLTips 10/6/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Tech Talk: AtScale + SnowFlake for Data Science Workflows]( [Use Power Automate to Export and Email Power BI Reports with Row Level Security]( [Use Power Automate to Export and Email Power BI Reports with Row Level Security]( Learn how to schedule sending Power BI reports as PDFs and using Power Automate to schedule the running and exporting a PDF version of a report.... [SQL SELECT INTO Examples for New Tables - Part 2]( [SQL SELECT INTO Examples for New Tables - Part 2]( In this article we look at more ways to create a new SQL Server table using SELECT INTO as well as some specific nuances you should be aware of.... [How to streamline data science and feature creation workflows in Snowflake]( [How to streamline data science and feature creation workflows in Snowflake]( Register for this Tech Talk (Thursday, October 14th, 2021 at 2PM ET / 11AM PT) to learn how to use AtScale and Snowflake to streamline time series predictions and move machine learning models closer to your data.... [SQL Server Download Quick Links]( [SQL Server Download Quick Links]( SQL Server download quick links are included in this tip for the SQL Server engine, Express Edition, Service Packs, tools and more. Be sure to bookmark this page to use as a quick and comprehensive reference guide.... [Seamless Monitoring and Reporting for SQL Server]( [Seamless Monitoring and Reporting for SQL Server]( SolarWinds SAM provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting system for your SQL Servers and entire infrastructure.... [Create Calendar Table Using Power Query M Language]( [Create Calendar Table Using Power Query M Language]( Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.... [Understanding the Availability Chain and its Impact on SQL Server]( [Understanding the Availability Chain and its Impact on SQL Server]( In this webinar learn about the chain of availability and how to determine your risk of downtime and failure for each link - and how to protect your most critical business applications.... [Find MAX value from multiple columns in a SQL Server table]( [Find MAX value from multiple columns in a SQL Server table]( Sometimes it is necessary to find the maximum or minimum value from different columns in a table that have the same data type. In this tip, we will look a different ways that this can be done.... [Faster SQL Server Clustering]( [Faster SQL Server Clustering]( 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... [By Basit Farooq -]( [How to migrate a SQL Server database to a lower version]( In this tip we take a look at one approach to downgrade a SQL Server database to a lower version of SQL Server since a simple backup and restore will not work.... [By Greg Robidoux -]( [Execute Dynamic SQL commands in SQL Server]( In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.... [By Koen Verbeeck -]( [Reading SharePoint Lists with Integration Services 2017]( In this tip we look at how to extract data from a SharePoint list using a SSIS package with the built-in components. ... [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