SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Another fun article for America's Independence Day using SQL Server's spatial features.
2026-07-03
894 reads
Another fun article for America's Independence Day using SQL Server's spatial features.
2026-07-03
894 reads
Taking SQL art from shamrocks and Easter eggs to something your DBA manager might actually care about. If you've been following my SQL spatial art series — shamrocks, Easter eggs, Christmas trees — you'll know I have a habit of finding increasingly creative misuses for SQL Server's geometry data type. Most of them have been […]
2026-06-12
4,753 reads
What a DBA team actually deals with There are many issues a DBA team faces, from servers going down to login access not being requested on time. These are not glamorous problems, but they are the problems that stop everyone else doing their jobs. In a modern environment you would expect a lot of the […]
2026-04-13
2,745 reads
2026-04-10
839 reads
Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.
2026-03-20
3,018 reads
Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]
2026-03-16
2,282 reads
This article presents a way to check and validate input before using it in your dynamic SQL queries to prevent SQL Injection problems.
2026-03-02
4,879 reads
A little Christmas fun for you using the spatial features in SQL Server and SSMS.
2025-12-24
4,352 reads
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Comments posted to this topic are about the item It's Never Just One Thing
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers