Sites anglophones


Reducing the Frequency of SQL Server Central Newsletters

Publié le 26 avril 2021 sur sqlservercentral.com
 

We are reducing the frequency of SQL Server Central newsletters from 5 a week to 3 starting on May 3. We will send out our regular newsletter on Monday, Wednesday, and Friday to all subscribers. The Database Weekly newsletter will continue to come out …

SQL Server plan cache mining – Plan attributes

Publié le 26 avril 2021 sur simple-talk.com
 

The execution plan cache in SQL Server is a treasure trove of information about queries that have recently executed. In addition to query text and execution plan details, a wide variety of statistics, options, and parameters are available to research, …

Creating Database Build Artifacts when Running Flyway Migrations

Publié le 26 avril 2021 sur sqlservercentral.com
 

The post Creating Database Build Artifacts when Running Flyway Migrations appeared first on SQLServerCentral.

An Introduction to Azure Data Explorer

Publié le 26 avril 2021 sur sqlservercentral.com
 

Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past …

Learn basics of Data Wrangling in SQL Server to handle Invalid Values

Publié le 23 avril 2021 sur sqlservercentral.com
 

The post Learn basics of Data Wrangling in SQL Server to handle Invalid Values appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for April 2021

Publié le 22 avril 2021 sur brentozar.com
 

This month’s release has two gems for SQL Server 2019 users. First, thanks to Greg Dodd, when you’re dealing with parameter sniffing issues, sp_BlitzWho can now show you the cached and live parameters for running queries. This lets you quic …

Dynamically Add a Timestamp To Files in Azure Data Factory

Publié le 22 avril 2021 sur sqlservercentral.com
 

This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example …

Common Data Transformations in Power Query

Publié le 21 avril 2021 sur sqlservercentral.com
 

The post Common Data Transformations in Power Query appeared first on SQLServerCentral.

Batch Processing using Flyway

Publié le 21 avril 2021 sur sqlservercentral.com
 

The post Batch Processing using Flyway appeared first on SQLServerCentral.

Who’s Hiring in the Database Community? April 2021 Edition

Publié le 20 avril 2021 sur brentozar.com
 

I’ve gotten a lot of emails from friends lately who are looking for work. It seems that as some companies go back to the office, some people are realizing they want to work remotely forever. And on the flip side, other folks are realizing they de …

Installing Docker Desktop on Mac

Publié le 20 avril 2021 sur sqlservercentral.com
 

Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you reme …

Recover Deleted TDE Key for Azure SQL Database

Publié le 20 avril 2021 sur sqlservercentral.com
 

The post Recover Deleted TDE Key for Azure SQL Database appeared first on SQLServerCentral.

Free TempDB Training Class Next Monday

Publié le 19 avril 2021 sur brentozar.com
 

You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and …

Navigating Trees With CTE

Publié le 19 avril 2021 sur sqlservercentral.com
 

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any tw …

Tell us about how you monitor your databases

Publié le 19 avril 2021 sur sqlservercentral.com
 

The post Tell us about how you monitor your databases appeared first on SQLServerCentral.


Pages :