Eli Leiba | ITPro Today

Eli Leiba

Latest from Eli Leiba

computer keyboard with green sprouts between keys

Innovations of the 2010s (SQL Server 2012 – 2019)

Using the New OFFSET and FETCH NEXT Options Using the New OFFSET and FETCH NEXT Options

Jul 20, 2012

1 Min Read

ITPro Today logo

Automated SQL Server Health Check Solution Automated SQL Server Health Check Solution

Jun 17, 2011

3 Min Read

All from Eli Leiba

computer keyboard with read question mark key

Execute a Stored Procedure Within a Query

Execute a Stored Procedure Within a Query

fingers typing on a laptop

Early Versions (SQL Server 2000 – 2008)

Simple String Encryption and Decryption

Simple String Encryption and Decryption

Change Many Server Configuration Options in One Fell Swoop

Early Versions (SQL Server 2000 – 2008)

Change Many Server Configuration Options in One Fell Swoop

Change Many Server Configuration Options in One Fell Swoop

Find Weak Database Passwords

Early Versions (SQL Server 2000 – 2008)

Find Weak Database Passwords

Find Weak Database Passwords

Use a Stored Procedure to Move User Tables Between File Groups

Early Versions (SQL Server 2000 – 2008)

Use a Stored Procedure to Move User Tables Between File Groups

Use a Stored Procedure to Move User Tables Between File Groups

T-SQL Stored Procedure Creates Trace Tables from Trace Files

Early Versions (SQL Server 2000 – 2008)

T-SQL Stored Procedure Creates Trace Tables from Trace Files

T-SQL Stored Procedure Creates Trace Tables from Trace Files

Early Versions (SQL Server 2000 – 2008)

T-SQL UDF Quickly Determines How Often a Substring Appears

T-SQL UDF Quickly Determines How Often a Substring Appears

Procedure Helps Pinpoint Problematic Processes

Early Versions (SQL Server 2000 – 2008)

Procedure Helps Pinpoint Problematic Processes

Procedure Helps Pinpoint Problematic Processes

Easily Find Rows That Violate Constraints

Easily Find Rows That Violate Constraints

Early Versions (SQL Server 2000 – 2008)

Summarize All the Constraints for a Table

Summarize All the Constraints for a Table

Early Versions (SQL Server 2000 – 2008)

Optimize the Size of Your Indexed Integer Columns

Optimize the Size of Your Indexed Integer Columns

Early Versions (SQL Server 2000 – 2008)

Rename Files or Directories On the Fly in T-SQL Scripts

Rename Files or Directories On the Fly in T-SQL Scripts

Early Versions (SQL Server 2000 – 2008)

Stored Procedures Work in Concert to Import and Export Data

Stored Procedures Work in Concert to Import and Export Data

Early Versions (SQL Server 2000 – 2008)

Quickly Retrieve a List of Available Media Resources

Quickly Retrieve a List of Available Media Resources

Early Versions (SQL Server 2000 – 2008)

Extend the sp_spaceUsed Procedure’s Usefulness in Obtaining Transaction Log Statistics

Extend the sp_spaceUsed Procedure’s Usefulness in Obtaining Transaction Log Statistics

Early Versions (SQL Server 2000 – 2008)

Dynamically Obtain a SQL Server’s IP Address in T-SQL Code

Dynamically Obtain a SQL Server’s IP Address in T-SQL Code

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up