Introduction Scheduled jobs are a part of development, may it be any application. Inventory applications require them the most when they automate almost everything. 🙂 SQL Jobs can prove to be handy when a query
Read moreCategory: SQL
Sending Email Using Stored Procedures in Sql Server
Introduction A very interesting topic of discussion. We have mail integrated to every application now a days. We integrate email using SMTP settings in the Web.Config in .NET and use the Send method to send
Read moreValidation & Security in MVC application
Introduction Validations in any application is so critical now a days that developers ought to be on their toes while developing any such critical and sensitive applications. Hackers are now in every corner of the
Read moreFull Text Search in SQL
Introduction Executing complex queries against character-based data on the sql tables can be accomplished using Full Text Queries across SQL as well as Azure SQL databases. There are many a times this type of requirement
Read moreEverything about SQL- Get Started
Topics to be Covered SQL Basics Introduction What is a database? What does Relational mean? A small example SQL Statement Naming Things Creating Things Everything about SELECT Statement Introduction FROM Clause Limiting Result Set WHERE
Read moreThe Unsung Hero ELMAH-Part 2
Background As discussed in my prvious blog post i.e. ELMAH Part-1. Now in this article I will be explaining the integration of ELMAH with Sql Server(SSMS). This is now-a-days an essential part in any application,
Read more
Facebook
Twitter
LinkedIn
GooglePlus