Must Know SQL Server join for all .NET Developers

December 21st, 2013 | Posted by Vidya Vrat in .NET | Database | SQL Server - (0 Comments)

As a .NET Developer most of the common tasks you do are database related operations, like INSERT, SELECT UPDATE and DELETE. These tasks are often collectively referred to as CRUD operations. The problem comes when writing a complex query directly or in a Stored Procedure that retrieves expected data from more than one table of your Normalized database, in other words you are working on “Joining the Tables” to pull the data. Read Full Article Here

Agenda

  • Creating two sample tables for Join
  • Insert data into sample Join tables
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

Must Know SQL Functions For All .NET Developers

December 13th, 2013 | Posted by Vidya Vrat in .NET | C# | SQL Server - (0 Comments)

This article explains the most commonly used and must-know SQL Server functions and techniques that help and are handy in daily .NET Development and working with SQL Server Database projects. I found that working knowledge of these functions are very helpful and used very often in software development. Read Full Article Here

Article Covers

  • GETDATE()
  • DATEADD()
  • DATENAME()
  • DATEPART()
  • DATEDIFF()
  • DAY()
  • MONTH()
  • YEAR()
  • DATALENGTH()
  • APP_NAME()
  • HOST_NAME()
  • SYSTEM_USER
  • @@IDENTITY
  • IDENT_CURRENT
  • SET IDENTITY_INSERT
  • sp_defaultdb
  • Sp_Password

 

Using CLR With SQL Server 2012

December 9th, 2013 | Posted by Vidya Vrat in .NET | C# | CLR | SQL Server - (0 Comments)

In this article, I’ll cover the following:

  • Introduction to SQL CLR
  • Choosing Between T-SQL and SQL CLR
  • Enabling SQL CLR Integration
  • Creating a SQL CLR Stored Procedure
  • Deploying a SQL CLR Stored Procedure into SQL Server
  • Executing the SQL CLR Stored Procedure

Introduction to SQL CLR
SQL CLR is a tiny version of the .NET CLR that is integrated into the SQL Server 2005 and onwards. The existence of CLR in SQL Server allows the C# programmers and other .NET compliant language programmers to write database specific business logic in a programming language like C# instead of T-SQL. Let’s understand what type of objects a programmer can create with SQL CLR integration. Read Full Article Here
The following are objects that can be created using SQL CLR:

  • The following types of database objects can be created with SQL CLR Integration:
  • Stored Procedures
  • User defined aggregates
  • Triggers
  • User defined types

 

Understanding Windows Authentication in Detail

December 2nd, 2013 | Posted by Vidya Vrat in .NET | ASP .NET | C# | Security - (0 Comments)

Agenda

  1. What is Authentication and Authorization?
  2. Understanding Windows Authentication
  3. Types of Windows Authentication
  4. Programmatic Authentication
  5. Impersonation

What is Authentication and Authorization?

In simple words Authentication is the process that addresses the question “Who are you?“. Authentication is done by obtaining a valid username and password on an internet or intranet system. Once a user is authenticated, the system confirms that you match with the identity who you claim to be. However, authentication doesn’t confirm whether you are authorized to access the resource that you might be trying to access; that is done by Authorization.
Authorization addresses the question “What Can You Do?” and this happens after successful authentication. Authorization is the process of verifying that a user is allowed to access a requested resource. Read Full Article Here