Skip to main content

Search This Blog

Subhash Subramanyam' s BI Blog

I felt it's useful to post blogs on Topic of Interests on Microsoft Sql Server BI, Technical articles and links, Issues and Workarounds came across while working on Projects. Thanks for those who visit my blog. By the way, Please post your feedback if it was useful to you..

Posts

Converting non-ansi = or = to SQL 92 type / ansi joins

Get link
Facebook
X
Pinterest
Email
Other Apps

Did you know that ISNULL function can take Query as a parameter ?

Get link
Facebook
X
Pinterest
Email
Other Apps

System Table Queries (2000)

Get link
Facebook
X
Pinterest
Email
Other Apps

Passing DataTable into a StoredProcedure

Get link
Facebook
X
Pinterest
Email
Other Apps

List of all Procedures and dependant Tables that are updated using linked server

Get link
Facebook
X
Pinterest
Email
Other Apps

Query to get a list of foreign key constraints for a table

Get link
Facebook
X
Pinterest
Email
Other Apps

Keep a check on your IDENTITY columns in SQL Server

Get link
Facebook
X
Pinterest
Email
Other Apps

About Data Profiling Task in SSIS 2008

Get link
Facebook
X
Pinterest
Email
Other Apps

My feedback for SQL Server 2008 February CTP-6.

Get link
Facebook
X
Pinterest
Email
Other Apps

An approach to Load fact and Dimension tables

Get link
Facebook
X
Pinterest
Email
Other Apps

December 29, 2007

Useful Oracle SQL PL/SQL Code Snippets for my Reference

Get link
Facebook
X
Pinterest
Email
Other Apps

Newer Posts Older Posts Home

Powered by Blogger

Theme images by Anna Williams

BI Archive

September2
June1
April2
March4
March3
December3
November3
October4
September2
July2

May1
April1
March1
February1
January1
December1

Show more Show less

Labels

Data Type Casting and Conversions1
Oracle1
Running SSIS on X642
Sql Server 20051
Sql Server 2005 Installation Issues1
Sql Server 2008 February CTP-61
SSAS4
SSIS10
SSIS 2008 February CTP-61
SSRS1

T-SQL Programming9
TSQL Programming3
VB.NET1

Show more Show less

Report Abuse