SSRS R2 - Naming Excel Worksheet Tabs
I was recently asked if it was possible to name an excel tab based on a page in a reporting...
2010-06-21
2,727 reads
PASS 2011 Spring Event In Orlando
In March of this year the PASS Board of Directors began kicking around the idea of holding some kind of...
2010-06-21
885 reads
SQLSaturday Schedule Changes
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
492 reads
2010-06-21
1,657 reads
SQL Server MasterClass
This Thursday gone, (June 18th) I went to a hotel near Heathrow airport in London for what was titled a...
2010-06-21
813 reads
Feature Packs for SQL Server (and SSIS)
Some of the best extensions for Integration Services (and SQL Server itself) are found in what Microsoft has released as...
2010-06-21
2,084 reads
T-SQL - Finding Changes
Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table...
2010-06-21
4,143 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,034 reads
SQL Server MasterClass Event Review
I often begrudge a 5am start to travel anywhere, let alone to SQL events but this was a trip definitely...
2010-06-19
530 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
874 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