SQL WHERE Logic, Active Sessions, Performance Tuning and PIVOT (MSSQLTips 5/1/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server Integration Services Tutorial - Start Learning]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL WHERE LIKE to Construct More Efficient Queries]( In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.... [Read Now]( [mssqltips image]( [Understand Important Data to Improve SQL Server Performance]( In this webinar, learn how to monitor SQL Servers' performance and the challenges of doing so across your environment whether it is on-premises, in the cloud or hybrid.... [Read Now]( [mssqltips image]( [SQL Server vs Oracle: Active Session Queries]( In this article, we look at SQL scripts for both SQL Server and Oracle that you can use to troubleshoot active sessions for both of these database platforms.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [How to Monitor Storage Performance with a Single Application]( Learn about storage monitoring and storage performance for your SQL Server environment with Storage Resource Monitor.... [Read Now]( [mssqltips image]( [Advanced report examples in SQL Server using PIVOT and GROUPING SETS]( In this article we look at how to pivot SQL Server data and also rollup and calculate group values by using PIVOT and GROUPING SETS.... [Read Now]( [mssqltips image]( [SQL Server Best Practices for Data Quality]( Data Quality | SSIS Integration - Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [PowerShell for the DBA - Performing DBA tasks using SQL Server CMDLETs]( Learn how to use these PowerShell scripts in SQL Server to get instance details, create backups, manage SQL Server jobs, start an instance and more.... [Read Now]( [mssqltips image]( [Simplify and Automate the Migration of Your Applications with AWS Migration Hub Orchestrator]( In this article, we look at how AWS can simplify the migration of your on-premises SQL Server workloads to the AWS environment using the AWS Migration Hub Orchestrator.... [Read Now]( [mssqltips image]( [Options to Perform backup of Azure SQL Database – Part 1]( In this article we cover various methods to export an Azure SQL Database so that it can restored and used somewhere else.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]