Sites anglophones


What DBAs Need to Know About Snapshots

Publié le 21 avril 2022 sur brentozar.com
 

Snapshots by Polaroid? That’s not right.You’re a DBA responsible for making sure SQL Server databases are online, backed up, corruption-free, and fast. Your databases have gradually grown in size over time, and you’re starting to hit …

CASE STUDY: The hybrid monitoring needs of a fast-growing global business

Publié le 20 avril 2022 sur sqlservercentral.com
 

The post CASE STUDY: The hybrid monitoring needs of a fast-growing global business appeared first on SQLServerCentral.

How to get length of Text, NText and Image columns in SQL Server

Publié le 20 avril 2022 sur sqlservercentral.com
 

The post How to get length of Text, NText and Image columns in SQL Server appeared first on SQLServerCentral.

SQL Server Graph Tables – Cross Database Surprises

Publié le 18 avril 2022 sur sqlservercentral.com
 

The post SQL Server Graph Tables – Cross Database Surprises appeared first on SQLServerCentral.

Webinar | Kick start your DevOps Initiative

Publié le 18 avril 2022 sur sqlservercentral.com
 

The post Webinar | Kick start your DevOps Initiative appeared first on SQLServerCentral.

Flyway Gotchas

Publié le 15 avril 2022 sur sqlservercentral.com
 

The post Flyway Gotchas appeared first on SQLServerCentral.

An Introduction to Flowlets in Azure Data Factory

Publié le 15 avril 2022 sur sqlservercentral.com
 

Introduction Flowlets is a new feature of Mapping data flows introduced in Azure Data Factory and Azure Synapse Analytics. Flowlets can be used to extract portions of an existing data flow and save them as separate « Flowlet » objects inside your data fa …

Tips and tricks with DAX table functions in paginated reports

Publié le 15 avril 2022 sur sqlservercentral.com
 

The post Tips and tricks with DAX table functions in paginated reports appeared first on SQLServerCentral.

[Video] Office Hours: Last San Diego Balcony Edition

Publié le 14 avril 2022 sur brentozar.com
 

It’s the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you’d like to see. Here’s what we covered this week: 00:00 Introductions 00:50 Steve E: Hi Bren …

What Do the LCK_M_SCH_M and LCK_M_IS Wait Types Indicate?

Publié le 13 avril 2022 sur brentozar.com
 

You’re investigating your SQL Server’s top wait stats, and you’re noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you’re just not getting complaints from your end users, and you’re wonder …

How to create a table using SQL Server Management Studio

Publié le 13 avril 2022 sur sqlservercentral.com
 

The post How to create a table using SQL Server Management Studio appeared first on SQLServerCentral.

ICYMI: Dealing with Database Data and Metadata in Flyway Developments

Publié le 13 avril 2022 sur sqlservercentral.com
 

The post ICYMI: Dealing with Database Data and Metadata in Flyway Developments appeared first on SQLServerCentral.

The Curious Case of… eager writing and minimally-logged operations

Publié le 12 avril 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 …

Updated First Responder Kit and Consultant Toolkit for April 2022

Publié le 12 avril 2022 sur brentozar.com
 

Wow, talk about stable! The last 3 months have only introduced a series of small bug fixes. I held this release back as long as I could, waiting to see if anything major might get added or if we might get a SQL Server 2022 CTP, but no dice. If there wa …

 

Compressed Backup and Performance – SQL in Sixty Seconds #196

Publié le 12 avril 2022 sur journey to sqlauthority
 

During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. I have blogged about this here: SQL SERVER – Sample Script for Compressed and Uncompr …

 


Pages :