Eric Blinn

Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries. Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers. He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User's Group.
  • MSSQLTips Awards: Author of the Year Contender - 2021, 2022 | Trendsetter (25+ tips) - 2021
Title Category Date
SQL IS NULL and SQL IS NOT NULL Examples TSQL2026-05-27
SQL Scripts for Monitoring Current Activity, Blocking and Performance Database Administration2026-05-04
Database Performance, Monitoring and Management with dbWatch Tools2026-04-15
What is a Relational Database Database Design2026-03-25
Improve SQL Server Query Performance with Searchable Arguments TSQL2026-02-16
SQL EXISTS Use Cases and Examples TSQL2025-10-03
Understanding SQL Server Linked Servers Linked Servers2025-06-19
SQL Server Master Database Recovery Model System Databases2025-05-04
SQL Server Master Database Disaster Recovery System Databases2025-05-04
SQL Server Master Database Backup System Databases2025-05-04
SQL Server Master Database Permissions System Databases2025-05-04
SQL Server Master Database Objects System Databases2025-05-04
SQL Server Master Database Tables System Databases2025-05-04
SQL Server Master Database Maintenance System Databases2025-05-04
SQL Server Master Database Size and Growth System Databases2025-05-04
SQL Server Master Database Location System Databases2025-05-04
SQL Server Master Database Overview System Databases2025-05-04
SQL Server Master Database Restore System Databases2025-05-04
SQL Server Master Database Tutorial Outline System Databases2025-05-04
SQL Server MSDB Database Tutorial Outline System Databases2025-05-04
SQL Server MSDB Database Overview System Databases2025-05-04
SQL Server MSDB Database Location System Databases2025-05-04
SQL Server MSDB Database Size and Growth System Databases2025-05-04
SQL Server MSDB Database Maintenance System Databases2025-05-04
SQL Server MSDB Database Tables System Databases2025-05-04
SQL Server MSDB Database Objects System Databases2025-05-04
SQL Server MSDB Database Permissions System Databases2025-05-04
SQL Server MSDB Database Backup System Databases2025-05-04
SQL Server MSDB Database Recovery Model System Databases2025-05-04
SQL Server MSDB Database Restore System Databases2025-05-04
SQL Server MSDB Database Disaster Recovery System Databases2025-05-04
SQL NOT IN Operator TSQL2025-03-14
Query SQL Server Agent Jobs, Steps, History and System Tables SQL Server Agent2025-03-12
SQL NOT EQUAL Examples TSQL2024-12-31
SQL NULL Meaning and How to Handle NULL Values TSQL2024-06-20
SQL Server Deprecated Features Management Deprecated Features2024-04-05
Identify SQL Server Locking and Blocking for Rows, Tables and Objects Locking and Blocking2023-05-15
SQL Cheat Sheet for SQL Server DBA Daily Operations Database Administration2023-04-05
Troubleshoot Performance with User Defined Functions in SQL Server Functions User Defined UDF2023-02-13
Learn Prepared Statements in SQL Server TSQL2022-12-12
How to get Time from a RowVersion value with T-SQL Code Dates2022-12-02
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server Functions System2022-11-22
SQL LIKE Statement Examples TSQL2022-10-27
SQL IF Statement for Conditional Logic TSQL2022-09-12
Adding SQL Comments to Code TSQL2022-07-18
Offload SQL Server Reporting to a Separate Database Database Administration2022-07-14
Manage SQL Server Without Remote Desktop Connections Database Administration2022-06-03
Reasons to Not Access SQL Server Remotely Database Administration2022-05-12
SQL Server datetimeoffset for Time Zones Dates2022-03-14
SQL WHERE Clause to Filter Rows for SELECT, UPDATE and DELETE TSQL2022-02-09
SQL ORDER BY Clause Code Examples TSQL2021-12-20
Data Architect for SQL Server Career Planning2021-12-09
SQL Server Database Roles and Job Titles Career Development2021-11-10
Microsoft SQL Server Virtual Machine Best Practices Virtualization2021-08-27
SQL Server Filtered Index Example Indexing2021-08-10
SQL IN Operator TSQL2021-05-06
SQL Window Functions in SQL Server Functions System2021-02-16
SQL Server SET STATISTICS IO ON Performance Tuning2021-01-26
SQL EXISTS vs IN vs JOIN Performance Comparison TSQL2020-12-14
How to Check Query Performance in SQL Server for CTE, View, Subquery TSQL2020-10-30
Query Tuning in SQL Server with Execution Plans and Missing Indexes Performance Tuning2020-10-20
How to Make Query Execution Faster in SQL Server Performance Tuning2020-09-30
SQL Server TempDB Tutorial System Databases2020-07-17
SQL Server Model Database Tutorial System Databases2020-06-17
SQL Server Index Basics Indexing2020-05-14
Sending mail messages from SQL Server Database Mail2020-04-06
Restore SQL Server Master Database Options System Databases2019-11-18
SQL Server Backup and Restore History Queries System Databases2019-05-10
SSRS ReportServer Database Overview and Queries Reporting Services Administration2019-04-09
SQL Server Trigger Columns Updated Function Triggers2019-03-22
How SQL Triggers Work for Insert, Update, Delete and Truncate Triggers2019-03-01
What is the Best Value for Fill Factor in SQL Server Indexing2019-02-15
Script to Run DBCC CheckDB on Alternate SQL Server to Reduce Load Database Console Commands DBCCs2019-01-21