While working on a customer implementation of Microsoft SQL Server 2008 R2 and Citrix DataStream I ran into a need to quickly failover mirror partners between servers for testing reasons. This can be done easily via the ALTER DATABASE command but to save time I wrapped the command up into a dynamic Stored Procedure.
mirroring_role being equal to 1 indicates it has the PRINCIPAL role where the mirroring_state being equal to 4 indicates it is SYNCHRONIZED.
The procedure should be run on the server where the database is the PRINCIPAL. Running it on the MIRROR server will not result in any changes. Using Linked Servers and 2 parameters in the Stored Procedure such as:
sps_FailoverMirror (@databaseName nvarchar(200), @serverOne nvarchar(200), @serverTwo nvarchar(200))
would allow the Stored Procedure to query both servers, find the PRINCIPAL server, and perform the failover.
The EMC VNXe 3100 Unified Storage and the EMC Data Domain DD160 Deduplication Storage System are designed to be the foundation for a next-generation IT infrastructure.
The VNXe series redefines networked storage for the small business to medium enterprise user, delivering an unequaled combination of enterprise-like features, simplicity, and efficiency. The Data Domain systems have revolutionized disk backup with high-speed, inline deduplication. The Data Domain DD160 is designed for small enterprise data centers and provides the simplicity and efficiency you require
Bundle Descriptions
Bundle 1: Storage and Backup Consolidation Bundle
VNXe3100 – 6TB
-6x 1TO NL-SAS & 3 Years Maintenance
DD 160 – 3.5TB
-Boost/Replication Software & 3 Years Maintenance
Bundle 2: Performance & Simple Storage and Backup Bundle
VNXe33100 – 9TB
-6 x 600 + 1TO SAS & 3 Years Maintenance
DD 160 – 6TB
-Boost/Replication Software & 3 Years Maintenance
Read more >>
When building out a rocking cloud over this past weekend, the topic of networking specific to NFS on vSphere came up. One of the questions that was asked was if the “Management traffic” checkbox on a vmkernel needed to be ticked in order of that specifc vmkernel to communicate to the NFS export. I didn’t believe this to be the case, and after some quick testing, we confirmed its as not needed.
The next question that came up is an important one to consider in your implementations of NFS on vSphere– and it was the question of “which vmkernel will be used to communicate to the NFS export?”. It’s important to keep in mind that once the connection to an NFS mount is made, it will continue over the same vmkernel AND NIC that was used to establish the connection, so if you get it wrong the first time, it’ll stay that way until you break the connection and re-establish it (which in our case, we tested by unmounting the export, making our changes, and then remounting).
What I had learned a ways back that I believed to still be true was that the the IP of the NFS server would determine which vmkernel would be used by using the vmkernel’s route table, and if no specific route (or same subnet vmkernel interface), the default route/gateway would be used.
Read more >>
I got this error recently when I tried to install VMWare Workstation 8 on my laptop with Windows 7 64-bit. I found the fix in the registry and wanted to share because I couldn’t find the solution anywhere on the internet.
Open the Registry Editor by going to Start > Run > then type ‘regedit’
Browse to the following key…
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\VMware, Inc.\Installer\VMware Workstation\DATASTORE_PATH
Change the value to the location you want your VMs to be stored (ie. ‘C:\Virtual Machines’), then click OK. Now, re-run the VMWare Workstation installer.
Cisco’s Unified Computing Systems (UCS) has acquired the reputation of leading the next-generation of data center platforms by merging together the IT needs of computing, networking, storage access and virtualization into one unified system.
Cisco has recently announced their Q3 Cisco Smart Play bundles. Now until April 28, 2013 there are (10) extensively discounted UCS B-Series Blade Server and C-Series Rack-Mount Server Bundles that are fully configured and ready to be implemented in any data center. This is a great opportunity for any company to experience the next-generation of data center platforms with Cisco’s UCS at an exceptionally low entry point.
UCS B-Series Smart Play Promo Summary
The Smart Play UCS B-Series Bundles have (4) options that range from an introductory priced B200 bundle to a high performance B230 Bundle which most now include the NEW Cisco 6248 48 Unified Port Fabric Interconnects. Based on the hard drive restraints experienced around the world, Cisco has now provided the option to purchase these Smart Play bundles “with” or “without” hard drives to meet faster delivery times for customers who wish to boot their UCS from SAN.
Read more >>
The Charleston SharePoint Users Group (CHSSPUG) is back! Come for an eGroup sponsored Lunch and Learn on Valentine’s Day 2012! Please RSVP and indicate how many people you are bringing so we can plan for you.
Who is this meeting for? We would like to see everyone from power users to advanced users and developers at this meeting!
Where is it meeting? We will be meeting in Room 120 at the Lowcountry Graduate Center:
Lowcountry Graduate Center
5300 International Blvd
Building B, Suite 100, Room 120
North Charleston, SC 29418
What’s the agenda? Due to feedback from the last meeting, these sessions will start at a lower level, but will quickly progress to more advanced features. This will give everyone a chance to learn something from each session.
10:00AM – Introduction to Document Management
11:15AM – Workflows
12:30PM – Lunch/Networking
13:30PM – Developing and Extending Document Management features
Ask the Experts! The founder of the Charleston SharePoint Users Group and internation speaker, Paul Swider, will be speaking at this meeting, along with several other SharePoint experts! Don’t miss an opportunity to get all of your tough questions answered!
REGISTER
