Sites anglophones


Error Handling Quiz Week: Making a Turkey Sandwich with XACT_ABORT

Publié le 13 janvier 2022 sur brentozar.com
 

CAN YOU BELIEVE THAT HOT MESS IN YESTERDAY’S POST?!? I know, right? You thought that by combining try/catch with a transaction, you’d get robust error handling.  Instead, you ended up with half the tables populated, and a leftover open …

A Fond Farewell

Publié le 12 janvier 2022 sur SQLSkills.com - Erin Stellato
 

If you haven’t guessed from the title, I’m writing this post because I am leaving SQLskills. This Friday, January 14th, is my last day, and I am currently a mess of emotions.  I am leaving on the best terms possible, and it’s bec …

The Curious Case of… tracking page compression success rates

Publié le 12 janvier 2022 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Error Handling Quiz Week: Combining Transactions And TRY/CATCH

Publié le 12 janvier 2022 sur brentozar.com
 

In yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not solve our problem – and in fact, it makes things worse. With yesterday’s code, we still got rows inserted into the Pa …

Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment

Publié le 12 janvier 2022 sur sqlservercentral.com
 

The post Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment appeared first on SQLServerCentral.

Automating Flyway Undos

Publié le 12 janvier 2022 sur sqlservercentral.com
 

The post Automating Flyway Undos appeared first on SQLServerCentral.

Error Handling Quiz Week: Will a Transaction Help?

Publié le 11 janvier 2022 sur brentozar.com
 

In yesterday’s post, we tried a TRY/CATCH, and those of us who actually ran the demo scripts were disappointed. We found that a TRY/CATCH alone doesn’t fix it: we end up getting rows in the Parent table, but no rows in the Child table. It t …

Error Handling Quiz Week: Tryin’ TRY/CATCH

Publié le 10 janvier 2022 sur brentozar.com
 

Let’s say we have two tables, Parent and Child, and we need to guarantee that they both get populated at once. We’ll write a single stored procedure to do both inserts:DROP TABLE IF EXISTS dbo.Parent; DROP TABLE IF EXISTS dbo.Child; CREATE …

Getting Started with Cloud-hosted Databases using Spawn

Publié le 10 janvier 2022 sur sqlservercentral.com
 

The post Getting Started with Cloud-hosted Databases using Spawn appeared first on SQLServerCentral.

How to filter DAX for paginated reports

Publié le 10 janvier 2022 sur sqlservercentral.com
 

The post How to filter DAX for paginated reports appeared first on SQLServerCentral.

The Changing Landscape of Information Management

Publié le 10 janvier 2022 sur sqlservercentral.com
 

Introduction In today’s world, data is considered the new gold. Every enterprise is in a rush to gather as much data as possible. Data is being monetized and taken care of more than ever. Enterprises are working hard to make sure they can capture …

Query control made easy

Publié le 7 janvier 2022 sur sqlservercentral.com
 

Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It’s a hard problem, and there is no single solution, other than a defense in depth. Let’s look at one of those defenses for databases: query cont …

Analyze Live Salesforce Data in Infragistics Reveal 

Publié le 7 janvier 2022 sur sqlservercentral.com
 

Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combi …

Using Flyway Teams with SQL Change Automation PowerShell Cmdlets

Publié le 7 janvier 2022 sur sqlservercentral.com
 

The post Using Flyway Teams with SQL Change Automation PowerShell Cmdlets appeared first on SQLServerCentral.

Azure Policies and Management Groups

Publié le 7 janvier 2022 sur sqlservercentral.com
 

The post Azure Policies and Management Groups appeared first on SQLServerCentral.


Pages :