Sites anglophones


Query Optimizer Suggests Wrong Index and Query Plan — Why?

Publié le 25 février 2021 sur sqlservercentral.com
 

As I was preparing my presentation for the C# Corner SQL Server Virtual Conference, I came across (accidentally) a query plan that was unexpected. This plan had a suggested index that unfortunately supported that very unusual query plan. This article i …

Comparing and Syncing Data using SQL Data Compare Command Line

Publié le 24 février 2021 sur sqlservercentral.com
 

The post Comparing and Syncing Data using SQL Data Compare Command Line appeared first on SQLServerCentral.

Learning SQL Server

Publié le 24 février 2021 sur sqlservercentral.com
 

The post Learning SQL Server appeared first on SQLServerCentral.

Jonathan’s ten year anniversary!

Publié le 23 février 2021 sur sqlskills.com - paul randall
 

Ten years ago today we announced that we were hiring our first employee: Jonathan Kehayias. It was a big risk for Kimberly and I, as rather than partnering with other consultants, we suddenly became responsible for another full-time salary, no matter h …

New SQL ConstantCare® Feature: One Serious Query to Tune

Publié le 23 février 2021 sur brentozar.com
 

Our monitoring tool, SQL ConstantCare®, is different. Some monitoring tools send you a whole bunch of emails for every little thing that’s happening on every one of your server – and having you end up just creating an Outlook rule to du …

Minimal Downtime Storage Migration of Large Databases

Publié le 23 février 2021 sur sqlservercentral.com
 

The Problem The performance and stability of the storage layer is extremely critical for large databases, especially when the data size has grown to terabytes. When there is a shared storage among multiple servers, the storage layer can be up …

Bitten by SSD Bit Rot

Publié le 22 février 2021 sur sqlskills - jonathan kehayas
 

Back in 2012, I wrote a post titled Looking at External Disk Performance using USB 3.0 and eSATA with SSD, where I tested a number of external drive caddy’s with SSD’s that I had replaced and just had sitting around. Ultimately I started to …

A data transformation problem in SQL and Scala: Dovetailing declarative solutions

Publié le 22 février 2021 sur simple-talk.com
 

Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a software problem. The software to be built must transform data in an operating system file. Would it make sense to include SQL Server in the deve …

SQL Server authentication methods, logins, and database users

Publié le 22 février 2021 sur simple-talk.com
 

Setting up and managing SQL Server security is an important part of building and maintaining your SQL Server environment. SQL Server security is a vast topic that cannot be covered in a single article. This article starts with a few foundation topics o …

Updated First Responder Kit and Consultant Toolkit for February 2021

Publié le 22 février 2021 sur brentozar.com
 

Along with the usual bug fixes & improvements, this month’s release includes a brand new sp_BlitzAnalysis script from Adrian Buckman. It’s for folks who have an Agent job to log sp_BlitzFirst to tables every 15 minutes, saving wait stat …

Securing SQL Server with DoD guidelines

Publié le 22 février 2021 sur sqlservercentral.com
 

The post Securing SQL Server with DoD guidelines appeared first on SQLServerCentral.

Implementation of Normalization in SQL Server

Publié le 22 février 2021 sur sqlservercentral.com
 

Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal for …

Resolve Git Merge Conflict for SSIS Projects

Publié le 22 février 2021 sur sqlservercentral.com
 

The post Resolve Git Merge Conflict for SSIS Projects appeared first on SQLServerCentral.

How to Trace a Nested Stored Procedure Without Using Profiler

Publié le 18 février 2021 sur brentozar.com
 

You’ve got a stored procedure that calls other stored procedures that build dynamic SQL that call other functions, and there’s so much calling going on that you would like to phone a friend. Your query plans look like piles of spaghetti, an …

Getting Started with Azure Purview

Publié le 18 février 2021 sur sqlservercentral.com
 

Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data gover …


Pages :