Indexing in Document Db
By default, DocumentDB automatically indexes every property in a document as soon as the document is […]
DocumentDB vs Azure SQL vs Azure Table
Microsoft Azure is now offering a third storage option for developers: DocumentDB. DocumentDB is a no-sql […]
best Fifty query for sql server
In this article I will explain some general purpose queries. I think each developer should have […]
Encryption in .net
The .NET Framework provides implementations of many standard cryptographic algorithms. These algorithms are easy to use […]
Executing stored procedure with user defined table type parameter in entity framework using EntityFrameworkExtras
Entity framework does not support user defined type by default. So to support user defined type […]
How to get all table size and row count from sql server
SELECT SCH.name AS SchemaName ,OBJ.name AS ObjName ,OBJ.type_desc AS ObjType ,INDX.name AS IndexName ,INDX.type_desc AS IndexType […]
Asp.net MVC 5 Customized Mobile based View For Iphone,Android,Windows Phone
Asp.net MVC 5 has great feture called Mobile based separate view , suppose your View for […]
Column level encryption in SQL server 2008r2
USE YourDB GO --get the list of keys in current adtabase select * from sys.symmetric_keys --get […]