Notes from the February 2012 MagicPASS Meeting
I was back at MagicPASS last week to do a presentation, my first time with the group at the new...
2012-03-06
570 reads
Views in Use?
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the post on finding your linked servers, you can read...
2012-03-06
9 reads
Views in Use?
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the...
2012-03-06
687 reads
SSRS NoRows – Display a custom message when there is no data
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you...
2012-03-06
1,858 reads
How to log off remote desktop users from a remote machine ?
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,236 reads
SQL Server 2012 has released to manufacturing (RTM) - Hot MS News!
All, wanted to immediately share the news today from Microsoft regarding SQL Server: This just in from the MVP/MS Newsroom. I'm...
2012-03-06
1,641 reads
T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-06
1,233 reads
SQL Server 2005 to SQL Server 2008 R2 upgrade considerations
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped...
2012-03-06
1,184 reads
Choosing the Right Microsoft Reporting Technology Part 2: Excel
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...
2012-03-06
2,007 reads
Date Dimension Script with Fiscal Year
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over...
2012-03-06
4,182 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