Query Databases Across SQL Servers, Upskilling Guide, SQL Aggregate Functions and Delta Lake Time Travel (MSSQLTips 3/27/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Query All Databases Across Multiple SQL Servers and Save Results]( In this article, learn how to query all databases on multiple SQL Servers and store the results in a single table.... [Read Now]( [mssqltips image]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, visibility, and governance over your entire data estate.... [Read Now]( [mssqltips image]( [6 Benefits of “Upskilling” or “Reskilling” in Your Job Search]( Here are six benefits and how to take advantage of them to learn key skills and technologies that will HELP you, especially during a job search.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [SQL Server Performance Tuning and Operational Monitoring]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.... [Read Now]( [mssqltips image]( [SQL Aggregate Functions in SQL Server, Oracle and PostgreSQL]( In this article we look at the similarities and differences of aggregate functions like sum, count, min, max, avg and more for SQL Server, Oracle and PostgreSQL.... [Read Now]( [mssqltips image]( [Azure SQL Managed Instance - Will it save your bacon?]( Migrating your SQL Server data to the cloud can yield immediate cost savings beyond shifting IT budget from a capital expense to an operational expense. You can continue to optimize your costs in the cloud to significantly impact your total cost of o... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability]( In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.... [Read Now]( [mssqltips image]( [Improve Data Quality for SQL Server Reporting]( Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution t... [Read Now]( [mssqltips image]( [Drop All Tables in SQL Server and Generate a List of Objects to Drop]( Learn how to drop multiple SQL Server objects with just one command and how to quickly generate a list of objects to drop.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]