SQL Server SELECT

SELECT [tips tricks and commentary] FROM [my experiences] WHERE subject IN ('database', 'data warehouse', 'business intelligence')

Monday, December 21, 2009

T-SQL End of Previous Week, Month, Quarter, Year

›
I recently had a requirement to capture periodic snapshots of an incident/activity type OLTP table into a fact table. I already had an accum...

Cognos 8.3 -- Framework Manager -- Model objects and shortcuts

›
I was recently tasked with creating a relational model in Cognos Framework Manager and got a little confused when deciding what kind of obje...
Monday, December 14, 2009

SSIS Error Codes (Hresults)

›
Ever get an Hresult error code and have no idea what it meant or how to figure out what it's related to? The SSIS run time engine and ...
Tuesday, December 8, 2009

SQL Server 2005/2008 Maximum Server Memory - What should it be?

›
While questions like this don't have black or white answers there is some simple guidance here . . . You probably want to change it fr...
Monday, December 7, 2009

Cognos 8.3 and SSAS 2005 - Not So Good

›
It's a rare day that I concede defeat but today was one of those rare days. I threw in the towel on migrating existing Cognos Report Stu...
Sunday, December 6, 2009

Process More Than One SSAS Object At a Time in SSMS

›
Durrr . . . sometimes I discover something so simple all I can say is "durrrrrr". I've been working with SSAS for over 2 years...

What's That Confounded Character?? (ASCII and CHAR Functions)

›
I was on my way back from the kitchen at my client's site when I passed the office of one of their developers. We made momentary eye con...
1 comment:
‹
›
Home
View web version

About Me

My photo
d.elish
Everywhere & Nowhere in My Airstream Trailer
Delivering bulletproof, data-centric software solutions to organizations such as Disney, PwC, Cymer, Boston Scientific, the Pittsburgh Steelers, Blue Cross Blue Shield of Massachusetts, Irving Oil, Bain Capital, LoJack, PETCO, and State Street Bank for over 14 years. Driven by a passion for problem solving, technology, and profitability.
View my complete profile
Powered by Blogger.