Sites anglophones


Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019

Publié le 29 octobre 2020 sur sqlservercentral.com
 

The post Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019 appeared first on SQLServerCentral.

The Curious Case of… the aborted xdes map

Publié le 28 octobre 2020 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 …

Recovering Databases From a Master Backup

Publié le 27 octobre 2020 sur sqlservercentral.com
 

I ran into a very interesting thread recently, where a posted had experienced a disaster. In this case, they had a SAN failure, where they lost a number of instances. There were backups of the master databases, but not backups of all the user databases …

Why database folks should care about User Research

Publié le 27 octobre 2020 sur simple-talk.com
 

I attended a training session at Redgate this week by Chris Spalton. Chris’ session topic was “An Introduction into Planning User Research.” Chris pointed out that there’s much more to User Research, but that planning the resear …

Execute SSIS Package from PowerShell – Part 1

Publié le 27 octobre 2020 sur sqlservercentral.com
 

The post Execute SSIS Package from PowerShell – Part 1 appeared first on SQLServerCentral.

SQL Server Backup Types

Publié le 26 octobre 2020 sur simple-talk.com
 

The most important task for a DBA to know is to be able to recover a database in the event of a database corruption issue. Corrupted databases can happen for lots of reasons, like hardware failures, power failures, incorrect shutdown of a server, faile …

How to Learn SQL Server in One Year

Publié le 26 octobre 2020 sur brentozar.com
 

You’ve been using Microsoft SQL Server for a few years, and it’s becoming increasingly important to your job. You can write a query, but… You feel like something’s missing. You attended a few local user groups or meetups before …

Let’s move: Azure Resource Mover

Publié le 26 octobre 2020 sur sqlservercentral.com
 

The post Let’s move: Azure Resource Mover appeared first on SQLServerCentral.

Better SQL Server Agent Job Failure Monitoring

Publié le 26 octobre 2020 sur sqlservercentral.com
 

SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t very useful. You’re only told which job, what time, who ran it, and which step failed. If you want to see why it failed, you have to …

New Music Friday: Killa DBA’s New Release Just Dropped

Publié le 23 octobre 2020 sur brentozar.com
 

Familiar readers will know that I don’t actually do New Music Friday here very often. Okay, ever. I don’t do it ever. Because frankly, nobody writes music about us. Nobody except Homer McEwen, aka Killa DBA (YouTube – @KillaDBA). You …

Monitoring Amazon RDS with Redgate SQL Monitor

Publié le 23 octobre 2020 sur sqlservercentral.com
 

The post Monitoring Amazon RDS with Redgate SQL Monitor appeared first on SQLServerCentral.

Azure Data Factory Pipelines: Filling in the gaps

Publié le 23 octobre 2020 sur sqlservercentral.com
 

The post Azure Data Factory Pipelines: Filling in the gaps appeared first on SQLServerCentral.

Welcome to Redgate Deploy and Cross-platform Database DevOps

Publié le 22 octobre 2020 sur sqlservercentral.com
 

The post Welcome to Redgate Deploy and Cross-platform Database DevOps appeared first on SQLServerCentral.

Make SQL Server Agent Jobs HADR Aware

Publié le 22 octobre 2020 sur sqlservercentral.com
 

Introduction Always On Availability Groups (AGs/AG) provides a fairly convenient and reliable High-Availability Disaster Recovery (« HADR ») solution. Each database is configured to provide a fail-over solution using multiple servers running Windows Clus …

If Your Trigger Uses UPDATE(), It’s Probably Broken.

Publié le 21 octobre 2020 sur brentozar.com
 

In yesterday’s blog post about using triggers to replace computed columns, a lively debate ensued in the comments. A reader posted a trigger that I should use, and I pointed out that their trigger had a bug – and then lots of users replied …


Pages :