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,683 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
528 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,921 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,748 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers