Sites anglophones


Getting Started with Azure Purview

Publié le 18 février 2021 sur sqlservercentral.com
 

Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data gover …

Some thoughts on courage

Publié le 17 février 2021 sur sqlskills.com - paul randall
 

(This is also the Ponderings – editorial – in today’s SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed me or commented about depression, after the last newsletter/post. It definitely seem …

How to become a data scientist: A data-driven approach to careers in data science

Publié le 16 février 2021 sur simple-talk.com
 

Imagine a world without any data. Now imagine the extent of all the available data. Both are equally unimaginable. Every second of the day, petabytes of data are being produced. However, copious amounts of data, also known as big data, in and of itself …

Storage 101: RAID

Publié le 16 février 2021 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

Changing Statistics Cause Longer Compilation Times

Publié le 16 février 2021 sur brentozar.com
 

I need to be up front with you, dear reader, and tell you that you’re probably never going to need to know this. I try to blog about stuff people need to know to get their job done – things that will be genuinely useful in your day-to-day p …

The Dilemma of DBAs

Publié le 16 février 2021 sur sqlservercentral.com
 

The year of COVID19 pandemic, 5 of the DBAs in my company were let go. It came as a total surprise to me and others. There were couple of reasons for the shock. We were all supporting critical projects until the last day.   Anyway, we all wen …

Azure Data Factory Pipeline Logging Error Details

Publié le 16 février 2021 sur sqlservercentral.com
 

The post Azure Data Factory Pipeline Logging Error Details appeared first on SQLServerCentral.

Win a Pluralsight subscription with Redgate’s competition

Publié le 16 février 2021 sur sqlservercentral.com
 

The post Win a Pluralsight subscription with Redgate’s competition appeared first on SQLServerCentral.

Key insights from the 2021 State of Database DevOps survey

Publié le 15 février 2021 sur simple-talk.com
 

This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each year, the number of respondents increases, reaching 3,200 submissions this year. An interesting new topic to consider this year is …

What’s New & Undocumented in SQL Server 2019 Cumulative Update 9

Publié le 15 février 2021 sur brentozar.com
 

Last week’s SQL Server 2019 Cumulative Update 9 snuck in some undocumented things. We got two new DMVs for Always On Availability Groups, sys.dm_hadr_cached_replica_states and sys.dm_hadr_cached_database_replica_states. They have a subset of data …

Execute Dynamic SQL commands in SQL Server

Publié le 15 février 2021 sur sqlservercentral.com
 

The post Execute Dynamic SQL commands in SQL Server appeared first on SQLServerCentral.

Connect to SQL Server

Publié le 12 février 2021 sur sqlservercentral.com
 

The post Connect to SQL Server appeared first on SQLServerCentral.

Getting Started with Flyway and SQL Server

Publié le 12 février 2021 sur sqlservercentral.com
 

The post Getting Started with Flyway and SQL Server appeared first on SQLServerCentral.

Query Store is the Flight Data Recorder. It’s Obvious What We Need Next.

Publié le 11 février 2021 sur brentozar.com
 

When Microsoft brought out Query Store, they wrote: Similar to an airplane’s flight data recorder, Query Store collects and presents detailed historic information about all queries, greatly simplifying performance forensics by reducing the time t …

Syncing your SQL Server database backups to an AWS S3 bucket

Publié le 11 février 2021 sur sqlservercentral.com
 

Introduction « Sometimes » just having all the database backups in one place is not enough. In fact, most of the time, putting all the eggs in one basket is a bad idea. You want to have some piece of mind that during the time of crisis, all your database …


Pages :