Get Free Tips
MSSQLTips.com

Author: Eli Leiba

Home » Archives for 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

TitleCategoryDate
SQL Server Database Users to Roles Mapping ReportSecurity2022-03-25
SQL Server Memory Usage QueryMonitoring2021-04-15
How to Extract URLs from HTML using Stored Procedure in SQL ServerTSQL2020-12-10
Check Windows Services Status with T-SQLTSQL2020-11-05
Solving Linear Equations with SQL Server T-SQL CodeTSQL2020-10-29
Shrink SQL Server Transaction Log for all DatabasesDatabase Administration2020-05-19
SQL Server Table Size ReportMonitoring2020-03-19
SQL Server Dynamic PIVOT QueryTSQL2019-12-04
SQL Server Function to Measure CPU Usage Per DatabaseMonitoring2019-11-05
Script to Find SQL Server Windows Login Expiration DateDatabase Administration2019-10-07
Find Top N Largest Gaps in Date Ranges in SQL Server with T-SQLTSQL2019-09-18
Disk Latency for SQL Server Database and Transaction Log FilesPerformance Tuning2019-08-19
SQL Server Instance Configuration Summary ReportSQL Server Configurations2019-08-06
Find the Last Windows Server Reboot Time and Last SQL Server RestartDatabase Administration2019-07-17
Use SQL Server Default Trace to Find ErrorsProfiler and Trace2019-02-18
Find Greatest Common Divisor for Any Number of Integers with TQLTSQL2019-01-09
Matrix Multiplication Calculated with T-SQLTSQL2018-11-23
SQL Server Internal Query Cardinality Estimator InformationPerformance Tuning2018-09-27
Script to Split SQL Server Database Backups into Multiple FilesBackup2018-09-12
Script to delete old SQL Server Backup Files Using Backup History DataBackup2018-08-29
SQL Server Function to Generate Random NumbersTSQL2018-08-07
SQL Server Script to Search Through All Error LogsError Logs2018-07-27
SQL Server Current Identity Value Report for All TablesIdentities2018-06-28
Using T-SQL to find the shortest distance between two pointsTSQL2018-06-19
SQL Server Script to Determine Free Space Prior to SQL Server BackupBackup2018-05-31
SQL Stored Procedure to Calculate Area of a Polygon and Draw its ShapeSpatial Data Storage2018-05-11
Function to quickly find the worst performing SQL Server Stored ProceduresMonitoring2018-04-19
Simple SQL Server Function to Generate Random 8 Character PasswordSecurity2018-01-31
SQL Server Stored Procedure to Calculate Database Backup Compression RatioCompression2017-12-28
SQL Server Stored Procedure to get every Nth row of a Query Result SetTesting2017-12-13
Scripts to Build a Network of Connected Records Using SQL ServerTSQL2017-11-10
Script to Drop and Delete Offline SQL Server Databases and Data FilesDatabase Administration2017-11-02
Stored procedure to generate HTML tables for SQL Server query outputScripts2017-09-08
Script to attach multiple SQL Server MDF filesScripts2017-08-25
Script to identify all non-indexed foreign keys in a SQL Server databaseIndexing2017-08-17
SQL Server function to check dynamic SQL syntaxFunctions User Defined UDF2017-08-02
Simple Image Import and Export Using T-SQL for SQL ServerImport and Export2017-07-17
Find All Failed SQL Server LoginsSecurity2017-07-03
SQL Server Credit Card Encryption and DecryptionEncryption2017-06-21
Use T-SQL to Find Folders Using the Most Disk SpaceScripts2017-06-02
Script to Disable Non Used SQL Server IndexesIndexing2017-03-27
Script to quickly find SQL Server DBCC CHECKDB ErrorsDatabase Console Commands DBCCs2017-02-28
SQL Server Function to Encrypt Integer ValuesEncryption2017-02-03
Simple free drive space alert for SQL Server databasesMonitoring2017-01-19
Find current running SQL Server queries with a PowerShell scriptPowerShell2016-12-27
Simple Procedure to Make a Copy of a SQL Server DatabaseRestore2016-12-05
Script to find oldest open SQL Server transactionScripts2016-11-22
SQL Server security report to show sysadmins and database ownersSecurity2016-11-14
Dynamically build a multi OR with LIKE query for SQL ServerTSQL2016-11-03
Quickly identify non-default sp_configure values for a SQL Server instanceSQL Server Configurations2016-10-24
Delete old SQL Server backup files with a Stored ProcedureBackup2016-10-13
Create a SQL Server InitCap FunctionFunctions User Defined UDF2016-09-26
Validate a SQL Server Backup can be RestoredBackup2016-09-21
SQL Server Stored Procedure to Compress Non Partitioned TablesCompression2016-08-09
Altering lock escalation for SQL Server tablesLocking and Blocking2016-07-28
Saving storage space alternative for rarely used decimal columns for SQL Server TablesDatabase Configurations2016-07-04
Script to calculate the Median value for SQL Server dataFunctions System2011-10-31
SQL Server Data Compression Storage Savings for all TablesCompression2011-06-06
Find SQL Server data and log files that are almost out of spaceDatabase Administration2011-04-26
Creating IO performance snapshots to find SQL Server performance problemsDynamic Management Views and Functions2011-04-11
Find Violating SQL Server Foreign Key ValuesConstraints2011-03-16

Categories

Recent Articles

  • SQL EXISTS Use Cases and Examples

  • SQL CASE Statement in WHERE Clause Examples

  • Managing Underused Indexes in SQL Server Availability Groups – Part 1

  • Inline Scalar UDFs vs. Inline Code Performance Comparison in Fabric Warehouses – Part 2

  • SQL Partition By Examples for Aggregating Data

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide