Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Eli Leiba profile

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.

   Items 1 to 9 of 9   

New and Basic Result-set Paging functionality in SQL 2012 Version.

Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.  Read more...
By Eli Leiba 2013/04/10 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 595 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,841 reads

Generating Permutations in T-SQL

In testing your applications, one of the things that you often want to do is run through a list of all possible values for some particular piece of code. Eli Leiba brings us a method for autmatically generating all the possible permutations for input values.   Read more...
By Eli Leiba 2005/10/19 | Source: | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,248 reads

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.   Read more...
By Eli Leiba 2004/12/27 | Source: | Category: user defined function (udf)
Rating: |  Discuss |   Briefcase | 9,963 reads

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.   Read more...
By Eli Leiba 2004/12/21 | Source: | Category: advanced querying
Rating: |  Discuss |   Briefcase | 12,780 reads

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.   Read more...
By Eli Leiba 2004/11/18 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 4,863 reads

Implementing a Flexible Backup Strategy

SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.   Read more...
By Eli Leiba 2004/10/19 | Source: | Category: backup and restore
Rating: |  Discuss |   Briefcase | 11,114 reads

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.   Read more...
By Eli Leiba 2004/10/28 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 12,367 reads

Handling Simple XML Using T-SQL

SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.   Read more...
By Eli Leiba 2004/09/20 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 12,899 reads
   Items 1 to 9 of 9