Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video.

Work with Auto Loader Resource manager in a Scala Databricks notebook to list filter and delete Auto Loader resources from an Azure Subscription.

Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate.

Learn how to schedule, export and email specific parts of Power BI Reports using Power Automate.

Power BI is becoming widely used for reporting and data analysis and this article covers the versions of Power BI and features that are offered.

Valuable SQL Server Performance Tuning tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

Learn about the books, videos, links and advice for passing the Microsoft Exam 70-761 Querying Data with Transact-SQL.

Learn how to convert SQL Server data to different data types such as string, date, integer and numeric using the CAST and CONVERT functions.

Find the right candidates for your open positions and do not rule out good prospects because they don't meet 100% of the job requirements.

In this article we cover how to setup partitioning for a SQL Server table and then how to partition a table that has a columnstore index.

Learn how Melissa's Data Quality Components for SSIS can improve the quality of your data for SQL Server reporting and decision making.

Learn how to use bloom filter indexes to build highly performant delta lake houses when working with delta tables in Databricks.

Learn about key content that might be missing from your resume to help you land your first IT technology job.

Valuable SQL Server Performance Tuning tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

Learn about different reasons why a SQL Server database can be stuck in a restoring state and how to fix this.

In this article we look at how to query for a list of random data from a SQL Server table by using TABLESAMPLE clause.

In this tip we look at how to write an SSIS package to export data from different SQL Server tables to different worksheets in the same Excel file.

In this article we look at what a SQL Full Join is and how you and why you would want to do this with an example you can follow.

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

When deploying a report in SQL Server Reporting Services, I am receiving an exception error stating Maximum request length exceeded. Read this tip to learn how to resolve this issue.