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
25 reads
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
19 reads
Deploying To a Power Bi Report Server with PowerShell
Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...
2018-09-04 (first published: 2018-08-21)
5,914 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
29 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
205 reads
Organizer's Thoughts on our STEM Kid's Track at SQLSaturday Baton Rouge
New this year to #SQLSatBR that was really nice for us - we hosted a kid's STEM track leveraging an existing children's education organization operated by the STEMupBR program...
2018-08-20
21 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...
2018-08-20
260 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
323 reads
The Good The Bad and The SLA
Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...
2018-08-20
270 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
224 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers