Get DataBase and System information from SQL

Before we migrate or upgrade we need to know some critical information that helps us find out about how SQL/System will be licensed based on CPU/Socket/Cores, some other information related to collation to find out what is the best way to consolidate Databases.

so I made this scrip that helped to get the basic informations that i needed, I decided to share it with the community and hopefully will be helpful for you.

Read More »

What does Apple need to do for Mac users?

Any successful company needs to focus and expand the areas where there are profits.

Through the last years we saw that Apple is focusing on iOS based devices (iPhone, iPod Touch, iPad, AppleTV) where profit comes not only from selling the iOS devices but comes from the iTunes contents (music, video, apps and books).

But, what about Mac, the Apple Computers? What is the future?Read More »

Installing VMware vCenter on Windows 2008 R2

Hello,

I have to say that VMware could do better installation process, but ….

I have Windows 2008 R2 with MSSQL Server (64bit) already installed (I will not use the MSSQL that comes with the vCenter installation)

any ways, Windows 2008 R2 is 64Bit only, there is no 32Bit, here is what I found and it may help!

  1. you need to make sure that the server name is no longer than 15 character.
  2. Make sure the service SQL Server Agent is running, check that it is set to Automatic Startup type.
  3. you must create a DSN (vCenter requires 32Bit System DSN) so that means you need to use the Native Client (MSSQL 2008) ODBC Driver (c:\Windows\SysWOW64\sqlncli10.dll)  by running %WINDIR%\SysWOW64\odbcad32.exe then create a DSN unde System DSN.

Sofar the installation went OK, but I did not test all the functions and made sure that it works without problems!
did any one else face the same need to the steps above?