XML Files, Data Visualization, Rolling Up Rows, Indexing and more (MSSQLTips 3/21/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Managing XML Files with Apache Spark]( In this article, we look at how to read and write XML files using Apache Spark. The article walks through how to do this with different data sets.... [Read Now]( [mssqltips image]( [Introduction to Creating Interactive Data Visualizations with Python matplotlib in VS Code]( In this tip, we present a step-by-step guide on how to present your data interactively using matplotlib and Python in VS Code.... [Read Now]( [mssqltips image]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, visibility, and governance over your entire data estate.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Optimize your costs with Azure SQL Managed Instance]( Migrating your SQL Server data to the cloud can yield immediate cost savings beyond shifting IT budget from a capital expense to an operational expense. You can continue to optimize your costs in the cloud to significantly impact your total cost of o... [Read Now]( [mssqltips image]( [Understanding Windows Server Cluster Quorum Options]( In this whitepaper learn about the different Failover Cluster quorum options to ensure your Windows Clusters stay up and running.... [Read Now]( [mssqltips image]( [Rolling up multiple rows into a single row and column for SQL Server data]( I need a way to roll-up multiple SQL Server rows into one row. I know I can roll-up multiple rows using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple T-SQL approach to accomplish... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Indexes to Improve Query Performance]( In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.... [Read Now]( [mssqltips image]( [SQL Server CLR Stored Procedure Development]( In this article we look at how to build Common Runtime Language CLR stored procedures in SQL Server along with different ways a stored procedure can be written in CLR.... [Read Now]( [mssqltips image]( [How to Encrypt and Decrypt CSV File in SSIS]( In this article we look at how you can use a SQL Server Integration Services (SSIS) package to encrypt and decrypt data to and from a flat file.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]