Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark
2020-09-16
Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good.
2020-09-16
In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.
2020-09-15
Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]
2020-09-14
7,741 reads
Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.
2020-09-14
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
2020-09-14
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
2020-09-11
When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.
2020-09-11
Learn how to correct an error that is overloading SCOM by fixing an SPN.
2020-09-10
7,694 reads
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.
2020-09-10
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I moved a table from MsSql to Postgresql that had a field defined as...
I tried to find an appropriate forum to post the question. This one seems...
Comments posted to this topic are about the item Resolving Access Denied Errors During...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers