Showing posts with label track. Show all posts
Showing posts with label track. Show all posts

Wednesday, March 28, 2012

Question regarding storing session with set context_info

Currently our need is to track the data that is changed by the user and record it as a part of the Audit Log.

We have accomplished this need ny making use ofset context_infoand also by passing the UserId from all the Layers and finally log the user name using the set context_info in the stored proc.

What we thought of was using the trigger for each update,delete records for the table.So by setting the context in teh stored proc we could access the UserId in the trigger and able to record the changes made by Tagged userId.

What we want to make sure before making this as our permananet solution is

(1) Reliability - In a web application (N Tier) how would the context not get out of scope.

2) any Performannce related issues, you guys can think of.

3) This Context used in the database -- would that be the part of the connection used from the UI, meaning the if a request is made from UI to the Database . would the context be alive till the connection doesn't go back to the connection pool.

Thanks

Sweety.

No answers yet.

Any idea wether this approach would be good or not.

Need your Input

Thanks

Wednesday, March 21, 2012

Question on sql server certification

I am planning to certify on sql server 2000 and become an MCDBA. I am new to sql server certification track. My understanding is I need to take 4 exams(3 must and 1 optional). I have few questions:
1>> Can I take one exam and still be certified?
2>> When yukon certification track may come?
3>>Whats the sql server certification upgrade path? I mean if I am 2000 certified, how many exams I need to take to upgrade to yukon - the next version.
4>> Can you ssuggest some good materials,urls etc for 2000 certification.
Thx in advance
Amit
> 1>> Can I take one exam and still be certified?
Yes, but not as MCDBA - just MCP (Microsoft Certified Professional).

> 2>> When yukon certification track may come?
> 3>>Whats the sql server certification upgrade path? I mean if I am 2000
certified, how many exams I need to take to upgrade to yukon - the next
version.
Both questions can't be answered at this time. You will have to wait, IMO,
for at least one year before we will ge more info.

> 4>> Can you ssuggest some good materials,urls etc for 2000 certification.
http://www.microsoft.com/learning/mc...quirements.asp
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

Question on sql server certification

I am planning to certify on sql server 2000 and become an MCDBA. I am new to
sql server certification track. My understanding is I need to take 4 exams(
3 must and 1 optional). I have few questions:
1>> Can I take one exam and still be certified?
2>> When yukon certification track may come?
3>>Whats the sql server certification upgrade path? I mean if I am 2000 cert
ified, how many exams I need to take to upgrade to yukon - the next version.
4>> Can you ssuggest some good materials,urls etc for 2000 certification.
Thx in advance
Amit> 1>> Can I take one exam and still be certified?
Yes, but not as MCDBA - just MCP (Microsoft Certified Professional).

> 2>> When yukon certification track may come?
> 3>>Whats the sql server certification upgrade path? I mean if I am 2000
certified, how many exams I need to take to upgrade to yukon - the next
version.
Both questions can't be answered at this time. You will have to wait, IMO,
for at least one year before we will ge more info.

> 4>> Can you ssuggest some good materials,urls etc for 2000 certification.
http://www.microsoft.com/learning/m...equirements.asp
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

Question on sql server certification

I am planning to certify on sql server 2000 and become an MCDBA. I am new to sql server certification track. My understanding is I need to take 4 exams(3 must and 1 optional). I have few questions
1>> Can I take one exam and still be certified
2>> When yukon certification track may come
3>>Whats the sql server certification upgrade path? I mean if I am 2000 certified, how many exams I need to take to upgrade to yukon - the next version
4>> Can you ssuggest some good materials,urls etc for 2000 certification
Thx in advanc
Ami> 1>> Can I take one exam and still be certified?
Yes, but not as MCDBA - just MCP (Microsoft Certified Professional).
> 2>> When yukon certification track may come?
> 3>>Whats the sql server certification upgrade path? I mean if I am 2000
certified, how many exams I need to take to upgrade to yukon - the next
version.
Both questions can't be answered at this time. You will have to wait, IMO,
for at least one year before we will ge more info.
> 4>> Can you ssuggest some good materials,urls etc for 2000 certification.
http://www.microsoft.com/learning/mcp/mcdba/requirements.asp
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||Ditto to what Amit said and...
Look up www.Transender.com on the internet, they sell
practise exams which are the best in the business.
There is an actual Microsoft MCDBA Newsgroup, you may get
some better stuff from there.
J
>--Original Message--
>I am planning to certify on sql server 2000 and become an
MCDBA. I am new to sql server certification track. My
understanding is I need to take 4 exams(3 must and 1
optional). I have few questions:
>1>> Can I take one exam and still be certified?
>2>> When yukon certification track may come?
>3>>Whats the sql server certification upgrade path? I
mean if I am 2000 certified, how many exams I need to take
to upgrade to yukon - the next version.
>4>> Can you ssuggest some good materials,urls etc for
2000 certification.
>Thx in advance
>Amit
>.
>