Eli Leiba

Eli Leiba is a senior application DBA at Israel Electric Company, a teacher at Microsoft CTEC, and a senior database consultant. With 19 years of experience working with both SQL Server and Oracle RDBMS. He is certified in Oracle and SQL Server database administration and implementation and has a B.S. in Computer Science. He can be reached at: iecdba@hotmail.com.
  • MSSQLTips Awards: Rising Star (50+ tips) - 2019 | Author of the Year Contender - 2016-2019
Title Category Date
SQL Server Database Users to Roles Mapping Report Security2022-03-25
SQL Server Memory Usage Query Monitoring2021-04-15
How to Extract URLs from HTML using Stored Procedure in SQL Server TSQL2020-12-10
Check Windows Services Status with T-SQL TSQL2020-11-05
Solving Linear Equations with SQL Server T-SQL Code TSQL2020-10-29
Shrink SQL Server Transaction Log for all Databases Database Administration2020-05-19
SQL Server Table Size Report Monitoring2020-03-19
SQL Server Dynamic PIVOT Query TSQL2019-12-04
SQL Server Function to Measure CPU Usage Per Database Monitoring2019-11-05
Script to Find SQL Server Windows Login Expiration Date Database Administration2019-10-07
Find Top N Largest Gaps in Date Ranges in SQL Server with T-SQL TSQL2019-09-18
Disk Latency for SQL Server Database and Transaction Log Files Performance Tuning2019-08-19
SQL Server Instance Configuration Summary Report SQL Server Configurations2019-08-06
Find the Last Windows Server Reboot Time and Last SQL Server Restart Database Administration2019-07-17
Use SQL Server Default Trace to Find Errors Profiler and Trace2019-02-18
Find Greatest Common Divisor for Any Number of Integers with TQL TSQL2019-01-09
Matrix Multiplication Calculated with T-SQL TSQL2018-11-23
SQL Server Internal Query Cardinality Estimator Information Performance Tuning2018-09-27
Script to Split SQL Server Database Backups into Multiple Files Backup2018-09-12
Script to delete old SQL Server Backup Files Using Backup History Data Backup2018-08-29
SQL Server Function to Generate Random Numbers TSQL2018-08-07
SQL Server Script to Search Through All Error Logs Error Logs2018-07-27
SQL Server Current Identity Value Report for All Tables Identities2018-06-28
Using T-SQL to find the shortest distance between two points TSQL2018-06-19
SQL Server Script to Determine Free Space Prior to SQL Server Backup Backup2018-05-31
SQL Stored Procedure to Calculate Area of a Polygon and Draw its Shape Spatial Data Storage2018-05-11
Function to quickly find the worst performing SQL Server Stored Procedures Monitoring2018-04-19
Simple SQL Server Function to Generate Random 8 Character Password Security2018-01-31
SQL Server Stored Procedure to Calculate Database Backup Compression Ratio Compression2017-12-28
SQL Server Stored Procedure to get every Nth row of a Query Result Set Testing2017-12-13
Scripts to Build a Network of Connected Records Using SQL Server TSQL2017-11-10
Script to Drop and Delete Offline SQL Server Databases and Data Files Database Administration2017-11-02
Stored procedure to generate HTML tables for SQL Server query output Scripts2017-09-08
Script to attach multiple SQL Server MDF files Scripts2017-08-25
Script to identify all non-indexed foreign keys in a SQL Server database Indexing2017-08-17
SQL Server function to check dynamic SQL syntax Functions User Defined UDF2017-08-02
Simple Image Import and Export Using T-SQL for SQL Server Import and Export2017-07-17
Find All Failed SQL Server Logins Security2017-07-03
SQL Server Credit Card Encryption and Decryption Encryption2017-06-21
Use T-SQL to Find Folders Using the Most Disk Space Scripts2017-06-02
Script to Disable Non Used SQL Server Indexes Indexing2017-03-27
Script to quickly find SQL Server DBCC CHECKDB Errors Database Console Commands DBCCs2017-02-28
SQL Server Function to Encrypt Integer Values Encryption2017-02-03
Simple free drive space alert for SQL Server databases Monitoring2017-01-19
Find current running SQL Server queries with a PowerShell script PowerShell2016-12-27
Simple Procedure to Make a Copy of a SQL Server Database Restore2016-12-05
Script to find oldest open SQL Server transaction Scripts2016-11-22
SQL Server security report to show sysadmins and database owners Security2016-11-14
Dynamically build a multi OR with LIKE query for SQL Server TSQL2016-11-03
Quickly identify non-default sp_configure values for a SQL Server instance SQL Server Configurations2016-10-24
Delete old SQL Server backup files with a Stored Procedure Backup2016-10-13
Create a SQL Server InitCap Function Functions User Defined UDF2016-09-26
Validate a SQL Server Backup can be Restored Backup2016-09-21
SQL Server Stored Procedure to Compress Non Partitioned Tables Compression2016-08-09
Altering lock escalation for SQL Server tables Locking and Blocking2016-07-28
Saving storage space alternative for rarely used decimal columns for SQL Server Tables Database Configurations2016-07-04
Script to calculate the Median value for SQL Server data Functions System2011-10-31
SQL Server Data Compression Storage Savings for all Tables Compression2011-06-06
Find SQL Server data and log files that are almost out of space Database Administration2011-04-26
Creating IO performance snapshots to find SQL Server performance problems Dynamic Management Views and Functions2011-04-11
Find Violating SQL Server Foreign Key Values Constraints2011-03-16