Sites anglophones


Flyway with MariaDB for Those of a Nervous Disposition

Publié le 27 décembre 2021 sur sqlservercentral.com
 

The post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral.

Views in SQL Server 2019 with SSMS

Publié le 27 décembre 2021 sur sqlservercentral.com
 

In SQL Server, a view is a virtual table with contents that you define by means of a query. The structure of a view is similar to a table. The contents of a view comprise a set of named columns and rows of data, that are generated dynamically whenever …

CData Connect: Derived Views and Query Federation

Publié le 24 décembre 2021 sur sqlservercentral.com
 

Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through vi …

Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow

Publié le 24 décembre 2021 sur sqlservercentral.com
 

The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral.

Bulk Loading Data via a PowerShell Script in Flyway

Publié le 24 décembre 2021 sur sqlservercentral.com
 

The post Bulk Loading Data via a PowerShell Script in Flyway appeared first on SQLServerCentral.

The SQL Server Posts You Read the Most in 2021

Publié le 23 décembre 2021 sur brentozar.com
 

I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to b …

[Video] Office Hours: SQL Server at Sunset

Publié le 22 décembre 2021 sur brentozar.com
 

Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: https://youtu.be/hwRAwhcgCGU Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How t …

Unity state machine behaviours

Publié le 22 décembre 2021 sur sqlservercentral.com
 

The post Unity state machine behaviours appeared first on SQLServerCentral.

Adding Test Data to Databases During Flyway Migrations

Publié le 22 décembre 2021 sur sqlservercentral.com
 

The post Adding Test Data to Databases During Flyway Migrations appeared first on SQLServerCentral.

Check Your SQL Server Backup Performance & Safety with sp_BlitzBackups

Publié le 21 décembre 2021 sur brentozar.com
 

Out of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you’ve used the least. Let’s talk about what comes out of it, and why you should use it more often. First, let’s define two terms: Recovery …

Why cloud and hybrid estates are important – but bring complexity

Publié le 20 décembre 2021 sur sqlservercentral.com
 

The post Why cloud and hybrid estates are important – but bring complexity appeared first on SQLServerCentral.

Is SQL Server Profiler in Azure Data Studio?

Publié le 20 décembre 2021 sur sqlservercentral.com
 

Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS and Azure Data Studio. Now we will compare the new SQL Profiler against the old one. If you check the SQL Server Profiler documentation, you will fin …

Working with PowerShell strings

Publié le 20 décembre 2021 sur sqlservercentral.com
 

The post Working with PowerShell strings appeared first on SQLServerCentral.

Performance Tuning Using Free Tools

Publié le 17 décembre 2021 sur sqlservercentral.com
 

Do you frequently upgrade your on-premises hardware in order to keep a certain level of performance? Are your Azure SQL bills bigger than you expected? Are your databases wasting money through inefficiency? You can keep expenses under control by improv …

Did you know SQL Monitor supports Azure databases, too?

Publié le 17 décembre 2021 sur sqlservercentral.com
 

The post Did you know SQL Monitor supports Azure databases, too? appeared first on SQLServerCentral.


Pages :