Sites anglophones


SQL Server REPLACE

Publié le 28 décembre 2020 sur sqlservercentral.com
 

The post SQL Server REPLACE appeared first on SQLServerCentral.

Migrate the SSIS Catalog in Just a Few Clicks

Publié le 28 décembre 2020 sur sqlservercentral.com
 

From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS, called the project deployment model. This new model has many benefits in terms of managing SSIS project deployments, executions, and configurations. With every new versi …

Stored Procedure in SQL Server with R Code

Publié le 25 décembre 2020 sur sqlservercentral.com
 

The post Stored Procedure in SQL Server with R Code appeared first on SQLServerCentral.

Database Build Blockers: Four-part Object References

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

The post Database Build Blockers: Four-part Object References appeared first on SQLServerCentral.

[Video] Office Hours: SQL Server Career Q&A, Part 2

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

Last week, I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here’s the next video with the questions you upvoted the most, and I’ll post the last round of ’ …

Execute SSIS Package with SQLCMD and Parameters

Publié le 23 décembre 2020 sur sqlservercentral.com
 

The post Execute SSIS Package with SQLCMD and Parameters appeared first on SQLServerCentral.

Sharing SQL Code Snippets with Coworkers, The World and Yourself

Publié le 23 décembre 2020 sur sqlservercentral.com
 

The post Sharing SQL Code Snippets with Coworkers, The World and Yourself appeared first on SQLServerCentral.

How to Batch Updates A Few Thousand Rows at a Time

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

You’ve got a staging table with millions of rows, and you want to join that over to a production table and update the contents. However, when you try to do it all in one big statement, you end up with lock escalation, large transaction log usage, …

How To Install SSAS 2019

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

The post How To Install SSAS 2019 appeared first on SQLServerCentral.

Scheduling SQL Scripts Using Jenkins

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

Introduction There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, like when you use SQL Server Express edition. Mostly, the DBAs in this case is will choose to use the Windows task scheduler. However, Je …

The case for SQL Server Agent 2.0

Publié le 21 décembre 2020 sur sqlservercentral.com
 

Introduction SQL Server Agent enables the ease of scheduling routine tasks without leaving the comfort zone of SQL Server Management Studio (SSMS). This system stores all its related data in the msdb database. This article is going to discuss the need …

Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates

Publié le 21 décembre 2020 sur sqlservercentral.com
 

The post Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates appeared first on SQLServerCentral.

How to Configure Amazon RDS SQL Server for Windows Authentication

Publié le 18 décembre 2020 sur sqlservercentral.com
 

The post How to Configure Amazon RDS SQL Server for Windows Authentication appeared first on SQLServerCentral.

Whitepaper: Enabling fast and easy database migrations with Flyway

Publié le 18 décembre 2020 sur sqlservercentral.com
 

The post Whitepaper: Enabling fast and easy database migrations with Flyway appeared first on SQLServerCentral.

The End of the Professional Association for SQL Server #SQLPASS

Publié le 17 décembre 2020 sur brentozar.com
 

This afternoon, PASS announced that their operations will cease in January: We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular operations, effective January 15, 2021. We encourage you to take full advantage of …


Pages :