Week in Review + Cloud Data Platform Driven Organization, Database Encryption and more (MSSQLTips 6/20/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server belongs on Azure]( [Becoming a Cloud Data Platform Driven Organization - Part 2]( [Becoming a Cloud Data Platform Driven Organization - Part 2]( This article explores the benefits of adopting a cloud data platform by defining the guiding principles of a Cloud Data Lakehouse, along with what a foundational data journey into the cloud might look like. ... [Get better performance for less on Azure]( [Get better performance for less on Azure]( In a recent study commissioned by Microsoft, Principled Technologies found Azure SQL Managed Instance leads in mission critical price-performance, providing up to 5 times faster performance and costing up to 93% less than AWS RDS. Read the report.... [My Favorite T-SQL Enhancements in SQL Server 2022]( [My Favorite 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.... [Easily Encrypt SQL Server Databases and Backups - All Versions and Editions]( [Easily Encrypt SQL Server Databases and Backups - All Versions and Editions]( SQL Server database encryption should be a best practice, but it can seem daunting to implement. You might be faced with the prospect of upgrading your SQL Server, changing editions, or recoding your applications. Learn how to easily encrypt your dat... [Split Delimited String into Columns in SQL Server with PARSENAME]( [Split Delimited String into Columns in SQL Server with PARSENAME]( In this tip we look at how to parse or split SQL Server data from one column into multiple columns using the parsename and other T-SQL functions.... [Find, Analyze and Optimize SQL Server Performance]( [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [Script to retrieve SQL Server database backup history and no backups]( [Script to retrieve SQL Server database backup history and no backups]( In this tip we provide queries you can use to get status information about all of your SQL Server database backups.... [Salesforce and QuickBooks Integration to Snowflake via SSIS]( [Salesforce and QuickBooks Integration to Snowflake via SSIS]( Learn how to use CData connectors to easily connect SSIS to Salesforce and QuickBooks Online then load the data into a Snowflake data warehouse.... MSSQLTips Week In Review [Basic SQL INSERT Statement with Examples]( [Basic SQL INSERT Statement with Examples]( In this article learn about the basics of SQL INSERT statements along with several different examples of how to insert data into SQL Server tables.... [Configure Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains - Part 3]( [Configure Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains - Part 3]( In this third article we continue building Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain.... [Different ways to Convert a SQL INT Value into a String Value]( [Different ways to Convert a SQL INT Value into a String Value]( In this article we cover different ways to convert a SQL Server numeric value into a string value.... [Dynamic Page Navigation in Power BI]( [Dynamic Page Navigation in Power BI]( In this article we look at how to add custom page navigation to Power BI to help navigate a multi-page report.... [How to Import and Export Connections from SQL Server Management Studio]( [How to Import and Export Connections from SQL Server Management Studio]( In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.... [Reduce Pandas Memory Needs and Errors - MemoryError: unable to allocate...]( [Reduce Pandas Memory Needs and Errors - MemoryError: unable to allocate...]( Learn how to reduce your memory needs when working with Pandas Dataframes and avoid the error MemoryError: unable to allocate...... [Study material for Exam PL-300: Microsoft Power BI Data Analyst]( [Study material for Exam PL-300: Microsoft Power BI Data Analyst]( Check out this large lists of resources you can use to study and pass the Microsoft exam PL-300 Microsoft Power BI Data Analyst.... [Using T-SQL and the RSI to Predict When to Buy and Sell Financial Securities]( [Using T-SQL and the RSI to Predict When to Buy and Sell Financial Securities]( In this article we look at how to implement a model with SQL code to make predictions based on the Relative Strength Index to determine when to buy and sell financial securities. ... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}