Exploring Scalar Solutions to Complex Data Math

There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity.

The Power of Generate_series

SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.

Improve Query Performance when SQL Server Ignores Nonclustered Index

Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.

SQL Server Backup or Restore using Network Share with SSMS

In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.

Engineering a Lakehouse with Azure Databricks with Spark Dataframes

How can we get familiar with Azure Databricks with Spark Dataframes?

Deciphering Data Architectures

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

• Printed book:
  • US
• Kindle book:
  • US

What If You Need to Index a Lot of Duplicate Data?

Let’s get a little nerdy and look at database internals.

Upgrade and Migrate SSIS Catalog and SSISDB to a New Server

There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.

Index Rebuilds Make Even Less Sense with ADR & RCSI

Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.

Find Text in Stored Procedure, Function, View, or Trigger

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?