Next Gen Data Quality, Script to backup all databases, NOLOCK hint, SQL Server TempDB Enhancements, and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Server TempDB Contention Enhancements]( Learn about system page latch concurrency enhancements in SQL Server 2022 compared to earlier versions to reduce tempdb contention.... [mssqltips image]( [Address The Future With Next Gen Data Quality]( Propel your business to the next level with cutting-edge developer tools to help you clean and standardize your data. Download our catalog full of flexible deployment options such as on-prem, web APIs and plugins to create the perfect solution... [mssqltips image]( [SQL code to roll up multiple rows into single row and column]( Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG. ... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [On demand webinar: Modernize in place with SQL Server 2022]( Learn about the latest SQL Server 2022 and on-premises innovation. This includes tips and tricks to take advantage of your upgrade while staying compatible.... [mssqltips image]( [Simple script to backup all SQL Server databases]( In this article we look at how you can automatically backup all of your SQL Server databases with a couple of T-SQL commands.... [mssqltips image]( [Date and Time Conversions Using SQL Server]( Learn SQL date format options with the SQL CONVERT function when working with date data types in SQL Server.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Understanding the SQL Server NOLOCK hint]( In this tip we look at the SQL Server NOLOCK hint and how it impacts query results, both good and bad.... [mssqltips image]( [DAX CASE Statement Functionality]( There is not a CASE statement in DAX, but in this article, we look at other options that have similar functionality such as IF(), SWITCH(), and SWITCH(TRUE()).... [mssqltips image]( [Set up SQL Server Transparent Data Encryption (TDE) in HA environment]( In this article, we look at how to enable TDE for databases that are already part of a SQL Server AlwaysOn Availability Group.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]