Learn how to schedule sending Power BI reports as PDFs and using Power Automate to schedule the running and exporting a PDF version of a report.

Learn how to create a customizable Power BI calendar date table that can be used for Power BI reports using Power Query.

Learn about different approaches for building dynamic SQL code using query parameters, EXEC and sp_executesql.

Learn about the Azure SQL DB purchasing model and how to change from DTU to vCore or vice versa.

Learn how to build and use a calendar table in SQL Server to make it easier to figure out and use dates and date ranges for queries.

Data breaches are commonplace with some accounts reporting more than 1000 breaches per year. Learn how SQL Server data masking helps.

Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.

This article looks at examples of when data type names are case sensitive and what you should do to avoid any possible errors in your SQL Server.

Learn about the challenges of implementing Data Lakes and the lakehouse concept to build scalable solutions capable of handling large data volumes.

Compare four time series models using SQL Server that signal when to buy and sell financial securities like company stocks or exchange traded funds.

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

Learn how to turn on and off SSMS show line numbers to see line numbers for code in SQL Server Management Studio queries.

SQL Server backups and restores can take a long time to complete and learn how to find the backup completion percentage in SQL Server.

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

Use SSMS to quickly find errors in your T-SQL code by double clicking on the error message and SSMS will bring you right to that line of code.

Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE.

Use these queries to get SQL server backup history for database backups to easily find the backup history of a database in SQL Server.

Data breaches are commonplace with some accounts reporting more than 1000 breaches per year. Learn how SQL Server data masking helps.

Learn how to schedule sending Power BI reports as PDFs and using Power Automate to schedule the running and exporting a PDF version of a report.

Deep dive into multiple linear regression for estimation and prediction using real estate data and SQL Server and R for data analysis.