Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,526 reads
Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
607 reads
A Better (Free) Search in SSMS
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,077 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016. My...
2016-06-14
21 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at...
2016-06-14
143 reads
What’s New in Reporting Services 2016
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long...
2016-06-21 (first published: 2016-06-14)
5,423 reads
Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)
In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual. The Hexbin Scatterplot is...
2016-06-23 (first published: 2016-06-14)
2,910 reads
Because
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
536 reads
OmniCompare: A free tool to compare SQL Instances
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,875 reads
It’s 2016 RLS for T-SQL Tuesday #79
It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write...
2016-06-14
1,135 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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