3 Wee Scripts in Powershell 2...

'Tis the season of giving. several of my students have been asking for advanced user interface examples in Powershell, so here are three scripts (and a module) for them, you, and anyone else who cares to look. they are heavily commented so I'll not go into details, but this is what i got you for Christmas...

screenctl.psm1 is a module that contains three useful functions used by the scripts in this set. set-cursor places the cursor exactly where you want it on the screen, so that whatever you print starts displaying there. clear-linesout-wrappedstring is a variation of the text-wrapping function i talked about here.

addusers.ps1 walks you through adding a user account to active directory. it uses the screenctl module to customize the output and the activedirectory module to read and write the database.

get-weather.ps1 provides current conditions and forecast from an internet xml stream. it uses the screenctl module to wrap long forecast strings.

netcfg.ps1 provides a graphical interface to the network information for machines listed in active directory. it uses the active directory module to locate computers.

read the example scripts, improve them, have fun with them this holiday season. it's better than listening to Uncle Lloyd snore in front of the television, right? clears a specific number of lines from the screen, rather than the whole thing. combined with set-cursor you can clear just a small section of the screen if you wish. 

- Robert Ritter, Powershell Expert; MCSE, MCT, CTT+, MCP+I, CCDA, CCNA, A+ LinkIn with Robert

Quickly copy a formula in Excel

You probably already know that you can copy a formula down or across by "dragging" the small plus sign (fill handle) in the bottom right corner of a cell, which is especially useful when working with formulas. If the data covers more than just a few cells, this can be tedious. Instead, double click on the fill handle.

Wow - that was fast!

- Irene Heckert, Microsoft Office Expert; CTT, MCAS, ITIL Certified, MOS LinkIn with Irene

Class Spotlight: MS-6430 Planning for Windows Server 2008 Servers

This course is a good course for students who want to take the 70-646 exam.  It will leverage the student’s knowledge of Windows Server 2008 and its service.   

The class focuses on planning exercises and then there is a hands-on lab for the students to set up the service that was planned.  This class is for students who understand Windows Server 2008 servers and their services and want to either learn more about the planning process or want to pass the Server Administrator Exam.

For more on the course, take a look at the course calendar here. See you in class! 

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

Need an alternative to ASP .NET Web Forms? Discover MVC!

The Model-View-Controller (MVC) architectural pattern separates an application into three main components: the model, the view, and the controller. The ASP.NET MVC framework provides an alternative to the ASP.NET Web Forms pattern for creating MVC-based Web applications. The ASP.NET MVC framework is a lightweight, highly testable presentation framework that (as with Web Forms-based applications) is integrated with existing ASP.NET features, such as master pages and membership-based authentication.

MVC is a standard design pattern that many developers are familiar with. Some types of Web applications will benefit from the MVC framework. Others will continue to use the traditional ASP.NET application pattern that is based on Web Forms and postbacks. Other types of Web applications will combine the two approaches; neither approach excludes the other. 

To learn more about ASP.NET MVC and more on Web Forms applications using .NET Framework 4 tools and technologies, try the course MS-10264, Developing Web Applications with Microsoft Visual Studio 2010. We are offering this course on February 7, 2011. The focus will be on coding activities that enhance the performance and scalability of a Web site application. Students will learn when to apply which technology.For more on ASP.NET MVC, check out Microsoft’s web site www.asp.net/mvc. 

For more on Visual Studio 2010 courses at Centriq Training, check out www.centriq.com.

- Leslie Koorhan, .NET Expert; MCT, MCSD (.NET), MCTS, MCDBA, MCPD LinkIn with Leslie

Microsoft Word: Get rid of the extra space!

Want to get rid of that pesky extra space once and for all that is included with "normal" text in a Word 2007 or 2010 document?

1.) Click the dialog box launcher in the Paragraph group (that is the little arrow in the bottom right corner of the group on the ribbon) on the Home tab of Word. This will open the dialog box with all your paragraph options. If necessary, choose the tab at the top of the dialog box for Indents and Spacing.

2.) Set the Spacing settings to 0 pt Before and After, and the Line spacing to Single.

3.) Now click the Set As Default button along the bottom of the dialog box. A confirmation dialog box will appear asking if you want to set the default; be sure to choose the option for "all documents based on the Normal template."

4.) Click OK, then close the Paragraph dialog box.

From now on, when you open a new blank document, the Normal style will have no extra spacing!

- Irene Heckert, Microsoft Office Expert; CTT, MCAS, ITIL Certified, MOS LinkIn with Irene

Visual Studio Tips [VIDEO]

Instructor Leslie Koorhan gives some litte known tips on using Visual Studio 2010. Check out our Corporate Class Schedule for the next available Visual Studio 2010 class date!  

http://www.centriq.com/CentriqSchedule.aspx

- Leslie Koorhan, .NET Expert; MCT, MCSD (.NET), MCTS, MCDBA, MCPD LinkIn with Leslie

Free Resources on Visual Studio 2010

Well, Visual Studio 2010 has been out for several months now, and it looks to be a super product. One of the nice things that Microsoft is doing is offering a lot of content for free to help explain and teach the features of VS2010.

For example, you may have heard of ASP.NET MVC (Model-View-Controller), which is a Microsoft template (actually, now MVC2) for developing web applications using what is known as the MVC design pattern. But there are other design patterns for developing applications. Here is a link for using the MVVM (Model-View-ViewModel) pattern for WPF and Silverlight applications: Problems and Solutions with Model-View-ViewModel.

Another recent discussion had to do with questions on what Microsoft is doing with data.

Anyway, I hope these give you something to think about until the next time. Coming in a couple of weeks, a long overdue course on Programming with C#, using Visual Studio 2010.

- Leslie Koorhan, .NET Expert; MCT, MCSD (.NET), MCTS, MCDBA, MCPD LinkIn with Leslie

Centriq’s Microsoft Partner Competency Training Offer

As part of an ongoing commitment to Microsoft partners in the Kansas City area, Centriq is offering a special savings for all Microsoft partners looking to meet Silver and Gold competency requirements.

Some of the technologies included are: SharePoint 2010, Windows Server 2008, SQL Server 2008 and Visual Studio 2010. For a limited time, partners who purchase one Microsoft Official Curriculum course will receive a second course at no additional cost.

Check out our course calendar for a full list of courses here.

Offer valid for both Local Instructor-Led Training as well as remote training available worldwide. If you are interested in learning more about this offer feel free to visit our offer page here.

- Jessica Oliver, Director of Operations LinkIn with Jessica

SharePoint Tip!

SharePoint Tip: SharePoint Manager 2010 is an object browser that is a one-stop tool that can be used to browse and view every property on the local farm or local site. It also enables you to change the properties in a single interface. This tool can be downloaded from Codeplex here: http://spm.codeplex.com/

- Steve Nichols, SharePoint Expert; MCT, MCTS, MCSE LinkIn with Steve

MS-6419 and MS-6420: What's the difference?

MS-6419 Configuring, Managing, and Maintaining Windows Server 2008 is a foundational class for system administrators who have experience with either Windows Server 2003 or with Windows Server 2008.  This class deals with creating users and groups, setting group policies and Active Directory structures.  The rest of the class is devoted to several different Microsoft products such as Network Access Protection, Backup, File Server Resource Manager and Distributed File System.  

MS-6419 is a choice for students who want detailed knowledge of Active Directory daily management, such as user, group and group policies, but want an overview of Network Access Protection, Backup, File Server Resource Manager and Distributed File System.

MS-6420 Fundamentals of Windows Server 2008 is a great class for students who are new to Windows Server 2008 R2 or who are moving from a Help Desk to a system administrator position.  MS-6420 is a foundational class to teach networking , security and basics of Server Administration in Windows Server 2008.  It covers what is a LAN, WAN, router, hub and switch.  It also covers subnetting an IP network.  The students will be exposed to installing a server and server roles, as well as virtualization.  Additionally, students are introduced to Active Directory Domain Services and  securing a server. 


Do you have question on Windows Server courses or certifications? E-mail me at jnichols@centriq.com.

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

Class Spotlight: MS-10175A Microsoft SharePoint 2010, Application Development

This class should be considered for certification and will help to prepare students for the 70-573 Exam.  This class is for experienced SharePoint 2007 developers who want to see the new features of SharePoint 2010.  

It showcases the ease of developing SharePoint applications with the built-in tools of Visual Studio 2010.  It introduces some of the new features of SharePoint Designer 2010 in the SharePoint web application development.  The developer candidate should be well versed in Visual Studio and the C# application language as this class does not teach these skills, it simply shows the student how to apply these skills to SharePoint development.

For more info on the course and to see upcoming dates on our calendar, click here. 

Once a student successfully completes this course, they can then take the MS-10232 course, which gets them into developing SharePoint Applications.

- Steve Nichols, SharePoint Expert; MCT, MCTS, MCSE LinkIn with Steve

Exchange Updates!

The Microsoft Exchange team has updated their popular Exchange 2007 Component Poster for Exchange 2010. For those of you that haven’t seen either, both are linked at http://msexchangeteam.com/. 

While you're there check out Office 365 - Microsoft's exciting new business solution for the cloud just announced today! 

http://msexchangeteam.com/archive/2010/10/19/456652.aspx

- Bob Reinsch, Microsoft Exchange/Windows 7 Expert; MCT, MCITP LinkIn with Bob

Class Spotlight: MS-6425 Configuring Windows Server 2008 Active Directory Domain Services

This is a good class for students to learn more about Active Directory maintenance and group policy.  It covers trusts, Active Directory integrated DNS zones, configuring sites and replication.  It also covers group policy.  

For students who need additional information about Active Directory and group policy, this is an excellent course.  MS-6425 along with MS-6424 will prepare the students for the 83-640 Exam.

To learn more about this course and see upcoming dates, view the course outline here.

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

Class Spotlight: MS-10174 Configuring and Managing Microsoft SharePoint 2010

MS-10174 should be considered for certification and will help you prepare for the 70-667 Exam. Ideal for IT installers and current Sharepoint Administrators of Sharepoint 2007, this class is also for individuals who are upgrading from Sharepoint 2007 to Sharepoint 2010. You should have Sharepoint 2007 experience before taking this course, so I would recommend taking some end-user courses first if you don't the background knowledge. 

Check out the course outline or look at upcoming dates by clicking here. 

Also, if you're ever interested in learning more SharePoint outside the classroom, this is an excellent site for Sharepoint End Users who want to advance their knowledge: http://www.sharepointshepherd.com/default.aspx

- Steve Nichols, SharePoint Expert; MCT, MCTS, MCSE LinkIn with Steve

Class Spotlight: MS-6421 Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure

This class compares to the MS-2277 Windows 2003 course.  It is a good course for students who are responsible for the maintenance and troubleshooting of DNS, DHCP, NAP and WINS. 

It also covers how to install and configure roles and services in Windows Server 2008.  It contains information on IPv6 and shows students how to set up IPv6 transition technologies.  It also teaches DFS, backup, File Server Resource Manager and WSUS.  It also covers Microsoft-based VPNs.  This course helps to prepare students to take the 70-642 exam.

For more information on this course or to find upcoming dates this course is offered, view the course outline here.  

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

ASP.NET Tips

Looking for more robust and dynamic controls for your ASP.NET application? Check out the new DexExpress “ASPxperience” suite of controls ( http://bit.ly/cOPYz9 ) or the suite from Obout ( http://www.obout.com ). Both suites include great AJAX (and non-AJAX) controls for displaying data, managing navigation, and providing a richer experience for your site users.

What about a great hosting company for your ASP.NET applications or  SqlServer databases? Discount ASP.Net ( http://www.discountasp.net ) is one of the best ASP.Net and SQL Server hosts on the planet. I  have been using DiscountAsp.net to host applications since 2003, and I could not be happier with their reliability and the options available.

Have questions on ASP.NET? Send them my way!

-Neill Horton, ASP.NET Expert; MCTS, MCP, CTT, Sun Certified Java Programmer LinkIn with Neill

Class Spotlight: MS-6419 Configuring, Managing and Maintaining Windows Server 2008 Servers

 This class is a good foundational Server Administration course for people already familiar with 2003.  It compares to the 2273 Windows 2003 course.  If students need to learn how to manage users, groups and group policy it is a great class!

The course also discusses file permissions, file sharing and Active Directory permissions.  It does a good job of explaining group policy.  It also discusses Distributed File System, fine grained password policy, WSUS and network policy server.  It also discusses trusts.  It is a great class for students who are responsible for user, group management and group policy.

View the upcoming dates MS-6419 is offered on the course outline here.  

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

Remote Training: The solution you may be missing out on

When it comes to today’s IT training customers have several options from companies nationwide. Instructor led training, mentored learning training, self-based learning and remote training all have their place in training.  Some students prefer to learn at their own pace and others like instructor led so they can ask questions and receive feedback.  Here at Centriq we offer 3 main training solutions to our customers as part of our Centriq Choice Program including Local Instructor Led Training, Remote Instructor Led Training and High Definition Instructor Led Training.

Local instructor led training has always been the favorite training type for most students.  Local ILT gives the opportunity for the student to have interaction with the instructor and receive feedback on questions and comments.  As an instructor of 15 years, my own opinion is biased.  I believe Local ILT provides the best opportunity for students to learn.  However in today’s environment, Local ILT is not always available because of time constraints of work and the cost of travel.  Also for some students there is the time away from the office.  In most of my classes today, corporate students are connected to work by either a laptop or cell phone still working even while attending classes.  It might not be the best learning opportunity but it is better than no training at all.  So is there a way for students to still get the training they need, be able to still be in touch with work and save money on travel and other expenses?  Remote ILT may be the answer for you and your company. 

With the increase in bandwidth, speed of internet links and new tools and methodologies, Remote ILT has come a long way.  Here at Centriq Training we are currently providing 2 ways to provide students with access to remote training—Remote ILT and HD ILT. 

Remote ILT is where a student can access a live class remotely from their work or home.  The class will have both students in the class as well as students remoting over the internet.  Just like a student in the class, each student will have access to the following: 1) their own host pc with their own virtual pc or VMware machines and 2) access to the instructor as well as other students via two way audio, one way video and internet chat.  The remote student can ask questions in class of the instructor or class so they feel a connection as if they are right in the class.  As an instructor I have been through extensive training to ensure remote students are encouraged to participate in class and feel at home. 

Along with my training, we also have tools that ensure that the remote student has a great experience.  First, Centriq sends out prior to the first day of class a check list of items for the student to complete to ensure proper and efficient connectivity to the classroom.  The student will also receive a headset with a microphone to ensure the two-way audio for the class.  Once the student has completed the checklist, they will be ready to attend the first day of class.  Also to ensure a good experience, we provide the best tech support should the student have any connectivity issues before and during class.  Centriq utilizes tools such as Microsoft Office Live Meeting for audio, video and chat, Citrix’s Go To My PC for the host connection and NetSupport for classroom management.  Consider, for example, a remote student having an issue with a lab. All they have to do is tell the instructor what they are having a problem with, then the instructor can use NetSupport to see the students host (which by the way is in the classroom, not in a rack somewhere out of sight) and help them.  Also if they are experiencing problems with the host, the instructor can go over to the host pc and fix the problem or have our support team fix the issue.  As you can see, using these tools along with a qualified remote instructor, the remote student will feel like they are right there in the classroom.

Our second remote solution, HD-ILT, utilizes a two audio-video solution.  We have a 60 inch High Definition TV with camera in the classroom at Centriq.  This currently is available for high-end Cisco classes only.  The student will come to Centriq and actively participate in a Cisco certified class remotely with a Cisco Certified Instructor and authorized curriculum.  The instructor from the remote classroom will see and hear all the students in the Centriq class and vice-versa.  The big benefit is that the student will be working on live Cisco equipment and not simulators or virtual machines.  Need a Cisco class that Centriq is not teaching locally? Check our schedule for remote Cisco VOIP, Security and Wireless classes.  We will still be teaching Cisco classes such as CCNA and CCNP locally, but for those who need more advanced Cisco training make sure you check out our HD-ILT solution.

I think the best benefit from Centriq’s remote training solutions is the cost and time.  No more does a company have to spend money on travel expenses to Kansas City for a week to take a course, now the student can be at work or home to and still get the training they need. 

I encourage you to check out our course schedule at http://www.centriq.com/CentriqSchedule.aspx and I hope to see you in a local or remote class.

- Tom Pruett, Cisco & Security Expert; MCT, CTT+, CISSP, CWNA, CEH, CHFI, CCSI, CCNA, MCSE LinkIn with Tom

She's a little runaway (query)

Stop that runaway query!

Have you ever noticed how SQL Server likes to just take over the CPU and memory of the box it is installed on? It just says, in it’s little SQL brain, “Gee, I think 90% of the CPU should be sufficient to run this query, and maybe I will just keep this memory in case I need it for something else.” Meanwhile, all other queries and/or applications start turning blue from lack of resources and die on the way to the query optimizer.

Are you ready to take back control of the CPU and memory and force applications or users to only use their fair share of the server’s resources? Well, another great, new feature of SQL Server 2008 is called the Resource Governor. You can set limits on how much CPU and memory can be used by creating functions that define an application name, a user name, a host name, a server role name, and so on.

You start by creating Resource Pools and assign minimum and maximum CPU and memory percentages to each pool. For example, you create a pool called Pool1 and assign it a minimum of 20% and a maximum of 30% CPU. This means that anything assigned to the pool will always have some CPU available (20%) but will never exceed 30%.

You also create Workload Groups which are assigned to specific pools. These workload groups can be assigned a high, medium or low priority within that pool. At this point, it would be fair to mention that all unclassified work is dumped into the Default Workload Group. This pool has UNLIMITED access to system resources, the reason that so many of us have seen runaway applications.

The third part is to create Classifier Functions. This defines which users, applications, roles, etc. (workloads), go into which workload groups. Now, we have control!

Just so you know, SQL Server 2008 reserves some CPU and memory for itself that is never given to any user or application. Didn’t you ever wonder how you could access a locked up server using the “SQLCMD –A” utility? There is always CPU and memory on reserve just to keep the motor running like the well oiled machine that SQL Server is. 

And if you like, I can show you how to build one of these Resource Governor contraptions right here in my MS 6231 class which runs from October 18-22 (it’s actually covered on Friday, usually). And if all else fails…

“Just hit it with a hammer!”

- Peter Trast, SQL Expert; MCITP DBA, MCITP EA, MCT LinkIn with Peter

Security+: Do you really need this certification?

In the past year I have been asked a couple of questions regarding the Security+ certification.  "I already have experience, why do I need to get Security+ certified? or "Is the Security+ certification worth anything anymore?"  The answer to both questions is a definite yes.

Over the past 10 years security has become a very prominent part of IT.  The need for well qualified individuals in security has increased.  There is not not one company that is not thinking about security.  Security has come to the forefront of IT due to the increased exposure to networks.  The exposure comes from the internet.  With all of this exposure comes the need to protect our personal and company assets.

So, how does the Security+ certification play a role helping protect our personal and private networks?  Knowlege knowledge and more knowledge.  That is the answer.

IT security is not just limited to single area of knowledge.  It actually encompasses all areas of IT.  Think about all the different systems, applications and OS's your company has running?  All of those have different needs for security.  So to be in security means to be knowledgeable in a lot of areas of IT.

Security+ certification provides you with exposure to all of the different areas of security for different systems, application and OS's.  No, it does not mean you will be an expert in security for all of these systems, but it does mean you will have exposure and an understanding of what it means to secure these systems.

Security is a journey not a destination.  There is not one person who knows everything about security.  Security knowledge comes from knowing how to defend your systems against different types of threats.
However for some, network defense comes from knowing how a system or OS works.

Security+ provides that base knowledge for security, network defense and hardening systems.  You could say it is a mile wide and a 2 inches deep.  Once you have the exposure to this knowledge then you can go into one of many areas of security such as: ethical hacking, firewalls, IDS, IPS, security policies, Cisco routers and switches or internet security.

As for the question is the Security+ certification worth anything?  Just ask anyone in the military or government who has to work on a secure system.  They are now required to be Security+ certified to work on said systems.

So if you are looking to get into security or need to start getting certified in security for other areas.  The Security+ certification is the place to start.

If you have any questions about Security+ certified, please feel free to contact me.

For more information on Security + click here.


- Tom Pruett, Cisco & Security Expert; MCT, CTT+, CISSP, CWNA, CEH, CHFI, CCSI, CCNA, MCSE LinkIn with Tom

Class Spotlight: MS-6416 Updating your Network Infrastructure & Active Directory Technology Skills to Windows Server 2008

This class should be considered for certification. The class has evolved.  There is now less information on the upgrade and more information on topics such as Federation Services, Rights Management Services and Lightweight Directory Services as opposed to the older version of this course.   

These three topics were taught in a single chapter less than 35 pages and is now taught in three separate chapters each a minimum of 35 pages.  More emphasis has been placed on the Network Policy Server.  DFS and File Server Resource Manager have been added.  Less emphasis is now placed on performance – information on Windows System Resource Manger has been dropped.  Server Core is now barely mentioned in this course. The section on Active Directory planning has been removed.  

 It is a great class and will help to prepare students for the 70-648 Exam. 

- Janet Nichols, Windows Server Expert; MCT, MCSE, MCITP: Enterprise Admin, Server Admin; Windows 7 EDA, MCTS LinkIn with Janet

Tired of slow SQL queries?

Getting tired of those poorly performing queries or stored procedures? Getting even more tired of the phone calls that result from those poorly performing queries or stored procedures? Obviously, disconnecting your phone and huddling in the corner crying is not the answer (take it from me). Maybe what you need to do is look at the structure of your database and consider a little modification. First, a few questions.

Is at least one of your tables the size of (insert favorite Hollywood actor’s name)’s ego? And does that titanically (not a movie reference) humongous table have at least one column that could be used to divide the data into smaller chunks, like a date column in a Sales table with many months or years of data with hundreds of thousands, maybe even millions of rows? Can you add (would your budget allow) more physical disks to your SQL Server solution? And the biggest question, can you afford, or do you already have, the Enterprise edition of SQL server?

Well, if you were able to answer yes to all of those questions, it is possible that you might be able to tweak that lumbering hulk into exhibiting a few more miles per hour by making a few simple, if not inexpensive, changes.

The short version (level 000) is that you create new physical drives, define ranges of data and assign those ranges of data to different disks (or RAID 5 arrays). This is called table partitioning. Read on only if you really want to know how it is done (level 100)!

First, you must decide where to divide your data. For example, if you have about 10 million rows of Sales data for the last 5 years, you need to choose how to break that data down into smaller pieces. This decision is really based on how many physical disks you can add to your system. If you like keeping your data on RAID 5’s and you can get your hands on 5 more RAID 5 arrays,  you can divide you data into 5 parts (which just happens to nicely match 5 years of data).

So you create 5 new RAID 5 arrays. And in your database properties you create 5 new filegroups with at least one file each, one filegroup per RAID 5 array. Then, we are going to use these 5 different filegroups residing on 5 different arrays to create our partitioning strategy.

Now, we use a Transact SQL statement like this one

CREATE PARTITION FUNCTION [myDateRangePF1] (datetime)

AS RANGE RIGHT FOR VALUES ('20030101', '20040101', '20050101',

                           '20060101', '20070101');

to define the range of values for each portion of our table that will be stored separately from the rest. In this case, all sales for the year 2003, date 20030101 thru 20031231 (RANGE RIGHT starts with date 20030101 and ends before the next date, 20040101) will be assigned to the first partition in our function. Then 2004 is assigned to the next and so on. The last partition, 20070101, being the last listed, includes all subsequent dates, unless the function is later modified, which it can be.

Next, each range is assigned to a filegroup with a statement that looks like this

CREATE PARTITION SCHEME myRangePS1

AS PARTITION myRangePF1  --the name of the function we just created

TO (test1fg, test2fg, test3fg, test4fg, test5fg, test6fg); --these are our filegroups

Now, all of the data for 2003 will be stored in the first filegroup on the first RAID 5 array, the data for 2004 will be stored on the second new array, and so on. This will give you more actual disks supporting queries for a single table, reducing (theoretically) disk I/O and increasing (keep your fingers crossed) query response times. Yeah, I know I mentioned 6 filegroups in my scheme but I need to leave at least one mystery hanging out there for you to explore on your own or read on http://msdn.microsoft.com (or learn about in my class!!)

If you really need more info, and you want me to give it to you (because who wants to take advantage of all that great free info on the internet?), connect to me on the LinkedIn link below and send me your questions. Or comment on this blog. Or come to my week long class MS 6232 starting November 15!

“Seeya at tha pahty, Richtah…”

- Peter Trast, SQL Expert; MCITP DBA, MCITP EA, MCT LinkIn with Peter