The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
1,081 reads
On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation...
2018-05-06
210 reads
Trace Flags are a way to change the behavior of the SQL Server database engine. They are often used for...
2018-05-06
99 reads
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
108 reads
There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be...
2018-05-05
285 reads
Congrats to Michael, Eric, John, all the organizers and volunteers, and all the speakers for a successful Spring Houston Tech Fest 2018. It was a pleasure for the wife...
2018-05-05
8 reads
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,361 reads
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
276 reads
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
340 reads
Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure...
2018-05-04
1,123 reads
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
When the schema of an object is changed, SQL Server wipes out the previous...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers