Browse by Tags

Windows Server 2008 deploy within your environment securely!

Published 6 March 8 2:50 AM | SSQA.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...

Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment

Server Virtualization or Virtualisation - what will be the affect, lighter side and nothing but truth!

Published 18 February 8 4:4 AM | SSQA.net

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!...( read more Read...

Filed under: sql server, microsoft, server, beginners, virtualization, concepts, benefits

An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server

Published 11 February 8 1:0 AM | SSQA.net

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 An additional resource group that contains...

Filed under: sql server, server, kba, group, 2005, resource, windows 2008

What are advantages of 64-bit system in relation to SQL Server?

Published 19 December 7 8:40 AM | SSQA.net

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...

Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Published 15 November 7 9:41 AM | SSQA.net

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...

Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads

SQL Server Max Worker Threads - What is the best value to setup?

Published 9 November 7 7:55 AM | SSQA.net

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...

Filed under: sql server, performance, server, best practice, max, setting, worker threads

Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error"

Published 7 October 7 8:33 AM | SSQA.net

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 Error message when an application connects...

Filed under: sql server, server, kba, connections, failure, general network error, transport-level, link, windows 2003, communication

Log Shipping error "Unable to copy the initialization file"

Published 3 October 7 6:49 AM | SSQA.net

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...

Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy

Installing SQL Server X64 on a 64-bit Operating System - problem with .NET framework package

Published 12 September 7 9:40 AM | SSQA.net

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...

Filed under: sql server, package, server, error log, directory, x64, .NET, distributed, client tools

Microsoft SQL Server Compact 3.5 for Windows Desktop Beta 2, Windows Mobile Beta 2 and Server Tools Beta 2

Published 7 September 7 6:26 AM | SSQA.net

SQL Server Compact edition is best used for replication purpose within the enterprise wide with a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains...

Filed under: sql server, databases, microsoft, server, download, windows, replication, compact, desktop, mobile

Paging and Available Memory for Operating sysem, what you need to know?

Published 6 September 7 7:29 AM | SSQA.net

Performance tuning exercise involves using SYSMON for the server based tasks, also I have seen users referring that MEMORY is at peak level by referring to Task Manager on the server. Not always depend upon the task manager, for optimum information better...

Filed under: sql server, performance, microsoft, server, sysmon, paging, vmm, processes, virtual memory

SP_HELP_REVLOGIN for SQL Server 2005

Published 4 September 7 8:54 AM | SSQA.net

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure...

Filed under: sql server, security, server, login, self, copy, sp_help_revlogin

How many DBAs you need to manage show in multi-server environment?

Published 30 August 7 5:24 PM | SSQA.net

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...

Filed under: sql server, server, services, dba, edition, multiple

Number of databases limit for Database Mirroring within X64 environment?

Published 30 August 7 5:27 AM | SSQA.net

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...

Filed under: sql server, performance, high availability, server, database mirroring, x64, geographic

Data Protection and Disaster Recovery Tips

Published 28 August 7 5:54 AM | SSQA.net

How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data...

Filed under: sql server, high availability, server, recovery, disaster, tips

Server Consolidation with SQL Server 2008

Published 27 August 7 9:50 AM | SSQA.net

Hot topic in the industry about the server consolidation and how you can take advantage by planning for SQL Server 2008 that is poised to release by next year. DOWNLOAD the document that consits the information on Server Consolidation DOWNLOAD the datasheet...

Filed under: sql server, microsoft, server, 2008, consolidation

While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

Published 27 August 7 5:47 AM | SSQA.net

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is...

Filed under: sql server, performance, memory, server, process, cube, Analysis Services

How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft SQL Server Analysis Cubes for Microsoft Dynamics GP

Published 22 August 7 3:50 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft...

Filed under: sql server, analysis, server, kba, dynamics, cubes

32bit vs 64 bit what other factors you need to consider?

Published 14 August 7 8:16 AM | SSQA.net

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of...

Filed under: sql server, performance, memory, server, windows, x64, system, hardware, 32 bit, 64 bit

SQL Server does not exist or access denied

Published 13 August 7 5:10 AM | SSQA.net

I hope you will get to see the above error message most often and I say a common question among forums & newsgroups. Few times you might be thinking why it is throwing error even though you are using right credentials to access that SQL Server instance...

Filed under: sql server, security, server, mdac, client, access denied, exists, does not, network