(Shailendra Chauhan) LINQ provides a common query syntax to query any data source. In a LINQ query, you always work with objects. The object may in-process object or out-process object. Based on objects, LINQ query expression is translated and executed. There are two ways of LINQ query execution as
Other News
CFFinally Tag Will Execute Even After An Abort In ColdFusion
(Ben Nadel) This is just a quick sanity check. Earlier this year, I tested to see if the CFFinally tag would execute if the CFCatch block threw an error; which it did. Along the same lines, I wanted to see if the CFFinally tag would execute if the CFCatch block tried to abort the request processing.
SharePoint 2013 Apps using JavaScript Object Model (JSOM)
(Mahesh Sabnis) SharePoint 2013 Apps using JavaScript Object Model (JSOM). In this article, we will see the implementation of a SharePoint 2013 App.
Calculating and Verifying Check Digits in T-SQL
(Dwain Camps) A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we?
Name Parsing with SQL Server Functions and T-SQL Programming
(Rick Dobson) My company receives names in a variety of different formats from business partners. The formatting for names varies substantially across business partners. However, the names need to be parsed into one consistent format to help with tracking details associated with persons.
Sharding With a Purpose
If you have looked into sharding there are a number of techniques you can use. You can shard data of the same type across multiple servers. You can replicate the same data duplicating it across multiple servers. You can shard data of different types across different servers. You can do any combination of the previous techniques. How you choose to […]
Undocumented SQL Server 2012 Database Maintenance Plan Stored Procedures
Undocumented SQL Server 2012 Database Maintenance Plan Stored Procedures SQL Server 2012 supports the following useful undocumented database maintenance plan stored procedures: sp_clear_dbmaintplan_by_db sp_maintplan_close_logentry sp_maintplan_delete_log sp_maintplan_delete_plan sp_maintplan_delete_subplan sp_maintplan_open_logentry sp_maintplan_start sp_clear_dbmaintplan_by_db The sp_clear_dbmaintplan_by_db database maintenance plan stored procedure is used to delete the maintenance plans, the maintenance plan’s history and the maintenance plan’s jobs for the specified database. Syntax sp_clear_dbmaintplan_by_db [...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Dealing with Node.js and Microsoft SQL Server: Part-1
(Mihail Mateev) In a series of articles will look at how to use Node.js with some of the most popular products and platforms like SQL Server, MongoDB, Microsoft Azure, how to create applications using jQuery, jQuery UI and Ignite UI with Node.js
Identifying Query Text and Graphical Execution Plans in Active Queries
(Tim Ford) One of the most important things to know as a database administrator when you get that dreaded call from someone in your organization or a client that “my database is slow,” is to understand what is currently running on the server in question.
Difference Between Prop and Attr in jQuery
(Sachin Kalia) This article explains the difference between prop and attr in jQuery.