October 2004 - Posts

The ultimate application pack for your Win XP machine - coz MS says so

Microsoft comes out with the Microsoft Partner Pack for Windows XP and calls it the ultimate application pack for the Win XP PC.

Well, I am in the process of downloading the pack and verifying the claim ... till then you can hop over and get a copy for yourself ...

And did I forget to say .. it is FREE ...

One of the components listed in the individual downloads is the Google deskbar ... weird !!!

 

posted Thursday, October 28, 2004 9:00 PM by Enigma with 0 Comments

Does a .Net component for this exist ??

Am seaching for a dot net component that can display the dimensions of a cube in the same way as the Analysis server (like shown above).

Does anyone know of any such component ?

posted Monday, October 25, 2004 1:39 PM by Enigma with 0 Comments

Where did my data go ???

How many times has this happened to you ??

Brett has come up with a great script to solve your problems .... you can find it here .

 

posted Thursday, October 21, 2004 3:43 PM by Enigma with 0 Comments

Create Default deprecated ???

As the SQL Server 2005 Beta 2 documentation says

“Create default will be removed in a future version of SQL Server”.

What I am confused about is why this is being done ? It was a good way to set default values which could be associated across the database for data consistency.

I had just dicovered this wonderful command and now its going away :( ...

Any explanations, guys ???

posted Wednesday, October 20, 2004 2:08 PM by Enigma with 0 Comments

I 'll be watching you !!!!

Just for this post ... I have put a small site statistics html code into my posts. Just want to have an idea about my aggregator readership ... hope you guys wont mind. I am currently using www.statcounter.com to track the visitors.

free hit counter
posted Monday, October 18, 2004 2:23 PM by Enigma with 0 Comments

.Net Developer Required

A position for a .NET developer is open on my Team.

A candidate with at least 3 years experience in .Net is required (ASP.NET, VB.NET ...C#,SQL Server will be an added advantage).  Position is based in Mumbai in one of the biggest IT consulting firms in the world.

If you are you interested ... rush in your resumes to me.

 

posted Friday, October 15, 2004 2:40 PM by Enigma with 0 Comments

SQL !!!

Thanks to Lou Schilling for pointing me back to why I originally started blogging on SQL Junkies. I started with the intention of talking about SQL and sharing whatever little knowledge I had, but somewhere down the line I deviated and started blogging about whatever I found interesting. I agree, that this one of the best sites for SQL related stuff , we should keep our personal rants to a minimum.

Ok!! Back to talking about SQL ...

One of the latest discoveries I have made (at least it was a discovery for me ...) is

CREATE DEFAULT

and

sp_bindefault

As for me, I find them identical in purpose to the User-defined data types ...

However .. this is what worries me ....

Defaults, a backward compatibility feature, perform some of the same functions as default definitions created using the DEFAULT keyword of ALTER or CREATE TABLE statements.

Is this still there in SQL Server 2005 or not ???

Watch out for an article on the same topic on SQL Junkies soon !!!
posted Friday, October 15, 2004 7:41 AM by Enigma with 0 Comments

WTF - Unable to download WMP10

Inspired by the post from Brandon Paddock, I set out to install WMP10 on my Laptop ( which incidently serves as my development server ).

The link to instructions is here. 

However, Microsoft has somehow decided that it wont allow a user of Windows 2003 to download the setup of WMP10. Here is the message that is displayed.

Windows Media Player Download

Setup detected that you are running: Windows 2003 Server

Windows Media Player 9 Series (for Windows XP)

Get fast and flexible playback with the best audio and video quality for Windows and the Web. Includes special new features optimized for Windows XP.
Total Size: 9,660 KB   45 min @ 28.8 Kbps

So, I was searching around for an alternative and found none .... Can anyone point me to a link where i can download the installable package ?

Update : Here is the link to download the Setup--> http://go.microsoft.com/fwlink/?Linkid=34505
posted Thursday, October 07, 2004 11:40 AM by Enigma with 0 Comments