Format your own SQL code using this free online formatter
The post Format your own SQL code using this free online formatter appeared first on SQLServerCentral.
10 DevOps strategies for working with legacy databases
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
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
The post Create a Feedback Loop between Devs and DBA Teams with Monitoring appeared first on SQLServerCentral.
Setting Rows to Odd and Even Values
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
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
(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
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
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
The post Execute SSIS Package from PowerShell – Part 1 appeared first on SQLServerCentral.
SQL Server Backup Types
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
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
The post Let’s move: Azure Resource Mover appeared first on SQLServerCentral.
Better SQL Server Agent Job Failure Monitoring
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
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 …