SQL Index Rebuild Script, Excel Pivot Table Alternative, SQL Date and Time Functions, Find Max Column Values

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]( [An Alternative to Excel Pivot Tables in Power BI]( Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.... [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]( [mssqltips image]( [Comparing Azure Analysis Services and SSAS]( This article compares Azure Analysis Services with On-Premises SQL Server Analysis Services and why you might choose one over the other.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [A Universal Data Management Tool]( Learn about Aqua Data Studio which is a feature-rich management tool and IDE for over 40 database platforms such as SQL Server, Oracle, MySQL, Snowflake, and many more. ... [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]( [Don't Let Inaccurate Date Cripple Your Business]( Learn about the Challenges, Interesting Findings and Opportunities in the 2023 Data Quality Report. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Find MAX value from multiple columns in a SQL Server table]( In this article we look at different T-SQL approaches to get the maximum value from multiple columns in a table.... [Read Now]( [mssqltips image]( [The complete guide to high availability in the Azure cloud]( This e-book will give you an overview of a complete, high-availability move to Azure, including an overview of how SANless clusters... [Read Now]( [mssqltips image]( [SQL Server script to rebuild all indexes for all tables and all databases]( In this tip we look at a simple script you can use to rebuild all SQL Server indexes for all specified databases.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]