Resources No resource found - 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.
- Some Useful LINQ Query OperatorsMar 24, 2016. In this article you will get to know about some useful LINQ Query Operators.
- An Overview of IIS 7.5 feature - Request FilteringMar 16, 2016. In this article, we will look into one of the features of IIS 7.5 that helps to allow\deny a web request based on its URL, HTTP verb, query string etc.
- Useful SQL Queries For SharePoint PractitionersMar 11, 2016. In this article you will learn useful SQL Queries for SharePoint practitioners.
- Differences Among CTE, Derived Table, Temp Table, Sub Query And Temp VariableFeb 28, 2016. In this article you will learn about the difference between CTE, Derived Table, Temp Table , Sub Query and Temp variable.
- Nullable Types And Null Coalescing Operator In C#Feb 27, 2016. In this article you will learn about nullable types and the null coalescing operator in C#. We will also see its use in LINQ queries.
- Stored Procedure With Common Table Expression Or CTEFeb 27, 2016. In this post we will see how to use common table expression or CTE in SQL Server.
- Querying In The Azure DocumentDB: Day TwoFeb 26, 2016. In this article you will learn about querying in the DocumentDB. This is day two of the article series.
- Top 10 Most Used SQL QueriesFeb 25, 2016. In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
- Detect Poor Performing Queries In Entity Framework 6.xFeb 23, 2016. In this article you will learn how to detect poor performing queries in Entity Framework 6.x.
- SQL Join Query With LINQFeb 22, 2016. In this article, I will show you how to make your query in SQL and the same query in Linq.
- Useful SQL QueriesFeb 21, 2016. In this article we will read about some useful SQL queries.
- Find Datatype Of Each Measure In SSAS MDX QueriesFeb 18, 2016. In this post we will see how we can get the datatype of each measure we use in our SSAS MDX Queries.
- Lookup In LINQFeb 06, 2016. In this article I am going to discuss what lookup in LINQ is and will compare it withthe dictionary.
