Highest Microsoft database programming certificate?

hi everybody
i registered in an access forum and asked them this question
they gave me a link to a microsoft access specialist certificate
but i didn't find that it is satisfactory....
what i want is the highest database programming certificate, whether using access, sql server 2005, or anything else
provided that i already know sql, intermediate in making database solutions with ms access, and i program with 6 programming languages...
and i wish that you could point me to the best premium online training resources..
thank you

You can hold the Microsoft Certified Database Administrator (MCDBA) certification from Microsoft. I passed that one some time back. You can also check out these training resources:

http://www.microsoft.com/sql/techinfo/default.mspx

Buck Woody

Microsoft SQL Server Team

High Performance SQL Server (article)

I posted a link to a prior article in here, that one about high
performance hierarchies, and have the first two parts of a new series.
Hopefully this is of value to someone.

http://www.yafla.com/papers/SQL_Ser..._sql_server.htm

Thanks.Thank you article!
It make me to know what is bookmark lookup?
and why sometimes use full table scan.

Thank again. I wait and see your PART IIII will come soon.

> I posted a link to a prior article in here, that one about high
> performance hierarchies, and have the first two parts of a new series.
> Hopefully this is of value to someone.

Hiding parameter passed through query string

I'm using Reporting Servicves for SQL Server 2000 and I've embedded a
ReportViewer control in an ASP.NET page. The reports I link to all require a
sensitive parameter value and I have been passing that through using the
query string. Unfortunately, the entire URL of the report--including the
parameter in the query string--is visible in the source for the page, and I
don't want the user to see this for security purposes.
Is there a way to hide this? I'm open to any and all suggestions.
Thanks,
MarkSearch the group on encryption - use System.Security.Cryptography package
I just repeat myself from a previous posting:
"Parameter's encryption is a key to solve your problem.
The simplest ( but not the only) way is:
1.create your own parameters collection pages (forms).
2. encrypt user input using a permanent or temporary encryption key.
3. Reference encryption assembly in your report designer.
4. use a decryption routine in your custom code akin
"=Code.Library.Decrypt(Parameters!account_id);" by retrieving an encryption
key used in step 2.
By using this approach even a simplest parameter will be totally un
guessable, because even a single digit will be encrypted to something like
"bHZiajB4TGpBdU1"
"
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:98599DF6-C0E8-418A-A573-8293EEE98E13@.microsoft.com...
> I'm using Reporting Servicves for SQL Server 2000 and I've embedded a
> ReportViewer control in an ASP.NET page. The reports I link to all require
> a
> sensitive parameter value and I have been passing that through using the
> query string. Unfortunately, the entire URL of the report--including the
> parameter in the query string--is visible in the source for the page, and
> I
> don't want the user to see this for security purposes.
> Is there a way to hide this? I'm open to any and all suggestions.
> Thanks,
> Mark|||For RS 2000 you can use web services. There is really no way using URL
integration to hide it from the source. You can hide it from the page being
displayed but if they go View, Source they will see it.
In VS 2005 there are two new controls that work with RS 2005. They use web
services under the covers, not URL integration. You do have to have RS 2005.
Note that you can upgrade to RS 2005 while leaving the database at 2000
(that is what I have done). You do need a SQL Server 2005 license for this
however.
My suggestion is if security is important then you use the new controls.
One other option, put the parameters in a database table and then pass the
primary key to the table and have a dataset extracting the parameters.
This does make things more complicated but it is a version independent
solution (if you can convince management to upgrade to RS 2005). Note what I
said about upgrading. Sometimes it is easier to get permission to upgrade
reporting services than it is to upgrade a SQL Server database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:98599DF6-C0E8-418A-A573-8293EEE98E13@.microsoft.com...
> I'm using Reporting Servicves for SQL Server 2000 and I've embedded a
> ReportViewer control in an ASP.NET page. The reports I link to all require
> a
> sensitive parameter value and I have been passing that through using the
> query string. Unfortunately, the entire URL of the report--including the
> parameter in the query string--is visible in the source for the page, and
> I
> don't want the user to see this for security purposes.
> Is there a way to hide this? I'm open to any and all suggestions.
> Thanks,
> Mark|||Good point. I forgot about doing that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:OdtQOZxCGHA.1816@.TK2MSFTNGP11.phx.gbl...
> Search the group on encryption - use System.Security.Cryptography package
> I just repeat myself from a previous posting:
> "Parameter's encryption is a key to solve your problem.
> The simplest ( but not the only) way is:
> 1.create your own parameters collection pages (forms).
> 2. encrypt user input using a permanent or temporary encryption key.
> 3. Reference encryption assembly in your report designer.
> 4. use a decryption routine in your custom code akin
> "=Code.Library.Decrypt(Parameters!account_id);" by retrieving an
> encryption
> key used in step 2.
> By using this approach even a simplest parameter will be totally un
> guessable, because even a single digit will be encrypted to something like
> "bHZiajB4TGpBdU1"
> "
>
> "Mark" <Mark@.discussions.microsoft.com> wrote in message
> news:98599DF6-C0E8-418A-A573-8293EEE98E13@.microsoft.com...
>> I'm using Reporting Servicves for SQL Server 2000 and I've embedded a
>> ReportViewer control in an ASP.NET page. The reports I link to all
>> require a
>> sensitive parameter value and I have been passing that through using the
>> query string. Unfortunately, the entire URL of the report--including the
>> parameter in the query string--is visible in the source for the page, and
>> I
>> don't want the user to see this for security purposes.
>> Is there a way to hide this? I'm open to any and all suggestions.
>> Thanks,
>> Mark
>

hiding link condtionally

hi all
i have a matrix report (rows&cols)and both are grouped
and the subtotal is displayed at the end of the
matrix,the problem is that i am making a jump link for
each data cell of the matrix and i dont want any links
for the totals cells(the ones on the edges of the matrix)
is there any expression to do this(hide links when the
cell is at totals(Hor,Ver)),please advize.Assuming the matrix column group has the name "ColumnGroup" and the matrix
row group has the name "RowGroup", you would use an expression like this on
the cell's hyperlink:
=iif(InScope("ColumnGroup") AND InScope("RowGroup"), "http:// some link",
Nothing)
A subtotal is not calculated in the scope of it's grouping, therefore
InScope will return false for subtotal cells for a certain grouping.
More information on the InScope function is available in BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"teko" <anonymous@.discussions.microsoft.com> wrote in message
news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
> hi all
> i have a matrix report (rows&cols)and both are grouped
> and the subtotal is displayed at the end of the
> matrix,the problem is that i am making a jump link for
> each data cell of the matrix and i dont want any links
> for the totals cells(the ones on the edges of the matrix)
> is there any expression to do this(hide links when the
> cell is at totals(Hor,Ver)),please advize.
>|||>--Original Message--
>Assuming the matrix column group has the
name "ColumnGroup" and the matrix
>row group has the name "RowGroup", you would use an
expression like this on
>the cell's hyperlink:
>=iif(InScope("ColumnGroup") AND InScope
("RowGroup"), "http:// some link",
>Nothing)
>A subtotal is not calculated in the scope of it's
grouping, therefore
>InScope will return false for subtotal cells for a
certain grouping.
>More information on the InScope function is available in
BOL:
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"teko" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
>> hi all
>> i have a matrix report (rows&cols)and both are grouped
>> and the subtotal is displayed at the end of the
>> matrix,the problem is that i am making a jump link for
>> each data cell of the matrix and i dont want any links
>> for the totals cells(the ones on the edges of the
matrix)
>> is there any expression to do this(hide links when the
>> cell is at totals(Hor,Ver)),please advize.
>
>.
>many thanks..it works

hiding "Change Credential" link

Is there any way to hide "Change Credential" link comes in browser?

I cannot change the credential type, It will be "Prompt" only as i am passing connection string and Credentials via URL.

You can hide the entire prompt area by specifying rc:Parameters=false in the url. Note that this will hide both the data source and the parameter prompts. There is no way to hide only the data source prompts via url access. If you use the ReportViewer webforms control, then you can control the parameter and data source prompts independently.|||

thanks Brian.

I am able to hide "Change Credential" link using mshtml object. mshtml object, has property called "document", using that you can get all the controls on the pages. Top three rows i am hiding using that.

Hope microsoft will not change the structure of HTML page, generates by Report Server.

|||What you are doing may work in the current version, but it is not a supported mechanism for changing the viewer. The html structure may change in a future version or service pack.