Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
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.
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?
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.
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.
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!)
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.
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?
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.
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!
E-mail Technical Questions: Kevin Remde – Kevin.Remde@microsoft.com
Kevin’s Blog “Full of I.T.” – Additional Resources and Discussion
Feedback E-mail to my boss: Melanie Brunner – firstname.lastname@example.org
Future Live, In-Person Event Information
Microsoft Across America: http://www.microsoft.com/acrossamerica
TechNet Events Bloggers - http://techneteventsbloggers.net
(Add your blog, or subscribe to IT Pro focused blog postings)
Microsoft Learning - Training Resources
SQL Server 2005 Upgrade Session Resources:
Introducing SQL Server 2005: http://www.microsoft.com/sql/2005/
Top 30 Features
SQL 2005 Feature Comparison by Edition
SQL Server 2005 System Requirements
Educational Webcast Series: “Get Ready for SQL Server 2005”
TechNet webcasts are designed specifically for the IT Professional, offering in-depth information on how to plan, deploy, and manage Microsoft products and technologies, such as Microsoft SQL Server, Microsoft Exchange Server, Windows Server, Microsoft Internet Information Services, and Microsoft Content Management Server.
TechNet Webcast Series: Upcoming & On-Demand
Upcoming TechNet Webcasts
· By Topic
· By Product/Technology
· NEW: TechNet Events and Webcasts blogger site.
§ Check out the TechNet Webcasts Weblog.
§ TechNet Webcast Calendar
§ Security Webcast Calendar
Now you can register for an on-demand webcast and choose how you would like to view the archive (for webcasts that took place December 1, 2004 or later). Register to view an on-demand webcast and download a .wmv of the webcast immediately. By registering, you will also receive a confirmation email the following day with a link to the PPT download.
Additional Webcast Resources
Exchange Server 2003 in Depth: Master concepts and optimize your server environmentLive and on-demand webcasts available now
Are you looking to get the most out of your messaging environment? Then join us for this in-depth 14-part series as we show you the ins-and-outs of Exchange Server 2003. Through the use of live product demonstrations, interactive presentations, "pop" quizzes and weekly homework assignments, our subject matter experts help you understand key concepts which are critical for any Exchange Administrator or IT Professional to understand. Topics covered include Managing Recipient objects, SMTP, Exchange Server Security, Troubleshooting, Exchange Server 2003 Service Pack 2, Administrative Best Practices and more! Plus, attend any of the live webcasts through December 14, 2005 and you could win an i-mate Smartphone! See official rules for more details.
Master Administrative Scripting with Don Jones
Second Tuesday of every month; on-demand webcasts available now
Join us as Scripting guru Don Jones—Microsoft MVP, creator of ScriptingAnswers.com, MCSE, author, speaker, consultant, scripting geek, and all-around Windows administrator—presents timely topics targeted at administrators, helping you script better, faster, and more.
A More Secure and Well-Managed Enterprise: Liberate your infrastructure
Live and on-demand webcasts available now
Attend this series and learn how to become a dynamic IT organization and achieve operational effectiveness through delivering higher quality of service, email availability, and a more secure Windows environment. Our technical experts help guide you through step by step instructions on how to install, configure, automate and mange a more secure and well managed infrastructure. Bonus: attend four of the five webcasts (live or on demand) in this series during the month of December and you will receive a Microsoft Lexan water bottle*.
Scripting Week 3: Script it up a Notch
On-demand webcasts available nowDuring Scripting Week 3, the Scripting Guys show you how to kick your scripts up a notch (and sometimes 2 or 3 notches). Learn how to quickly modify your scripts so they run against all the computers in an organization unit or all the computers listed in a text file. Learn how to create output that not only has aesthetic appeal but is much easier to read and understand. Learn how to craft graphical user interfaces that feature checkboxes, radio buttons, dropdown lists, and all the other GUI controls you know and love. Scripting Week 3: it’s the answer to all of life’s problems. (Legal disclaimer: Scripting Week 3 is not the answer to all of life’s problems. But it can’t hurt.)
SQL Server 2005: Upgrade your skills to 2005
Live and on-demand webcasts available nowLearn how Microsoft SQL Server 2005 can help you leverage your existing investment in business intelligence without sacrificing the ability to extend and add cutting-edge functionality. Through the use of interactive presentations and live product demos, we step you through all the major enhancements in SQL Server 2005 and demonstrate how you can bring these benefits to your organization.
TechNet Webcast Calendar
TechNet webcasts listed in an easy-to-use calendar format.
Security Webcast Calendar
Security webcasts listed in an easy-to-use calendar format.
TechNet Webcasts Weblog.
Bonus: Attend any live webcast through June 2006 and you could win a 40 GB MP3/WMA player. See official rules for more details. Offer open to residents of the U.S. and Canada only.
Additional Live & On-Demand Webcast Series Available Now:
§ Active Directory
§ Ask the Security Experts
§ Business Intelligence with SQL Server 2005
§ Desktop Deployment
§ Group Policy
§ ISA Server 2004
§ Managing a Microsoft Infrastructure
§ Microsoft Office Visio 2003
§ Microsoft Project
§ Real-Time Collaboration
§ Tech·Ed 2005 Webcast Series
§ To Active Directory and Beyond: Learn Windows migration strategies
§ Windows Mobile
§ Windows Server 2003
*Offer good for the first 1000 attendees of the A Secure, Well-Managed Infrastructure webcast series to attend 4 of the 5 December webcasts by December 31, 2005. A webcast evaluation must be submitted to gain attendance credit. Eligible webcasts are: TechNet Webcast: A More Secure and Well Managed Infrastructure Parts 14-18 of 18. This offer is non-transferable. This offer open to residents of the U.S. and Canada and is valid from December 1 through December 31, 2005. Please allow 8-10 weeks for delivery.
TechNet Webcast: Using Windows Event Logging to Enhance Compliance and Security (Level 200)
Thursday, December 01, 2005 - 11:00 AM - 12:30 PM Pacific Time
Upesh Patel, Vice President, Product Marketing, Network Intelligence Corporation
Have you considered your security and compliance posture from an “inside” or host-based perspective? The event logs in Microsoft Windows contain crucial information about your system, security, and applications. This information can help you identify and resolve real-time security breaches such as root kit installations. This webcast demonstrates how to use the monitoring and reporting data that you can automatically collect with Microsoft Internet Information Server (IIS), Microsoft Internet Security and Acceleration Server (ISA), Microsoft SQL Server, and the Windows platform. This data provides you with an accurate picture of failed attempts to log on, changes to the status of accounts and privileges, and accounts that have been misused or locked out. We also show you how to map specific Windows compliance reports with regulatory rules and requirements such as Sarbanes-Oxley, Gramm-Leach-Bliley, and the Federal Information Security Management Act of 2002 (FISMA).
TechNet Webcast: Deciphering the Tools of the Trade: A Review of IIS Stress Testing Toolsets (Level 200)
Thursday, December 1, 2005 - 11:30 AM - 1:00 PM Pacific Time
Chris Adams, Program Manager, Microsoft Corporation
Are you new to Microsoft Internet Information Services (IIS)? Have you been assigned to deploy 200 Web servers in the next year, but you don't want to configure all of those servers individually? You can easily use IIS Manager to create a set of sites and virtual directories, as well as enable security for all of them. In the past, the Microsoft Web Application Stress tool was used to apply load to a Web server to simulate the true usage of Web applications. This webcast outlines how IIS Manager tools work and helps administrators and developers determine the right tool for a given environment.
TechNet Webcast: An Overview of the SQL Server 2005 Upgrade Process (Level 200)
Michael Schechter, Software Development Engineer, Microsoft Corporation
This overview webcast provides you with the background you need to choose the best strategy for upgrading your system to Microsoft SQL Server 2005. Find out how to identify any incompatibility issues that you must address before you begin the process and how to prepare your system for a successful upgrade. We also offer tips and techniques that can help you make the most effective use of the upgrade tools and minimize downtime during the upgrade process.
TechNet Webcast: A More Secure and Well-Managed Infrastructure (Part 14 of 18): SMS 2003 Software and Patch Management (Level 300)
Friday, December 2, 2005 - 9:30 AM - 10:30 AM Pacific Time
John Baker, TechNet Presenter, Microsoft Corporation
Continuing on from the points addressed in our previous webcast, this webcast session shows how to use Microsoft Systems Management Server 2003 (SMS 2003) for patch management and software management. Learn how to use this product and how SMS 2003 can help you deploy software and patches to numerous locations.
TechNet Webcast: Exchange Server 2003 In Depth (Part 11 of 14): Exchange Best Practice Analyzer (Level 200)
Friday, December 2, 2005 - 11:30 AM - 12:30 PM Pacific Time
Harold Wong, Technology Specialist, Microsoft Corporation
The Microsoft Exchange Server Best Practices Analyzer Tool (ExBPA) is an automated health check and troubleshooting tool. An essential tool for any Exchange administrator the ExBPA collects configuration settings and performs network and protocol tests in an Exchange topology. Join this webcast as we will cover what the tool is and how to install it, set it up, and use it.
TechNet Webcast: How Microsoft Does IT: Using Business Scorecard Manager 2005 to Enhance Business Performance (Level 300)
Tuesday, December 6, 2005 - 8:00 AM - 9:00 AM Pacific Time
Bruno Aziza, Microsoft Product Manager, Microsoft Corporation
Daniel Rubiolo Mendoza, Office Business Scorecard Manager - Microsoft Operations Manager, Microsoft Corporation
The Microsoft IT team has integrated Microsoft Office Business Scorecard Manager 2005 into its business performance management system. Would you like to learn the methods the team used and their advantages? Join this webcast to learn how to enhance the execution of your business strategy by integrating performance information into an accessible Microsoft SharePoint user environment. The performance information is clearly associated with supporting contextual data and seamlessly shared across the enterprise. This webcast shows how Microsoft IT monitors performance against objectives and facilitates accountability.
TechNet Webcast: Virtual Server: Advanced Scripting and Other Secrets (Level 300)
Tuesday, December 6, 2005 - 1:00 PM - 2:00 PM Pacific Time
Allen Stewart, Architect - Microsoft Consulting Services, Microsoft Corporation
Robert Osborne, Project Manager, Microsoft Corporation
Jim Ni, Group Product Manager, Microsoft Corporation
Peter Doulas, Senior Product Manager with US BMO Windows Server Group, Microsoft Corporation
Microsoft Virtual Server 2005 provides a powerful selection of Component Object Model (COM) interfaces for manipulating all facets of a virtual machine. These interfaces can support everything from provisioning to day-to-day management operations. Join this webcast as we showcase the COM application programming interface (API) and demonstrate a range of scripting examples. We also demonstrate how partners are using the API to turn provisioning and management functionality into products.
TechNet Webcast: Making the Transition from Lotus Domino Messaging to Exchange Server (Level 200)
Wednesday, December 7, 2005 - 8:00 AM - 9:00 AM Pacific Time
Erik Ashby, Exchange Program Manager, Microsoft Corporation
Gary Devendorf, Technical Evangelist, Microsoft Corporation
Join this webcast to get in-depth knowledge of the recommended process for transitioning from an IBM Lotus Domino to a Microsoft Exchange Server messaging topology. Learn about the best path to an easy transition, and find out about recent updates to the tools available from Microsoft that can help you migrate from IBM Lotus Notes and Domino.
TechNet Webcast: A More Secure and Well-Managed Infrastructure (Part 15 of 18): Automating Desktop Configuration with SMS 2003 OSD (Level 300)
Wednesday, December 7, 2005 - 9:30 AM - 10:30 AM Pacific Time
Open Software Description (OSD) is an Extensible Markup Language technology that describes software components and their relationships to other components. The OSD vocabulary is a standardized way to describe software components, their versions, their underlying structures and their dependence on other components. Concluding this series-within-a-series about Microsoft Systems Management Server, this webcast shows how to use the OSD to enable organizations to deploy a standard set of desktop operating systems.
TechNet Webcast: Using the Security Configuration Wizard Effectively with IIS 6.0 and Windows Server 2003 and Service Pack 1 (Level 200) - Part I (Level 200)
Wednesday, December 07, 2005 - 11:30 AM - 1:00 PM Pacific Time
In this two-part series, you learn about the updated Security Configuration Wizard (SCW) that ships as part of the Microsoft Windows Server 2003 Service Pack 1. This first session describes SCW's built-in capability to tighten security across all Web sites on a single server. The discussion highlights how the SCW is designed and how to use it to reduce the attack surface of your Web server. This configuration, which can be stored for later use, is vital for helping Web application servers achieve higher availability with less opportunity for service failures.
TechNet Webcast: Exchange Server 2003 In Depth (Part 12 of 14): Client Security (Level 200)
Wednesday, December 07, 2005 - 11:30 AM - 12:30 PM Pacific Time
This webcast covers client security for use with Microsoft Office Outlook, Microsoft Office Outlook Web Access (OWA), and POP3 and Internet Message Access Protocol version 4rev1 (IMAP4) access (except mobile devices, which are covered in Part 13). The Outlook segment presents security features that relate to attachments security, address book and object model access, security zones, S/MIME, Remote Procedure Call over HTTP and Information Rights, anti-virus protection, and spam protection through filters. The OWA segment shows how to secure OWA access, Secure Sockets Layer with OWA, how to enable and configure it, S/MIME within the OWA environment, the infrastructure, and integration with firewalls and publishing through Microsoft Internet Security and Acceleration Server. The presentation concludes by addressing POP3 and IMAP4, following the same steps as with Outlook and OWA.
TechNet Webcast: Securing SharePoint 2003 Sites with ISA Server 2004 (Level 300)
Thursday, December 08, 2005 - 9:00 AM - 10:30 AM Pacific Time
Michael Noel, Consultant, Convergent Computing
Colin Spence, Consultant/Partner, Convergent Computing
This webcast provides guidelines for securing Web access to Microsoft Office SharePoint Portal Server 2003 sites using the advanced application layer filtering in Microsoft Internet Security and Acceleration (ISA) Server 2004. Learn undocumented ways that you can secure SharePoint sites, such as using an ISA Server in the perimeter network (also known as DMZ, demilitarized zone, and screened subnet) of an existing firewall. Find out how to secure SharePoint Portals that are encrypted by Secure Sockets Layer (SSL). Get tips and tricks for increasing the security of an externally facing SharePoint environment. In addition, this webcast offers advanced techniques, such as port redirection and link translation.
TechNet Webcast: An Introduction to SharePoint Products and Technologies (Level 100)
Thursday, December 8, 2005 - 9:30 AM - 10:30 AM Pacific Time
David Smith, Senior Consultant, Entirenet
Microsoft SharePoint Portal Server helps teams to work together, follow best practices, make better decisions, and obtain the information and applications that are most relevant to them. Designed for those new to the program, this webcast demonstrates the collaboration functionality that SharePoint products and technologies provide. Learn how to publish a consolidated view of the information pertinent to the knowledge workers in your organization. Join us online to find out how to personalize, integrate, and collaborate using SharePoint Portal Server.
TechNet Webcast: Dialing for Desktops: Microsoft Communicator and PBX Integration Calling (Level 200)
Thursday, December 8, 2005 - 11:30 AM - 12:30 PM Pacific Time
Adam Marlin, Director of Sales & Strategic Alliances, Siemens
Would you like to simplify your desktop devices by using one device to manage all communication? Now you can. Siemens HiPath OpenScape Telephony Control Link (TCL) integrates your existing Private Branch Exchange (PBX) voice networks with Microsoft Live Communications Server 2005 and Microsoft Office Communicator 2005, an open, standards-based Instant Messaging (IM) client for the enterprise. HiPath OpenScape TCL extends the capabilities of Live Communications Server and Office Communicator by enabling PBX telephony functions in the client. Check out this webcast to learn more about this valuable solution, and see how it can enhance your employees’ productivity and provide significant cost savings for your business.
TechNet Webcast: SQL Server 2005 Failover Clustering for SQL Server 2000 Users (Level 200)
Friday, December 9, 2005 - 8:00 AM - 9:30 AM Pacific Time
Allan Hirt, Consultant, Avanade, Inc.
Have you implemented a Microsoft SQL Server 2000 failover cluster (or two)? If you plan to migrate your SQL Server 2000 implementation to a Microsoft SQL Server 2005 failover cluster, this webcast offers a comparison of failover clustering in the two versions. We discuss new features and issues that you should watch out for during your upgrade process. In addition, we highlight important things you should know when you implement a SQL Server 2005 failover cluster alongside one or more existing instances of SQL Server 2000.
TechNet Webcast: A More Secure and Well-Managed Infrastructure (Part 16 of 18): Using MOM to Monitor Your Environment (Level 300)
Friday, December 9, 2005 - 9:30 AM - 10:30 AM Pacific Time
Adding servers to an environment to add business value might seem easy, but you must consider the costs of keeping all those servers running, secure and up to date. This webcast presents an example organization that has chosen Microsoft Operations Manager (MOM) to help manage a rapidly growing network. This webcast and the one to follow examine how our example organization leveraged MOM and the MOM Management packs to reduce management overhead. See how our example organization monitors its servers worldwide, how the design points for deploying MOM were chosen, how the server locations were decided and how all servers were monitored.
TechNet Webcast: Exchange Server 2003 In Depth (Part 13 of 14): Mobility (Level 200)
Friday, December 9, 2005 - 11:30 AM - 12:30 PM Pacific Time
This webcast covers the mobility support in Microsoft Exchange Server 2003, including the new mobility features in Microsoft Exchange Server 2003 Service Pack 2 (SP2) and Windows Mobile 5.0. The webcast provides a brief overview of Open Mobile Alliance, and then shows how to configure and enable OMA, before covering some security considerations. From there the webcast discusses Wireless Application Protocol (WAP) access considerations, examining WAP 1.x and WAP 2.0 gateways and how they affect Secure Sockets Layer traffic. The presentation concludes with a brief Windows Mobile 5.0 discussion featuring the Messaging & Security Feature Pack, its integration with SP2, the features of SP2, and what business issues it solves.
TechNet Webcast: Managing Windows Mobile Devices with the Messaging and Security Feature Pack (Level 300)
Monday, December 12, 2005 - 9:30 AM - 10:30 AM Pacific Time
Khalid Siddiqui, Mobility Architect, Microsoft Corporation
As mobile devices become a larger part of the information technology (IT) infrastructure, managing them becomes a greater challenge. Join this webcast to learn how device management works on the Microsoft Windows Mobile platform. See demonstrations of features and functionality, and learn how to use the components of Windows Mobile that provide device management capability. We also illustrate how you can utilize the Messaging and Security Feature Pack in an enterprise environment.
TechNet Webcast: Planning and Deploying Systems Management Server (SMS) 2003 (Level 200)
Monday, December 12, 2005 - 9:30 AM - 11:00 AM Pacific Time
Chris Avis, TechNet Presenter, Microsoft Corporation
Planning and deploying your Microsoft Systems Management Server (SMS) 2003 environment helps to ensure that your installation is a success. This webcast presents the best practices for deployment and introduces the tools available to assist you with your SMS 2003 installation. This webcast demonstrates the Capacity Planner tool in SMS 2003 that can help model the topology of your proposed SMS site and suggest appropriate configurations for your SMS site systems.
TechNet Webcast: SQL Server 2005 Analysis Services: Preparing to Migrate (Level 200)
Monday, December 12, 2005 - 11:30 AM - 1:00 PM Pacific Time
Thierry D'Hers, Program Manager Lead, SQL Server, Microsoft Corporation
T.K. Anand, Program Manager, SQL Server, Microsoft Corporation
Migrating from Microsoft SQL Server 2000 to SQL Server 2005 could be a daunting task. If you face this challenge, you will want to join this webcast to learn about the options available for migrating SQL Server 2000 Analysis Services solutions to SQL Server 2005. We explain the trade-offs involved to help you make better-informed decisions for your own implementation. We also summarize the known issues with backward compatibility and suggest some strategies that you might use to mitigate potential issues in your own implementation.
TechNet Webcast: Microsoft Solutions for Windows Update Management (Level 200)
Monday, December 12, 2005 - 11:00 AM - 12:30 PM Pacific Time
What is Microsoft Windows Update management? Why do you need to manage updates, and how should you go about it? Learn the answer to these questions and more in this webcast for information technology (IT) professionals. This webcast lays out the business case for update management, the vulnerability timeline, and how the vulnerability timeline shortens with every new vulnerability. Discover what the various severity ratings that are attributed to vulnerabilities mean and the ways that Windows Update management has improved the update experience by making it as straightforward as possible. Attend this webcast that explores the components of the update management solution and demonstrates how they work.
TechNet Webcast: Identity and Access Management (Part 1 of 2): Technical Overview (Level 200)
Tuesday, December 13, 2005 - 9:00 AM - 10:00 AM Pacific Time
This two-part series describes how you can use identity management solutions to create and manage user account information efficiently and securely across multiple systems in an enterprise. This first webcast shows how identity information may be shared and synchronized even when distributed across several different locations. We show how access management solutions can help you to ensure that user accounts are granted the appropriate access to resources across different systems in an enterprise network.
TechNet Webcast: How Microsoft IT Deployed Active Directory Federation Services (ADFS) and Distributed File Replication Services (DFSR) (Level 300)
Tuesday, December 13, 2005 - 8:00 AM - 9:00 AM Pacific Time
Brian Puhl, Microsoft, Sr. Systems Engineer, Microsoft Corporation
Active Directory Federation Services (ADFS) is a new component in Microsoft Windows Server 2003 R2 that helps companies to extend their authentication infrastructure across enterprise and organizational boundaries. Come listen to engineers on the Microsoft IT team discuss the challenges and opportunities of designing and deploying an ADFS infrastructure.
TechNet Webcast: Mastering Multi-Computer Scripts (Level 200)
Tuesday, December 13, 2005 - 9:30 AM - 10:30 AM Pacific Time
Don Jones, Microsoft MVP, Book Author, and Founder of ScriptingAnswers.com
Turn those single-computer scripts into multi-computer powerhouses. In this webcast, learn techniques for writing single-computer scripts that are easy to test and debug, and even easier to incorporate into multi-computer wrapper scripts. You will have access to several wrappers that target computers from lists, in Microsoft Active Directory, and more. Go from scripting a single computer to scripting your entire environment in less than an hour.
TechNet Webcast: Reap the Immediate Benefits of Upgrading to SQL Server 2005 (Level 200)
Tuesday, December 13, 2005 - 9:30 AM - 11:00 AM Pacific Time
Don Vilen, Program Manager, SQL Server, Microsoft Corporation
Do you know what benefits you can deliver to your organization just by upgrading to Microsoft SQL Server 2005? Join this webcast to find out. Even if you do not use all the new features in SQL Server 2005, such as database mirroring and partitioning, or writing stored procedures in Microsoft .NET languages, you can still reap great benefits. This webcast introduces the many new features in SQL 2005 that you can utilize, without rewriting your applications or undertaking any new development efforts. We provide many examples where you can improve your system’s performance, concurrency, and availability simply by upgrading.
TechNet Webcast: Automating a Dev/Test Lab with Virtual Server 2005 (Level 300)
Tuesday, December 13, 2005 - 11:30 AM - 12:30 PM Pacific Time
Mike Sterling, Program Manager - Virtual Machine
Virtualization can significantly reduce the cost of developing and testing complex, multitier applications. Are you ready to take advantage of this new, automated technology? Join this webcast to learn how virtualization is changing development and testing. The webcast includes real world examples of how Microsoft Virtual Server 2005 can automate the configuration, integration, and management of virtual machines. Virtual Server 2005 also enables more flexible deployments and increases developer productivity for better test coverage. Learn how you can provision and manipulate several servers “virtually” without using a lot of physical hardware.
TechNet Webcast: Windows Server 2003 R2 Technical Overview (Level 200)
Tuesday, December 13, 2005 - 11:30 AM - 1:00 PM Pacific Time
Chris Henley, IT Evangelist, Microsoft Corporation
This webcast provides an end-to-end overview of Microsoft Windows Server 2003 R2. We discuss three key scenarios: simplified branch management, identity management, and efficient storage management. We also examine new and improved features that are related to each scenario.
TechNet Webcast: From DTS to SSIS: Making the Move to SQL Server Integration Services (Level 200)
Tuesday, December 13, 2005 - 1:00 PM - 2:30 PM Pacific Time
James Howey, Program Manager, SQL Server, Microsoft Corporation
Are you considering the move from Data Transformation Services (DTS) in Microsoft SQL Server 2000 to SQL Server Integration Services (SSIS) in Microsoft SQL Server 2005? SQL Server upgrades do not typically affect DTS processing, but there are some things you should know. With SSIS, you can: use the Upgrade Advisor to inventory your DTS packages and scope your migration efforts; use a wizard to ease the task of migrating and porting packages to SSIS; and successfully respond to situations that may require additional effort. Join this webcast to learn how to get ready to plan and implement your move to SSIS.
TechNet Webcast: A More Secure and Well-Managed Infrastructure (Part 17 of 18): Using MOM Management Packs to Monitor Your Environment (Level 300)
Wednesday, December 14, 2005 - 9:30 AM - 10:30 AM Pacific Time
Continuing from the previous webcast, this webcast shows how our example organization used Microsoft Operations Manager (MOM) to manage its environment. This installment examines a variety of management packs to monitor Microsoft Systems Management Server, Microsoft Internet Security and Acceleration, Sybari Antigen and third-party servers.
TechNet Webcast: Upgrade Considerations for Query Optimizer Statistics (Level 200)
Wednesday, December 14, 2005 - 9:30 AM - 11:00 AM Pacific Time
Lubor Kollar, Group Program Manager, SQL Server, Microsoft Corporation
Are you facing the prospect of a statistics upgrade? Or do you need to consider it, but have not done so? If yes, what steps should you take? Does Microsoft SQL Server 2005 provide anything new in statistics? If so, how could you benefit? This webcast answers these questions and many more. Join us for a deep dive into “Upgrade Considerations for Query Optimizer Statistics.”
TechNet Webcast: Exchange Server 2003 In Depth (Part 14 of 14): Exchange Server 2003 Service Pack 2 (Level 200)
Wednesday, December 14, 2005 - 11:30 AM - 12:30 PM Pacific Time
This final webcast looks at the new features within Microsoft Exchange Server 2003 SP2. We will cover the improvements in the Intelligent Message Filter and the mailbox enhancements, increased storage limits for standard edition, as well as some of the mobility improvements in the service pack.
TechNet Webcast: Administering and Maintaining the Branch Office Technologies in Windows Server 2003 R2 (Level 300)
Wednesday, December 14, 2005 - 1:00 PM - 2:30 PM Pacific Time
Dan Boldo, Program Manager, Microsoft Corporation
Take a tour of the day-to-day operations that administrators are likely to encounter after they deploy the branch office technologies in Microsoft Windows Server 2003 R2. These technologies include distributed file system (DFS) namespaces, DFS replication, DFS management tools, DFS diagnostics tools, and the Microsoft Operations Manager 2005 Management Pack. This webcast covers a range of informative topics, including configuration, delegation, replication, monitoring, and the best practices that can help keep users at branch offices happy.
TechNet Webcast: Information About Microsoft December Security Bulletins (Level 200)
Wednesday, December 14, 2005 - 11:00 AM - 12:00 PM Pacific Time
Christopher Budd, CISA, CISM, CISSP, ISSMP Security Program Manager, PSS Security, Microsoft Corporation
Stephen Toulouse, Security Program Manager, Microsoft Corporation
On December 13, 2005, Microsoft releases its monthly security bulletins. Join us for a brief overview of the technical details of the December security bulletins. The intent of this webcast is to address your concerns. Therefore, most of our time is devoted to giving you the opportunity to ask questions about the bulletins and get answers from our security experts.
TechNet Webcast: Using the Security Configuration Wizard Effectively with IIS 6.0 and Windows Server 2003 and Service Pack 1 (Level 200) - Part II (Level 200)
Wednesday, December 14, 2005 - 11:30 AM - 1:00 PM Pacific Time
This second half of our webcast series shows how the Microsoft Windows Server 2003 Security Configuration Wizard (SCW) stores the configuration used to tighten security on the Web server. The SCW can help Web administrators and developers ensure that Internet Information Server Web servers start with a similar configuration. This session shows how to create a standard SCW configuration file and extend it to make other Web servers behave the same. This presentation also explains how to roll back changes introduced by the SCW to ensure safe recovery.
TechNet Webcast: Identity and Access Management (Part 2 of 2): Details of Intranet and Extranet Access Management (Level 200)
Thursday, December 15, 2005 - 9:00 AM - 10:00 AM Pacific Time
This two-part series describes how you can use identity management solutions to create and manage user account information efficiently and securely across multiple systems in an enterprise. Having described the principles and concepts of access management in the first webcast, this second webcast explains in more detail how to apply these principles and methods specifically to your organization's intranet, and also how to apply them to an external network.
TechNet Webcast: Virtual Server: Architectural Best Practices (Level 300)
Thursday, December 15, 2005 - 9:30 AM - 10:30 AM Pacific Time
Bryon Surace, Program Manager - Virtual Machine
Today’s information technology (IT) organizations are under pressure to reduce costs and prioritize spending on new equipment. Virtualization technology is emerging as an effective way to increase productivity and deployment flexibility. Virtualization can provide an effective way to consolidate production servers. Join this webcast for a discussion of using Microsoft Virtual Server in the real world and how you can apply it in your IT organization.
TechNet Support WebCast: Troubleshooting public folder replication - Level 300Thursday, December 15, 2005: 10:00 A.M. Pacific time (Coordinated Universal Time - 7 hours).
Provides an overview of public folder replication. Discusses how to troubleshoot public folder replication problems by reducing the problem area. Talks about what data to collect and what tools to use to troubleshoot public folder replication problems.
TechNet Webcast: Identity Management and Active Directory Federation Services in Windows Server 2003 R2 (Level 200)
Thursday, December 15, 2005 - 11:30 AM - 1:00 PM Pacific Time
This technical webcast focuses on the identity management scenario in Microsoft Windows Server 2003 R2. Our discussion includes a review of the Active Directory Application Mode (ADAM) and UNIX Identity Management features. We also provide an in-depth exploration of Active Directory Federation Services.
TechNet Webcast: Upgrading to SQL Server Agent in SQL Server 2005: Issues to Consider (Level 200)
Gops Dwarakanathan, SQL Agent Program Manager, Microsoft Corporation
Before you upgrade a component of Microsoft SQL Server, you must be informed of any issues that might arise. This webcast addresses what to consider as you prepare to upgrade to SQL Server Agent in Microsoft SQL Server 2005. We discuss changes to the following from an upgrade point-of-view: Agent stored procedures, tables and views, registry knobs, proxy accounts, notification mechanisms, master and target server (MSX/TSX) operations, and service accounts. We also explain architectural changes that positively affect you, and we describe known issues and how to work around them.
TechNet Webcast: Planning and Deploying Microsoft Operations Manager (MOM) 2005 (Level 200)
Friday, December 16, 2005 - 8:00 AM - 9:30 AM Pacific Time
Join this webcast for a complete look at Microsoft Operations Manager (MOM) 2005, whether you are upgrading or newly installing a MOM 2005 management solution. Learn about MOM 2005 features and components, deployment topologies and scenarios, planning considerations, upgrade tips, and security settings.
TechNet Webcast: A More Secure and Well-Managed Infrastructure (Part 18 of 18): Product Road Map and Beyond (Level 200)
Friday, December 16, 2005 - 9:30 AM - 10:30 AM Pacific Time
Matt Hester, TechNet Presenter, Microsoft Corporation
This final webcast examines the Microsoft product roadmap. It shows where the various products discussed throughout this series are heading and how they will integrate in the future.
TechNet Webcast: Troubleshooting Systems Management Server (SMS) 2003 (Level 200)
Friday, December 16, 2005 - 9:30 AM - 11:00 AM Pacific Time
Troubleshooting Microsoft Systems Management Server (SMS) 2003 installations can be a difficult task unless you know where to look and what to look for. This webcast examines some of the common problems you are likely to encounter in SMS 2003 environments and provides straightforward solutions with practical demonstrations. We cover issues involving both management points and Advanced Clients, including troubleshooting steps you can use to identify specific problems and techniques for resolving the issues you find.
TechNet Webcast: Exchange Server 2003 Tips, Tricks, and Shortcuts (Level 300)
Friday, December 16, 2005 - 11:30 AM - 1:00 PM Pacific Time
Michael Murphy, TechNet Presenter, Microsoft Corporation
Your organization is running Microsoft Exchange Server 2003, and it is stable. What can you do to improve your Exchange operations, customize them, and optimize them to better meet the requirements of your organization? This webcast provides tips on how to customize system messages, create custom address lists, customize Microsoft Office Outlook Web Access, and control which versions of Outlook are allowed to connect to the Exchange server. We also show you how to use Mailbox Manager and create catch-all mailboxes.
TechNet Webcast: Strategies and Tools for Upgrading to SQL Server 2005 (Level 200)
Monday, December 19, 2005 - 9:30 AM - 11:00 AM Pacific Time
Bryan Von Axelson, TechNet Presenter, Microsoft Corporation
Get the knowledge you need to upgrade a server running either Microsoft SQL Server 7.0 or Microsoft SQL Server 2000 to the recently released Microsoft SQL Server 2005. This webcast introduces you to the strategies and tools that can help you make a smooth transition. We outline two different upgrade strategies: the migration strategy, which involves installing SQL Server 2005 on a new server and then migrating data; and the in-place strategy, in which you upgrade your existing installation. We also look at the Upgrade Advisor, a tool for planning and preparation. Using this information, you can decide which approach is right for your servers, and plan your next steps.
TechNet Webcast: System Center Capacity Planner 2006 Overview (Level 200)
Monday, December 19, 2005 - 11:30 AM - 1:00 PM Pacific Time
Microsoft System Center Capacity Planner 2006 provides you with state-of-the-art tools and guidance to help you create a system architecture model for deploying a Microsoft server application, such as Microsoft Exchange Server 2003 or Microsoft Operations Manager (MOM) 2005. Tune in to this webcast to learn more about the capabilities and features of System Center Capacity Planner 2006, and find out how it can help you plan and implement a successful deployment.
TechNet Webcast: Securing Your Microsoft Operations Manager (MOM) 2005 Environment (Level 200)
Monday, December 19, 2005 - 8:00 AM - 9:30 AM Pacific Time
Get an overview of security management and learn about the new security features that have been added to Microsoft Operations Manager (MOM) 2005. In particular, this webcast introduces you to an important new scenario in MOM 2005, trusted monitoring. Discover how to secure your MOM 2005 deployments from the MOM management (server-side) and the MOM agent (client-side) perspectives.
TechNet Webcast: Implementing Multifactor Authentication Using Smart Cards (Level 200)
Tuesday, December 20, 2005 - 9:00 AM - 10:30 AM Pacific Time
Kai Axford, Security Specialist, Microsoft Corporation
Do user name and password combinations provide enough security for your organization's network resources? Many users choose passwords that can easily be compromised. This particular security vulnerability can be difficult to control. To address this issue, multifactor authentication uses a combination of components separate from the user name and password combination to provide more secure access to network resources. Deploying a smart card solution is an increasingly popular way to implement multifactor authentication. Attend this webcast so you can understand the challenge of securing critical administrator accounts and remote access logon sessions, and how to implement multifactor authentication using smart card technology.
TechNet Webcast: Microsoft Operations Manager (MOM) 2005 for Active Directory (Level 200)
Tuesday, December 20, 2005 - 8:00 AM - 9:30 AM Pacific Time
Kevin Remde, TechNet Presenter, Microsoft Corporation
This webcast presents the Active Directory Management Pack in Microsoft Operations Manager (MOM) 2005, a valuable tool for monitoring events that are placed in the Application, System, and Directory Service event logs by various components and subsystems of Microsoft Active Directory directory services. This management pack provides important information in the areas of trending, user account problems, configuration, and service level availability. It also monitors the overall health of Active Directory and alerts you to critical performance issues. The Active Directory Management Pack is designed to provide monitoring information for most implementations of Active Directory. Join this webcast to explore the various monitoring scenarios.
TechNet Webcast: Microsoft Operations Manager (MOM) 2005 Performance and Sizing (Level 200)
Wednesday, December 21, 2005 - 8:00 AM - 9:30 AM Pacific Time
This webcast explains how the configuration of key components in the Microsoft Operations Manager (MOM) 2005 architecture affects the performance of the monitoring environment as a whole. Join us to find out what the support limits are for MOM 2005 configurations and understand the reasons behind them. We conclude by showing common MOM problems that affect performance and the solutions to these problems.
TechNet Webcast: Managing and Administering SQL Server 2005 (Level 200)
Wednesday, December 21, 2005 - 9:30 AM - 11:00 AM Pacific Time
Microsoft SQL Server 2005 offers some new features for database administrators and information technology (IT) professionals. Join this webcast to learn about new administration tools, including SQL Management Studio; SQLCMD, the new command-line utility (and its GUI equivalent in SQL Management Studio); and SQLiMail, the new Simple Mail Transfer Protocol (SMTP)-based replacement for SQLMail. We look at SQL Server Express 2005, a “light” version of SQL Server 2005 that replaces the Microsoft Desktop Engine (MSDE). We conclude by exploring maintenance and performance tools included in SQL Server 2005, such as maintenance plans, SQL Profiler, and SQL Server Agent.
· Connected Productivity/Office Professional Solutions
· Exchange Server
· Internet Information Server
· Office Live Communications Server
· Operations Manager
· SharePoint Portal Server
· SQL Server
· System Management Server
· Virtual Server
· Windows Server
§ ALL Upcoming Webcasts
§ ALL On-Demand Webcasts
§ Microsoft Business Solutions Webcasts
§ Microsoft Executive Circle Webcasts
§ Microsoft Office System Webcasts
§ Microsoft Small Business Webcasts
§ MSDN Webcasts
§ MSDN Architecture Webcasts
§ Security Webcasts
§ TechNet Webcasts
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.