The same as any IT position - either go to the business side and become a project leader, DBA manager, operation director, VP of IT, CIO .....

or remain technical but...

Because of SOX, I was allowed to be administrator of the development box but not the production box.

Use the web site http://www.toadsoft.com to download the free version of TOAD. It does not have the full version of TOAD but is good enough to do most of...

Here is an article talking about inserting large amount of data into a table that has a trigger would cause performance problem. Also there is an example not using...

I agree that it is not just Microsoft, it is the problem of most software companies. I used to work for a software company. They need to have...

In the Roles table, 'Developer' has a 'Y' in the InboxEnabled field.

So if you select user from the Users table where InboxEnabled = 'Y' in the Roles table, how...

select Roleid from Roles where Inboxenabled ='y' will return me Admin and Dev roles

According to the data you supplied, the query should return Admin, Developer and Network. In the...

SELECT f.FolderID, f.FolderName,

SUM(CASE WHEN Displayed IS NULL AND NoteDate IS NOT NULL

THEN 1

...

Have you installed excel in the window server where the Sql Server is?

Steve, give Microsoft a break!!!!! A lot of other software companies have the same problems too, eg Oracle, you think their release is on time, even it is on...

The last company I worked for was a big company too, at least it was within the fortune 500 list. It had a ERP system JD Edwards running on...

What about table partitioning, will it work in your case?

What if you use a factless table to keep track of the application? (Kimball used this method to keep track of which event happened, you could find it in...

Can you give me an example of the data in Excel and also the table you want to create?

What kind of problem do you have?

I just want to know, what is the purpose of the level? Does it matter I posted 10 times or 1000 times?