Sites anglophones


How to Log Active Queries with sp_BlitzWho

Publié le 3 décembre 2018 sur brentozar.com
 

Queries are running when you’re not around. They’re wreaking havoc – maybe they’re filling up your TempDB, or causing blocking, or flushing your buffer pool out. When I wanna see what queries are running, I run sp_BlitzWho: That …

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

Publié le 3 décembre 2018 sur sqlservercentral.com
 

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.

Cost estimation for SQL Server Azure VMs

Publié le 3 décembre 2018 sur sqlservercentral.com
 

This article provides pricing guidance for SQL Server virtual machines in Azure.

Monitoring Changes in Permissions, Users, Roles and Logins

Publié le 3 décembre 2018 sur sqlservercentral.com
 

Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be at …

SQL SERVER – Small Backup for Large Database

Publié le 3 décembre 2018 sur journey to sqlauthority
 

Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check. The issue was related to small backup for the large database and it was so much interesting I decided to s …

[Video] Office Hours 2018/11/28 (With Transcriptions)

Publié le 2 décembre 2018 sur brentozar.com
 

This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the future, what languages a DBA needs to learn, backup issues, measuring the overhead of transparent data encryptio …

How to Start Database in a Single User Mode? – Interview Question of the Week #202

Publié le 2 décembre 2018 sur journey to sqlauthority
 

Question: How to Start Database in a Single User Mode? Answer: We all needed one time or another time this particular help. Whenever there is a corruption or any issue with SQL Server where we need to stop access from external users/system. We hav …

What Is SQL Injection?

Publié le 1 décembre 2018 sur brentozar.com
 

Say we have a stored procedure that queries the Stack Overflow database. We have two separate parameters, @DisplayName and @Location, so folks can search for people by name, location, or both. For performance reasons, we decide to build dynamic SQL:CRE …

SQL SERVER – What is the Meaning of PREEMPTIVE_HTTP_EVENT_WAIT? How to Fix it?

Publié le 1 décembre 2018 sur journey to sqlauthority
 

While playing with my SQL Server in Azure VM, I faced an interesting issue.  I did some change in networking to avoid internet access by creating an outbound rule and then I started facing this issue. In this blog, I would explain one of the possi …

Updated First Responder Kit for November 2018: Get Into Sports Dummy

Publié le 30 novembre 2018 sur brentozar.com
 

COACH! I dunno, I just like this picture. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1786 – @dallyhorton made a good point: if we’re gonna warn you about Change Tracking, we should te …

A Basic Technique for Masking Address Data using Data Masker

Publié le 30 novembre 2018 sur sqlservercentral.com
 

Grant Fritchey shows how to use Data Masker to obfuscate address data, wile ensuring that the masked data retains the characteristics and distribution of real address information.

SQL SERVER – Finding The Oldest Query Plan From Cache

Publié le 30 novembre 2018 sur journey to sqlauthority
 

Often people ask where do I come up with a new blog idea everyday. Well, answer is that I am not the one who comes up with new idea, it is all of you who inspire everyday with a new idea. Recently one of the healtch check client Comprehensive Data …

Power BI Introduction: Visualizing SQL Server Audit Data — Part 9

Publié le 29 novembre 2018 sur simple-talk.com
 

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …

There is a New COUNT in Town

Publié le 29 novembre 2018 sur simple-talk.com
 

We have all been using the COUNT(DISTINCT) function to return row counts for a distinct list of column values in a table for ages. With the introduction of SQL Server 2019, there is a new way to get an estimate of distinct row values and counts for a t …

Tales From Overindexing: Too Many One Column Indexes

Publié le 29 novembre 2018 sur brentozar.com
 

Master Plan Sometimes you see a query, and it’s hitting one table, and then the query plan looks like a vase full of spaghetti. Usually, there’s a view involved. Usually. Sometimes, there’s just really weird indexing. Here’s A T …


Pages :