Jonathan Kehayias

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

4.6 (5)

2014-11-11

22,756 reads

Tracking Database File AutoGrowth with Event Notifications

As discussed in my previous Getting Started with SQL Server Event Notifications article, SQL Server Event Notifications allow us to capture and handle events that occur inside the SQL Server database engine. Event Notifications execute for DDL Events and Trace Events and we can use to capture information about the event that fired, and automate […]

4.75 (16)

2012-11-06

7,139 reads

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery

The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.

4.46 (13)

2012-07-13

2,395 reads

Troubleshooting SQL Server eBook Download

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

2011-09-29

22,627 reads

Blogs

How a new custom PowerPoint template is helping us to be more effective presenters

By

DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...

New Event Calendar

By

Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...

Databricks Delta Lake

By

Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

Finding out mismatch between time lines.

By koti.raavi

CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...

development of encrypted password field

By snomadj

I want to be able to: encrypt a password column display characters x &...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers