How Do Azure Accounts and Subscriptions Work Together?
Azure accounts vs. Azure subscriptions – often a topic that brings some confusion to Azure newbies. Are they the same? What’s...
2018-08-28
205 reads
Blog Posts
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
11 reads
Ignoring NULLs with FIRST_VALUE
Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...
2018-08-28
8,949 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
14 reads
MAXDOP Calculator
Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance...
2018-08-28
14,079 reads
Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,731 reads
More on Two Posts About PASS
Yesterday I linked to two really interesting posts about PASS and I hope you read them. I’ll start with a...
2018-08-28
240 reads
Redgate Lives DevOps
At Redgate, we release a lot of changes to our products. In fact, this is the “About Redgate” slide I’ve...
2018-08-28
1,116 reads
Top 5 Reasons You Should Be Excited About Power BI Composite Models
In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited...
2018-08-28 (first published: 2018-08-13)
3,008 reads
TSQL Tuesday #105: WrapUp
When I hosted this past TSQL-Tuesday, I fully expected to have the wrap-up done a few days later. Lots of...
2018-08-28
234 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