Aubrey Love

Aubrey Love is a self-taught DBA with more than six years of experience designing, creating, and monitoring SQL Server databases as a DBA/Business Intelligence Specialist. Certificates include MCSA, A+, Linux+, and Google Map Tools with 40+ years in the computer industry. Aubrey first started working on PC’s when they were introduced to the public in the late 70's.
  • MSSQLTips Awards: Author of the Year - 2022 | Trendsetter (25+ tips) - 2023
Title Category Date
Split Delimited String into Columns in SQL Server Functions System2026-05-14
SQL Triggers for Inserts, Updates and Deletes on a Table Triggers2025-05-27
How to Shrink SQL Server Database Files Database Administration2025-01-02
SQL WHERE IN Examples for SELECT, UPDATE, and DELETE Queries SQL SELECT2023-10-16
SQL WHERE LIKE Clause in SQL Server SQL WHERE Clause2023-05-01
SQL Clause, Statement, Command, Expression and Batch Defined TSQL2023-03-28
SQL WHERE IS NOT NULL Examples SQL NULL2023-03-13
SQL Server WRITE Function to Update BLOB Data Types TSQL2023-02-27
SQL STUFF, SQL REPLACE and SQL WRITE Similarities and Differences String Functions2023-02-17
How to Encrypt a Stored Procedure in SQL Server Encryption2023-01-18
Learn SQL Variables for Scripts and Development TSQL2022-12-21
Getting Started with SQL Schemas Database Design2022-12-12
Drop All Tables in SQL Server and Generate a List of Objects with Type Database Design2022-10-19
SQL Stored Procedures Getting Started Guide Stored Procedures2022-10-04
SQL Synonyms to access Tables, Views, Functions, Stored Procedures Synonyms2022-09-21
Build a Simple Bar Chart using SQL Code TSQL2022-09-16
Delete vs Truncate SQL Server Quick Reference Guide SQL DELETE and Truncate2022-09-06
Delay SQL Code Execution with SQL WAITFOR Functions System2022-08-08
Creating SQL VIEWs Step By Step Views2022-04-20
SQL Create Table using SQL Server Management Studio SQL Server Management Studio2022-03-29
CREATE TABLE SQL Server Syntax Examples Database Design2022-03-15
SQL COUNT Code Examples Functions Aggregate2021-10-25
SQL GROUP BY to Summarize and Rollup Query Results SQL ORDER BY and GROUP BY2021-09-09
SQL UPDATE from SELECT, JOIN or MERGE SQL UPDATE2021-08-05
SQL CAST Function for Data Type Conversions Functions System2021-05-25
SQL Server Collation Overview and Examples SQL Server Configurations2020-05-05