SQL GROUP BY Examples, Azure Geo-Replication, Schedule PowerShell Scripts and Power BI Data Modeling (MSSQLTips 5/1/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Free SQL Server Tutorials]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Remove Azure SQL Databases from a Failover Group and Remove Geo-Replication]( Learn about the steps needed to remove a SQL database from an Azure failover group and also how to remove geo-replication for the database.... [Read Now]( [mssqltips image]( [Efficiently Manage SQL Server Farms]( Managing a database environment has gotten significantly more complex with 24x7x365 requirements, limited qualified database professionals and fierce ... [Read Now]( [mssqltips image]( [Scheduling PowerShell Scripts with Puppet]( In this article, learn about Puppet a tool to help schedule and automate tasks in your systems environment. This covers installation and the configuration of a simple automated task for a PowerShell script.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Data Warehouse Cleansing, Verification and Matching]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?... [Read Now]( [mssqltips image]( [Learning the SQL GROUP BY Clause]( Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.... [Read Now]( [mssqltips image]( [Slash Downtime with Simple SQL Server Backup and Restores]( Learn how to slash downtime for SQL Server backup and restores with FlashBlade® backup terabyte databases in minutes, make database restores your first choice for disaster recovery and protect your databases from ransomware.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Read Now]( [mssqltips image]( [SQL Server Monitoring On-premises and Cloud for Management and DBAs]( The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to ... [Read Now]( [mssqltips image]( [The Importance of a Good Data Model in Power BI Desktop]( This tip will go through some guidelines for creating an optimized data model when working with Power BI for performance and accurate results.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]