A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables.
2013-01-31
2,946 reads
You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.
2013-01-25 (first published: 2012-10-23)
12,771 reads
In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.
2013-01-22 (first published: 2013-01-08)
2,657 reads
2013-01-21
1,562 reads
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2013-01-17
7,238 reads
Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.
2012-12-25 (first published: 2012-10-30)
18,171 reads
After winning a number of awards for our software, Red Gate is giving away books to 300 people as a celebration.
2012-12-18 (first published: 2012-12-11)
7,193 reads
Red Gate won 8 awards in the recent SQL Server Pro annual product reviews. As a celebration, we're giving away a few prizes.
2012-12-06
2,714 reads
Get a free ebook from Red Gate Software and SQLServerCentral from MVP Grant Fritchey. Learn how to read and interpret execution plans.
2012-12-04
7,296 reads
A free day of training in the US nation's capital. Come join in if you are nearby.
2012-12-03
1,447 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers