My MCSD Track for Microsoft .Net

Hi All,

Upon the request of many readers of my blog, below is the track in reverse chronology which I had completed for my MCSD. I had appeared all the exams with the language of choice as C# (wherever applicable).

1) 70-300 Analyzing Requirements and Defining Microsoft .NET Solution Architectures
2) 70-340 Implementing Security for Applications with Microsoft Visual C#® .NET
3) 70-320 Developing XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET Framework
4) 70-315 Developing and Implementing Web Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET
5) 70-316 Developing and Implementing Windows®-based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET

70-316 and 70-315 were quite easy.
70-320 was a challenging one, but I rate the toughness of this paper to be 6/10

70-340 was the hardest paper that I had ever appeared. I just got skipped with it. It was so so tough and it is one of the rarest paper that professionals appear. But it's an excellent paper to appear for those who may be interested in designing and developing security for applications.

70-300 was also a thrilling and tough one. It requires how microsoft expect you to answer on case-studies and not on your personal or any ethical experiences.

Dear Readers, if you feel my post to be helpful, please feel free to add comments to my post.

Siddharth Mehta
[MSc(I.T.), MCP, MCAD, MCSD]

Intellisense for SQL Server Query Analyzer

Friends,
Are you looking for features like these as in the image below ??


Click Here to download a completely FREE cool utility from Red-Gate software, that provides Intellisense for SQL Server and other features like
Code completion for fast, accurate script building, Discoverability in SQL Server query creation Keyword formatting, code snippet integration other extended features.

The tool/add-in is called SQL Prompt and is Free until 1st September, 2006 as published by Red-Gate Software. SQL Prompt works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32.

Siddharth Mehta.
[MSc(I.T.), MCP, MCAD, MCSD]

SQLiMail Overview

SQLiMail in SQL Server 2005 is a replacement of SQLMail of SQL Server 2000. It still exists in SQL Server 2005 but is only meant to be for backward compatibility only.
SQLiMail does not need: Extended MAPI, Outlook, to execute mail calls in the server process.
Also it is supported on a cluster, and it does support SMTP. In fact it uses SMTP to send e-mails. E-mails having mail-attachments can now also be sent. SQLiMail uses ServiceBroker to deliver messages to avoid blocking a stored procedure.
One of the striking feature is that it has a feature of failover accounts. Using this, it's possible to specify more than one SMTP server per profile. So in case of unavailability of the primary SMTP server, the next one can be used to deliver e-mails.

Siddharth Mehta
[MSc(I.T.), MCP, MCAD, MCSD]

Enhancements in SQL Server 2005 - Part III

Enhancements in full-text search are as follows:

1) Support for full text search against linked servers
2) No limitations of using either one or all the columns in a table, you can now specify whichever columns you require in the column_list argument.
3) Full-text queries using a different language to the default column language.
4) Full-text catalogs can now be backed up and restored with or without the database data.
5) Full-text catalogs are included in attach and detach operations.
6) Full-text indexes can be created on XML data.
7) Performance of index population is improved.

SQL Server Integration Services

SQL Server Integration Services (SSIS) provides a comprehensive solution for transferring and transforming data between diverse data sources.

1) SSIS has been redesigned to separate package-control flow from data flow. Two engines have been introduced to handle these aspects of data transformation: the SSIS Run-time engine and the SSIS Data-Flow engine.
2) SSIS Designer is hosted in Business Intelligence Development Studio or SQL Server Management Studio.
3) Provides many built-in transformations
4) Management and Deployment has become easy as you can choose to deploy a SSIS package using design time deployment or the SSIS Installer.

Siddharth Mehta
[MSc(I.T.), MCP, MCAD, MCSD]

Enhancements in SQL Server 2005 - Part II

Analysis Services available in SQL Server 2005 has a lot to offer for the Business Intelligence platform. Microsoft has come up with a new Business Intelligence Studio. Analysis services makes it possible to create datawarehouses and also mine out data from OLAP data warehouses. Enhancements to Analysis services are as follows:

1) With the Business Intelligence Development Studio, it has become lot easy to use and implement this feature similiary like Visual Studio.
2) Multiple instance of Analysis services can now be implemented. I guess there's a limit of maximum 50 instances, still I am not sure of this limit.
3) New features KPI - Key Performance Indicators, support for stored procedures are avialable that enable business for making powerful analysis and decision making.
4) As published by Microsoft, Analysis services now supports Microsoft Naive Bayes algorithm which would enhance the performance of data mining.
5) Even for development there are major enhancements like Integration with CLR, XML for Analysis (XMLA), Enhanced MDX, ADOMD.Net API, Analysis Management objects, and Analysis Services Scripting Language.
6) There's a new support available now for development in live mode as well as project mode. Development in project mode makes it possible to make and test changes without affecting client's production systems.

Siddharth Mehta
[MSc (I.T.), MCP, MCAD, MCSD]