Sites anglophones


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.

Storage 101: Data Center Storage Configurations

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

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

Want SQL Server Training? Copy/Paste This Email To Your Boss.

Publié le 8 avril 2020 sur brentozar.com
 

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Sa …

Working with SQL Cursors

Publié le 8 avril 2020 sur sqlservercentral.com
 

The post Working with SQL Cursors appeared first on SQLServerCentral.

[Video] How Can I Measure If My Database Does More Reads Than Writes?

Publié le 7 avril 2020 sur brentozar.com
 

When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users run a lot of …

Iterating Over Calculated Tables using Power Query

Publié le 7 avril 2020 sur sqlservercentral.com
 

Problem Many of us are already aware of the looping methodologies in a programming language and their benefits. Looping helps us iterate over a set of items over and over again to obtain a final result. In this article, I’m going to demonstrate how to …


Pages :