Your database performance heavily depends on how you have physically placed your database objects and how you have configured your disk subsystem. Designing the physical layout of your database correctly is the key factor to improve the performance of your database queries and thus the performance of your database. However, the correct decision on a physical design structure of the database depends on the available hardware resources that you might have. This includes the number of processors, RAM, and storage resources, such as how many ,disks or RAID controllers you might have in your database environment. The best thing while designing physical layout of the database is to have multiple physical disks for your database. If you configure your database in such a way that it spreads across multiple disks, it can benefit from parallel I/O operations.
The following are some of the decisions that influence your database performance:
- Where do you place data files?
- Where do you place log files?
- Where do you place large objects?
- Where do you place indexes?
- Where do you place the tempdb database?
You can control the physical location of database objects within the database by using files and filegroups.
In this article by Ritesh Shah and Bihag Thaker, co-authors of Microsoft SQL Server 2012 Performance Tuning Cookbook, we will learn how to best design the physical structure of the database on your disk subsystem when you have enough available hardware resources, such as multiple processors and multiple physical disks.Read Microsoft SQL Server 2012 Performance Tuning: Implementing Physical Database Structure in full
A common challenge for many SharePoint users is finding sites with content that is relevant to them. It is pretty common to find environments with hundreds if not thousands of sites. In past versions of the product, there was a Site Directory feature that was available, but it was essentially just a SharePoint list which required manual entry and significant maintenance, which ultimately made it a pretty unreliable and ineffective solution.
In this article by Mike Oryszak, author of Microsoft SharePoint 2010 Business Application Blueprints, will provide some alternative solutions for addressing these challenges, starting with an overview of some key concepts on how to leverage SharePoint Search to provide an optimized experience, making it easier for users to search and discover relevant sites. In addition to the conceptual overview, the following configurations and custom solutions will be covered:
- Sites Search Scope
- Site Directory page
- Relevant sites Web Part
Read Building a Site Directory with SharePoint Search in full
One of the key aspects that separates a computer game from that of, for example, a movie, is its interactive nature and its ability to be influenced by the player to achieve a different outcome each and every time.
In this article by Luke Drumm,author of Microsoft XNA 4.0 Game Development Cookbook, we will examine some different ways of capturing the player's intent that may not be immediately obvious or trivial to implement when we first set ourselves the challenge.Read Microsoft XNA 4.0 Game Development: Receiving Player Input in full
The majority of time administrating a network is spent managing users. Users not only need access to a Windows Small Business Server (SBS) 2011 network but they all need access to its resources. The key to good network administration is doing this in the most effective manner. Probably the most important part of a network will be the users. They need access to the resources on the server as well as the services that it provides. To do this securely they are firstly going to need a network login ID that identifies them to the domain. They will typically use this login ID at a workstation connected to the domain.
In this article by Robert Crane and Drew Hills, co-authors of (MCTS): Microsoft Windows Small Business Server 2011 Standard, Configuring (70-169) Certification Guide, we shall look at creating and managing user accounts.Read Creating and managing user accounts in Microsoft Windows SBS 2011 in full
In this article by Gill Cleeren and Kevin Dockx, authors of Microsoft Silverlight 5 Data and Services Cookbook, we will cover:
- Connecting and reading from a standardized service
- Persisting data using a standardized service
- Configuring cross-domain calls
- Working cross-domain from a trusted application
- Reading XML using HttpWebRequest
BizTalk enables the integration and managment of automated business processes within or across organizational boundaries. To build a solid BizTalk solution, deploy a robust environment, and keep it running smoothly you sometimes need to broaden your spectrum, explore all possibilities, and choose the best solution for your purpose. In this article by Steef-Jan Wiggers, author of BizTalk Server 2010 Cookbook, we will cover:
- Gathering requirements by asking the right questions
- Analyzing requirements and creating a design
- Installing and using the BizTak Best Practices Analyzer
- Validating BizTalk installation with the BizTalk Benchmark Wizard tool
- Automating performance analysis by using the PAL tool
It can be difficult to combine multiple different frameworks into the same solution while working with new technologies. This article will focus on how to combine Silverlight 4, Windows Azure, and a WCF 4.0 (Windows Communication Foundation) service together.
In this article by David Burela, author of Microsoft Silverlight 5 and Azure Enterprise Integration, we will discuss the following topics:
- Combining Silverlight and Windows Azure projects
- Consuming an Azure-hosted WCF service within a Silverlight application
- Configuring the number of web roles
Most Line of Business (LOB) applications have to interact with a database. The recommended technology in order to cover this interaction is RIA Services.
In this article by Braulio Díez Botella,co-author of Mastering LOB Development for Silverlight 5: A Case Study in Action we will cover:
- Advanced topics
- RIA Services and MVVM
UAG customizations can be very intense and deeply technical, but what everyone wants is for everything to look its best, right? The fact is, a large portion of UAG customers perform at least some adjustments to the appearance, even if it is just changing the title of the portal page. Look and feel customizations are considered to be rather well documented, as opposed to some of the more advanced stuff you will see later on in the book, but the purpose of this chapter is not to repeat that official documentation. We will be guiding you through the actual process, of course, but also suggesting some creative thoughts to get the message across in ways that you may have never thought of.
In this article by Erez Ben-Ari and Rainier Amara , the authors of Mastering Microsoft Forefront UAG 2010 Customization,the following topics will be covered:
- Visual customization overview
- Customizing the login and admin pages
- Customizing the portal
- Portal application icons
- Changing texts
- Adding a user-interface language
- Portal selection for clients
In this article by David Overton, author of Microsoft Windows Intune 2.0: Quickstart Administration, we will examine the real-time nature of PC management as we explore the alerts that Windows Intune raises which require action on our part, exploring how we both monitor and respond to them.
We can have configure computers to minimize situations where alerts will be raised through good practices of updates, firewall, and anti-malware management. However, problems will still arise with users' computers, whether this is a request for assistance, a computer that will not boot, or some other warning picked up by Windows Intune. These need to be categorized and responded to in a timely manner. Some can be closed and filed depending on circumstances, while others require a visit to the computer itself with other tools to further diagnose and resolve.
In this article, we will discuss this in the following sections:
- General Windows Intune alerts
- Malware alerts
- Remote Assistance alerts