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!

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

  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 the files for SQL Server Compact 3.5 and Microsoft Synchronization Services ...

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 to rely upon SYSMON counters. In this scenario capturing the Available Byes & ...

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 for Server Consolidation Finally WebCast on the Server Conslidation

• .NET Framework 2.0 (for Windows Server 2003, Windows XP, and Windows 2000) • .NET Framework 2.0 (for Windows Vista) • .NET Framework 1.1 (for Windows Server 2003) • .NET Framework 1.1 (for Windows XP and Windows 2000) • .NET Framework 1.1 (for Windows Vista)  

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that ...

SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using the dm_os_performance_counters View. The results listed using this DMV will ...