The Execution plan comparison feature (in SSMS)
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
1,014 reads
ASF 018: Mladen Prajdic interview
Introduction Mladen Prajdic is a Data Platform MVP from Slovenia. He’s been professionally programming for over 15 years, developing di?erent...
2019-01-25
195 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don't have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
18 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is...
2019-01-25
16 reads
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and...
2019-01-25
236 reads
Careful with Session_Context()–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-02-13 (first published: 2019-01-24)
2,222 reads
Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
316 reads
It’s always parameter sniffing (Part 2): SET options
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,536 reads
Don’t Forget To Take Break
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More often than not this leads to the “not seeing...
2019-01-23
14 reads
Don’t Forget To Take Break
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More...
2019-01-23
175 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