SQL WHILE Loop, Power Query, SQL PIVOT and Azure Databricks CLI

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL WHILE Loop for Processing Time Series Data]( This article looks at use cases and examples for using a while loop to process time series data using T-SQL code.... [Read Now]( [mssqltips image]( ?utm_content=img) [The role of automation in database DevOps]( ?utm_content=head) Wondering where and how to focus your investment in technology? We've found three common themes that help steer where we focus our efforts. Find out more.... [Read Now]( ?utm_content=but) [mssqltips image]( [Getting Started with Power Query M Language in Excel]( This article introduces M language concepts and examples of using M to manipulate data in Excel.... [Read Now]( WEEK IN REVIEW ON MSSQLTips [mssqltips image]( [Managing Azure Databricks with the Azure Cloud Shell CLI]( The Databricks Command Line Interface (CLI) allows you to perform a variety of tasks from the command line versus the Azure Portal. In this article, we look at how to use the Azure CLI with the Azure Cloud Shell.... [Read Now]( [mssqltips image]( [Parameter Sniffing Issue in SQL Server 2022]( In this article, we look at how parameter sniffing can still be an issue in SQL Server 2022 when using temporary tables and one way to resolve the issue.... [Read Now]( [mssqltips image]( [Configuring a Virtual Private Cloud for GCP]( Learn how to use the Google Cloud Platform to share a VPC for multiple projects and how we can connect to GCP from on-premises.... [Read Now]( [mssqltips image]( [SQL Athena Introduction - How it works, Use Cases and Advantages]( Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.... [Read Now!]( [mssqltips image]( [Rounding Numbers to the Nearest Integer with T-SQL]( In this article, we look at how to use T-SQL to round to the nearest integer using round, ceiling, floor, and the banker's rounding rule.... [Read Now!]( [mssqltips image]( [Microsoft Fabric Personas]( Learn about personas when working with Microsoft Fabric to help filter the options and features that best meet your needs.... [Read Now!]( [mssqltips image]( [Upgrade SQL Server from Evaluation Edition to Standard or Enterprise]( Learn how to upgrade SQL Server from the Evaluation edition to other SQL Server editions like Standard or Enterprise.... [Read Now!]( [mssqltips image]( [SQL Pivot Like a Pro]( In this article, we look at ways to pivot and unpivot data using T-SQL code to transform data into rows and columns.... [Read Now!]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]