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
Resource Page forTechNet Webcast: Successfully Implementing a Complex Active Directory Design (Level 200)Here are some resources relating to the TechNet webcast topic presented on November 21, 2005. I hope you find them useful.Kevin — This session’s Content Resource Page http://www.microsoft.com/technet/ADD-03 Planning and Implementing Federated Forests in Windows Server2003http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/activedirectory/fedffin2.mspx Service Administrator Scopt of Authorityhttp://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/DepKit/2f956712-68b6-48de-8d2f-d2e22dffbb44.mspx Autonomy vs. Isolationhttp://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/DepKit/e638db7d-ae87-45b2-beba-ec5815876ca2.mspx Determining … Continue reading Resource Page for TechNet Webcast: Successfully Implementing a Complex Active Directory Design (Level 200)
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 … Continue reading Big list of RSS Feed Readers and News Aggregators
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 … Continue reading Exchange 12 News coming out of IT Forum
SQL Server 2005 Tidbit 034The 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… … Continue reading SQL Server 2005 Tidbit 034
SQL Server 2005 Tidbit 033The 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!)“I heard … Continue reading SQL Server 2005 Tidbit 033
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 … Continue reading SQL Server 2005 Tidbit 032
SQL Server 2005 Tidbit 031We 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 … Continue reading SQL Server 2005 Tidbit 031
Absolutely Full of I.T. 