SQL GROUP BY, Hung SQL Agent Jobs, Power BI Training and Tutorials

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 GROUP BY Alias for SQL Server]( Wouldn't be nice if SQL Server allowed you to use an alias in the SQL GROUP BY clause for complex code? Learn more about this and vote for this SQL Server feature.... [Read Now]( [mssqltips image]( [Five database DevOps practices for boosting team productivity]( Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.... [Read Now]( [mssqltips image]( [Monitor for Hung SQL Server Agent Jobs]( In this article, we look at setting up an automated process to alert you about long-running SQL Server Agent jobs and the ability to stop the job if needed.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Power BI Training - 40% End of Year Discount]( Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.... [Read Now]( [mssqltips image]( [Tutorial - Getting Started with Snowflake]( In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors.... [Read Now]( [mssqltips image]( [Simple SQL Server Estate Monitoring for all DBAs]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Date Functions Tutorial]( Learn about the SQL CURRENT_TIMESTAMP function and why this should be used instead of the SQL Server GETDATE() function.... [Read Now]( [mssqltips image]( [SQL Server and .NET Development Best Practices]( A new set of best practices have emerged to accommodate this new generation of applications. In this interactive session, you will learn some techniques to help you get the best performance, security, and scale from your modern .NET applications usin... [Read Now]( [mssqltips image]( [SQL Server Management Studio Tutorial]( This gives an overview of what SQL Server Management Studio is and what it is used for.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]