Sites anglophones

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

Publié le 30 novembre 2018 sur

COACH! I dunno, I just like this picture. You can download the updated 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

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

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

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

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 …

Meeting Preparation for SQL Server Projects

Publié le 29 novembre 2018 sur

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.

T-SQL Decommenter Part IV

Publié le 29 novembre 2018 sur

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edi …

SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)

Publié le 29 novembre 2018 sur journey to sqlauthority

Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see SQL Server Agent node in SQL Server Management St …

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

Publié le 28 novembre 2018 sur

When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic’s exc …

SQL Server on Amazon Web Services (AWS)

Publié le 28 novembre 2018 sur

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazo …

New Whitepaper: Data Protection and Compliance During Provisioning

Publié le 28 novembre 2018 sur

Data privacy and protection is a large concern across all organizations and knowing how to best approach it can be daunting. Grant Fritchey unpicks US legislations HIPAA and SOX to uncover exactly what is required of you and your team to ensure complia …

Are You Making the Right Cloud Storage Decisions for SQL Server tempdb?

Publié le 28 novembre 2018 sur

Here’s why selecting the right storage for SQL Server tempdb is critical, and how to determine what will work.

Data Privacy – Are Your Database Processes Fully Compliant?

Publié le 28 novembre 2018 sur journey to sqlauthority

This year has been filled with data privacy and protection concerns. From the introduction of the General Data Protection Regulation (GDPR) and the exposure of data breaches at Cambridge Analytica, Facebook and Under Armour, to new legislation springin …

Getting Sneaky With Forced Parameterization

Publié le 27 novembre 2018 sur

Silly Rules I’ve blogged about some of the silly rules about where Forced Parameterization doesn’t work. One rule that really irked me is this one: The TOP, TABLESAMPLE, HAVING, GROUP BY, ORDER BY, OUTPUT…INTO, or FOR XML clause …

Pages :