Unpivoting SQL Server Data, Indexing Tutorial, Current Date and AWS Auditing

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Stop Chasing Red Herrings - Find True Performance Problems]( [Stop Chasing Red Herrings - Find True Performance Problems]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY]( Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY. ... [Read Now]( [mssqltips image]( [How solid is your performance monitoring?]( Monitoring SQL Server can be categorized at three different levels. House of straw - performance counters. House of sticks top x queries and performance counters. House of bricks - historical queries, execution plans, query waits, lock trees, custo... [Read Now]( [mssqltips image]( [Getting Started with Databricks Unity Catalog and Volumes]( In this article, we look at how to get started with Databricks Unity Catalog and Volumes in this step-by-step overview.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Tuning Problematic SQL Server Queries with Minimal Changes]( A common problem with tuning problematic SQL Server queries is the inability to make immediate code changes to fix performance problems when production databases are impacted. In this demo-centric presentation you will learn several levers available ... [Read Now]( [mssqltips image]( [Query Amazon CloudTrail Logs]( This tip covers using Amazon Athena to query Amazon CloudTrail logs for auditing your AWS account.... [Read Now]( [mssqltips image]( [Correcting SQL Server Data Accuracy]( Learn about the Challenges, Interesting Findings and Opportunities in the 2023 Data Quality Report. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Index Tutorial Overview]( This tutorial will try to go through each type of index available in SQL Server and explain why/when each one could be used to improve your query performance.... [Read Now]( [mssqltips image]( [Five Costly Myths About High Availability in Cloud]( Separating the facts and myths of HA and DR in cloud deployments can help you save money and reduce risk of downtime and data loss.... [Read Now]( [mssqltips image]( [How to Get Current Date in SQL Server]( In this article we will explore the different options for getting the current date from SQL Server and understand when to use one option over the other.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]