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

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

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

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

/3GB /PAE and AWE blurb what is it you hear within your environment?

Published 25 July 7 9:6 AM | SSQA.net

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

Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae

Get SYSMON counters using a TSQL query aka DMVs.

Published 31 May 7 10:26 AM | SSQA.net

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

Filed under: sql server, perfmon, microsoft, server, dmv, sysmon

SQL Server 2005 Analysis Services community samples

Published 29 May 7 4:44 AM | SSQA.net

As the evolution of Analysis Services has taken to new heights in SQL Server 2005 equally the users are looking to deploy on the large scale and having a need to go though the samples that are helpful. So how about referring to a project that contains...

Filed under: sql server, analysis, microsoft, ssis, server, ssas, codeplex

Things to take care before installing SQL Server 2005 on Vista operating system or Windows Server 2008?

Published 29 May 7 3:29 AM | SSQA.net

I have seen mounting questions asking on support for SQL Server 2005 on Vista & Windows 2008, what a surprise! As Windows Server 2008 (aka Longhorn) is still in CTP (BETA 3) stages it is hard to comment or confirm any sort of support arrangements...

Filed under: sql server, microsoft, server, windows, longhorn, 2008, vista