Author: Ashif
-
Indexing in Document Db
By default, DocumentDB automatically indexes every property in a document as soon as the document is added to the database. However, you can take control and fine tune your…
-
DocumentDB vs Azure SQL vs Azure Table
Microsoft Azure is now offering a third storage option for developers: DocumentDB. DocumentDB is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with…
-
best Fifty query for sql server
In this article I will explain some general purpose queries. I think each developer should have knowledge of these queries. These queries are not related to any specific topic…
-
Encryption in .net
The .NET Framework provides implementations of many standard cryptographic algorithms. These algorithms are easy to use and have the safest possible default properties. In addition, the .NET Framework cryptography…
-
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 in entity framework we implement EntityFrameworkExtras package available on NuGet. Below are step…
-
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 ,PART.partition_number AS PartitionNumber ,PART.rows AS PartitionRows ,STAT.row_count AS StatRowCount ,cast(((STAT.used_page_count * 8)/1000000) as…
-
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 all application is index.cshtml, you need to separate your view for iPhone and…
-
Column level encryption in SQL server 2008r2
USE YourDB GO –get the list of keys in current adtabase select * from sys.symmetric_keys –get the list of certificates in current database select * from sys.certificates –To store…