Sites anglophones


Take the 2020 State of Database Monitoring Survey

Publié le 16 avril 2020 sur sqlservercentral.com
 

The post Take the 2020 State of Database Monitoring Survey appeared first on SQLServerCentral.

Free Training Week: How I Use the First Responder Kit – sp_BlitzCache

Publié le 15 avril 2020 sur brentozar.com
 

This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst. Today, we’re using sp_BlitzCach …

Advanced Performance Tuning for Microsoft SQL Server

Publié le 15 avril 2020 sur sqlservercentral.com
 

The post Advanced Performance Tuning for Microsoft SQL Server appeared first on SQLServerCentral.

Codd’s Twelve Rules

Publié le 14 avril 2020 sur simple-talk.com
 

Let me take you back to those thrilling days of yesteryear when the relational model and relational databases were the fads that all hip kids were getting into. Yes, we have fads in IT. Sometimes it’s a new programming language that will solve al …

Free Training Week: How I Use the First Responder Kit – sp_BlitzFirst (1h41m)

Publié le 14 avril 2020 sur brentozar.com
 

This week, I’m giving away modules from my How I Use the First Responder Kit class. Yesterday, we covered sp_Blitz, and today, we’re doing a server-wide performance checkup with sp_BlitzFirst. If you bookmark these posts for later read …

How To Avoid MERGE in SQL Server

Publié le 14 avril 2020 sur sqlservercentral.com
 

Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you’re merging a pair of tables with hundreds of columns, since the script doesn’t know anything about them. This technique …

Adding Reports Users to SQL Monitor

Publié le 14 avril 2020 sur sqlservercentral.com
 

The post Adding Reports Users to SQL Monitor appeared first on SQLServerCentral.

Considerations for Deploying Azure SQL Database Managed Instances

Publié le 14 avril 2020 sur sqlservercentral.com
 

The post Considerations for Deploying Azure SQL Database Managed Instances appeared first on SQLServerCentral.

Free Training Week: How I Use the First Responder Kit – sp_Blitz

Publié le 13 avril 2020 sur brentozar.com
 

During the quarantines, I’m giving away all kinds of free training. Last month, I gave you the recordings of my Fundamentals of Index Tuning and Fundamentals of Query Tuning classes, and then last week, we even got together and did those classes …

Getting Started with SQL Data Masker: I Need to Mask some Columns

Publié le 13 avril 2020 sur sqlservercentral.com
 

The post Getting Started with SQL Data Masker: I Need to Mask some Columns appeared first on SQLServerCentral.

Perform Data Filtering in Oracle Link to SQL Server

Publié le 13 avril 2020 sur sqlservercentral.com
 

In SQL Server, it’s easy to set up a linked server to Oracle and get data from there. You only need a UserID and a Password. If you need to filter a lot of data, it’s recommended to do the filtering where the biggest amount of data resides, …

Help us define the State of Database Monitoring in 2020

Publié le 10 avril 2020 sur sqlservercentral.com
 

The post Help us define the State of Database Monitoring in 2020 appeared first on SQLServerCentral.

Upgrading My Training Game Again: My Home Office Studio Setup: Spring 2020

Publié le 9 avril 2020 sur brentozar.com
 

When I last blogged about my home office setup in December, I’d just invested in a new massive beast of a desktop: a Mac Pro with a 16 cores, 96GB RAM, and a AMD Radeon Pro Vega II 32GB. Now it’s time to put that horsepower to work. In the …

Implementing Reporting Application Enhancements with No Downtime

Publié le 9 avril 2020 sur sqlservercentral.com
 

Abstract The purpose of this article is to detail steps that would help implement an enhancement to a reporting application that uses a SQL Server database (or any other database) as the back end without causing any downtime for the reporting applicati …

SQL Server Disaster Recovery Options

Publié le 9 avril 2020 sur sqlservercentral.com
 

The post SQL Server Disaster Recovery Options appeared first on SQLServerCentral.


Pages :