My Experience

Nikon CoolPix S100 PJ, concept and features available in this camera are impressive. With option of Projector this is the looks like best camera to be owned. Take a look at nikon's website: http://www.nikonusa.com/Find-Your-Nikon/Product/Digital-Camera/26236/COOLPIX-S1100pj.html

Let me know your opinion.

Wait for new one :)

Continue reading...

This Error occurs for some strange reasons. To overcome this error, just register XML3 and XML6 version. Commands to register XML Version.
regsvr32 msxml3.dll
regsvr32 msxml6.dll

More on this error: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/3bd72b8a-aa9e-4cb9-8d3c-5a623c026e62/

Hope this would help someone with error in SSIS Package.

Regards,
Rajesh
Continue reading...

Insert into <Table> (<Col1>,<Col2>)
Values (<Val1>,<Val2>),
Values (<Val3>,<Val4>);

Continue reading...

Hi,

Adding Network Login to Analysis Service without creating dedicated user or static user.
1) RDC to Server
2) Properties of the Analysis Server in SSMS
3) Add User, search for users in groups and add.

More in details latter.

regards,
Rajesh

Continue reading...

Hi All,

My new learning. Have you ever comeacrossed any time for requirement to select data from one tabe and not in second table. I guess everyone would have atleast this scenerio. There are plenty of ways of doing, either union all and do not exists or full join and .....

Today I found easy ways.
1) in Oracle we have minus operator which would result difference of two tables
    Eg: Select * from Table1 minus Select * from table2 (I am not sure with syntax in Oracle)
2) In SQL Server 2005 on war...
Continue reading...

In this post I am posting link, for truncating all log files in Database. link: http://sharepoint-geek.com/2010/04/07/shrink-all-log-files-within-a-ms-sql-instance/

Snapshot of the Script Just incase if removed from above website:

Continue reading...

Hi,

I thought to list few SQL Server 2005 system tables, stored procedures which could be used in daily DBA activities. The ones which mostly used
1) Information_Schema.Tables : Holds information of available tables in Database
2) Information_Schema.Columns: Lists all columns from all tables in specific Database
3) sp_MSforeachdb: usefull for free up disk space, e.g., Shrink Command. There is are some limitations of using shrink command thats in next post if I get time to post. E.g. Exec sp_msfor...
Continue reading...

Hi Folks,

In this post I would like to talk about Microsoft Analysis Services. I am amazed by the way Microsoft does aggregations in Analysis Services. Reason for me to write this post is, I ran into problem in Analysis services with Measure. I saw data in Measure, but after processing data was not stored in Measure. So after hours of debuging and analysis this is my finding and trust me it works great. In Analysis service in Calculation there has to be first code with "Calculate" if by mistak...
Continue reading...

Hi All,

This is one heck topic which I cant forget to update on my website. I have spent two weeks figuring way of the this. 

Problem: I have job scheduled to execute SSIS Package which imports data from Excel. It was failing with weired Messages.
How I Solved ? I searched web for resolution and found its problem with Connection Drivers. SQL Server 2005 64 Bit Version will not support any Excel Dataloads. This is statement from Microsoft, isn't it amazing ? And I was looking for "dtexec" Utility...
Continue reading...