SQL String Functions, SSRS Security, T-SQL Enhancements and Predictive Analysis

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Predictive and Descriptive Analysis with Azure and Power BI]( In this article, we look at how to build an Azure streaming data collection and analysis process to analyze and predict stock prices.... [mssqltips image]( [Is your database on its death bed?]( SQLGrease gives you deep insights down to the individual query and helps you identify problematic workload. With features such as anomaly detection and our recommendations you will find issues quickly. Try SQLGrease free with our 30 day trial.... [mssqltips image]( [SQL Server Reporting Services Security]( This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [SQL Server Disaster Recovery Strategies]( Being able to recover our data in the event of an outage is a critical aspect of managing SQL Server. But how do we plan for the worst? What technologies are available to us? And how do we implement a disaster recovery strategy when the worst has jus... [mssqltips image]( [SQL String Functions]( In this article, we look at how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.... [mssqltips image]( [SQL Query Optimization Solved]( 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]( [Archive SQL Server Data]( This tip explores a better, more direct, and more optimized method for moving or archiving data in SQL Server using the SQL OUTPUT clause.... [mssqltips image]( [Data Quality Solutions for SSIS]( Learn about the Melissa Data Quality Solutions for SSIS.... [mssqltips image]( [T-SQL Enhancements in SQL Server 2022]( A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical use cases. ... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]