Sites anglophones


[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 …

Frequently Asked Questions from Office Hours

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

In my Twitch & YouTube live streams, some questions seem to come up every week. I’m not expecting this post to stop ’em by any means – most folks on the live stream don’t seem to read the blog regularly – but I thought …

Join the Redgate Tool Tips Swap

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

The post Join the Redgate Tool Tips Swap appeared first on SQLServerCentral.

Using Azure Synapse Link for Azure Cosmos DB

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

Introduction In my previous article named An Introduction to Azure Synapse Analytics Workspace,I discussed the step-by-step process to create a Synapse workspace and how to use its components and features. Another article named An Introduction to …

SQL Server Error Log Configuration

Publié le 16 décembre 2020 sur simple-talk.com
 

Most applications have a log of some sort that tracks activity. SQL Server is no different. It has a log file known as the error log for tracking what’s happening on an instance of SQL Server. Server. Each instance of SQL Server has its own set o …


Pages :