Microsoft SQL Server Certifications

Hello all,

I'm working as DBA.I wish to do certifications for Microsoft sql server.So Could i know what are the certifications are available and what i've to do for certififcations.

Thanks in advance
David RPlease find all the details here.

Microsoft SQL Server 2005 Compact Edition Released

Microsoft SQL Server 2005 Compact Edition is now available at

http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&DisplayLang=en#QuickInfoContainer

The Microsoft SQL Server 2005 Compact Edition SDK is now available at

http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

Robert Wishlaw

Is it necessary to uninstall SQL Mobile (not the beta of this)?|||Does Microsoft hire copy editors to review their content before publishing it to the world? This site is rife with errors that a $15/hour copyeditor would spot. It just makes them look totally unprofessional.|||I got the new SDK bits to install but only after having uninstalled VS 2005 (completely), reinstalling it and SP1 and then the new bits.|||

William Vaughn wrote:

Does Microsoft hire copy editors to review their content before publishing it to the world? This site is rife with errors that a $15/hour copyeditor would spot. It just makes them look totally unprofessional.

Complain to the Group Manager at the new blog.

http://blogs.msdn.com/sqlservercompact/archive/2007/01/13/sql-mobile-on-desktop.aspx

Robert Wishlaw

|||That blog is very confusing with entries copied from other blogs but with Jan 13 07 date.

There is nothing remotely new or upto date on theresql

Microsoft SQL Server 2000 Reporting Services

I understand that this is available for free but I have not been able to find it for downloading. Can anyone point me in the right direction for this? Do you know does it really require alot of resources like I have been reading. People recomending a seperate SQL box just for thes reporting services. Please advise.

You can download evaluaiton copy from here.

Also you can download SP2 for RS 2000 here.

|||Thank you.... but my understanding was that I could get a regular copy vs. evaluation copy for free. Microsoft was letting SQL 2000 users have the reporting services until they upgraded to SQL 2005 which would have it in it. Do you know where you can get a regular copy?|||I am curious where this was mentioned. As far as your performance question, it is true that processing reports is an intensive task. However, a single box should more than enough to handle low to medium report loads. Besides, it will save you money if you host the database engine on the same server.

Microsoft Reports

I am trying to create some reports in MS Visual Studio Express. Is there way to make report viewer or report templates available in Visual Studio Express ?

Hi,

Do you mean those express editions like Visual Web Developer, right?

Business Intelligence Development Studio is the environment that you will use to develop reports and report models in SQL Server 2005 Reporting Services. Business Intelligence Development Studio is theMicrosoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions.

Thanks.

Microsoft Feedback Center: Available?

I've been trying to get to the MSDN Product Feedback Center to report a bug
in SQL Server 2005 Management Studio. I'm getting an Error when I try to
reach the site - msdn.microsoft.com/feedback - Is it available?
"An error has occurred during the processing of your request. Please try
again later. "
Persistence pays off. I got in with the menu at the top of Management Studio
with Community-Send Feedback.
"Dr. Network" <charles.hawkins@.jenzabar.net> wrote in message
news:ObkYbN1VGHA.5288@.TK2MSFTNGP14.phx.gbl...
> I've been trying to get to the MSDN Product Feedback Center to report a
> bug in SQL Server 2005 Management Studio. I'm getting an Error when I try
> to reach the site - msdn.microsoft.com/feedback - Is it available?
> "An error has occurred during the processing of your request. Please try
> again later. "
>
|||Try http://lab.msdn.microsoft.com/ProductFeedback/
That URL works for me.
Andrew Watt [MVP]
On Mon, 3 Apr 2006 15:18:17 -0400, "Dr. Network"
<charles.hawkins@.jenzabar.net> wrote:

>I've been trying to get to the MSDN Product Feedback Center to report a bug
>in SQL Server 2005 Management Studio. I'm getting an Error when I try to
>reach the site - msdn.microsoft.com/feedback - Is it available?
>"An error has occurred during the processing of your request. Please try
>again later. "
>

Microsoft Drivers for Accessing data from Unix.

Are there any microsoft provided ODBC drivers that can be installed on Unix
side for accessing SQL Server data? OR they are only available from third
party.
Regards,
MZeeshan
MS does not provide an ODBC driver that works on Unix. However, you can
get that from Data Direct. Microsoft does make a JDBC driver though.
MZeeshan wrote:
> Are there any microsoft provided ODBC drivers that can be installed on Unix
> side for accessing SQL Server data? OR they are only available from third
> party.
>
|||Hi MZeeshan,
Thanks for your post.
Unfortunately, I am sorry to say that we do not support ODBC drivers for
UNIX officially. However, I have noticed here is a very good article from
MVP Erland Sommarskog for your reference
Connecting to MS SQL Server from Unix
http://www.sommarskog.se/mssql/unix.html
Hope it helps.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft Drivers for Accessing data from Unix.

Are there any microsoft provided ODBC drivers that can be installed on Unix
side for accessing SQL Server data? OR they are only available from third
party.
Regards,
MZeeshanMS does not provide an ODBC driver that works on Unix. However, you can
get that from Data Direct. Microsoft does make a JDBC driver though.
MZeeshan wrote:
> Are there any microsoft provided ODBC drivers that can be installed on Uni
x
> side for accessing SQL Server data? OR they are only available from third
> party.
>|||Hi MZeeshan,
Thanks for your post.
Unfortunately, I am sorry to say that we do not support ODBC drivers for
UNIX officially. However, I have noticed here is a very good article from
MVP Erland Sommarskog for your reference
Connecting to MS SQL Server from Unix
http://www.sommarskog.se/mssql/unix.html
Hope it helps.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

MIcrosft SQLServer Best Practices document on securing SQLServer

I'm chasing after a documetn that was available on one of the Microsoft
websites that was titled somethign like "MS SQL Server Best Practices"
and detailed a nyumber of best practices about securing the server.

Included in this was revoking public access to the system table
objects.

Can someone post the URL where I can pick this up, or drop me a note on
contacting them for a copy of the document?"byrocat" <bdealhoy@.sympatico.ca> wrote in message
news:1122653744.611069.56230@.o13g2000cwo.googlegro ups.com...
> I'm chasing after a documetn that was available on one of the Microsoft
> websites that was titled somethign like "MS SQL Server Best Practices"
> and detailed a nyumber of best practices about securing the server.
> Included in this was revoking public access to the system table
> objects.
> Can someone post the URL where I can pick this up, or drop me a note on
> contacting them for a copy of the document?

You can find the Microsoft security docs, including a best practices white
paper, here:

http://www.microsoft.com/sql/techin...ty/default.mspx

I don't know of any good reason to revoke public permissions on system
tables - it might actually break something if users can't retrieve metadata
for some operations. Books Online states that a REVOKE applied to the public
role applies to all database users, which is probably not desirable in many
cases.

This issue often seems to be raised by IT auditors, probably because it has
somehow became part of an industry-standard audit checklist, but the MS best
practices document says only "do not grant additional permissions to this
role", implying that the existing permissions are fine:

http://www.microsoft.com/technet/pr...n/sp3sec02.mspx

Simon|||byrocat (bdealhoy@.sympatico.ca) writes:
> I'm chasing after a documetn that was available on one of the Microsoft
> websites that was titled somethign like "MS SQL Server Best Practices"
> and detailed a nyumber of best practices about securing the server.
> Included in this was revoking public access to the system table
> objects.

I would not do this. At least not without extensive testing first.

The fact that all metadata is open to anyone is not entirely
satisfyable, but the opposite is not good either.

In SQL 2005 things are different. Here you can only see metadata
for objects that you have access to. Unfortunately, this important
distinction is not possible to make in SQL 2000.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Message in place of blank subreport

Is there any way I can check the option to suppress blank subreport, but then put a "No data is available" message in it's place?
Thanks.Create a new Report named BlankReport having the content "No data Available"
Check the existance of the records before calling a report
If there are records then call that report otherwise call BlankReport