Monday, August 29, 2011

Visual Studio LightSwitch 2011 : Introduction

Microsoft Visual Studio LightSwitch 2011 is a flexible business application development tool that can be used with Visual Studio 2010 IDE. It gives you a simplified development environment which give the capability to create CRUD based business applications within few minutes.

Typical business application manage data through user interfaces, provide search facilities and provide data validations. Usually, if you want to create a business applications you have to develop the user interfaces, write codes for interactions with data sources, along with the most critical business logic. But with Visual Studio LightSwitch, you can omit the first two and concentrate only about the business logic.

Saturday, August 27, 2011

The Story Never Ends ! [UCSC Batch 6]

End of a journey. But still couldn’t believe it! Though this wasn't un-expected, I never anticipated that reaching the end of my undergraduate life would make me this much emotional. Even though we (me and my batch mates - UCSC 6th batch, 2007/2008 intake) are not graduated yet, yesterday was the final remarkable day at university for most of us except our friends who’ll be continuing with their specialization on the fourth year.

Saturday, August 13, 2011

Logins, Users and Guest users in MSSQL

Recently I was working with some database restoring and configuring stuff. And I was getting errors due to the conflicts on database users, server logins and their permissions.

In the ideal scenario, there should be a 'login' in the database server, and a corresponding 'user' for the database. Sometimes people get confused with the difference of these two. But they are for two entirely different purposes.

Tuesday, August 9, 2011

What are MDF, NDF and LDF ?

If you have experience with SQL Server, you may have heard the terms MDF, NDF and LDF already. Those are the commonly used file name extensions in SQL Server for specify the Primary Data files, Secondary data files and Log files respectively.

In SQL Server, data and log information are never stored in the same file. Furthermore, those individual files (primary data, secondary data and log) are used by only one server. However, below is a brief description about the three file types in SQL Server.