Sites anglophones


A Quick Diff Checker for SQL Server Databases

Publié le 2 juillet 2021 sur sqlservercentral.com
 

The post A Quick Diff Checker for SQL Server Databases appeared first on SQLServerCentral.

Store Files in a File System, Not a Relational Database.

Publié le 1 juillet 2021 sur brentozar.com
 

Since the dawn of time, database vendors have called out to developers, “Store everything inside the database. You know you want to. Here, we’ll make it easy for you by adding data types like binary and features like filestream.” Ah, …

Testing Flyway Migrations Using Transactions

Publié le 30 juin 2021 sur sqlservercentral.com
 

The post Testing Flyway Migrations Using Transactions appeared first on SQLServerCentral.

Lock Escalation Sucks on Columnstore Indexes.

Publié le 29 juin 2021 sur brentozar.com
 

If you’ve got a regular rowstore table and you need to modify thousands of rows, you can use the fast ordered delete technique to delete rows in batches without hitting the lock escalation threshold. That’s great for rowstore indexes, but …

Learn Fundamentals of Columnstore for $1.

Publié le 28 juin 2021 sur brentozar.com
 

Last week, I gave you a 1-week, $1 deadline, and 777 of you took me up on it. That’s awesome! I love having fun with stuff like this. Let’s do it again! You’ve got 1 week to learn the Fundamentals of Columnstore for $1, and sales clos …

Creating and Maintaining a SQL Code Snippet Library

Publié le 28 juin 2021 sur sqlservercentral.com
 

The post Creating and Maintaining a SQL Code Snippet Library appeared first on SQLServerCentral.

Getting Started with Azure Purview for Data Governance

Publié le 28 juin 2021 sur sqlservercentral.com
 

The post Getting Started with Azure Purview for Data Governance appeared first on SQLServerCentral.

Running SQL Clone on an Azure VM with Azure File Storage

Publié le 25 juin 2021 sur sqlservercentral.com
 

The post Running SQL Clone on an Azure VM with Azure File Storage appeared first on SQLServerCentral.

Opening JSON Data with T-SQL

Publié le 25 juin 2021 sur sqlservercentral.com
 

The post Opening JSON Data with T-SQL appeared first on SQLServerCentral.

Free Video: 500-Level Guide to Career Internals: Building a Brand

Publié le 24 juin 2021 sur brentozar.com
 

Last week, I shared my 300-Level Guide to Career Internals post & video. We talked about how the world is changing so quickly, and how it’s a great time to adapt your career to accomplish the things in life that are important to you. One of t …

Who is responsible for building tests?

Publié le 23 juin 2021 sur sqlservercentral.com
 

The post Who is responsible for building tests? appeared first on SQLServerCentral.

Notify Users of Power BI Dataset Changes

Publié le 23 juin 2021 sur sqlservercentral.com
 

The post Notify Users of Power BI Dataset Changes appeared first on SQLServerCentral.

Adding Managed Instances to SQL Server Distributed Availability Groups

Publié le 22 juin 2021 sur brentozar.com
 

SQL Server Always On Availability Groups help you build a more highly available database server by spanning your database across two or more SQL Server instances. When the primary goes down, the secondary can take over. You can also scale out reads to …

Stop Planning a Backup Strategy

Publié le 21 juin 2021 sur sqlskills - jonathan kehayas
 

I feel like I have had this discussion multiple times over the last few months with clients, so I decided to turn those discussions into a blog post. One of the things we often get asked about is how to plan a backup strategy, and my routine answer is …

Learn Fundamentals of Index Tuning for $1.

Publié le 21 juin 2021 sur brentozar.com
 

You’re lazy and overconfident. You’ve been reading this blog for a while, and you’ve been telling yourself, “Yeah, I’m pretty good at this database thing. I’ve got years of experience under my belt. I know the fundam …


Pages :