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 …
Updated First Responder Kit and Consultant Toolkit for February 2023
Thanks to this technique to run SQL Server on Apple Silicon chips, I’m now developing exclusively on my Mac! I’ve been using a Mac for over 15 years, but in the past, I’ve always used Windows at some layer somewhere. This time around, …
SQL Server 2022: Measuring Extended Events Performance Impacts
Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a lot about Extended Events and have been a huge promoter of why you should be using Extended Events instead of SQL Trace for longer than I have wor …