A “Business Intelligence” (BI) Definition
[read this post on Mr. Fox SQL blog]
Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions...
2016-01-19 (first published: 2016-01-11)
2,781 reads
Blog Posts
Advent of Code – Day 1 – Parsing a variable
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
285 reads
Change Availability Group Endpoint Port
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can...
2016-01-19
1,743 reads
How to Solve the Tail Insert Problem
In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s...
2016-01-19
1,362 reads
Name Your Defaults So SQL Server Doesn't
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...
2016-01-19
21 reads
Natively compiled user-defined functions
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
4,275 reads
New SQL Blogging Challenge
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
415 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO! I’ll talk to you about this subject because I’m not normal. Still, my goal is that...
2016-01-19
53 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO!
I’ll talk to you about this subject because...
2016-01-19
1,704 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,035 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
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers