Talking Data: Six Word Stories
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
337 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,137 reads
ARM vs Classic Deployment in Azure
When Azure Resource Manager (ARM) was created back in 2014, I (like many) thought, “What does that mean?” Up until...
2018-08-30
317 reads
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
362 reads
Custom Data Purging in SQL Monitor
In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a...
2018-08-30
412 reads
The unwanted Side Effects of enabling Read Committed Snapshot Isolation
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-30
2,448 reads
Helpful Undocumented Stored Procedure “sp_MsForEachDB”
This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called...
2018-08-30
283 reads
How Azure Storage Kick Starts Your Big Data Projects
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
987 reads
Employee Agreements & Contracts: Best Practices (23 minute video)
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
32 reads
Next week is SQL in the City Streamed
This picture is out of date. I’ll make sure we get a new one next week at SQL in the...
2018-08-29
370 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