Jonathan Kehayias


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2014-11-11

25,620 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2012-11-06

8,953 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2012-07-13

2,606 reads

SQLServerCentral Article

Simplified Restores with SQL Server 2012 Recovery Advisor

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.

4.33 (12)

You rated this post out of 5. Change rating

2012-06-27

2,926 reads

Troubleshooting SQL Server A Guide for the Accidental DBA eBook cover

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".

You rated this post out of 5. Change rating

2011-09-29

24,864 reads

Blogs

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Picking a Starting Table in Test Data Manager

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

SQL Server Migration Using a Distributed Availability Group

By

SQL Server migrations are a headache, ask anyone who’s been through the pain of...

Read the latest Blogs

Forums

what is the difference between these two queries

By jaango123

Please I am struggling to understand the difference between these two queries. It behaves...

Introduction to PostgreSQL for the data professional

By Site Owners

Comments posted to this topic are about the item Introduction to PostgreSQL for the...

what happens to ssis and ssrs whenb we migrate to sql saas

By stan

Hi we know (or believe)  ssas saas gets stood up separately when a company...

Visit the forum

Question of the Day

CHOOSing an Alias

I have this code:

SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x
FROM ProductSales;
What is a good name for the column alias?

See possible answers