SQL Server SELECT

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

Monday, November 26, 2012

Team Foundation Service (TFS) Preview with Visual Studio 2008 (and BIDS)

›
It is now possible to use the Team Foundation Service Preview (Microsoft hosted TFS) with Visual Studio 2008 and BIDS (VS 2008 Shell). 1)...
1 comment:
Wednesday, October 3, 2012

The feature: "Shared dataset" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

›
Ouch. I was recently working on a project that started with SQL Server 2008 R2 Standard Edition and eventually ended up with SQL Server 2...
Monday, August 27, 2012

Publish SSDT Projects Without Visual Studio Using SqlPackage.exe

›
If you'd like to publish your SSDT database project but don't have access to your target database from the machine you run Visual St...
Wednesday, August 22, 2012

SSDT: unresolved reference to object [dbo].[sp_executesql].

›
Procedure: Some_Procedure has an unresolved reference to object [dbo].[sp_executesql]. Look familiar? There's a simple solution. W...
Tuesday, August 14, 2012

Creating a CLR Function in SSDT

›
Creating a CLR function in SSDT (SQL Server Data Tools) is not very difficult but if you've never done it before you might be wondering ...
Friday, August 10, 2012

SSIS Event Handlers: Behavior In Package Hierarchy

›
I recently stumbled onto what seemed to be an odd performance problem in an SSIS project I was working on. The problem was that I had a nu...
2 comments:
Thursday, July 19, 2012

Visual FoxPro Upsizing Wizard

›
If you're in the unfortunate position that I recently found myself in and need to move data from a Visual FoxPro (VFP for the die-hards)...
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.