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
20 reads
Blog Posts
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
12 reads
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,281 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...
2018-08-21
35,323 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
77 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
17 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
318 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
198 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers