Service Broker Solutions - Don't Forget the Basics
After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it...
2010-04-03
916 reads
A T-SQL Holiday Message
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)
INSERT INTO...
2010-04-03
731 reads
A DMV a Day – Day 3
The DMV for Day 3 is sys.dm_os_sys_info, which is described by BOL as:
Returns a miscellaneous set of useful information about...
2010-04-03
1,078 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...
2010-04-02
85 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...
2010-04-02
39 reads
Winner of the March SQL Aloha Contest
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
424 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,473 reads
Speaking Seven Times in April
April will be a busy month for me as I will be speaking seven different times, on seven different topics,...
2010-04-02
450 reads
The Best vs. The Good Enough
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
472 reads
The Way - The Reason
This is one thing outside the SQL World, but it has very strong place in every aspects, it is one...
2010-04-02
622 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
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,...
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