Katmai's Cool DBA Feature
OK, I said I would be looking for a DBA-specific feature, and it looks like I found one. I knew about this before, it just didn't come to mind the other day when I was writing the other blog. Katmai has this cool feature where you can run code against a group of servers. And I don't know if it's specifically for DBAs, but it's certainly well suited for us. I'm constantly having to run code on a number of servers
1 RecommendationOK, I said I would be looking for a DBA-specific feature, and it looks like I found one. I knew about this before, it just didn't come to mind the other day when I was writing the other blog.
Katmai has this cool feature where you can run code against a group of servers. And I don't know if it's specifically for DBAs, but it's certainly well suited for us. I'm constantly having to run code on a number of servers like giving a new user rights to multiple boxes, or deploying an SP to a lot of boxes. This is a fabulous feature and it looks like MS got a couple things right here.
1. When one box is unavailable it continues to connect to the other boxes.
2. If one box has an error, it doesn't affect the other boxes.
3. You can register a single box in multiple server groups so you can group them logically by application.
Things that didn't get done as well as I'd like:
1. It would be nice to have the same thing at a DB level on an individual box. So instead of having to create a cursor or use the built-in MSforeachDB cursor, I could group the DBs on my server to admin them all at once.
2. I wish you could just copy an instance of a registered server that just logically belonged to different groups. The way it's currently done, you can register a server in multiple server groups, but they're all separate registrations. If I need to change my password or even auth method in that registered server, and I've got it in 25 groups, I have to change it 25 times.
Those aren't really complaints, just things that would have made the feature perfect. Still though, it's a really nice feature, so kudos MS.
I've put together a short Camtasia just to demonstrate how it works.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com
Read my book reviews at:
www.ITBookworm.com
Blog Author of:
DBA Rant – http://dbarant.blogspot.com
White Paper
D2D Virtual Tape Library Replication Primer
This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.
Download now »
White Paper
An Alternative to Virtualization for Datacenter Cost Savings
Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.
Download now »
White Paper
Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network
The emergence of WLANs has created a new breed of security threats to enterprise networks.
Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation
White Paper
Bringing the Edge to the Data Center
Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.
Download now »
Sign up to receive InfoWorld Resource Alerts
