Kevin Remde's IT Pro Weblog
This question was asked recently of our team, and it was just interesting enough of a question to see if someone reading this blog might like to play with this scenario on their own.
Yes.. you are finally being encouraged to “try this at home”.
Here’s the question: Can you create a virtual machine Windows Server 2003 guest being hosted in a Windows XP Virtual PC installation, and make the host XP machine a member of a domain running on the Windows 2003 Server?
Hint: Some have suggested to use a loopback adapter installed on the XP machine as the common link between them… although I don’t see why the physical adapter on on the XP machine wouldn’t work just as well.
It was discussed by a few people who said it couldn’t be done, but I’m not so sure. And before I tried it I thought I’d toss it out here and see if someone wants to give it a whirl and share their experience with us.
Today finds me sitting in a hotel room in Green Bay, Wisconsin. It’s getting cold outside, so sitting in here doing work in a quiet location is quite enjoyable. And as you see from the number of blog posts I’ve made today, I’ve been quite productive.
One of my tasks today was also to work on an RSS talk I’m going to give to anyone on my team who wants to listen. I volunteered to lead some informal internal training on the subject, since the multiple and powerful uses of RSS is a subject I’m passionate about.
In fact, check out what the weather is doing outside my hotel room now(click to enlarge).
In doing some research on blog reading tools options for my attendees, I did a search for “blog reader online”, and found this very useful list of Web-Based, PC-Based, and multi-platform news readers, complete with mini-summaries of each one. Thank you, Haiko Hebig!
Personally, I use SharpReader. I like being able to set up my subscriptions in a folder heirarchy that lets me view and work with either individual blogs or sources, or higher level folders (and all items contained within). I might start playing with Bloglines, though… or some other online reader, mainly because I would like to have the same list and view of read/unread items whether at my desk, on my mobile phone, or any other Internet-connected computer.
What do you use? How did you receive this post? And how are you reading it now – on the blog directly, or via some reader?
SQL Server 2005 Tidbit 037
This question was asked at our event TODAY in Des Moines, IA.
“Can the SQL Server 2005 Database Engine Tuning Advisor (DTA) aslo tune databses running on SQL 2000?”
Short answer. YES!
And in fact, something I didn’t mention at the event, but is also quite useful in the new tool; the new Database Engine Tuning Advisor (DTA) can also tune against MULTPLE databases at a time. So you’re not limited to, oh, ONE database as you were in the SQL 2000 version of the tool (Index Tuning Wizard).
Here’s a screenshot I saved that shows I’ve connected to that SQL 2000 instance, and have even selected multiple databases to tune.
(click it to see the enlarged screen capture)
Got an IT question? Give me a comment, or contact me.
These are GREAT!
The SQL Server Chopper contest is over. And today (Nov 7, 2005) they’re going to announce the winners at the SQL Server 2005 Launch event in San Francisco. Paul Sr. and Mikey (for President!) are even going to be there at the Launch party that evening.
And at the launch, as well as at many of our “Best of SQL Server Launch” events, we’ll be showing some fun case-study videos done at Orange County Choppers, where they talk about how great SQL Server 2005 is, naturally.
Here’s the short promo video.
Here’s the longer case study video.
Confession: I’m a digital photography nut. I’m the guy at every family gathering or team function with either a digital camera or DV camcorder. Or both! (Those of you I work with, or have worked with, or LIVE with already know this.) I post my photos to a family web site I run on a server at home, and I edit my videos into menu-driven DVDs. And sometimes I even share videos with YOU.
For video editing, I’ve been using Pinnacle Studio 9.x for quite awhile now. Version 8 was buggy… and version 9.00 was nearly unusable, but later updates have really improved it dramatically. 9.4 has been very good. And I’ve always wished that Microsoft would come out with something comparable. And now I see they’ve released version 10.
I have tried to use Microsoft’s Digital Image software in the past (previous versions), but honestly I didn’t think it was as easy to use as ACDSee (by ACD Systems). I’m currently using ACDSee 7.0. Love it. But maybe it’s time to give Digital Image another try.
Here is the Press Release on the new product offering.
Here is where you can buy it.
Anyone else have any opinions on these products, or other alternatives that you have used and like well?
Yeah… that’s me, working hard. For the past several weeks (several months, really) the team has been focused on learning and presenting SQL Server 2005 in all it’s glory… and doing a pretty good job of it (if I can brag a bit on my team here.)
This coming week we start our new “Best of SQL Launch” events. SQL Server 2005 (And Visual Studio 2005 and BizTalk 2006) are officially launching on Monday, followed by several major city launch events, as well as our team’s TechNet Events where we’re doing select IT Pro-related content from the launch events.
“And this has eaten into your time for blogging?”
Yup. I missed a couple of days there. I hate doing that. I like to give you something fun or useful at least once a day. Hopefully I’ll have a little more time in the next couple of weeks to blog from hotel rooms. I’m also considering bring my camera and video camcorder along and documenting some of the mayhem.
So… I guess today’s useful tip is that you should check out the links above and see if there is a Launch or a “Best of Launch” event coming to your area. Next week I’ll be presenting in Omaha and Kansas City (Merriam, KS). The following week I’m in Madison and Green Bay. The events are filling up fast (several are closed to new registrations) mainly because we’re giving away copies of software to every attendee, so REGISTER ASAP.
And if you live in the Minneapolis, St. Paul area, please come to the BIG LAUNCH event going on at the Minneapolis Convention Center on December 14th. I’ll be presenting Session 1 of the Data Platform track there, as well as helping out in the “Ask the Experts” area.
See you there!
Yes indeed… It has been announced that Windows AntiSpyware…
This is VERY good news. The AntiSpyware beta is being downloaded by 3 million new users per month… and has over 18 million active customers. It’s recieved great reviews, also. I’m using it as my only AntiSpyware at home, and that includes a family laptop that gets serious digital abuse by two teenage boys.
The folks at AnandTech have posted their first looks at the XBOX 360 – from the INSIDE!
Yep. They tore apart one of these babies, and have posted a bunch of photos and discussion on the various innerworkings.
Makes for a fun, interesting, geeky read.
Eileen Brown has posted on her weblog the news coming out of IT Forum this week that the next version of Microsoft Exchange Server – “Exchange 12” – will only be available for 64 bit platforms. (Yes, she said “only”.)
The official Press Release is here, outlining the 64–bit announcement as well as other great announcements that Bob Muglia made in his keynote speech.
Other of my team have blogged this, too:
Now… let’s discuss…
Here’s what I think, right now. I’m not sure. I'm still "on the fence" about how the public will react to this news. Yes, it's great for Enterprise customers. They will absolutely love it.
But small-to-mid-sized business is still quite skeptical about having to buy new hardware "just for the support of new software". In this case I wonder if we're not just encouraging the notion that Exchange 2003 is "good enough" for a long time to come.
What do you think?
SQL Server 2005 Tidbit 034
The following question was asked at a Recent “Best of SQL Server 2005 Launch” TechNet Event in Kansas City (Overland Park Kansas, actually. Had a lovely time there, thank you! …and although it was a bit of a dive, the Karaoke at the Red Balloon was a lot of fun!)
“DDL Triggers… Do you have to delete them to get rid of them? Can you simply disable and later re-enable them?”
Glad you asked, because I didn’t know, and now I do. Yes, that would certainly make sense. And indeed, it’s as simple as using the Transact SQL (T-SQL) commands DISABLE TRIGGER and ENABLE TRIGGER. Here’s some DDL Trigger sample code from the Books Online…
CREATE TRIGGER safety ON DATABASE FOR DROP_TABLE, ALTER_TABLE AS PRINT 'You must disable Trigger "safety" to drop or alter tables!' ROLLBACK;GODISABLE TRIGGER safety ON DATABASE;GOENABLE TRIGGER safety ON DATABASE;GO
The same holds true (though the syntax is different) for DML Triggers as well.
(NOTE: You’ll need to have SQL Server 2005 Books Online installed for the TRIGGER links above to work. I highly recommend it! It’s FREE!)
Microsoft took a big step into the Software Services world today, with some major announcements.
Here’s the Press Release on the subject…
To summarize – we announced a number of new, free online services. Some are still in the planning stages, and others are ready for you to try out. Click the picture above, or this link, to find out more about those services and give ‘em a try.
Personally, I’m pumped about saving my IE favorites online so they can be used anywhere.
I just now saw on Jeff Alexander’s blog that Virtual Server 2005 R2 has RTM’d (Released To Manufacturing). It’s shipped!
The announcement was made at IT Forum in Barcelona. Here’s the Press Release that followed this annoucement, and here’s the Virtual Server 2005 R2 web page.
Just one more reason, Nancy*, that we need to replace our home “server” with a 64 bit box.
* Nancy is my lovely wife as well as my better financial conscience.
Mr. Michael J. Murphy, coworker friend of mine, has produced his first in what I’m sure will be a long series of web radio shows (okay… some call them podcasts. I prefer just “casts”). The show is called IT Heros.
You can read his blog entry about it here.
Or click here to listen to the show.
Nice work, MJ! Keep ‘em coming!
PS – I am offering to SING the opening disclaimer over that blues riff he has playing on his show. We’ll see if he takes me up on it.
Yeah! I know a lot of people have been waiting for this.
(Not me, however.. I don’t yet have a Media Center. <sigh> They are so cool…)
Previously, if you wanted HDTV to play or be recorded through your Media Center, it had to come from an over-the-air HDTV broadcast.
Today, however, Microsoft and CableLabs have agreed to enable sending HDTV over the Cable to the PC… so future versions of Media Center PCs will be able to record High Def that comes in via Cable. Sweet!
“When are you gonna get YOUR Media Center, Kevin?”
Well… that was actually one of the hurdles I was waiting for them to overcome. Others are my kid’s braces, my kid’s college educations, a replacement TV for the TV we got as wedding gift 21 years ago (It’s as old as our marriage, and even more beat up!)… Oh… and a 64 Bit Server to support my home Exchange 12 installation… At this rate, I figure I’ll be able to buy a new family entertainment room setup probably sometime after 2017 and only slightly before the next ice age.
Do you own a Media Center? What do you think of this news?
I’ve posted the entire TechNet Webcast schedule, complete with breakdowns by topic or product/technology, as well as full descriptions, as an article HERE.
[Shameless Plug Alert]
Also, I’m delivering a couple of these. On December 20th I’ll be talking about using Microsoft Operations Manager (MOM) 2005 for Active Directory manangement. And on December 21st I’m covering the Management and Administration of SQL Server 2005.
And on December 22nd I’ll be doin all of my Christmas shopping. Ho Ho Ho.
SQL Server 2005 Tidbit 029
Another tidbit? It’s been awhile!
FAR too long. My apologies.
This tidbit is about a new flexible security feature in SQL Server 2005: SQL Server Agent Proxies.
In the past, if you wanted a job to have access to some secured subsystem, you had to basically give that job rights as the sa user, or some other account that you created specifically for all agent job steps. So the job had all-or-nothing access.
In SQL 2005, the SQL Server agent has access to some subsystems that it didn’t have access to before, such as SQL Server Integration Services, and Analysis Services.
But the big benefit in 2005 is that you can create or use Windows accounts or groups (but preferably accounts) that you specify, and then proxy those for the sake of agent jobs and those special protected tasks.
SQL Server 2005 Tidbit 030
30 tidbits. The bit “3 oh”. Our list is not a young list anymore.
This tidbit as a result of really good questions (aka questions I didn’t have a sufficient answer for or that I wanted to research more thoroughly) at our TechNet Events in Chattanooga and Knoxville, Tennessee. (Which reminds me… I had a great time down there! The people I met and worked with were so nice and friendly! Thanks for making this northern boy feel right at home!)
“You say that you can manage SQL Databases and even SQL 7 and SQL 2000 Servers with the SQL Server 2005 Management Studio. But what can’t you do to or with those databases or servers?”
Well… I have to correct myself on that one. At the time the plan was to be able to manage SQL 7 databases with the Management Studio. That changed before RTM. Currently only SQL 2000 and newer database servers can be managed using the Management Studio.
Note that this doesn’t mean you can’t still run SQL 7 and replicate or otherwise interact with your new 2005 databases.
That question is bigger than I can really address here… Your absolutely best source of answers to your specific questions of will-this-or-that-work-in-SQL-2005 is the books online.
“But Kevin… Don’t I need to buy SQL Server 2005 to get the books online?”
No! You can get a free, full, stand-alone downloadable and installable copy of the documentation! Click HERE for the download page.
SQL Server 2005 Tidbit 031
We got 31 flavors of tidbits for ya…
“I’d like some more information on the requirements for online defragmentation and indexing.”
Well, first of all… The new online index operations are only available in the Enterprise edition of SQL Server 2005.
The SQL Server 2005 Books Online has a great section on the requirments for performing Online Index Operations.
From the manual…(And if you have the books online already installed, clicking on this link will bring you right to the correct topic: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d82942e0-4a86-4b34-a65f-9f143ebe85ce.htm)
When you perform online index operations, the following guidelines apply:
The following table shows the index operations that can be performed online and the indexes that are excluded from these online operations. Additional restrictions are also included….
See the books online for the table, plus some additional considerations of Disk Space, Performance, and Transaction Log loads.
SQL Server 2005 Tidbit 032
“I want to program against and/or use table and database configuration information. Is there a way to access the metadata associated with those? Could I add my own metadata or comments into that area?”
This gentleman was looking for manipulating and using hidden information. He suggested that if it wasn’t available, it should be, perhaps in the form of a hidden column of data for each table.
I don’t know the answer to how programmable Metadata information is. (If someone else knows, please add it as a comment to this blog posting!)
However, you do have visibility to object metadata in SQL Server 2005 – although in fact, it’s much more tightly secured now. You won’t have the ability to access metadata about objects to which you haven’t been given permissions on.
For a description of Metadata Visibility, see the SQL Server 2005 Books Online “Metadata Visibility Configuration”
(NOTE: You’ll need to have SQL Server 2005 Books Online installed for that link to work. I highly recommend it! It’s FREE!)
SQL Server 2005 Tidbit 033
“I heard somewhere that you now can replicate some table schema changes during replication. Is this true?”
Yes indeed! From the Books Online:…
If you make the following schema changes to a published article, they are propagated, by default, to Microsoft SQL Server Subscribers:
You can use replication stored procedures to specify whether these schema changes are replicated. The stored procedure that you use depends on the type of publication.
The full books online article is found HERE.
Yes indeed… your PC can be more secure and healthy.
The Windows Live Safety Center is a place where anyone can quickly tune up their PC. There are three “Service Centers” where you can
your PC. There is also an online community forming there as well.
NOTE: This is a service still in BETA, but it’s well worth your time to check it out.
That says it all. Today in San Francisco Steve Balmer will keynote the offical launch event for SQL Server 2005, Visual Studio 2005, and BizTalk 2006.
And all over Microsoft, all over the world, we are “READY to ROCK the Launch”.
Today (if it’s not live yet, it will be soon) we also have a new Launch web site.
Personally… I’m celebrating the launch by flying to Omaha, Nebraska, so that tomorrow I can deliver a “Best of SQL Launch” event, with “jaw-dropping content and demos”, to over 500 screaming IT Pros and Developers.
…and I hope you’re one of them!
In preparation for our series of “Best of SQL Launch” events, I put together a page of resources that I hand out to my event attendees. I figure that it beats having to try and quickly write down URLs as they fly by in the slides… and it gives you something else to scribble on, too.
“But I hate typing those long URLs when I get home, Kevin!”
I hear ya! That’s why I’m making the document available HERE as well, so you can just click on the links!
I hope you’ll make good use of these resources.
And if you came to the event, don’t forget to dive into that awesome Resource DVD that we gave you.
(Trust me – that DVD alone is worth the trouble to come to our events these days!)
READY to ROCK the LAUNCH!
Earlier Today I delivered a webcast (content number ADD-03) on considerations for planning a complex AD design. I thought I’d post some of the Q&A here, and maybe expand on some of the answers also.
Thanks again to Blain Barton, Chris Avis, and Rob Westover, for helping out in a pinch to handle Q&A for all of us.
Also, if you’re interested, here is the Resource Document I put together for this webcast.
“Cross Forest GPO's, can I use local resources in forest #2 with a forest #1 GPO's? Should the users from forest #1 have ACL & Share permissions so they can access the resources instead of having them access the resources back on Forest #1 and across a WAN connection. Looking for some advice.”
Re: GPOs working cross-forest… this is not possible. Group Policy is defined in a domain, and is applicable to domain member machines and users at the site, domain, OU, or sub-OU levels. If you want Group Policy objects to exist or be applied in other forests, you can back them up from where they have been created and then IMPORT them into pre-existing or newly created Group Policy objects in the other forest.
As for your ACL question… well, that’s the beauty of Forest trusts. As long as Forest 2 trusts Forest 1, your users in Forest 1 can be granted access to resources in Forest 2.
I am not sure if that answers all of your question. If you have more, please contact me here or email me.
“I have a site without a DC. How can I force a client at that site to logon through a particular DC?”
If you have defined your site links properly, then the user should login using the path to the nearest (least cost path) DC. However, as one of my Q&A helpers pointed out, there are situations where you can, for example, tell Outlook to contact a particular GC…
“In some situations, you may notice excessive network traffic when Microsoft Outlook attempts to contact the global catalog server. This article describes how to configure Outlook to a specific global catalog server or to the closest global catalog server. Note If the global catalog server and the Exchange Server computer are in the same site as the Outlook client, you do not need to make this registry setting. The normal referral mechanism provides the best performance. Check out: http://support.microsoft.com/default.aspx?scid=kb;en-us;319206”
“Do you recommend to create a site corresponding a VLAN where there is no DC at remote site for a group of 20 users (20 users have a different VLAN or network ID)?”
You should at least apply Global Catalog caching, but I would make every attempt to have a DC in each site - purely for authentication reasons. The latency caused by authentication traffic just becomes too burdensome.
“Is there a source for these numbers being presented?”
Check this blog entry for the resources supporting the numbers presented.
“Can you briefly explain what is a schema master? We have not run into any usage of that particular term. We run a single domain.”
The domain controller that holds the schema master role is the only domain controller that can perform write operations to the directory schema. Schema updates are replicated from the schema master to all other domain controllers in the forest.
“what happens when the needed bandwidth grows to exceed the allotted bandwidth”
Traffic slows down to levels below desired targets
“Which Performance monitors should i use to analyze AD replication traffic?”
Start Here --> http://www.microsoft.com/technet/prodtechnol/windows2000serv/technologies/activedirectory/maintain/opsguide/part1/adogd02.mspx
Yep… another day, another webcast!
I’m presenting this “TechNet Webcast: Technical Overview of DNS in Windows Server 2003” today.
Here are some resources relating to this session’s topic. I hope you find them useful, and that you are either joining me live for the webcast, or will be viewing it at some later date.
“How DNS Works”http://www.microsoft.com/Resources/Documentation/windowsserv/2003/all/techref/en-us/w2k3tr_dns_how.asp
“How DNS Query Works”http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/sag_DNS_und_HowDnsWorks.asp
“DNS Domain Names”http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/sag_DNS_und_DomainNames.asp
“DNS Requirements for Installing Active Directory”http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/sag_dns_und_dcpromo_requirements.asp
“Understanding Zones and Zone Transfers”http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/sag_DNS_und_ZoneTransfers.asp
“Active Directory Integration”
“DNS Overview – Server Features”
MSDN – Platform SDK – Active Directory Partitions
“Understanding Aging and Scavenging”http://www.microsoft.com/resources/documentation/WindowsServ/2003/enterprise/proddocs/en-us/Default.asp?url=/resources/documentation/windowsserv/2003/enterprise/proddocs/en-us/sag_DNS_und_AgingScavenging.asp
“Using Server Debug Logging Options”
Official Series Resource Pagehttp://www.microsoft.com/technet/tnt4–04
Free Windows Server 2003 Virtual Labs:http://www.microsoft.com/technet/traincert/virtuallab/windowsserver2003.mspx
Windows Server 2003 Evaluation kit:http://www.microsoft.com/windowsserver2003/evaluation/trial/evalkit.mspx
Windows Server 2003 Training and Events:http://www.microsoft.com/windowsserver2003/techinfo/training/default.mspx
New and improved Microsoft Events page:
New and improved Microsoft Events page: