SQL GROUP BY Queries, Time Series Models, SQL Server TDE and Step by Step Tutorials (MSSQLTips 9/8/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Monitor SQL Server Like a Brick House]( [SQL GROUP BY Queries to Summarize and Rollup Sets of Records]( [SQL GROUP BY Queries to Summarize and Rollup Sets of Records]( In this article, we look at some basic examples of how to use the SQL GROUP BY clause when writing queries to summarize and rollup sets of records.... [How to Build a Data Science Time Series Model with SQL Server]( [How to Build a Data Science Time Series Model with SQL Server]( This article covers how to build time series models using SQL and presents a framework for data science time series model building that may be appropriate to many types of indicators. ... [How solid is your performance monitoring]( [How solid is your performance monitoring]( Monitoring sql server can be categorized at three different levels. House of straw - performance counters. House of sticks top x queries and performance counters. House of bricks historical queries, execution plans, query waits, lock trees, customi... [Suspend and resume initial scan for Transparent Data Encryption (TDE) in SQL Server]( [Suspend and resume initial scan for Transparent Data Encryption (TDE) in SQL Server]( When enabling TDE for a SQL Server database the initial encryption of data pages can take some time and have a performance impact. In this article, we look at how to suspend and resume this process so it does not impact performance.... [Improve Your SQL Server Data Accuracy]( [Improve Your SQL Server Data Accuracy]( Data is being generated at breakneck speed, and more companies are moving towards a data-driven culture. But many data professionals and companies still struggle with the challenge to improve data quality and accuracy in their systems.... [SQL Server DAX Tutorial]( [SQL Server DAX Tutorial]( Data Analysis Expressions (DAX) is perceived to be a query language for Tabular SSAS, Power BI Desktop and PowerPivot. Technically, DAX is a library of functions and operators that can be used to develop a formula that can be used with the Vertipaq E... [Conduct Deep SQL Query Optimization]( [Conduct Deep SQL Query Optimization]( 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.... [My First SQL Server Business Intelligence Project Tutorial]( [My First SQL Server Business Intelligence Project Tutorial]( In a Business Intelligence project, data is the currency and analytics is the merchandise. Without having the right type, amount and shape of data, one cannot get the right kind of analytics.... [Universal Data Integration Across the Enterprise]( [Universal Data Integration Across the Enterprise]( Universal real-time data integration is a serious technical and organizational challenge that supersedes the native SQL Server capabilities. CData has recognized these challenges and has delivered a universal data access solution via drivers for on-p... [By Tim Ford - ]( [Script to retrieve SQL Server database backup history and no backups]( In this tip we provide queries you can use to get status information about all of your SQL Server database backups.... [By Jeremy Kadlec - ]( [SQL Server Join Example]( I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples and ex... [By Koen Verbeeck - ]( [Using hash values in SSIS to determine when to insert or update rows]( When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update - a historical change - or an insert, which is a new occurrence of a record. In this tip we show how... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}