Sites anglophones


SQL Server Database Deployment: What Could Go Wrong?

Publié le 4 mai 2020 sur sqlservercentral.com
 

The post SQL Server Database Deployment: What Could Go Wrong? appeared first on SQLServerCentral.

Configuring Database Alerts for Azure SQL Database

Publié le 4 mai 2020 sur sqlservercentral.com
 

This article will help us to understand how to monitor Azure SQL Database and set up Azure metric alerts. Even though the database in Azure SQL Database is fully managed by Microsoft, we are still responsible for proper database access and performance. …

Free Webcast on Dynamic SQL Pro Tips

Publié le 1 mai 2020 sur brentozar.com
 

Dynamic SQL is one of the most powerful tools in the database developer’s arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by lev …

Troubleshooting Performance in Azure SQL Database

Publié le 1 mai 2020 sur SQLSkills.com - Erin Stellato
 

At some point, whether you’re a DBA, developer, or application administrator, you’re going to find yourself troubleshooting performance in Azure.  Within the Azure Portal you have the capability to look at performance for an Azure SQL …

Export SQL Server Tables to Excel

Publié le 1 mai 2020 sur sqlservercentral.com
 

The post Export SQL Server Tables to Excel appeared first on SQLServerCentral.

Can You Use NVARCHAR As a Universal Parameter? Almost.

Publié le 30 avril 2020 sur brentozar.com
 

A perfect storm of unusual problems caused a client to ask, “What if we just used NVARCHAR(4000) as the default datatype parameter for any query, regardless of what datatype the table has in it – like numbers or dates?” It actually wo …

DAX for SQL Folks: Part II – Translating SQL Queries to DAX Queries

Publié le 30 avril 2020 sur sqlservercentral.com
 

Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning ex …

Right-Sizing Row Mode Query Memory Requirements

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

In older versions of SQL Server (prior to SQL Server 2019, aka 15.x), SQL Server memory grant feedback supported was added, but only for batch mode queries. Queries that use batch mode performing scanning and calculations on up to 900 rows at a time, v …

Implementing a Data Quality Monitoring Framework

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

I. Introduction Data Quality is imperative to the success of any Business Intelligence solution. In today’s era, where the data is being ingested from multiple sources, the quality of the data might differ between sources. The first step to a suc …

If You Have Foreign Keys, Don’t Update Fields That Aren’t Changing.

Publié le 29 avril 2020 sur brentozar.com
 

If you update a row without actually changing its contents, does it still hurt? Paul White wrote in detail about the impact of non-updating updates, proving that SQL Server works hard to avoid doing extra work where it can. That’s a great post, a …

SQL Server 2019 New Performance Features

Publié le 29 avril 2020 sur sqlservercentral.com
 

The post SQL Server 2019 New Performance Features appeared first on SQLServerCentral.

Storage 101: Modern Storage Technologies

Publié le 28 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 …

Free Webcast Today: How to Measure Your SQL Server

Publié le 28 avril 2020 sur brentozar.com
 

If you get into a car, how do you know if the car is fast or not? You hold down the gas pedal, and you time how long it takes before you’re breakin’ the law. Now what about SQL Server: how do you know if yours is fast…or a clunker? D …

Your First Pipeline with Azure Data Factory

Publié le 28 avril 2020 sur sqlservercentral.com
 

If you’re new to Azure Data Factory (ADF), it can be difficult to know where to start. Even if you have some experience with SSIS, everything in ADF looks both familiar and different at the same time! In this article I step through creating a bas …

How to Get Better Estimates for Modification Queries

Publié le 27 avril 2020 sur brentozar.com
 

When you’re doing DUI operations against tables with millions of rows, you have to be really careful about SQL Server’s estimates. Ideally, you want your delete/update/insert (what – what’d you think I meant?) queries to be as s …


Pages :