Why my way of writing SQL is superior
⚠️ It’s hard to convey sarcasm over the text. I’m putting this disclaimer at the top so I don’t come off egoistic. This post is meant as hyperbole, and...
2022-04-13
24 reads
Ensuring SQL Compare Checks Synonyms
I was running a PoC for a customer and they noticed that synonyms were being missed when they changed the database being used. It was surprising to me, but...
2022-04-27 (first published: 2022-04-13)
167 reads
Choco upgrade, y’all
Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea is this: when you’re...
2022-04-13
76 reads
Daily Coping 13 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-13
21 reads
RunAsRadio- Query Performance Tuning Strategies
Had a great time talking with Richard on RunAsRadio about Query Performance Tuning Strategies, check it out. How do you keep your SQL queries fast? Richard chats with Monica...
2022-04-27 (first published: 2022-04-13)
389 reads
Online Training Courses
Today Paul sent out the quarterly numbers to the team letting us know the hours our courses have been viewed during March. Being a data guy, I decided that...
2022-04-25 (first published: 2022-04-12)
428 reads
T-SQL Tuesday #149–Advice about T-SQL to a Younger Me
It’s that time of the month again, when we have the T-SQL Tuesday blog party. This month we have a new host, Camilia Henrique with an invitation on advice...
2022-04-12
152 reads
T-SQL Advice For Young, Old, and even Eccentric
Be mindful of advice. Give an ear to those offering it. Just be mindful, there is no need to accept the advice, but it is wise to at least...
2022-04-22 (first published: 2022-04-12)
852 reads
Webinar – Intro to Azure Data Factory
I’m excited to announce I’m giving a webinar for MSSQLTips.com, with “Introduction to Azure Data Factory” as the subject. The webinar will take place at Tuesday May the 3th,...
2022-04-12
59 reads
Daily Coping 12 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-12
25 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers