http://www.sqlmag.com/authors/author/author/5611427/rss/5611427en-USFri, 25 May 2012 08:15:06 GMTFri, 25 May 2012 08:15:06 GMThttp://www.sqlmag.com/article/tsql3/plugging-the-gaps-in-sql-server-job-trackingFind missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.]]>Omri BahatThu, 28 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/plugging-the-gaps-in-sql-server-job-trackinghttp://www.sqlmag.com/article/sql-server-2000/moving-tables-between-filegroups-a-better-wayEliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script. ]]>Omri BahatTue, 18 Dec 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2000/moving-tables-between-filegroups-a-better-wayhttp://www.sqlmag.com/article/tsql3/kick-a-user-out-of-a-database-in-just-2-stepsBy gathering information from sysprocesses and running KickUserOut.sql, you can terminate processes that are impeding a server’s performance.]]>Omri BahatWed, 22 Aug 2007 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/kick-a-user-out-of-a-database-in-just-2-stepshttp://www.sqlmag.com/article/encryption2/decrypt-sql-server-objectsDevelopers 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.]]>Omri BahatThu, 19 Jul 2007 00:00:00 GMThttp://www.sqlmag.com/article/encryption2/decrypt-sql-server-objectshttp://www.sqlmag.com/article/encryption2/a-brief-background-on-encoding-and-encryptionDifferences between encoding and encryption mean that decoding objects that were created WITH ENCRYPTION can be relatively straightforward. ]]>Omri BahatThu, 19 Jul 2007 00:00:00 GMThttp://www.sqlmag.com/article/encryption2/a-brief-background-on-encoding-and-encryptionhttp://www.sqlmag.com/article/tsql3/a-dependency-checker-you-can-depend-onDiscover why SQL Server’s built-in dependency tracking functionality doesn’t work well and how the dependency checker avoids the same problems.]]>Omri BahatThu, 19 Apr 2007 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/a-dependency-checker-you-can-depend-on