SqlServer-QA.net

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day! The recent release of Windows Server 2008 from  Microsoft will help them address these ...

One of my colleague forwarded me the problems with Virtualisation, some point to truth so and this is not to take on lighter side: Dilbert1 Dilbert2 Dilbert3 Dilbert4 No difference when it comes to SQL SErver virtualization too, Enjoy!

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server ...

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application.  I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and 64-bit editions and bit hard for ...

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a value that will affect the whole server ...

We have been going through a load-performance exercise for an application that will have more than 5000 concurrent connections at one time.   Going by books and expeirence by default the Max Worker Threads setting is 255, which means that up to 255 worker threads are allowed to be created. Most of the times I never had any issues ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications Error message when an application connects to SQL Server on a server that is running Windows Server 2003: ''General Network error,'' ...

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group policies. Initial thought of the error brings up permissions issue while copying the file ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications List of known issues when you install SQL Server 2005 on Windows Server code name ...

I have had problem when installing SQL Server 2005 on one of the 64-bit server, the error was: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. So as per the message I have looked in to the specified directory for the logs which is ''C:\Program ...