Sunday, August 29, 2010

Top 10 SQL Server 2008 Security Features

Protecting database information from threats and vulnerabilities is vital for any organization. This article discusses 10 new security features introduced in SQL server 2008 that facilitate effective management of the database by using server surface area configuration (policy-based management configuration), full database encryption (TDE), enhanced auditing features and more.

Read full article..
http://www.databasejournal.com/features/mssql/article.phpr/3899866/article.htm

Friday, August 27, 2010

How to Use the Visual Studio Code Analysis Tool FxCop

In today's world, software security is the first and foremost requirement of any customer when you are developing a new application. But you can develop a secure application by mitigating all the risks in the development cycle itself.

The best way to mitigate software risks is by doing code reviews and code analysis throughout the development cycle.
Another positive aspect of code analysis is you can easily identify bugs early in the development cycle before those are identified by testers or even users of the application. Identifying and correcting critical bugs early in the software development cycle mitigates risks like reducing developer productivity, creating unnecessary bottlenecks in the software development lifecycle, increasing software development costs, etc. In this article I will discuss the integrated static code analysis tool (FxCop), introduced with Visual Studio 2010. Visual Studio code analysis rules are applicable for five different programming languages.

Read full article - http://www.devx.com/dotnet/Article/45499

Sunday, August 08, 2010

Top 10 SQL Server 2008 Development Features

Many new developer features were introduced in SQL Server 2008 database to facilitate robust database development. SQL server 2008 improves developer productivity by providing seamless integration between frameworks, data connectivity technologies, programming languages, Web services, development tools and data. This article discusses the new top 10 developer features introduced in SQL server 2008. Read my full article.

http://www.databasejournal.com/features/mssql/article.php/3897251/article.htm

Friday, August 06, 2010

Developing Reports for ASP.NET Web applications Using SQL Server 2008 Reporting Services

Crystal Report was the most recommended reporting tool used with ASP.NET web application before SQL server reporting service (SSRS) was first introduced in 2004 as an add-on to SQL server 2000 by Microsoft. An enhanced version of this SQL server reporting service was released with SQL server 2005 and the latest version of SSRS is launched with SQL Server 2008. A SSRS report is an XML file with a .RDL extension (Report Definition Language). After installation of the business intelligent development studio (BIDS) tool , developers can create a RDL report file using Microsoft Visual Studio editor. SSRS also provides a web service (server) interface for custom reporting applications. Read my full article in codeguru
http://www.codeguru.com/csharp/.net/article.php/c17661

Mocking API Responses in Azure API Management Portal

A mock API imitates a real API call by providing a realistic JSON or XML response to the requester. Mock APIs can be designed on a developer...