SQLServerCentral - Guest Columnist: Jonathan Kehayias

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,031 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 2009/05/27 | Source: SQLServerCentral.com | Category: Administration

Rating:

|

Discuss |

Briefcase | 12,581 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 | 3,721 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 2009/03/03 | Source: SQLServerCentral.com | Category: SQLCLR

Rating:

|

Discuss |

Briefcase | 7,425 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 2009/02/05 | Source: SQLServerCentral.com | Category: SQLCLR

Rating:

|

Discuss |

Briefcase | 11,149 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 2009/02/02 | Source: SQLServerCentral.com | Category: deadlock

Rating:

|

Discuss |

Briefcase | 14,615 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 | 8,843 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...

By Jonathan Kehayias 2008/08/14 | Source: SQLServerCentral.com | Category: SQL Server Management Studio (SSMS)

Rating:

|

Discuss |

Briefcase | 4,625 reads