Omri Bahat

Omri Bahat is a director at SQL Farms in Alexandria, Virginia. Specializing in large database environments, he served as the lead database architect at Symantec and has a doctorate in electrical and computer engineering.

Email: omri@sqlfarms.com

My Latest Content

My Latest Comments

Author Articles

Plugging the Gaps in SQL Server Job Tracking

By Omri Bahat, 08/28/2008

Find missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.

Moving Tables Between Filegroups: A Better Way

By Omri Bahat, 12/18/2007

Eliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script.

Kick a User Out of a Database in Just 2 Steps

By Omri Bahat, 08/22/2007

By gathering information from sysprocesses and running KickUserOut.sql, you can terminate processes that are impeding a server's performance.

Decrypt SQL Server Objects

By Omri Bahat, 07/19/2007

Developers and software vendors use the WITH ENCRYPTION clause to obscure the underlying schema of their products. However, advanced users can still access the code. Here’s a ...

A Brief Background on Encoding and Encryption

By Omri Bahat, 07/19/2007

Differences between encoding and encryption mean that decoding objects that were created WITH ENCRYPTION can be relatively straightforward.

A Dependency Checker You Can Depend On

By Omri Bahat, 04/19/2007

Discover why SQL Server's built-in dependency tracking functionality doesn't work well and how the dependency checker avoids the same problems.

White Papers

Get your Windows 7 deployment off to the right start by implementing PC lockdown. A locked-down environment is easier and cheaper to support since users are less likely to make unnecessary changes to the core system configuration - read more here!

Essential Guides

Is your iSCSI "lossy"? The reality is that most off-the-shelf Ethernet hardware deployed for iSCSI can lose packets, resulting in slow performance or application downtime. Learn how to assess your current iSCSI infrastructure and engineer an advanced iSCSI SAN infrastructure.

Web Seminars

What's the best way to keep your network safe from malware? In this web seminar, security expert Greg Shields suggests an alternative method to the traditional blacklisting approach that is common with anti-virus and anti-malware solutions.

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux