Browsing articles from "February, 2012"
Feb
18
2012

What is Active/Active Cluster means in SQL Server World

Source: http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/b6787cbc-e165-4730-9fba-7898af1716a6/ MSCS (Microsoft Cluster Services) is not a load-balancing product, it is simply a high-availability solution. Load balancing does not come in to play at all with clustering a Sql database…the term Active/Active seems to imply that this would be the case, which is why we typically try to refer to them as Multi-instance clusters now instead of the Active/Active label. Active/Active in the MSCS world basically means that you have 2 independent Sql […]

Feb
12
2012

How to do FTP in binary mode

1. Go to server 2. open command prompt as Start > Run > cmd 3. type ftp and enter 4. type open and give ftp address (for e.g. xxx.abcd.com) 5. it will ask you for user name and password (give as provided by ftp providor) 6. Now type binary and enter 7. It will show that it is now in binary mode 8. Now type put and enter 9. ftp should complete 10. Do not […]

Feb
5
2012

T-SQL to find Physical and Logical Processors (CPU)

Today while searching for t-sql scripts to collect Physical and Logical CPU count for around 100+ SQL servers (all version SQL 2000, 2005 and 2008 R2) came across following articles and the useful scripts, read below for more details, The basic limitation behing finding physical CPU count is you can’t find directly using t-sql in SQL Server 2000, from SQL 2005 onwards you can easily find it using DMV sys.dm_os_sys_info Script provided at following links, […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

February 2012
M T W T F S S
« Jan   Mar »
 12345
6789101112
13141516171819
20212223242526
272829  

View Post by Categories

%d bloggers like this: