Getting Started with Azure Purview
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
(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
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
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
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
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
The post Azure Data Factory Pipeline Logging Error Details appeared first on SQLServerCentral.
Win a Pluralsight subscription with Redgate’s competition
The post Win a Pluralsight subscription with Redgate’s competition appeared first on SQLServerCentral.
Key insights from the 2021 State of Database DevOps survey
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
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
The post Execute Dynamic SQL commands in SQL Server appeared first on SQLServerCentral.
Connect to SQL Server
The post Connect to SQL Server appeared first on SQLServerCentral.
Getting Started with Flyway and SQL Server
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.
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
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 …