Overview/Description As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in...

Overview/Description One aspect that should not be overlooked when planning an infrastructure is the requirement for patch management and system compliance. Enterprise administrators must be aware of the approaches and tools that are available to them before recommending a software update plan. They also have to understand those tools before designing a strategy for software and system configuration compliance. This course examines the importance of patch management and the use of Windows-incorporated tools, such as Windows Update and Microsoft Update, in keeping client system operating...

Overview/Description SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple...

Overview/Description SQL Server 2008 R2 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 R2 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level...