Sites anglophones


Simple Credential Management for DevOps Database Release to Azure SQL Database

Publié le 25 novembre 2020 sur sqlservercentral.com
 

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

Publié le 25 novembre 2020 sur brentozar.com
 

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

Publié le 25 novembre 2020 sur sqlservercentral.com
 

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

Publié le 24 novembre 2020 sur brentozar.com
 

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

Publié le 24 novembre 2020 sur sqlservercentral.com
 

The post Learn about Version Control with Redgate University appeared first on SQLServerCentral.

Fixing « Login failed for user » error in SQL Server

Publié le 24 novembre 2020 sur sqlservercentral.com
 

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

Publié le 24 novembre 2020 sur sqlservercentral.com
 

The post Check Windows Services Status with T-SQL appeared first on SQLServerCentral.

Developing a backup plan

Publié le 23 novembre 2020 sur simple-talk.com
 

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

Publié le 23 novembre 2020 sur brentozar.com
 

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

Publié le 23 novembre 2020 sur sqlservercentral.com
 

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

Publié le 23 novembre 2020 sur sqlservercentral.com
 

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

Publié le 23 novembre 2020 sur sqlservercentral.com
 

The post Visualizing Azure Resource Metrics Data in Power BI appeared first on SQLServerCentral.

What It Takes To Write Two Blog Posts

Publié le 20 novembre 2020 sur brentozar.com
 

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 …

Normal Forms

Publié le 20 novembre 2020 sur simple-talk.com
 

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

Publié le 20 novembre 2020 sur sqlservercentral.com
 

The post Managing Cross-Database Object References appeared first on SQLServerCentral.


Pages :