SQL Server SELECT

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

Wednesday, July 28, 2010

Visual Studio 2010 Database Projects - MSBuild Issue

›
I've recently begun using Visual Studio 2010 database projects (DBPro). I think it's a great tool and having been a .NET developer f...
1 comment:
Monday, July 26, 2010

Report Functional Requirements - Too Often Overlooked

›
A template for what follows can be found on my personal  website . Reports are often an afterthought and commonly believed to be an easy t...
3 comments:
Thursday, July 15, 2010

Data Warehouse vs. Data Mart

›
II'm currently working on a Business Intelligence project and depending on who I am talking to we are either building a Data Mart or a D...
Monday, June 21, 2010

DISTINCT or GROUP BY?

›
GROUP BY and DISTINCT can return the same results when looking for uniqueness in a resultset. Consider the Sales table below. Store     Pr...
2 comments:
Wednesday, June 16, 2010

Unique Constraint or Unique Index?

›
A few things to keep in mind when deciding whether you want a unique index or constraint. 1) The index creation options other than FILLFAC...

SQL Formatter Is Great for Auto Generated SQL

›
Ever had to try to decipher SQL that was generated by a report writer or sql generation tool such as Cognos Framework Manager? How about try...

SSIS Extracting Reading from Oracle 10g

›
Here are a few hints if your extracting data from an Oracle database using SSIS. 1) Use Oracle 11g client. The 10g client has bugs around ...
2 comments:
‹
›
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.