This article is dedicated to building the new generation data warehouse called lakehouse and we discuss common data warehouse building challenges.

In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.

In this article we cover technical skills and soft skills that are typically found in successful BI developers.

In this article we look at how to get the correct repositories in place to install SQL Server 2019 on Red Hat Linux virtual machine.

This article shows different ways to compare SQL Server data, datatypes and tables using TSQL and some development tools.

Use SQL format number functions like CAST, CONVERT, ROUND, CEILING, FLOOR and FORMAT for number formatting in SQL.

Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data with TDE encryption across numerous medical devices.

Learn various ways to check if a SQL Server table exists before trying to drop the table to avoid the table does not exist error.

In this article we look at how to create a basic Power App that allows saving data to a database table.

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

In this article we look at a script you can use to find all index hints that are being used from the SQL Server cache and from stored procedure code.

In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.

One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.

SQL Server provides SELECT INTO and INSERT INTO for inserting data into temporary tables. In this tip we look at which performs better.

In this tip we look at PowerShell commands you can use to manage SQL Server Reporting Services.

This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.

This article compares performance for a SQL Server temporary table, table variable and a CTE using some simple SELECT queries.

Learn about different ways to capture and identify blocking in SQL Server using TSQL, profiler, extended events, SSMS and more.

Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data with TDE encryption across numerous medical devices.

Guide to fix network-related or instance-specific errors related to could not open a connection to SQL Server.