Greetings!Below I’ve pasted an edited and cleaned up copy of most of the Q&A from today’s webcast on SQL Server 2005 Management Administration. Big BIG thank you to Bryan von Axelson for handling the Q&A on the backend, and who’s work this really represents.-Kevin—“As a technet subscriber I have been watching the development of SQL2k5 … Continue reading Best of Q&A from Webcast: SQL Server2005 Management and Administration
Merry Christmas!or Happy Holidays!As promised, here are some related resources and helpful web pages for the content delivered in my webcast today – Managing and Administering SQL Server 2005I hope you find them useful!-Kevin—Official Resource Page for this contenthttp://www.microsoft.com/technet/sql-02SQL Server 2005 Webcast Serieshttp://www.microsoft.com/events/series/technetsqlserver2005.mspxSQL Server 2005 Books Online (downloadable, installable, searchable, and FREE)http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspxTechNet SQL Server 2005 … Continue reading Webcast Resources: Managing and Administering SQL Server 2005
Yes indeed! The January TechNet Webcast Schedule is Live!We’ve got lots of great content for you this month; especially the two sessions I’m doing on Exchange Server Security.TechNet Webcast: Implementing Exchange Server 2003 Security (Part 1 of 2): Securing Services and Messaging Protocols (Level 200)Monday, January 16, 2006 - 11:00 AM - 12:30 PM Pacific Time … Continue reading A New Year of TechNet Webcasts Begins!
SQL Server 2005 Tidbit 039 I have talked about and demonstrated the new SQL Server Upgrade Advisor in my live events recently. When showing that you can include a profiler trace file for the sake of the analysis, I was asked,“But what events should we trace? What trace would be the most useful for the advisor?”And the … Continue reading SQL Server 2005 Tidbit 039
SQL Server 2005 Tidbit 038 The MSDN web site has links to some SQL Server 2005 Virtual Labs.“What’s this ‘virtual lab’ thing of which you speak?”Virtual labs are hosted sessions on a pre-installed virtual machine, along with lab notes to work through various scenarios on the installed software.“But, can’t I just do that on my … Continue reading SQL Server 2005 Tidbit 038
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 … Continue reading SQL Server 2005 Tidbit 037
TechNet Virtual Labs“Ever wanted to test Microsoft's newest software in a sandbox environment? Wouldn't it be great to be able to test new servers immediately, without formatting hard drives or dedicating one or more computers to the project? Now you can, with the TechNet Virtual Labs.”For those of you not already aware of these, I … Continue reading TechNet Virtual Labs
SQL Server 2005 Tidbit 036 Credit for this one goes to Chris Avis, who had this asked of him in an event recently…“With ‘instant file initialization’, what is it really doing?”Here’s a document that describes it well.From the document: In SQL Server 2005, data files can be initialized instantaneously. This allows for fast execution of … Continue reading SQL Server 2005 Tidbit 036
SQL Server 2005 Tidbit 035 Credit for this one goes to Chris Avis, who had this asked of him in an event recently…“What is the max number of filegroups supported as part of a single database?”Well… it’s a nice big binary number: 111111111111111 (or 32,767 for you decimal lovers). The answer is found here.—Got an … Continue reading SQL Server 2005 Tidbit 035
Absolutely Full of I.T. 