In this article we will look at how to perform SQL Server database restores using file snapshot backups.

Comparison of SQL loop through table row options with a SQL Server Cursor versus a While Loop.

In SQL Server 2016 and later, a property has been added to the Integration Services (SSIS) data flow: AutoAdjustBufferSize. What is this property and how can I use it?

This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages.

Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG.

Learn about the Microsoft Azure Data Community that help's community members run events and learn from one another.

Learn about 4 ways to get SQL Server row count for all tables in a SQL Server database with practical examples and sample code.

Learn how to parse or split SQL Server strings from one column into multiple columns using the parsename and other T-SQL functions.

Learn how to use SSRS IIF, Switch and Choose statements in reports to make them more dynamic and appealing for users.

No matter if you are a seasoned Power App developer or just starting, the platform has some caveats and knowing will save you some time and effort.

In this article we look at how to setup transparent data encryption for SQL Server data files stored in Azure storage, but keeping the TDE keys local.

Learn how to efficiently utilize Dynamic Partition Pruning in Databricks to run filtered queries on your Delta Fact and Dimension tables.

In this article learn how to use Performance Monitor to collect disk related counters to help troubleshoot SQL Server issues related to storage proble

Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.

Learn about performance of Adaptive Query Execution when disabled versus enabled while querying big data workloads in your Data Lakehouse.

In this article we look at how to concatenate SQL Server data using various methods using concatenation operator, functions CONCAT and CONCAT_WS.

Learn methods and applications to create and support your Data Lakehouse ELT design, development, scheduling, and monitoring of pipelines in Azure.

SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats and anomalies.

In this tip we look at how SQL Server can minimally log Bulk Load Inserts and some of the things you should know.

Learn how to customize your SQL Server 2016 Reporting Services web portal.