I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
766 reads
Backing up a Certificate
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....
2012-03-07 (first published: 2012-02-27)
10,836 reads
Another 24 Hours of PASS
Nothing like a 24 hour barrage of SQL Server training for FREE!!! Did I mention it was free?
The PASS Data...
2012-02-27
620 reads
Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned
I was very surprised to see the results of my latest poll, which asked “When was the last time you...
2012-03-06 (first published: 2012-02-27)
4,842 reads
A Script A Day - Day 23 - Find an Object In Job Steps
Today’s script is one which saves me a lot of time on occasion. On large systems with lets say more...
2012-02-27
790 reads
End-User Microsoft BI Tools – Clearing up the confusion
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there...
2012-02-27
5,931 reads
The Armor of Transparency
Yesterday I blogged about hosting a daily status meetings and some of the tricks I use to make it work....
2012-02-27
651 reads
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...
2012-02-27
1,469 reads
I’m speaking at SQL Rally 2012
I’ve learned that my session entitled “Introduction to Data Quality Services” has been selected as one of the community choice...
2012-02-27
684 reads
SSRS 2008 Error – The report definition is not valid
Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and...
2012-02-27
4,726 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