Sites anglophones


Format your own SQL code using this free online formatter

Publié le 30 octobre 2020 sur sqlservercentral.com
 

The post Format your own SQL code using this free online formatter appeared first on SQLServerCentral.

10 DevOps strategies for working with legacy databases

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

Database teams often maintain large and complex legacy databases that they must keep operational to support existing applications. The teams might have maintained the databases for years, or they might have inherited them through acquisitions or other …

Unveiling the 2020 Black Friday Sale Lineup

Publié le 29 octobre 2020 sur brentozar.com
 

I love Black Friday sales. I would never normally just go buy a TV out of nowhere – unless mine was broken or something – but as Black Friday approaches, I find myself scanning all the upcoming ads, reading reviews, and comparing features. …

Create a Feedback Loop between Devs and DBA Teams with Monitoring

Publié le 29 octobre 2020 sur sqlservercentral.com
 

The post Create a Feedback Loop between Devs and DBA Teams with Monitoring appeared first on SQLServerCentral.

Setting Rows to Odd and Even Values

Publié le 29 octobre 2020 sur sqlservercentral.com
 

Problem In manufacturing, sometimes you need to do strange things, like cause certain parts to be interleaved when they run down the line. I recently ran across this problem at work and wanted to share my solution to this problem. In this example there …

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 …


Pages :