Daily SQL Server 2008 New Feature – Day 24
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-16
390 reads
I’d buy an iPhone4, but ….
I don’t trust ATT.
That’s saying something. AT&T, the company that built US telco, that gave us innovations from Bell Labs,...
2010-06-16
934 reads
Leaders in Meetings
As the owner of a meeting/discussion you have two options on how to drive the conversation, and which you use...
2010-06-16
395 reads
A Strange Twist in my life
As the plane was landing the other day for SQL Saturday in Pensacola, I was struck by how amazing my...
2010-06-16
810 reads
Building HTML Emails With SQL Server and XML
Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data...
2010-06-15
62,811 reads
Insert Unknown Row to Dimension Table
When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me,...
2010-06-15
1,433 reads
Hawaii is Not Prometric Microsoft Certification Test Friendly
While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...
2010-06-15
1,502 reads
Building A Remote Desktop Manager Connection List
Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...
2010-06-15
2,348 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
719 reads
The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
665 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