Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking
The post Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking appeared first on SQLServerCentral.
Why your PL/SQL needs to be testable – and how to do it: Part 1
The post Why your PL/SQL needs to be testable – and how to do it: Part 1 appeared first on SQLServerCentral.
Office Hours, Text Edition: No-Brainer Questions
Not all questions require a video answer. Here are some simple no-brainer ones: Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it? A: They don’t make …
[Video] Office Hours: New Las Vegas Home Office Edition
It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrat …
Understanding the Mapping Data Flow Activity in Azure Data Factory
Azure Data Factory is used for ELT (Extract, Load, Transform) operations in Azure. We do have multiple activities to move data from source and destination. However, we cannot do many data transformations using the general activities of Azure Data Facto …
The 10 Benefits of Monitoring for Leaders
The post The 10 Benefits of Monitoring for Leaders appeared first on SQLServerCentral.
Understanding SQL Server Linked Servers
The post Understanding SQL Server Linked Servers appeared first on SQLServerCentral.
DAX in Power BI Tutorial
Introduction This time we will provide an introduction to DAX in Power BI. Everybody loves Power BI. It is intuitive, easy to understand, a very cool UI. However, some people feel scared about DAX. In many reports, you can skip the use of DAX, however, …
Getting an Overview of Changes to a PostgreSQL Database using Flyway
The post Getting an Overview of Changes to a PostgreSQL Database using Flyway appeared first on SQLServerCentral.
Site Reliability Engineering vs. DevOps
The post Site Reliability Engineering vs. DevOps appeared first on SQLServerCentral.
What DBAs Need to Know About Snapshots
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
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
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
The post SQL Server Graph Tables – Cross Database Surprises appeared first on SQLServerCentral.
Webinar | Kick start your DevOps Initiative
The post Webinar | Kick start your DevOps Initiative appeared first on SQLServerCentral.