SQL Development, AWS Athena, Hybrid Analytics and Star Schema in Power BI

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]( [SQL Script for SQL Server Table and Column Properties]( In this article, we look at a set of T-SQL code that can be used to profile all the tables and columns in a SQL Server database.... [Read Now]( [mssqltips image]( ?utm_content=img) [Come build a Microsoft application on AWS in 2 hours]( ?utm_content=head) If you've ever wondered what it takes to migrate a Microsoft-based application from on premises and transform it into a cloud-efficient, cost-saving, high-performing application on AWS, then this virtual workshop is for you. Come join us!... [Read Now]( ?utm_content=but) [mssqltips image]( [Working with AWS Athena]( In this article, we look at how to use AWS Athena to query data as well as create tables and views when working with Athena.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Manage Many SQL Server Instances with Ease]( 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 FORMAT Function for Dates and Numbers]( In this tip we look at some other useful ways you can use the SQL Server FORMAT function in your daily work.... [Read Now]( [mssqltips image]( [Dow Jones modernizes its business-critical database workloads]( Learn the 5 stages Dow Jones followed to modernize 2 TB databases to the AWS cloud to meet performance at scale, gain effectiveness and cost benefits... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server 2022 LEFT_SHIFT and RIGHT_SHIFT Functions]( Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.... [Read Now]( [mssqltips image]( [Enable Hybrid Analytics with Modern Data Architectures]( Learn about the evolution of the data platform architecture from data warehouses to data lakes to data lakehouses to bring together structured, semi-structured and unstructured data to unlock insights quicker.... [Read Now]( [mssqltips image]( [How to Create a Star Schema in Power BI Desktop]( Learn how to build a star schema data model using Power BI Desktop for improved report development and performance.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]