Sites anglophones


Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017

Publié le 29 octobre 2018 sur sqlskills.com - glen berry
 

One interesting and useful new feature in SQL Server 2017 is Automatic plan correction. This feature, which relies on having Query Store enabled for your database, will look for query plan choice regressions where there has been a significant regressio …

Compare SQL Server, MySQL and PostgreSQL Features

Publié le 29 octobre 2018 sur sqlblog.com
 

Have you ever wondered how MySQL and PostgreSQL are different? Take a look at the mapping that I have made for myself: https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/ I would be happy to see comments posted …

What Is SQLPSX?

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

I was and still am a big fan of SQLPSX (SQL PowerShell Extensions). It´s is a complete PowerShell library for SQL Server written by Chad Miller and Mike Shepard, and I was one of the developers on some of the modules. It’s composed of 13 mo …

You read reviews before you buy training, right?

Publié le 29 octobre 2018 sur brentozar.com
 

Confession time: I love buying stuff. It’s not so much the buying as it is the comparing. I go to The Wirecutter, I read every review on Amazon, and I make little Excel spreadsheets to show differences between products. So what about when you buy …

Get the Error Column Name in SSIS

Publié le 29 octobre 2018 sur sqlservercentral.com
 

This article will show how you can get the column name for error rows in an SSIS 2016 Data Flow task. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and …

5th annual “Seattle Freecon”

Publié le 29 octobre 2018 sur sqlservercentral.com
 

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of …

The future of SQL Census

Publié le 29 octobre 2018 sur sqlservercentral.com
 

Find out what plans Redgate has for SQL Census and leave your comments to have your own input in the future of the tool. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-st …

SQL SERVER – Parallelism for Heap Scan

Publié le 29 octobre 2018 sur journey to sqlauthority
 

Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the  Comprehensive Database Performance Health Check  …

[Video] Office Hours 2018/10/24 (With Transcriptions)

Publié le 28 octobre 2018 sur brentozar.com
 

This week, Brent, Tara, and Richie discuss increasing a table’s varchar field from 1 to 2, predicting how long CHECKDB should take, SQL Server configuration options, reporting, reducing high waits, analysis services for SQL Azure, advice to first …

What is Read Ahead Read in SQL Server? – Interview Question of the Week #197

Publié le 28 octobre 2018 sur journey to sqlauthority
 

Question: What is Read Ahead Read in SQL Server? Answer: The read-ahead mechanism is SQL Server’s feature which brings data pages into the buffer cache even before the data is requested by the query. Whenever we run a query, SQL Server Engin …

SQL SERVER – Finding Compression Ratio of Backup

Publié le 27 octobre 2018 sur journey to sqlauthority
 

During the recent Comprehensive Database Performance Health Check, I was asked if there is any way to know compression ration of backup if we enable compressed backup settings in SQL Server. As you know that a compressed backup is smaller tha …

Discover how SQL Server can use Python to access any NoSQL engine

Publié le 26 octobre 2018 sur sqlblog.com
 

. Many companies these days keep their data assets in multiple data stores.  Many companies that I have worked at have used other database systems alongside SQL Server, such as PostgreSQL instances, Redis, Elasticsearch or Couchbase. There are sit …

My AWS Aurora Postgres instance is 100% CPU. What’s next?

Publié le 26 octobre 2018 sur sqlblog.com
 

I had to investigate today situation when my AWS Aurora PostgreSQL instance CPU was 100%.I have started to search for a root cause at the database statistic views level. There is a view pg_stat_activity which shows information related to the …

Filtered Indexes vs Parameterization (Again)

Publié le 26 octobre 2018 sur brentozar.com
 

At First I Was Like… This won’t work at all, because parameters are a known enemy of filtered indexes. But it turns out that some filtered indexes can be used for parameterized queries, whether they’re from stored procedures, dynamic …

Have your say on the future of data masking

Publié le 26 octobre 2018 sur sqlservercentral.com
 

Find out what Redgate have been doing with their data masking tool. Find out where they are heading next in terms of development and help them gain a deeper understanding of your requirements for the tool.


Pages :