Sites anglophones


Can You Nest Transactions in SQL Server?

Publié le 28 février 2023 sur brentozar.com
 

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

Publié le 27 février 2023 sur sqlskills - jonathan kehayas
 

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

Publié le 27 février 2023 sur sqlservercentral.com
 

The post How to create a Sankey Chart in Power BI Desktop appeared first on SQLServerCentral.

How to Forecast Data in Power BI

Publié le 27 février 2023 sur sqlservercentral.com
 

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

Publié le 27 février 2023 sur sqlservercentral.com
 

The post The business value of frequent deployments appeared first on SQLServerCentral.

Find 40 Problems in This Stored Procedure.

Publié le 24 février 2023 sur brentozar.com
 

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

Publié le 24 février 2023 sur sqlservercentral.com
 

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

Publié le 24 février 2023 sur sqlservercentral.com
 

The post Getting started with SSIS External Configuration File appeared first on SQLServerCentral.

 

Find 40 Problems in this SQL Server Stored Procedure

Publié le 23 février 2023 sur simple-talk.com
 

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

Publié le 22 février 2023 sur brentozar.com
 

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

Publié le 22 février 2023 sur sqlservercentral.com
 

The post Undoing Actions on Groups of Database Tables appeared first on SQLServerCentral.

Azure Automation With Visual Studio Code

Publié le 22 février 2023 sur sqlservercentral.com
 

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

Publié le 21 février 2023 sur simple-talk.com
 

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

Publié le 21 février 2023 sur brentozar.com
 

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

Publié le 20 février 2023 sur sqlskills - jonathan kehayas
 

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 …


Pages :