You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a certificate-issuing authority, such as Verisign, or if for testing purposes, by using tools to ...

This sounds like a joke that ''How many DBAs you need to change a light bulb?''. I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by a DBA or how many DBAs you need to manage a 400+ SQL Servers within their environment. I believe ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The ''SQL Server:SSIS Pipeline'' performance object does not appear in the ''Performance object'' list after you install Integration Services from a 64-bit version of SQL ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications On a computer that has a 64-bit processor, you receive an error message in SQL Server Management ...

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues between SQL Server 2005 & Vista but bit struggling with errors such as '' Access to the path ...

You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other blogs on the web suggests that The fix for that error is to update setup.sql file residing into ...

Microsoft introduced an Incremental Servicing Model (ISM) is available from the SQL Server team to deliver hotfixes for reported problems. The SQL Server team is moving away from the current priority-driven hotfix release model to a scheduled delivery model. In the scheduled delivery model, a customer can receive a hotfix to address their most ...

I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to ''Find Fast'' that ships with Microsoft Office. There is a downside in using this option on a Windows ...

The Notification Services tutorial teaches you how to build a simple Notification Services application. The tutorial uses a SQL Server Management Studio solution to make it easy to edit tutorial files and then build the solution using SQL Server Management Studio Object Explorer. Before you start the tutorial, you should be familiar with ...