Reblog: July 19 to July 25
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-07-26
916 reads
Blog Posts
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,834 reads
SQL Server Login Errors
Hello Dear Reader. Quick blog today. If you are working in the SQL Server world eventually you will try to...
2013-07-26
1,039 reads
The SQLAndy Rules for Storing Credit Card Numbers
I’ll try to write more about these over the next couple months, but I wanted to write down a quick...
2013-07-26
1,133 reads
Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events
If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my...
2013-07-26
933 reads
70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,854 reads
Blog Images and PNG Compression
I’m not terribly good at putting at least one image in every post. The images I do use are either...
2013-07-25
948 reads
Crash when inserting to a FileTable with a parallel plan
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,379 reads
First Time Speaker
So this week was another first for me, I finally bit the bullet and gave a talk at the Leeds...
2013-07-25
780 reads
SQL – Query to find data,log,Total Size and other Useful information of all databases – SQL 2000/2005/2008/R2
I’ve encountered a situation where I need to find out the database file,log file, total size and other useful information...
2013-07-25
4,604 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers