SQL Server Date Tips, Exam Preparation, Parameters in Stored Procedures and SQL Server 2022 Storage Features

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Solving Date Range SQL Server Query Performance Issues]( In this article, I demonstrate the issue of creating two SQL Server indexes to enhance performance, but the query optimizer only chooses one which doesn't help with performance.... [Read Now]( [mssqltips image]( [MB-260 Microsoft Customer Data Platform Specialist Exam Preparation]( Prepare for the MB-260 Microsoft Customer Data Platform Specialist Exam with the resources in this article.... [Read Now]( [mssqltips image]( [Don't miss our exclusive year-end offers to supercharge your security.]( Overwhelmed by your SQL server logs? EventLog Analyzer is here to your rescue. Securely collect and audit logs from your SQL server to detect vulnerabilities proactively.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [.NET Apps and SQL Server in the Cloud]( A new set of best practices have emerged to accommodate this new generation of applications. In this interactive session, you will learn some techniques to help you get the best performance, security, and scale from your modern .NET applications usin... [Read Now]( [mssqltips image]( [Recursive Common Table Expression Examples]( Learn how to write and use recursive CTEs in SQL Server along with explanations and several examples.... [Read Now]( [mssqltips image]( [Stop SQL Server Data Quality Headaches]( Learn about the Challenges, Interesting Findings and Opportunities in the 2023 Data Quality Report. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Parameters in Queries and Stored Procedures]( One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In t... [Read Now]( [mssqltips image]( [SQL Server 2022 New Storage Features]( Check out the new storage-related features in SQL Server 2022 including snapshots to restore a database, copy a database, and seed an Availability Group replica, all nearly instantaneously. Learn how to configure SQL Server for backup to S3, backup ... [Read Now]( [mssqltips image]( [Searching between two date values in SQL Server]( Learn different ways to select data between two dates using various techniques along with how to improve performance for very large tables.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]