Finished a successful session on basics of SQL Server 2008 yesterday.

Finished a successful session on basics of SQL Server 2008 yesterday.

• Started from the basics of how to install SQL Server 2008,

• How to Open the same,

• What is the Use of it.

• Explained the Interface of SQL Server Management Studio

• Started with SQL Queries Syntax. ( I took the reference from w3schools.com for the same)

I was able to cover up to the following topics yesterday :

SQL Basic

SQL HOME
SQL Intro
SQL Syntax
SQL Select
SQL Distinct
SQL Where
SQL And & Or
SQL Order By
SQL Insert
SQL Update
SQL Delete

SQL Advanced

SQL Top
SQL Like
SQL Wildcards
SQL In
SQL Between
SQL Alias
SQL Joins
SQL Inner Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Union

Still there are more topics to cover. Enough time was not there yesterday. So would take up a Part-2 soon on this.

Got a fan for my session yesterday. Her name is Lisha and she is from US.

Hyderabadtechies owner chandu asked her also to join with me to take the second part of my SQL session.

So got a team member to offload my work ;)

Tonight @ 9PM stay tuned to hyderabadtechies to listen to my C# Session :

Here is the meeting URL :

https://www.livemeeting.com/cc/usergroups/join?id=C8KW4C&role=attend&pw=gGr%5E7%23dhc

For more details on how to install live meeting and how to join the sessions, Read my previous blog posts.

How to enable connections tab, autoconfig, proxy, and set proxy server thru registry settings

The following snapshots would show you what are all the keys that you need for setting up

the registry settings in such a way that your connections tab in IE gets enabled and also for editing your proxy server.

See the rounded places below.

Those are the places where exactly you need to have all these keys.

The values need to be set to 0 for enabling and  1 for disabling.

If you still have more doubts you can mail me.. i would write another blog in detail :)

Adding a value to a 'datetime' column caused overflow.

Adding a value to a 'datetime' column caused overflow.

Came across this error today. So thought of posting the same.

Whenever you try to do a dateadd like this 

dateadd(mm,12,datefield)

you might face this error if the value in your records in the datefield is not a valid date or

if u add some months or date to this value and the output of that will exceed the date range

In my case i was just thinking what would be the error here.

But unfortunately there was some data in the table which was there with the value

(Ex:date of joining column)

1-1-9999

So my sql statement has tried to add 12 months to this and it had caused this error.

URL for attending my sessions in HyderabadTechies.info

URL for attending my sessions in HyderabadTechies.info

1. Get Speakers / Headset if you dont have one

2. Download Microsoft Office Live Meeting 2007
Here is the Download Link - Click Accept Terms and conditions
http://office.microsoft.com/en-us/help/HA101733831033.aspx

Once the above part is done.
Please proceed with the next step

3. Here is the URL for my attending my sessions in HyderabadTechies
https://www.livemeeting.com/cc/usergroups/join?id=C8KW4C&role=attend&pw=gGr%5E7%23dhc

4. You can also join to our Hyderabadtechies website as a member to get a lot of benefits.
Click here to join as a member

5. Stay tuned to this website to listen further sessions on new topics and technology advancements from me and my friends.

TECH ABC @ hyderabadtechies.. Grand event of March begins from 22nd March

TECH ABC @ hyderabadtechies.. Grand event of March begins from 22nd March

 

Hyderabadtechies.info is back with its online sessions.. After great success of February Fever with 50+ Online sessions and speakers across the globe it has just took a quick gap of few days for online sessions planning for more exciting events.. We appreciate your particpation for all the events that are conducted.. Tech Five Stars was an open judgement platform and it has picked up Five TECH Stars.

 

Even am taking some of the sessions here..

 

For More details on this month sessions. Click here.

Some awards and appreciations at Hyderabadtechies.info

I have got some awards and appreciations at Hyderabadtechies.info for the sessions that i
have presented in the site last month.

I have presented sessions on SSIS,SSAS,SSRS,Silverlight,Cloud Computing (Part I and II)

Videos will soon be uploaded.

Here is the link for the awards and appreciations

Windows 7 UI in my Windows Mobile 5.0

Windows 7 UI in my Windows Mobile 5.0

I have an HTC p3400 running on Windows Mobile 5.0
I have used the instructions in the following URL and converted the interfaces in
my mobile similar to a Windows 7 OS

http://www.freewarepocketpc.net/ppc-download-windows-7-theme.html

attribute key not found error while processing the cube in SSAS

Attribute Key Not found Error occurs in SSAS due to the following reasons :

 

1. Dimensions processed after measure groups
2. Null values / references in Keys
3. Please check for the Null values in Interrelated dimensions.

(For Ex : You might have a dimension table employees, employees relates to table sub department, subdepartment relates to table department.

If by chance there exists a Null value in the mapping between subdepartment and department you will get this error).

Man and Donkey

Man and Donkey

Equation 1:
Human = eat + sleep + work + enjoy
Donkey = eat + sleep
Hence Human = Donkey + Work + enjoy
Therefore: Human-enjoy = Donkey + Work
In other words, A Human that doesn't know how to enjoy = Donkey that works.
Equation 2:
Man = eat + sleep + earn money
Donkey = eat + sleep
Therefore: Man = Donkey + earn money
Therefore: Man-earn money = Donkey
In other words Man who doesn't earn money = Donkey
Equation 3:
Woman= eat + sleep + spend
Donkey = eat + sleep
Therefore:
Woman = Donkey + spend
Woman - spend = Donkey
In other words,
Woman who doesn't spend = Donkey
-------------------------------------------------------------------------------
To Conclude:
From Equation 2 and Equation 3
Man who doesn't earn money = Woman who doesn't spend
So Man earns money not to let woman become a donkey!
And a woman spends not to let the man become a donkey!
So, We have:
Man + Woman = Donkey + earn money + Donkey + Spend money
Therefore from postulates 1 and 2, we can conclude

Time to celebrate ...

Time to celebrate ...

This weekend is for celebrations with a small party. There are two reasons for the same:

1. The long time downtime of this weblog and/or its afflicting maladies have been addressed.
2. I am also now recognized as 'Techstar of the Day' in Microsoft HyderabadTechies.info. Check it out here or here.

HyderabadTechiesInfoAppreciation_TechStar

We are back after a little downtime...

We are back after a little downtime...

The weblog was reeling under some acute spam (saturn) menace and because of time-crunch to investigate the same,  it was suffering a little downtime and serving bad obnoxious content. These have been cleared off and we are back to serve the tech fraternity with more vigor and passion.