String Conversion, SQL Reference Guide, Power BI and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Convert a String to JSON with SQL Server Queries]( In this article, we look at various ways to generate JSON formatted data for SQL Server queries using FOR JSON option.... [mssqltips image]( [From hiccups to nausea SQLGrease can help]( SQLGrease collects query level performance statistics to determine the root cause of performance issues, and in some cases provides recommendations on fixing them. Try SQLGrease free for 30 days.... [mssqltips image]( [SQL Quick Reference Guide]( This guide outlines various aspects of working with SQL along with several links to resources to help you better understand how to use the SQL language.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [SQL Server Protection and Peace of Mind]( Attend this webinar and learn about Single Server Protection High Availability (SSP-HA).... [mssqltips image]( [Dynamically Create Tables in Power BI with DAX Functions]( Learn about various DAX functions to dynamically create tables in Power BI such as ADDCOLUMNS, CROSSJOIN, VALUES, SUMMARIZE, GENERATE, CALENDAR, FILTER, TOPN, UNION, and NATURALINNERJOIN.... [mssqltips image]( [Deep SQL Query Optimization with SQL Grease]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Dynamically Move Multiple Tables in Bulk using Azure Data Factory]( This article covers how to use Azure Data Factory to dynamically move bulk data from multiple sources to a new destination using the ForEach and Lookup activities.... [mssqltips image]( [Enabling Academic Research with Real-World Data Sets]( Learn how Melissa for Education is helping students with research projects, cyber security, GIS data, medical research, datathons and more.... [mssqltips image]( [Understanding Power BI Security Options]( In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]