|
|
-
|
|
In the recent past I am fortunate to get my hands on to new technology ASP.Net Web API. I was fascinated to hear ASP.Net Web API’s definition from MSDN as follows – “ASP.NET Web API is a framework that makes it easy to build HTTP services that reach a broa...
|
|
-
|
|
In this short tutorial, I am going to narrate on how we can lazy load images in a ASP.Net MVC 4 page. In most of today’s social media sites, we often come across lots and lots of images which load immediately a page renders and in return kill most of the b...
|
|
-
|
|
This articles narrates on how to parse XML data in TSQL using NODES(). In this tutorial we are going to validate input XML data against its corresponding schema. Upon successful validation data has been extracted from the same using nodes() method. Nodes()...
|
|
-
|
|
At times, we have to validate the XML input passed from different sources. In SQL Server, we can use XML Schema Collection to have a schema defined and then use the same for validating corresponding XML inputs which are received. XML Schema declaration and...
|
|
-
|
|
There are two types of DML triggers in SQL Server. First type was AFTER/FOR trigger and the other was INSTEAD OF trigger. Triggers are extremely useful for logging different database operations (Insert/Update/Delete) into audit tables. Apart from afore sai...
|
|
-
|
|
Last night I ran into a situation when I started creating a new database using SSMS, it was complaining me ‘Database already exists’. I quickly checked object explorer and was not able to find the database with the same name. I was confused and lost for a ...
|
|
-
|
|
At times we might need to check out all active connections made by all processes to the SQL Server databases. Also some times we might need to check with all active transactions in the SQL Engine. To accomplish the same tasks, we have two system provided v...
|
|
-
|
|
Sometimes we might get this error when we perform ALTER statements on an existing database. This error means, that particular database is being used by lot of other user connections and the present ALTER statement needs to have an exclusive lock on the dat...
|
|
-
|
|
First of all I would like to convey my heartiest new year wishes to one and all. I wish may god bless you all with good fortunes, health and happiness. I do wish a prospective future and career for one and all.
Personally, I had a very good start to 2013. ...
|
|
-
|
|
Sometimes, we might need to have a copy of database running on a different server for testing purpose. In that scenario creating a backup and restoring it in a different server would help. In this short tip, I am going to narrate on how to backup an existi...
|
|