Our authors bring a wealth of industry experience to uCertify,  helping students prepare for IT certifications. We are pleased to present Muhammed Ali Sakhi – A uCertify author!

Author Profile:

Muhammed Ali Sakhi is a Microsoft Certified Trainer with over 5 years of experience in application development, database development, IT Solutions architecture, and project management. He has been conducting trainings for over 2 years on Microsoft ASP.Net, SQL Server SharePoint 2007 and SharePoint 2010. Ali is also certified as an MCTS on development and server platforms, including Microsoft ASP.net, Windows Forms, WCF, ADO.Net, SharePoint Server 2007 and SharePoint 2010. He is also an MCPD: Enterprise Developer and Certified Business Value Planning Specialist.

You can find him at his blog at www.pakdev.net.pk. He currently works as a Product Manager at IW and Learning Solutions.

Q. What is the 70-502 VB.NET exam?

A. The Microsoft 70-502 VB.NET exam measures your knowledge and skills in developing and implementing Windows-based applications by using Microsoft .NET Framework 3.5. This exam measures your knowledge of Microsoft Visual Studio 2008. You have to take this exam along with 70-536 VB.NET. NET in order to achieve the MCTS: .NET Framework 3.5 – Windows Presentation Foundation Applications certification.

Q. What are the prerequisites of the 70-502 VB.NET exam? Continue reading

Installing and Configuring SQL Server 2005

  • In order to change collation settings, reinstall SQL Server 2005 on a server with the same collation settings as another server.
  • In order to install SQL Server 2005 on a computer on which SQL Server 2000 is already installed, install SQL Server 2005 as a named instance.
  • Members of db_access role can assign permissions to other users to enable them to access and query the database.
  • RAID-0, also known as disk striping, is made up of a disk set in which data is divided into blocks and spread equally in each disk. It provides best performance because data read and data write operations are not limited to a single disk, but to a set of disks. It does not provide data redundancy. Data once lost cannot be recovered.
  • The Service Broker can be attached to a database by using the FOR ATTACH clause of the CREATE DATABASE statement.
  • If a snapshot of a database is present on the same computer on which the database is present, the database cannot be deleted.
  • In order to connect to the DAC, specify ADMIN: server_name in the Connect to the Server dialog box.
  • The login information stored in the master database.
  • In order to secure data that is data transmitted over a network, set the value of the ForceEncryption option on a server to Yes.
  • In order to enable a user to connect to the database, a DBA should add the user to that database.
  • The db_ddladmin fixed database role allows its members to add, modify, or drop objects in the database. Members of the db_ddladmin role can issue DDL statements (e.g. CREATE, ALTER, and DROP) in the database.
  • Member of db_ddladmin role have the permission to execute the T-SQL statements.
  • The sysadmin role allows a user to view the security log.
  • Continue reading

Developing applications that use system types and collections

  • Use the CausesValidation property of the ImageButton class to set a value to indicate whether validation is performed on a Web server control when an ImageButton control is clicked.
  • Installation packages are created for deploying a Web application by using a Web Setup project. A merge module project is used for components to be added to the application.
  • Use the Web Setup project and Deployment project to create installation packages for the deployment of Web-based applications such as XML Web services, Web applications etc., to a Web server.
  • Use a RequiredFieldValidator control to check whether or not an input control contains a value.
  • Use a RegularExpressionValidator control to check whether or not the value entered into a form field matches the pattern specified by a regular expression.
  • Use the validation error messages to be displayed on a Web page in a message box by setting the ShowMessageBox property of the ValidationSummary control to true. By setting the ValidationSummary property of the ValidationSummary control to false, the validation summary will not be displayed on the Web page.
  • Create and sort an array of data using the System namespace.
  • Continue reading

Optimizing the performance of database servers and databases

  • Memory: Pages/sec counter is used to detect whether or not the memory bottleneck is caused by I/O overhead.
  • Disk I/O bottleneck can be monitored by Physical Disk: % Disk Time and Physical Disk: Avg Disk Queue Length counters.
  • The System Monitor tool is used to know the cause of slow authentication.
  • The SQLServer: Buffer Manager performance object is used to check the amount of RAM used by a computer.
  • The Physical Disk: %Disk Time counter measures the pressure on a physical hard disk array.
  • Add more RAM if the reading of Memory: Pages/sec counter is high.
  • Reduce the Maximum Worker Thread configuration settings if the value of System: Processor Queue Length counter is high.
  • Continue reading

Developing applications that use system types and collections

  • Use the CausesValidation property of the ImageButton class to set a value to indicate whether validation is performed on a Web server control when an ImageButton control is clicked.
  • Installation packages are created for deploying a Web application by using a Web Setup project. A merge module project is used for components to be added to the application.
  • Use the Web Setup project and Deployment project to create installation packages for the deployment of Web-based applications such as XML Web services, Web applications etc., to a Web server.
  • Use a RequiredFieldValidator control to check whether or not an input control contains a value.
  • Use a RegularExpressionValidator control to check whether or not the value entered into a form field matches the pattern specified by a regular expression.
  • Continue reading

Creating User Services

  • The SessionID property of the HttpSessionState class identifies an active ASP.NET session by using a unique session ID.
  • The @ Import directive is used to explicitly import a namespace into an ASP.NET application.
  • The @ Implements directive is used to implement a specified .Net Framework interface in a Web page.
  • The CodeBehind attribute of the @ Page directive specifies the name of the compiled file that contains the class associated with the page.
  • The ErrorPage attribute of the @ Page directive is used to set the URL if an unhandled exception occurs. Sam can set this target to the home page.
  • The Language attribute of the @ Page directive specifies the language used while compiling the inline rendering and code declaration blocks.
  • The Inherits attribute of the @ Page directive specifies a code-behind class for the page to inherit. It can be any class that is derived from the Page class.
  • Public variables and objects can be accessed from all other procedures and functions in all the modules in the same project.
  • The public class Manager : HeadOfDept declaration will create a class named Manager, which implements the HeadOfDept interface.
  • Continue reading

Brij is an Expert in .Net Application and a graduate in computer science. At present, he is working as a project lead for Genisys Software


Brij is working on Framework 2.0/ 3.5 ASP.NET, WebServices, WCF, C#VB.NET, MVC Framework, ASP.NET Ajax, LINQ, SQL Server Reporting Services, SQL Server Integration Services, Crystal Reports .NET, Database Replication and Backup, etc.

Brij is a technology freak. He is always keen to learn more and more about new technologies. He also loves writing about various prominent IT certifications. His articles can be read on http://www.dotnetglobe.com/

After reviewing the Ucertify PrepKit, Brij said “This is one of the best Preparation Kit for exam 70-528 I found in the market, equipped with all the tools which a candidate needs. I strongly recommend uCertify, for those who is aspirant for Microsoft .NET certifications” Read his full review on uCertify Practice test here
 

Continue reading

Creating User Services

  • The identity object that implements the IIdentity interface, is used during the authentication process, when a user’s identity is verified. It contains information about a user who is being validated, such as username and password.
  • The principal object that implements the IPrincipal interface, is used during the authentication process when the application determines the data that can be accessed by a user and the code to be executed. It contains information about a user’s identity, such as username and password, as well as information about a user’s role, such as manager or associate.
  • Setting the MinimizeBox property of a Windows form to false prevents the minimize button from being displayed in the caption bar of the form.
  • Continue reading

Creating and Managing Microsoft Windows(r) Services, Serviced Components, .NET Remoting Objects, and XML Web Services

  • The SessionID property of the HttpSessionState class identifies an active ASP.NET session by using a unique session ID.
  • The Process.Start method is used to start a Windows application and is registered in the system registry on a computer.
  • The Status property of the ServiceController class specifies the status of the current instance of a Windows service.
  • If a class derives from the ServiceBase class, the OnCustomCommand method is executed when the Service Control Manager (SCM) passes a custom command to the service. This method is used to specify actions when a command with the specified parameter value occurs.
  • The AutoLog property of the ServiceBase class is used to determine whether or not a service automatically logs the entries in the event log when events such as Start, Stop, Pause, and Continue occur.
  • The CreateEventSource method of the EventLog class establishes an application as a valid event source for writing event information to a particular event log on a computer.
  • The Imports statement is used to import namespace names from referenced projects and assemblies.
  • Continue reading