Another MVP Award and a Few Thoughts
I got the news of my MVP award last week. I’m honored that Microsoft feels I do quite a bit...
2018-07-09
352 reads
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,816 reads
SQL Agent for Azure SQL Database? Not quite
The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is...
2018-07-16 (first published: 2018-07-09)
2,403 reads
Power BI Custom Visuals Class (Module 110 – Icon Map)
In this module you will learn how to use the Icon Map. The Icon Map allows you to display your...
2018-07-17 (first published: 2018-07-09)
2,406 reads
Apache Hadoop Ozone+HDDs and Kubernetes
As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with...
2018-07-09
711 reads
Finding Unused Indexes
Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not...
2018-07-07
539 reads
Finding Missing indexes
Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...
2018-07-07
428 reads
Kubernetes
Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers,...
2018-07-06
327 reads
Microsoft Acquire GitHub after Linkedin
Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering...
2018-07-06
398 reads
Setting Up Pi-Hole.Net
I saw a tweet a short time ago from Drew Furgiuele about pi-hole.net. He noted this was a near use...
2018-07-06
480 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