Date and Time Functions, New SQL Server 2022 Storage Features, Tune Problematic Queries and SQL CASE

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]( [Learn Spark SQL Date and Time Functions]( This article covers how to use the different date and time functions when working with Spark SQL with several different examples of how to use these date/time functions.... [Read Now]( [mssqltips image]( [Bring Cloud Manageability to your SQL Server anywhere with Azure Arc]( Microsoft is bringing Azure innovation to your SQL Server workloads running anywhere, on premises or across multicloud environments. You can now improve SQL Server business continuity by viewing and managing Always-On availability groups, failover cl... [Read Now]( [mssqltips image]( [Create Calendar Table Using Power Query M Language]( Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.... [Read Now]( RECOMMENDED READING ON MSSQLTips [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]( [SQL Server Date and Time Functions with Examples]( This tip covers the different SQL Server date and time functions all in one place to make it easier to find what you are looking for when working with dates times.... [Read Now]( [mssqltips image]( [Understanding Disaster Recovery Options for SQL Server]( This white paper provides some practical guidance to help system and database administrators tasked with creating business continuity and disaster rec... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Resolving could not open a connection to SQL Server errors]( Solving - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote ... [Read Now]( [mssqltips image]( [Tuning Problematic SQL Server Queries]( 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]( [SQL CASE Statement in Where Clause]( Learn about different ways you can use a CASE statement in the WHERE clause for a T-SQL statement with these several examples.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]