Flipping Sides in SQL Operations Studio
I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...
2018-08-08
483 reads
Exporting Extended Events Session Data to a Table
If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...
2018-08-23 (first published: 2018-08-08)
2,374 reads
Tracking Down tempdb usage
Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues. Luckily SQL...
2018-08-08
9,919 reads
Why you should not use SELECT *
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...
2018-08-08
482 reads
Putting Object Explorer etc on the right side of SSMS rather than the left.
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....
2018-08-08
306 reads
MVP for Another Year
I am a little late in posting this, but I still wanted to share. It is a huge honor to...
2018-08-08
367 reads
Azure Training in London
I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...
2018-08-08
373 reads
A Day in the Life (1/?) - August 7, 2018
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
13 reads
NTFS Compression and SQL Server Do Not Play Well Together
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
23 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,289 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