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-17
792 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This course targets IT professionals that design and maintain Linux...
2016-06-17
15 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This...
2016-06-17
788 reads
Why is creating excel sheets from SSIS so hard ?
If there is one process that should be simpler than it is out of the box, it is creating Excel...
2016-06-17
1,462 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
23 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
728 reads
Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
350 reads
SSMS Tools Pack - A Handy Tool for generating CRUD
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,944 reads
Selective Logging with the UPDATE() Function
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,390 reads
When were statistics updated?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-16
659 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