Simple Credential Management for DevOps Database Release to Azure SQL Database
In working with Azure DevOps, one of the challenges is to ensure that our processes can connect to systems, but not unnecessarily disclose credentials. While performing deployments with an automated process, we often allow many people to access and cha …
How to Set & Get the Next ID Without Serializable Isolation
Say for some reason you can’t use identity columns or sequences, or maybe your application was built a long, long time ago – and you’ve got a table with a list of IDs to use next:DROP TABLE IF EXISTS dbo.Ids; CREATE TABLE dbo.Ids (Tab …
SQL Snippets Galore, Added to SQL Prompt
The post SQL Snippets Galore, Added to SQL Prompt appeared first on SQLServerCentral.
How to Insert Rows and Get Their Identity Values with the OUTPUT Clause
Say you’ve got a two-step process where you’re: Inserting rows into a table that has an identity column, then Querying that table to figure out what identities you got There’s a a faster way that doesn’t require hitting the tabl …
Learn about Version Control with Redgate University
The post Learn about Version Control with Redgate University appeared first on SQLServerCentral.
Fixing « Login failed for user » error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is « Login failed for user ‘DomainNameServerName$’. Reason: Could not find a login match …
Check Windows Services Status with T-SQL
The post Check Windows Services Status with T-SQL appeared first on SQLServerCentral.
Developing a backup plan
The most important task for a DBA is to be able to recover a database in the event of a database becoming corrupted. Corrupted databases can happen for many different reasons. The most common corruption problem is from a programming error. But database …
Finding the One Query to Tune in a Multi-Query Batch
When you have a stored procedure or application query that has multiple queries inside of it, how can you tell which query to focus on? For starters, do NOT believe the percentages you see in execution plans. Let’s take a classic performance tuni …
Get involved in the 2021 State of Database DevOps survey
The post Get involved in the 2021 State of Database DevOps survey appeared first on SQLServerCentral.
Getting Informative SQL Agent Notifications from Failed SSIS Packages
Introduction The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter the MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS …
Visualizing Azure Resource Metrics Data in Power BI
The post Visualizing Azure Resource Metrics Data in Power BI appeared first on SQLServerCentral.
What It Takes To Write Two Blog Posts
This week, I published two blog posts: How Bad Statistics Cause Bad SQL Server Query Performance How Scalar User-Defined Functions Slow Down Queries Let’s talk about the process of writing ’em. A couple I was putting together this week …
Everyone gives lip service to normalized databases. But the truth is that normalization is a lot more complicated than most people know. First of all, I’ll bet almost no one reading this article (including me!) could name and define all of the cu …
Managing Cross-Database Object References
The post Managing Cross-Database Object References appeared first on SQLServerCentral.