How To Avoid MERGE in SQL Server
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
The post Adding Reports Users to SQL Monitor appeared first on SQLServerCentral.
Considerations for Deploying Azure SQL Database Managed Instances
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
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
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
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
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
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
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
The post SQL Server Disaster Recovery Options appeared first on SQLServerCentral.
Storage 101: Data Center Storage Configurations
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.
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
The post Working with SQL Cursors appeared first on SQLServerCentral.
[Video] How Can I Measure If My Database Does More Reads Than Writes?
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
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 …