Using SWITCH On A Single PartitionMar 12, 2018. Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.

Table Splitting In Entity Framework Core 2.0Mar 06, 2018. One of the major benefits of the Entity Framework is that our entity model does not need to match our database model. With Table Splitting, it is possible to map multiple entities to the single database table.

Blob Security On Azure Storage - Part ThreeFeb 01, 2018. Shared Access Signature is shortly called as SAS, SAS is a URI that grants restricted access rights to Azure Storage resources, you can provide a SAS to clients who should not be trusted with your azure storage account key but whom you wish to delegate access to certain storage account resources. By distributing a shared access signature URI to these clients, you can grant them access to resource for a specific period time. The Service – Level SAS delegates access to a multiple storage services like blob, files, tables and queues.

ASP.NET Core 2.0 IdentityJan 30, 2018. In a previous post, I showed how to use cookie authentication middleware to protect your web application. ASP.NET Core also provides a richer set of services, called Identity, to work with user authentication and management scenarios. For instance, in addition to authentication and password hashing, it provides features for registering new users, creating forgot &amp; reset password tokens and their validation, two-factor authentication and authentication using external providers.

Custom Model Binding In ASP.NET Core 2.0Jan 17, 2018. In an earlier post I discussed how to prevent insecure object references by encrypting the internal references (e.g. table primary keys) using Data Protection API. To avoid duplication of code that encrypts/decrypts on every controller I used filters in that example. In this post I’ll use another complimentary technique: custom model binding.

Hashing In ASP.NET Core 2.0Jan 08, 2018. The new Data Protection API in .NET Core includes functionality to create hashes using PBKDF2algorithm. ASP.NET Core uses this behind the scenes in PasswordHasher class, which is used in ASP.NET Core Identity.

Send Email With Attachment In Office 365 (SharePoint Online)Jan 07, 2018. Recently, I came up with a requirement to send an email with attachment in Office 365 (SharePoint Online). This needs to be a custom functionality wherein for each line item in a jQuery Data table (as shown in below image), user needs to send an email with an attachment to specific email address.

ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.

Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.

Implementing Power BI - Part 1Dec 18, 2017. Power BI is the product of Microsoft. It is used as a tool for developing and creating business analytics. It provides interactive visualizations for creating reports, charts, tables and dashboards.

Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.

How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.

Custom Search Using Client Side CodeNov 11, 2017. The Custom Search functionality is achieved through JS. The Search produces live results for each key press. This search can be used to filter the data table or html table data dynamically based on the key words entered. The below code explains the search for html table.

How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.

How To Implement Angular Data Table With CRUD Using ASP.NET MVC And AngularSep 22, 2017. In this article, we will discuss how to implement Angular Data Table with (Insert, Update, and Delete) Short Form (CRUD) using Asp.net MVC + Angular JS in one page without any full page reloads. This table will be similar to JQuery Data Table and this one is implemented using Angular Data table.

How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).

Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.

How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.

Create TableView In Xamarin.iOSSep 07, 2017. In this tutorial, I am going to share how to create a table view in Xamarin IOS applications using C# and how to use navigation controller in our application.

Getting Started With Azure TablesSep 01, 2017. In this article, we will walk through some important concepts of Azure Tables through Emulator. Create the Azure Tables by using Microsoft Azure Storage Explorer.

Data Persistence Using SQLite In Xamarin.FormsJul 04, 2017. In this article, we are going to make our data persistence using SQLite in Xamarin.Forms. Firstly we will setup SQLite db for our project than make a table in it and add some data in this table. After this whenever we open our application we will see that our data is now persisted and saved in local db of application.

Write HTML Code In Xamarin Cross Platform With Table ExampleMay 17, 2017. You build your mobile app entirely in HTML, however those apps can suffer from performance problems when trying to accomplish complex processing or UI effects and are also limited in the platform features which they can access.

Add TOC (Table Of Contents) To Your Wordpress Posts Or PagesMay 07, 2017. In this post, we are going to a see how we can add Table of Contents to our WordPress posts and pages. Here, we are going to install a plugin to do this work. I have chosen this plugin because it is so simple and yet does the work very well. It doesn’t have more settings and features but the way it is created is 100% apt for what it is meant to be.