Be in the SQL Yearbook
I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be...
2018-09-06
278 reads
Moving On To New Adventures
I am pleased to announce that as of September 10, 2018, I will be part of the SQL Data Partners...
2018-09-06
248 reads
Decision tree on the pattern of choosing how to pass data to a procedure
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
346 reads
T-SQL: How many bananas tall are you?
So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September...
2018-09-06
329 reads
Join Me At PASS Summit 2018
The PASS Summit 2018 schedule has been published, and I’m on it twice! On Monday, November 5, I am giving...
2018-09-06
282 reads
How to Get Developers Using Azure
You know the talk out there, everyone is moving to the cloud and people are looking at Azure to get...
2018-09-06
297 reads
Fix: When an Availability Group listener’s IP is stolen
When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener,...
2018-09-05
896 reads
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
280 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free. As mentioned in my blog Azure...
2018-09-05
138 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,555 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