Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017
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
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?
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?
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
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”
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
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
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)
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
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
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
. 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?
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)
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
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.