SQL Server SELECT

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

Tuesday, May 31, 2016

Multiple Rows of Tabs/Docs in SSMS

›
For a long time I felt like a crazy person for constantly closing documents in SSMS just because I could not easily access the documents tha...
Wednesday, March 5, 2014

SSIS Lookup Transformation Using Salesforce.com as a Data Source

›
Pragmatic Works offers a Salesforce.com Source component as part of its Task Factory SSIS component library. Using this component along wit...
Friday, February 28, 2014

RapidMiner jTDS Network error: IOException: Connection refused: connect

›
Network error: IOException: Connection refused: connect There a quite a number of reasons why you might get this error. However, as...
1 comment:
Monday, April 29, 2013

Identifying the source of SQL Server login failures (18456 errors) - Re-post

›
Great post on identifying the source of SQL Server login failures:  http://www.eraofdata.com/sql-18456-login-failures/
Wednesday, April 3, 2013

Connect to Analysis Services from Outside of Domain

›
You might find yourself in the unfortunate situation of having your SSAS server within a particular domain but your client machine in anothe...
3 comments:
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...
‹
›
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.