Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


 
Eli Leiba
   

Eli Leiba is a senior application DBA at Israel Electric Company, a teacher at Microsoft CTEC, and a senior database consultant for 2Cher IT Professionals Co. With 14 years of experience, he is certified in Oracle and SQL Server database administration and implementation and has a B.S. in Computer Science.
Email address: Eli.Leiba@2Cher.com

15 results found for Eli Leiba, displaying items 1 - 15
October 2008  
Find Weak Database Passwords
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
SQL Server Magazine

August 2008  
Use a Stored Procedure to Move User Tables Between File Groups
Here's a T-SQL stored procedure that finds and moves the clustered-indexes user tables you specify from old file groups to new file groups.
SQL Server Magazine

December 2007  
T-SQL Stored Procedure Creates Trace Tables from Trace Files
LoadTraceFileToTable loads the data from a trace file into a trace table so that you can easily sort and analyze that data.
SQL Server Magazine

November 2007  
T-SQL UDF Quickly Determines How Often a Substring Appears
To determine the number of occurrences of a substring within a string, a user-defined function (UDF) performs a simple arithmetic calculation.
SQL Server Magazine

June 2007  
Protect Your T-SQL Objects from Deletion
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you've created by marking them as system objects.
SQL Server Magazine

April 2007  
Procedure Helps Pinpoint Problematic Processes
Here's a stored procedure that displays all the T-SQL statements currently being executed along with the IDs of the processes running those statements.
SQL Server Magazine

March 2007  
Easily Find Rows That Violate Constraints
The showViolatingRows procedure automates the tedious task of finding rows that violate check and foreign-key constraints.
SQL Server Magazine

October 26, 2006  
Summarize All the Constraints for a Table
The sp_showConstraints stored procedure is an alternative to using sp_helpconstraint when you need to find all the constraints for a table.
SQL Server Magazine

April 10, 2006  
Optimize the Size of Your Indexed Integer Columns
Together, the suggestIntType and scanIntIndex procedures search for indexed integer columns in a database and determine whether the optimal data type is used for those columns.
Windows IT Pro

March 2, 2006  
Rename Files or Directories On the Fly in T-SQL Scripts
SQL Server Magazine

February 13, 2006  
Stored Procedures Work in Concert to Import and Export Data
Here’s a simple yet generic solution for exporting or importing data. This solution consists of two stored procedures: BCPObject and ExpOrImpDB.
Windows IT Pro

January 31, 2006  
Quickly Retrieve a List of Available Media Resources
The sp_GetAllSQLMediaTypes stored procedure lists the names of all the available media and their types on a SQL Server machine.
SQL Server Magazine

January 31, 2006  
Extend the sp_spaceUsed Procedure’s Usefulness in Obtaining Transaction Log Statistics
By compiling sp_LogSpace in a master database and calling it from an updated version of sp_SpaceUsed, you can extend the ability of sp_SpaceUsed to obtain transaction log statistics.
SQL Server Magazine

December 12, 2005  
Don’t Let Resource-Intensive Sessions Consume All Your Resources and Time
The getMaxResourceConsumeSessions stored procedure lets you quickly identify the sessions that are consuming most of a SQL Server machine's resources.
Windows IT Pro

October 31, 2005  
Dynamically Obtain a SQL Server’s IP Address in T-SQL Code
The getSQL_IPaddr.sql procedure uses the Ipconfig utility to dynamically find the IP address of a server running Microsoft SQL Server.
SQL Server Magazine





ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

Latest Advancements in SSL Technology
There are a variety of different kinds of SSL to explore to ensure customer data is kept confidential and secure. In this paper, we will discuss some of these SSL advances to help you decide which would be best for your organization.

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Solving PST Management Problems
In this white paper, read about the top PST issues and how to administer local/network PST Files.

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Maximize Your SharePoint Investment: Get Your Data Moving
Watch this web seminar now to learn how to maximize your SharePoint investment! Join us as we take a look at the complex business of securing, accessing and managing vast amounts of information in a global network and various ways to get your data moving.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing