Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jonathan Kehayias

SQLServerCentral.com profile

   Items 1 to 14 of 14   
 

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.  Read more...
By Jonathan Kehayias 2012/07/13 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,294 reads

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.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,751 reads

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".  Read more...
By Jonathan Kehayias 2011/09/29 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 20,276 reads

Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail

Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.  Read more...
By Jonathan Kehayias 2009/12/17 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,768 reads

Getting Started with SQL Server Event Notifications

Learn the basics of Event Notifications from MVP Jonathan Kehayia. This article will show you how to create customized responses to events in SQL Server 2005/2008.  Read more...
By Jonathan Kehayias 2009/12/22 | Source: SQLServerCentral.com | Category: event notifications
Rating: |  Discuss |   Briefcase | 12,678 reads

Use Backup/Restore to Minimize Upgrade Downtimes

Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.  Read more...
By Jonathan Kehayias 2009/06/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 5,674 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,840 reads

Retrieving Deadlock Graphs with SQL Server 2008 Extended Events

Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.  Read more...
By Jonathan Kehayias 2009/02/23 | Source: SQLServerCentral.com | Category: deadlock
Rating: |  Discuss |   Briefcase | 25,425 reads

Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.  Read more...
By Jonathan Kehayias 2011/05/06 (first published: 2009/03/03) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 16,825 reads

Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.  Read more...
By Jonathan Kehayias 2013/11/22 (first published: 2009/02/05) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 29,370 reads

Using SQL Profiler to Resolve Deadlocks in SQL Server

MVP Jonathan Kehayias brings us a short article on how to troubleshoot deadlocks in SQL Server.  Read more...
By Jonathan Kehayias 2010/06/04 (first published: 2009/02/02) | Source: SQLServerCentral.com | Category: deadlock
Rating: |  Discuss |   Briefcase | 34,898 reads

Using the Blocked Process Report in SQL Server 2005/2008

When excessive blocking occurs in SQL, performance degrades. Learn how to use the Blocked Process Report to rapidly resolve excessive blocking scenarios in SQL Server 2005/2008.  Read more...
By Jonathan Kehayias 2008/10/30 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 19,713 reads

Multiple Server Queries with SSMS 2008

This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008  Read more...
Rating: |  Discuss |   Briefcase | 5,523 reads
   Items 1 to 14 of 14