Testing before coding: shifting farther left
The post Testing before coding: shifting farther left appeared first on SQLServerCentral.
Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character data in a computer. But in the dark ages, before we invented dirt and entered into the stone age, there were other contenders. The Control D …

Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table:DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE dbo.StatusLog (TimeItHappened DATETIME2 PRIMARY KEY CLUSTERED, Step VARCHAR(20)); GO And then let’s try a two-part transaction:BEGIN TRAN I …

Event exceeds the number of allowable bound actions
Did you know that there is a limit to the number of actions you can add to a single event in Extended Events? While I was playing around with Trace Flag 9708 for my previous blog post, one of the things I wanted to try to see was whether it would be ea …
How to create a Sankey Chart in Power BI Desktop
The post How to create a Sankey Chart in Power BI Desktop appeared first on SQLServerCentral.

How to Forecast Data in Power BI
Introduction In this article, we will learn how to Forecast data in Power BI. Forecasting in Power BI will help us to predict the future based on our current information. You can easily forecast in Power BI by following some simple steps. Requirements …
The business value of frequent deployments
The post The business value of frequent deployments appeared first on SQLServerCentral.
Find 40 Problems in This Stored Procedure.
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where the folks in marketing requested a list of users to e-mail a new promotional campaign. The customers need to meet at least one of the f …

An Overview of PostgreSQL Window Functions
This article is a guide on using SQL window functions in applications that need to make computational heavy queries. Data is proliferating at an astonishing rate. In 2022, the world produced and consumed 94 zetabytes of data. Today we have multiple too …
Getting started with SSIS External Configuration File
The post Getting started with SSIS External Configuration File appeared first on SQLServerCentral.
Find 40 Problems in this SQL Server Stored Procedure
I’ve been at this for a while now, and have a very particular set of rules and coding conventions that I follow when writing and, more importantly, reviewing T-SQL code. I often perform code reviews and thought it would be fun to frame this exerc …

Office Hours: Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded responses. Brandon: Do you seen a rise in json queries to address impedance mismatch between data/objects? I struggled with EF to produce a query that was …
Undoing Actions on Groups of Database Tables
The post Undoing Actions on Groups of Database Tables appeared first on SQLServerCentral.

Azure Automation With Visual Studio Code
Introduction Azure Automation is a cloud-based service that provides consistent management capabilities across Azure and non-Azure environments. Visual Studio Code (VS Code), in my opinion, is a next-gen code editor that is based on open-source. It is …
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) are created and managed in PostgreSQL Depending on your background with permissions, particularly in other database products, some of those …