Working with Operators in LINQ – Part 1 In this series of articles we will discuss on operators in LINQ. In this part we will explore the aggregation operators and conversion operators. Aggregation Operators Count Count operator counts the number of elements in the sequence. A check is being performed if the source of type T implements the ICollection<T> interface...
Pro Members
Querying Relational Data With XQuery
Querying Relational Data With XQuery By Yuli Vasiliev This article illustrates how you might query relational data with Oracle XQuery. It also shows how you might join relational data with XML in a single SQL query, thus demonstrating the Oracle Database’s ability to work with and combine together different format data. In the following example, you query the DEPARTMENTS and...
Recovery Is a Compliance Issue
Recovery Is a Compliance Issue By Craig S. Mullins When data professionals think about regulatory compliance we tend to consider only data in our production databases. After all, it’s this data that runs our business and must be protected. So, we work to implement database auditing to know who did what to which data when; or, we tackle database security...
Useful SQL Server 2012 trace flags
Useful SQL Server 2012 trace flags Introduction Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2012: – global trace...
The LINQ to SQL Data Model – Part 2
Create operation using LINQ to SQL Open VisualStudio.NET and create a new ASP.NET WebApplication. From the main menu click Project > Add New Item, click on the Web Form item. Change the name of the web form to Create.aspx. From the main menu click Project > Add New Item, click on the Web Form item. Change the name of the...
Generating Relational Data From XML With XMLTable
Generating Relational Data From XML With XMLTable By Yuli Vasiliev Starting with 10g Release 2, Oracle Database offers a full-featured, native XQuery engine integrated with the database that can be used to accomplish various tasks involved in developing XML-enabled applications. With the help of Oracle XQuery you can construct XML data using SQL/XML functions XMLQuery and XMLTable, which provide a...
Back to basics: Transact-SQL programming fundamentals – (Part 1)
Back to basics: Transact-SQL programming fundamentals – (Part 1) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learn how to use scripts and batches, and basics of Transact-SQL variables. SQL Server users use Transact-SQL programming to create sets of statements for ad hoc execution. The aim of the Transact-SQL programming is to carry...
SQL Server 2012 Profiler Optimization Tips
SQL Server 2012 Profiler Optimization Tips SQL Server 2012 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some tips to performance tune and optimize SQL...
The LINQ to SQL Data Model – Part 1
The LINQ to SQL Data Model – Part 1 LINQ to SQL is a technology that allows you to create an object relational mapping between the tables in your relational database to objects. You can imagine LINQ to SQL as an object mapping tool that makes easier for developers to develop data centric applications using Microsoft SQL Server. It basically...
Transforming XML Data With XMLQuery in Oracle Database
Transforming XML Data With XMLQuery in Oracle Database By Yuli Vasiliev With a full-featured, native XQuery engine integrated with Oracle Database starting with 10g Release 2, you can accomplish various tasks involved in developing XML-enabled applications. With the help of Oracle XQuery you can construct XML data using SQL/XML functions such as XMLQuery and XMLTable, which provide a general interface...