Sites anglophones


PowerShell editors and environments: Part 1

Publié le 3 mars 2021 sur sqlservercentral.com
 

The post PowerShell editors and environments: Part 1 appeared first on SQLServerCentral.

Create Calendar Table Using Power Query M Language

Publié le 3 mars 2021 sur sqlservercentral.com
 

The post Create Calendar Table Using Power Query M Language appeared first on SQLServerCentral.

#TSQL2sday 136 Invitation: Blog About Your Favorite Data Type (Or Least Favorite)

Publié le 2 mars 2021 sur brentozar.com
 

T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting this month’s episode. Your mission: write a blog post about your favorite data type, and schedule it for next Tuesday, March 9. Mad ab …

Monitor SQL Server Error Logs with PowerShell

Publié le 2 mars 2021 sur sqlservercentral.com
 

Introduction The Error Logs of your SQL instances often contain valuable information. Information that may require follow-up attention or an awareness of certain situations. Information such as backups failing, I/O problems, or failed login attempts. T …

Using Azure SQL Data Sync to Replicate Data

Publié le 2 mars 2021 sur sqlservercentral.com
 

The post Using Azure SQL Data Sync to Replicate Data appeared first on SQLServerCentral.

The Curious Case of… log generated during a DROP TABLE

Publié le 1 mars 2021 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Unlocking the “PASS Pro” Educational series

Publié le 1 mars 2021 sur sqlservercentral.com
 

The post Unlocking the “PASS Pro” Educational series appeared first on SQLServerCentral.

Microsoft Azure ADF – Dynamic Pipelines

Publié le 1 mars 2021 sur sqlservercentral.com
 

Azure Data Factory (ADF) is a cloud based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. Azure Data Factory does not store any data itself. b …

sqldf in R Example for SQL Server

Publié le 1 mars 2021 sur sqlservercentral.com
 

The post sqldf in R Example for SQL Server appeared first on SQLServerCentral.

Partitioned Tables Cause Longer Plan Compilation Times

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

The post Partitioned Tables Cause Longer Plan Compilation Times appeared first on SQLServerCentral.

Customizing Database Deployments using Flyway Callbacks and Placeholders

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

The post Customizing Database Deployments using Flyway Callbacks and Placeholders appeared first on SQLServerCentral.

Free Webcast: Planning a SQL Server to Azure Migration in 2021

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

You manage database servers for your company, and they’re thinking about migrating everything to Microsoft Azure. You’ve searched the web for information and advice, but everything you’re finding is outdated. You just want a list of t …

Ten tips for building a collaborative DevOps culture

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

The post Ten tips for building a collaborative DevOps culture appeared first on SQLServerCentral.

Query Optimizer Suggests Wrong Index and Query Plan — Why?

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

As I was preparing my presentation for the C# Corner SQL Server Virtual Conference, I came across (accidentally) a query plan that was unexpected. This plan had a suggested index that unfortunately supported that very unusual query plan. This article i …

Comparing and Syncing Data using SQL Data Compare Command Line

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

The post Comparing and Syncing Data using SQL Data Compare Command Line appeared first on SQLServerCentral.


Pages :