SQL Monitor Custom Metric: Top Buffer Cache Object

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.

Disaster Recovery Tip #4 - Learn about partial restores!

Sometimes recovery simply entails rerunning a failed process.

SQL in the City Seminar Sacramento 2013

Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action.

SQL Saturday #239 East Iowa

SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.

SQL Saturday #222

SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney

SQL Saturday #231 Cocoa Beach

Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.

SQL Saturday #230 Rheinland

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 13 2013 at Grantham-Allee 20, Sankt Augustin, Cologne/Bonn, Rheinland, 53757 , Germany.

New SQL Monitor Custom Metric: Untrusted Check Constraints

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.

SQL Saturday #214 Louisville KY

Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13.

This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.

Free eBook - Control Your Transaction Log so it Doesn't Control You

Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.