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.