Enigma

Google Talk

Enigma — Wed, 24 Aug 2005 08:58:00 GMT

Its been only five minutes since I downloaded Google Talk ... the new IM client from google and its already on my "DON'T USE" Instant Messengers list.

I take a strong exception to the fact that the voice call feature automatically un-mutes my speakers so as to give me a ring or when I make a call to another user. Other than that seems good .. but does not have enough features yet .. maybe because it is in beta.

Free E-Learning Courses

Enigma — Tue, 02 Aug 2005 05:15:00 GMT

I don't know if it has been blogged about before .... but Microsoft is giving away free E-Learning courses for SQL Server 2005. Offer is valid till November 1, 2005 ... so make the best out of it.

https://www.microsoftelearning.com/sqlserver2005/

Also for the Dot Net guys ... you got some free goodies too ....

https://www.microsoftelearning.com/visualstudio2005/

Back to Blogging ...

Enigma — Fri, 29 Jul 2005 11:16:00 GMT

I've been away from blogging for a long time now ... and now that I am back I will be multi posting my blog content at three places :

1. http://sqlserverarena.com/communityserver/blogs/enigma/

2. http://sqljunkies.com/weblog/enigma

3. http://blogs.msdn.com/enigma

I would be blogging a lot about SQL Server 2005 , Analysis Services 2005, Reporting Services 2005 and SSIS as my current work would be revolving around these. So keep watching this space.

Worth a look !!!

Enigma — Wed, 27 Jul 2005 09:23:00 GMT

http://www.escapeyesterworld.com/

Your chance to escape from the Yesterworld ...

Missing Me ???

Enigma — Mon, 25 Jul 2005 08:52:00 GMT

Ok !!! I know I have broken the rule ... I should be blogging more often and not let the blog die down ...

But I am back now !!!

To update you on what's been happening in my life :

I have joined the corp as a Senior App Developer and would be working out of Hyderabad, India. Moved to Hyderabad a few days ago and am finding it a really cool place.

I will be working on SQL Server 2005 and hope to blog about my experiences soon ( I think I have identified a bug but need to relplicate it across another machine / check the bug database ) before I submit it to the SQL Server Dev Team.

Once again ... I hope not to disappear again into the mist ... and will keep updating the blog.

My Bad !!!!

Enigma — Sat, 12 Feb 2005 04:20:00 GMT

Hey Rob ...

Thanks for correcting that mistake of mine ....

Apologies for not testing my code to the extent that I should have done .....

Please take a look at your First and Last Day of a Quarter example.
ARTICLE: http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

DECLARE @Date datetime SET @Date = '10/21/04'
--First Day of the Quarter
   SELECT DATEADD(qq, DATEPART(qq, @Date), DATEADD(dd, -(DATEPART(dy, @Date) - 1), @Date)) [First Day of the Quarter - INCORRECT],
          DATEADD(qq, DATEPART(qq, @Date) - 1, DATEADD(dd, -(DATEPART(dy, @Date) - 1), @Date)) [First Day of the Quarter - CORRECTED]
   PRINT ''
--Last Day of the Quarter
   SELECT DATEADD(qq, DATEPART(qq, @Date) + 1, DATEADD(dd, -(DATEPART(dy, @Date)), @Date)) [Last Day of the Quarter - INCORRECT],
          DATEADD(qq, DATEPART(qq, @Date), DATEADD(dd, -(DATEPART(dy, @Date) + 0), @Date)) [Last Day of the Quarter - CORRECTED]
   PRINT ''

Excellent article; keep up the good work.

Rob

PS : Not unit tested this code too ... didn't get the time .... hope this does not screw up in some other case ... apologies again !!!!

MDX Query generator tool

Enigma — Sat, 22 Jan 2005 05:18:00 GMT

Though the guys at microsoft may not have projected it as such, but I find Excel 2002/2003 Add-in for SQL Server Analysis Services a great way to generate MDX queries.

Getting MDX to get specific result sets for reports sometimes gets to be a tricky thing ... this add in solves the problem for you ... here's a screen-shot.

Also .. would just like to know .. if you are a regular reader of my blog ... other than the two I know I have

If yes ... please leave a comment below !!!

Dilbert for 26 Dec 2004

Enigma — Sun, 26 Dec 2004 15:29:00 GMT

Somehow, this reminds me of .... www.thedailywtf.com

Christmas Gifts !!!

Enigma — Fri, 24 Dec 2004 00:56:00 GMT

36 gmail invites to be given away ...

The conditions for getting an invite :-

1. You must be the owner of a website.

2. You need to tell me the site address and the name of Content Management Software you are using (I need to know this to decide on the CMS for my website).

3. I need a valid email address to send the invite to ...

4. You can choose the number of invites you get, if you help me configure the CMS on my site -> www.sqlserverarena.com

Community Server Now Available !!!

Enigma — Wed, 22 Dec 2004 05:15:00 GMT

Via http://dotnetjunkies.com/WebLog/richard.dudley/archive/2004/12/22/38213.aspx

Every day or so, I make it a point to check out the new controls in the ASP.NET Control Gallery. Right there on top today is this one:

Previously known as ASP.NET Forums, Community Server is a knowledge management and collaboration platform that includes a powerful forums engine, a blog engine, and a photo gallery engine. Used by Microsoft, Autodesk, Intel, and many other companies as the platform of choice for building communities.

http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=2443&tabindex=2

Update : Looks like I may have jumped the gun . The Download link on the page still takes me to Community Server :: Forums.

Just found out about my long lost brother !!!

Enigma — Tue, 21 Dec 2004 21:22:00 GMT

http://www.mymactech.com/blog/MeDrivingAt70MPH.jpg

http://sqljunkies.com/Content/enigma/Enigma.jpg

This one definitely made me go “WTF” !!!

Thanks to my buddy Melroy for pointing this one out !!!

Oracle buys Peoplesoft !!!

Enigma — Mon, 13 Dec 2004 21:19:00 GMT

As per this news ... with PeopleSoft's board of directors approving the $10.3 billion takeover deal with Oracle.

I had been expecting this to happen for a long, long time ...

Webcast - MSDN Webcast: Introducing the New SQL Server Management Studio

Enigma — Tue, 07 Dec 2004 04:58:00 GMT

Have been sitting in the office at 3:13 in the night just to listen to the latest about Yukon straight from the SQL Server Team. So far as I can see, both the webcasts have been full house and the team is being innundated with queries.

Bill Ramos will be putting out the queries on his blog ... so be on the lookout for a really long post from him soon ...

Have been learning a lot about the new tools from his webcasts, things I never knew we could do ...

Thanks Bill ... you ve increased my productivity a lot today !!!

Weblogs on my site are finally up !!!

Enigma — Sun, 28 Nov 2004 02:53:00 GMT

Finally managed to set up the aggregate page on my site up and running ... :)

Currently I am hosting two weblogs ... i.e Harshal and me .

The new url for our blogs is

Harshal :- http://sqlserverarena.com/weblog/sqldude

RSS :- http://sqlserverarena.com/weblog/sqldude/Rss.aspx

and

Me :- http://sqlserverarena.com/weblog/enigma

RSS :- http://sqlserverarena.com/weblog/enigma/Rss.aspx

Any SQL Gladiators out there who wanna blog ??? I will be more than happy to set up a blog for you. Just mail me at sqlapostle@gmail.com with your details.

Update : Still having problems with the OPML ... hope to get that fixed soon :)

Cease and desist !!!

Enigma — Wed, 24 Nov 2004 00:47:00 GMT

Wow !!! Ted Neward has been served a "cease and desist" letter by Sun for Javageeks.com use of Sun's trademarks in its company name, as well the other uses of Sun's trademarks on the www.javageeks.com web site which they say are inconsistent with Sun's Trademark and Logo Usage Requirements.

Hey, this leads me to think twice about using any images related to SQL Server on my upcoming site www.sqlserverarena.com !!! So the question that is obviously bothering me is, “What are Microsoft's rules on use of its trademarks on a community site ?”