Resources No resource found - Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
- Using Optional Query Parameters With Microsoft Graph API - Part OneOct 12, 2017. While Microsoft already has all the documentation to cover all its technology, in this article I will try to explain these ODATA query parameters with some different angles and usage scenarios. I’m sure you will enjoy reading this article and learn something new.
- Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
- Overview Of Let In LINQOct 09, 2017. In general, Let allows create a local variable at the LinQ query. Let has the same operation as to build local variable in a loop. The example with let hast better performance than the without let example, because the first execute one time and second two time for each item.
- CRUD Operations In MVC Using Entity Framework With AJAX Call, jQuery, And All ValidationsSep 19, 2017. This article describes how to perform basic CRUD operations in an Asp.Net MVC application using Entity Framework with Ajax call and j query.
with using Datatable Grid ,Toaster messagebox and also Bootstrap css.
- 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
- Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
- Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
- Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
- Use Of Union, Intersect, Distinct And Except In LINQSep 01, 2017. Here, you will learn the uses of Union, Intersect, Except, and their differences, To get a clear picture, we will go with examples.
- Use Of Deferred And Immediate Query Execution In LINQAug 31, 2017. Here, you will see about query execution in linq and what is deffered query execution, what is immediate query execution and it's differences, we will see with example for better understanding.
- Use Of Range, Repeat And Empty In LINQAug 21, 2017. Here, we are going to see the uses of the Range,Repeat and Empty keywords in LINQ and we also will discuss their differences.
- Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
- Element Operators In LINQAug 17, 2017. Here, we will learn about Element Operators, their uses, and various element operators.
- Use Of Into And Let In LINQAug 07, 2017. Here, we going to see the uses of Into and Let keywords in LINQ and their differences.
- Statistics And Cost Estimation Internals - Part OneJul 30, 2017. Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look deep inside Statistics.
- How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
- Preliminary Practices On Python ProgrammingJul 17, 2017. This article describes the basic concept of Python programming including program syntax, data types, looping & conditional statements and more
- How To Use Joins, and Group By Clause In Entity Framework With LINQ C#Jul 15, 2017. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
- How To Query The Entities In Dynamics CRM From ADX Portal Using JQueryJul 11, 2017. It is difficult to get the Dynamics CRM Entities from ADX Portal using any Web API call, because that may require authorization token, client id and client secret etc. Also, you will not be able to get any client context or to use XRMServiceToolKit.
- Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
- Chat Bot Using Microsoft Bot Framework With LUIS - Part OneJul 03, 2017. LUIS: Language Understanding Intelligent Service. We can teach this service to understand intention and extract the entities from user query/activity. Client app (e.g. chat bot) can consume this output using HTTP endpoint of LUIS application.
- Building Your Own Rest Query Language - An Experiment With Azure Cosmos DbJun 27, 2017. A simple, fun tutorial to build a REST query language using ANTLR and Azure Cosmos Db as storage.
- Writing Complex Queries Using LINQ And LambdaJun 22, 2017. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
- JavaScript For Querying An Entity And Updating Attribute Values In FormJun 20, 2017. In this article, you will learn about JavaScript for querying an Entity and updating attribute values in form.
- Code Improvement Techniques In C#Jun 13, 2017. General code improvement technique over string.empty, string.Equals, string.Intern, StringBuilder, string.Format, case insensitive comparisons, using Block and Linq - First, FirstOrDefault, Single and SingleOrDefault. Main focus points are - what are the advantages and the purpose to use these.
- Time And Date Query Code And Analysis - Part OneMay 30, 2017. Time and Date query code and analysis.
- LINQ Basic To Advanced - MVC Demo ApplicationMay 16, 2017. Here, in this post, we are going to see some basic and advanced LINQ queries
- Cross Database Queries In Azure SQLMay 06, 2017. In this article, you will learn about cross database queries in Azure SQL.
- SQL Server - Execution PlansMay 01, 2017. Execution plan will be generated by Query optimizer with the help of statistics and Algebrizer/ processor tree. It is the result of Query Optimizer and tells how to do/ perform your work/ requirement.
- What Is Deferred/ Lazy Loading And Eager Loading?Apr 28, 2017. In his article, you will learn about Deferred/ Lazy Loading and Eager Loading.
- A Brief Introduction To LINQApr 27, 2017. Introduction to LINQ.
- LINQ Extended JoinsApr 24, 2017. This article illustrates LINQ extended joins.
- Aggregate Function With LINQ In C#Apr 11, 2017. In this article, we going to see about how to use the aggregate function with LINQ.
- Querying With U-SQL In A TSV File On Azure Data Lake StoreFeb 13, 2017. In this article, you will learn about using a U-SQL query in a TSV file on Azure Data Lake Store.
- Explain About jQuery Selector And CSS Use Jquery ElementFeb 04, 2017. In this article, you will learn about jQuery selector and Id selectors, followed by how to use CSS in jQuery Selector Element, followed by an explanation of the basic syntax in jQuery Selector and ID Selector.
- Accessing SQL From Entity Framework Core Queries In ASP.NET CoreFeb 03, 2017. In this article, you will learn how to access SQL from Entity Framework Core Queries in ASP.NET Core.
- Introduction To SQL Database Query Editor In Azure PortalFeb 01, 2017. In this article, you will learn how to use SQL Database Query Editor in Azure Portal.
- LINQ To SQL - CRUD OperationsJan 19, 2017. In this article, we will see LINQ to SQL CRUD Operations.
- Get Data From Multiple Tables Using Parameters While Combining LINQ ExpressionsJan 11, 2017. In this article, you will learn how to get data from mutliple tables using parameters when combining LINQ expressions in ASP.NET MVC 5.
- Convert DateTime To String Format Using IQueryableJan 10, 2017. In this article, you will learn how to convert DateTime to string (yyyy/mm/dd) format in ViewModel/Whatever class with IQueryable.
- Overview Of Concurrency In LINQ To SQLJan 10, 2017. In this article, you will learn about concurrency in LINQ to SQL.
- Identity Cache In LINQ To SQLJan 08, 2017. In this article, we will see what identity cache is and its impact on LINQ to SQL queries.
- Compile Queries And Execute SQL Queries Using LINQ To SQLJan 08, 2017. In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
- Lazy Loading And Eager Loading In LINQ To SQLJan 08, 2017. In this article, you will learn about Lazy Loading and Eager Loading in LINQ to SQL.
- Single Table Inheritance In LINQ To SQLJan 07, 2017. In this article, we will see single table inheritance in LINQ to SQL.
- How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL Jan 02, 2017. In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
- Stored Procedure With Output Parameters In LINQ To SQL And What SQLMetal IsJan 02, 2017. In this article, you will learn how to call a stored procedure with output parameters using LINQ to SQL.
- How To Use LINQ To SQL For Retrieving Data From SQL Server DatabaseJan 01, 2017. In this article, we will learn how to use LINQ to SQL to retrieve data from the SQL server database.
- CRUD Operations Using LINQ To SQLJan 01, 2017. In this article, you will learn about CRUD operations using LINQ to SQL.
- How To Run Interactive Spark SQL Queries On Apache Spark Hdinsight Linux ClusterDec 31, 2016. In this article, you will learn how to run Interactive Spark SQL queries on Apache Spark HDinsight Linux cluster.
- Introduction To LINQDec 26, 2016. In this article you will learn an introduction to LINQ.
- SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part TwoDec 12, 2016. This second part of this article presents you with some more of the important queries that you can use to query SharePoint content databases.
- SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part OneDec 08, 2016. This article presents you with some of the important queries that you can use to query SharePoint content databases.
- Node.js - Query String And API - Day TwelveNov 28, 2016. In this article, you will learn about Query String and API in Node.js.
- Best Practices And Programming Guidelines In SQL Server - Part OneNov 20, 2016. In this article, we will learn the best Practices, and Programming Guidelines in SQL Server.
- Introduction To Generic IEqualityComparerNov 20, 2016. In this article, you will learn about Generic IEquality Comparer.
- To Filter SharePoint List View Using Query String Web Part With No CodeOct 22, 2016. In this article, we are going to see how the "Query String Filter" Web Part can be used to filter the SharePoint List View Web Part values.
- Bing Service Into UWP App Using UWP Community ToolkitSep 29, 2016. In this article, you will learn about integrating Bing to search the query in the web.
- ASP.NET WebAPI Query String ParametersSep 29, 2016. In this article, you will learn about ASP.NET WebAPI query string parameters.
- Run A Hive Query From Azure PortalSep 10, 2016. In this article, you will learn how to run a Hive query from Azure Portal.
- AngularJS Nested Scopes And Controllers As SyntaxSep 09, 2016. In this article, you will learn about AngularJS Nested Scopes and Controllers as Syntax.
- AngularJS Controller As SyntaxSep 07, 2016. In this article, you will learn about AngularJS controller as syntax.
- Bind Add Update Delete Data Using MVC Entity Framework And LINQAug 29, 2016. In the article, you will learn how to add, update, and delete data, using Entity Framework and LINQ. This is for the beginner users like me in MVC.
- LINQ to SQL - Basic Guide To Perform Fetch, Filter, Insert, Update And DeleteAug 25, 2016. In this article, you will learn the basic guide to perform fetch, filter, insert, update and delete in LINQ to SQL.
- Query List Action On SharePoint Online And Office 365 Using Nintex WorkflowsAug 16, 2016. In this article, you will learn about Query List Action on SharePoint Online and Office 365, using Nintex Workflows.
- Introducing Swift Programming LanguageAug 15, 2016. In this article, you will learn about Swift Programming Language.
- SQL Server Tricky Query Interview QuestionJul 30, 2016. In this article you will learn about a SQL Server tricky query interview question.
- Sql Injection Through Query String And Its Prevention MechanismJul 17, 2016. In this article, you will learn about SQL Injection through Query String and its prevention mechanism.
- Understanding CQRSJul 15, 2016. In this article, you will learn about Command Query Responsibility Segregation.
- Search Query On SharePoint Online And Office 365 Using Nintex WorkflowsJul 11, 2016. In this article, you will learn how to search query on SharePoint online and Office 365, using Nintex Workflows.
- CQRS: A High Level ViewJul 07, 2016. In this article, you will learn about the internals of Command Query Response Segregation.
- Query User Profile Action On SharePoint Online And Office 365 Using Nintex WorkflowsJul 01, 2016. In this article, you will learn about the query user profile action on SharePoint online and Office 365, using Nintex Workflows.
- Learn MySQL Queries With ExamplesJun 23, 2016. In this article, you will learn select, update and delete statements in MySQL queries with examples.
- Learn R Programming LanguageJun 21, 2016. This article is just a beginning and in this article, I am trying to familiarize the readers with R programming.
- Dynamic SQL Query Injection And Its Prevention MechanismJun 20, 2016. In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
- MongoDB Tutorial - Queries: Part TwoJun 07, 2016. In this article, we will see some MongoDB specific queries.
- Diving Into Visual Studio 2015: Debugging Improvements (Tool Window Support for LINQ and Lambda) - Day SixMay 29, 2016. In this article, you will learn about Debugging Improvements In Visual Studio 2015.
- SQL Query Plans Each Developer Should KnowMay 26, 2016. In this article you will learn about SQL Query Plans for each Developer.
- Top 10 Functions In JQuery May 26, 2016. In this article you will learn about the top 10 Functions in JQuery.
- Getting Started With Azure HDInsight: Run A HBase Hive Query - Part TwoMay 19, 2016. In this article you will get to know how to run a HBase Hive Query in Azure HDInsight.
- LINQ to SQL Using Visual StudioMay 18, 2016. In this article you will learn about LINQ to SQL using Visual Studio.
- Getting Started With Azure HDInsight: Run A Hive Query - Part TwoMay 09, 2016. In this article you will learn about how to run a Hive Query in Azure HDInsight. This is part two of the article series.
- Keyboard Query Shortcuts In SQL Server Management StudioMay 06, 2016. In this article we are going to see some shortcuts that may be useful to you when you work with SQL Server Management Studio.
- Introduction To AngularJS: Controller as Syntax - Day Twenty OneMay 04, 2016. In this article you will learn about 'Controller as' Syntax in AngularJS. This is part 21 of the article series.
- Manage Query Rules Of Search Administration At The SharePoint Admin Center on Office 365Apr 30, 2016. In this article you will learn how to manage Query Rules of Search Administration at the SharePoint Admin Center on Office 365.
- Manage Query Client Types Of Search Administration At The SharePoint Admin Center On Office 365Apr 30, 2016. In this article you will learn how to manage Query Client Types of Search Administration at the SharePoint Admin Center on Office 365.
- Query Suggestion Settings Of Search Administration At The SharePoint Admin Center On Office 365Apr 28, 2016. In this article you will learn about Query Suggestion settings of Search Administration at the SharePoint Admin Center on Office 365.
- How To Optimize SQL QueriesApr 24, 2016. In this article you will learn how to optimize an SQL Query.
- 50 Important Queries In SQL ServerApr 23, 2016. In this article you will learn about 50 Important Queries in SQL Server.
- SharePoint 2013: How To Create Custom Result Blocks Using Query RulesApr 20, 2016. In this article you will learn how to create Custom Result Blocks using Query Rules in SharePoint 2013.
- Query Unstructured Data From SQL Server Using PolybaseApr 17, 2016. In this article you will learn about querying Unstructured Data from SQL Server using Polybase.
- SQL Injection In Dynamic SQLApr 17, 2016. In this article you will learn about SQL Injection in Dynamic SQL.
- SharePoint 2013: How To Create Custom Intent Based Results Blocks Using Query RulesApr 13, 2016. In this article you will learn how to create Custom Intent Based Results Blocks using Query Rules in SharePoint 2013.
- SharePoint 2013: Execute SharePoint Search Queries Using CSOMApr 13, 2016. In this article you will learn how to execute SharePoint Search Queries using CSOM in SharePoint 2013.
- Export To Excel Data By LINQ to SQLApr 11, 2016. In this article we will see how to get data from LINQ to SQL query and export to excel.
- LINQ - Partitioning OperatorsApr 04, 2016. In this article you will learn about Partitioning Operators in LINQ. We will learn about LINQ Partitioning Operators: Skip, SkipWhile and Take, TakeWhile.
- Stored Procedure with LINQ to SQLMar 30, 2016. In this article you will learn how to work with stored procedure with LINQ to SQL.
- An Overview Of LINQMar 30, 2016. In this article you will get an overview of LINQ.
- Using Web API Function in CRM 2016 - Part TwoMar 24, 2016. This is second article regarding Web API Query functions.
