CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,860 reads
Power BI Custom Visuals Class (Module 05 – KPI Indicator)
In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine”...
2016-07-05 (first published: 2016-06-28)
2,682 reads
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power...
2016-06-28
539 reads
BREXIT…IT professionals need a plan… much like the UK government
The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has,...
2016-06-28
498 reads
The Desktop Rebuild–Part 2
You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on...
2016-06-27
548 reads
Monday Morning SQL Break – June 27, 2016
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
897 reads
Debuting Talks at the Summit
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-27
527 reads
Announcing Workshop for SQLSaturday Porto 2016
I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called
SQL...
2016-06-27
470 reads
Perfectly Placed Parentheses
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....
2016-07-05 (first published: 2016-06-27)
2,917 reads
Retrieving the SQL Server License Key
Strangely enough its been a long time since I installed SQL in production. It’s almost always done by someone on...
2016-06-27
1,732 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