Eli Leiba

Eli Leiba works at Israel Electric Company as a Senior Application DBA in Oracle and MS SQL Server. He also has certifications from Microsoft and BrainBench in Oracle and SQL Server database administration and implementation. Mr. Leiba holds a B.S. in Computer Science since 1991 and has 13 years experience working in the databases field. Additionally Mr. Leiba teaches SQL Server DBA and Development courses at Microsoft CTEC and also serves as a senior database consultant for several Israeli start-up companies.

Technical Article

Get the #lines in a TSQL view/SP/UDF of a String

The following procedure gets a TSQL program object(View/UDF/stored procedure) and a given stringIt searched object's source code for the string and returns the number of lines where a match is found.This is helpful when we want to search all our TSQL code for a specific table name, column etc. and investigate where it is referenced […]

You rated this post out of 5. Change rating

2005-06-02

102 reads

SQLServerCentral Article

Tokenizing a String Using PARSENAME

SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.

1 (1)

You rated this post out of 5. Change rating

2004-12-27

12,046 reads

SQLServerCentral Article

Evaluating Boolean expressions using T-SQL

Every once in awhile there is a unique T-SQL solution in SQL Server that solves a rare problem. Not many of us have had to deal with boolean evaluation in our jobs, but a few have. Author Eli Leiba has and brings us a new article that shows how to build a procedure that can take a boolean expression and evaluate it to true or false.

You rated this post out of 5. Change rating

2004-12-21

15,073 reads

SQLServerCentral Article

Tracking Down Newly Created Databases

SQL Server was designed to make the DBA job easier, distribution of security, automated procedures, etc. But in some areas it either does not go far enough, or a feature is used for an unintended purpose. One of those areas comes into play when allowing many people to create databases. Author Eli Leiba brings us a tecehnique he uses to close the gap and track down those newly created databases.

You rated this post out of 5. Change rating

2004-11-18

4,949 reads

SQLServerCentral Article

Identifying Blocking Locks

Blocks in SQL Server can cause untold amounts of pain and headache, mostly because they are so transient and often when you go to look for them, they have been released on whatever object you are researching. Author Eli Leiba has writeen a short piece on how you can automate the search for blocking locks and help you as a DBA be proactive in identifying them.

2 (1)

You rated this post out of 5. Change rating

2004-10-28

12,394 reads

Blogs

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

By

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Read the latest Blogs

Forums

Connect tabular model to excel via Power BI semantic model

By Bhagat

I have a tabular cube, with myself included in one of the roles. I...

New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

By uratol

  Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers