SQL Server Calendar Table, PowerShell Scripts, Microsoft Fabric and ETL Processes

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Take The Guess Work Out of Performance Problems]( [Take The Guess Work Out of Performance Problems]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [What are Lakehouses in Microsoft Fabric?]( This guide will walk you through the process of creating a Data Lakehouse in Microsoft Fabric.... [Read Now]( [mssqltips image]( [Stop guessing where your performance problems are]( No one is a fan of being in a war room with every team in the organization while trying to diagnose a performance problem. SQLGrease helps quickly identify if the performance problem is in the database, and the root cause so you don’t end up in war ... [Read Now]( [mssqltips image]( [What I Wish Everyone Knew About ETL Processes]( In this article, learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Salesforce and QuickBooks Integration to Snowflake]( Learn how to use CData connectors to easily connect SSIS to Salesforce and QuickBooks Online then load the data into a Snowflake data warehouse.... [Read Now]( [mssqltips image]( [Creating a date dimension or calendar table in SQL Server]( A calendar table can be immensely useful, particularly for reporting purposes, and for determining things like business days between two dates. I often see people struggling with manually populating a calendar or date dimension table; usually there a... [Read Now]( [mssqltips image]( [Find SQL Server Performance Problems]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Run PowerShell Scripts with SQL Server Agent or Windows Task Scheduler]( Learn how to schedule and automate your PowerShell scripts using either SQL Server Agent or Windows Task Scheduler.... [Read Now]( [mssqltips image]( [How clean is your SQL Server data?]( Learn about the Challenges, Interesting Findings and Opportunities in the 2023 Data Quality Report. ... [Read Now]( [mssqltips image]( [Sample Use Case for Using SQLCMD Utility Batch Files]( In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]