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.
The post SQL Server appeared first on SQLServerCentral.
SQL Developer – A great tool and better ways to use it
SQL Developer is a free tool provided by Oracle. It has a wide variety of options and utilities to help in day to day development or support activities. Some of the key features are discussed here to help navigate the tool and better understand it. Com …
When You’re Troubleshooting Blocking, Look at Query #2, Too.
When I’m troubleshooting a blocking emergency, the culprit is usually the query at the head of a blocking chain. Somebody did something ill-advised like starting a transaction and then locking a whole bunch of tables. But sometimes, the lead bloc …