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 address: omri@sqlfarms.com

5 results found for Omri Bahat, displaying items 1 - 5
January 2008

Moving Tables Between Filegroups: A Better Way This article is only available to subscribers. Sign up now and get instant access!

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

SQL Server Magazine

September 2007

Kick a User Out of a Database in Just 2 Steps This article is only available to subscribers. Sign up now and get instant access!

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

SQL Server Magazine

August 2007

Decrypt SQL Server Objects This article is only available to subscribers. Sign up now and get instant access!

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 simple do-it-yourself T-SQL algorithm that unlocks encrypted database objects.

SQL Server Magazine

August 2007

A Brief Background on Encoding and Encryption This article is only available to subscribers. Sign up now and get instant access!

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

SQL Server Magazine

May 2007

A Dependency Checker You Can Depend On This article is only available to subscribers. Sign up now and get instant access!

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

SQL Server Magazine

Add these Headlines to your Website