FizzBuzz and Multiple Recursive Member CTEs
Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...
2018-08-21
9 reads
Blog Posts
Power BI Custom Visuals Class (Module 114 – Overview by CloudScope)
In this module you will learn how to use the Overview by CloudScope. The Overview by CloudScope show a list...
2018-08-21 (first published: 2018-08-07)
2,280 reads
Power BI: Dataflows
Dataflows, previously called Common Data Service for Analytics as well as Datapools, will be in preview soon and I wanted...
2018-08-21 (first published: 2018-08-03)
3,171 reads
SQL Server Error 5123 Attach Database - Resolution
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This error is a kind of permission error that occurs...
2018-08-21
65 reads
SQL Server Error 5123 Attach Database - Resolution
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This...
2018-08-21
35,287 reads
SQLSaturday Orlando–Power BI On-Premises In A Day
Please join me for a day of developing and deploying Power BI reports in an On-Premises environment. This event is a pre-conference session on the Friday before SQLSaturday #801...
2018-08-21
14 reads
Actual Execution Plan Costs
Why don’t “actual execution plans” have “actual execution plan costs”? This is a question and a myth I have to...
2018-08-20
317 reads
Granting CONTROL on a database–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-20 (first published: 2018-08-09)
1,825 reads
Midlands PASS Restart – October 2, 2018
The Midlands PASS Chapter, a local group of PASS, will restart on October 2nd, 2018. We will be meeting at...
2018-08-20
196 reads
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours...
2018-08-20
218 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