This article discusses the new C++ Elmax XML Library feature to implement Linq-To-XML node creation to write XML files. Linq-To-XML node creation is the natural way to create nodes with code that is structurally identical to resultant XML.

In this age of cloud computing, massive parallel systems and complex security threats like identity theft and decentralized botnets, devoting resources to combat the seemingly age-old issue of integer overflow appears distinctly passC). Despite the fact that integer overflow is such a well know problem, particularly within C and C++ programming, the problem remains a real issue from both a defect and security standpoint, that's why the introduction of the SafeInt template class in Visual C++ 2010 to address overflows is a great addition.

Unquestionably, the most effective tool for a C++ programmer's productivity is the Standard library's rich collection of algorithms. In 2008, about 20 new algorithms were voted into the C++0x draft standard. These new algorithms let you among the rest copy n elements intuitively, perform set theory operations, and handle partitions conveniently. Find out how to use these algorithms to make your code more efficient and intuitive.

Application manifest files provide a declarative means for an application to detail its dependencies and runtime requirements. Each version of Windows and Visual C++ adds further options that can be specified in the application manifest file, and it is important for correct application deployment and execution that the Visual C++ developer keeps up to date with these advances.

Find out how to use nullptr to avert bugs and simplify the future maintenance of your C++ applications.

Using shared_ptr instead of raw pointers helps you avoid the common pitfalls associated with raw pointers but in some cases, its performance isn't satisfactory. Unique_ptr is a new C++0x smart pointer that is compact, fast and fully compatible with the standard library. Find out how to use unique_ptr to make your code safer without sacrificing performance.

Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.

Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database.

In this C++ tutorial, learn how to utilize Lambda expressions in your C++ Applications.

Do you need to create Dynamic Where Clauses at runtime? No need to use string concatenation with SQL, LINQ is fully capable of performing the same task.

Learn how to use SQL Modeling Services to hunt for interdependencies without having to access source code.

In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.

Learn how to define policies and use them to better manage your SQL Server 2008 instances.

This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.

An Object Oriented approach to handling XML.

This tutorial shows you how to use Visual Studio 2008 with SP1 to build your first Dynamic Data web application and explore its features.

Explore a CRecordSet-like interface to a SQLite database table.

By Dee Quang - Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.

Serialize and deserialize XML files and XML buffer with this set of macros and classes. The serializer uses ATL String and ATL collections. Get the object representations of XML files and a means to store and load objects to and from XML.

Why get bogged down in the quicksand of the Oracle Call Interface (OCI) when you can get the same service with less code and fewer headaches with Vincent Rogier's OCILIB?

Got XML files? Look no further than libxml2, which gives you both DOM and SAX model XML parsing in a single freeware library that works with most common languages in all popular platforms including Linux and Win32/Win64.

A MySQL Storage engine requires functions that MySQL provides. Therefore, you normally need to link it into mysqld-core under Windows because mysqld.exe doesn't export all required functions (because it's an .exe, not a .dll). So, you're unable to import the required functions in our Plugin. Learn a possible way to circumvent this limitation by using the .map files that are provided with MySQL.

by William R. Vaughn - Having problems importing large amounts of data? ADO.NET has only one method designed to help with this task: the SqlBulkCopy class exposed in ADO.NET 2.0.

Are you having problems setting up a TableAdapter that can be fed from stored procedures instead of base tables? Here is a road map to guide you to success.

The people at Microsoft are busy with lots of products. Did someone forget that they should be excited about them?

Follow an experiment and draw interesting conclusions on where and when to use temporary tables or table variables.

In the last of this three-part SQL Server Reporting Services recipe series, Wrox author Paul Turley shows how to create the graphics for word-size graphics that visualization pioneer Edward Tufte dubbed sparklines.

If you thought the end of Visual FoxPro had already happened, then you are wrong. Its end is now.

If you're haven't used CodeSmith for your TSQL coding yet, now's the time. This template-based code generator enables you to add fire-and-forget programming to your TSQL development.

Microsoft SQL Server 2005 Compact Edition provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Take a look under the hood.

Learn how to conquer a SQL Express 2005 remote connection issue.

Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?

Learn how the Service Broker provides the "plumbing" to let you pass messages between applications, using SQL Server as the transport mechanism.

SQL Server Management Studio just doesn't cut it for complicated configuration and monitoring implementations. Learn how to implement your own SQL Service Broker (SSB) control bus solution to serve the needs of complex SQL Server-based messaging solutions.

Learn how to write server applications. One of the recurring tasks was dealing with the problem of creating an instance of a class associated with a unique resource of the operating system, such as a file.

Learn how to extend MySQL with your own functions in C/C++.

You can leverage SQL 2005 Server Service Broker with existing technologies such as SQL Server 2000 and MSMQ. BizTalk and SSB external activation are viable options, but a simple polling solution is easier.

Custom controls assist developers in maximizing code reuse and minimizing headaches. Learn the process of creating custom controls within Microsoft's latest UI model, the Windows Presentation Foundation (WPF).

Learn about a pair of stored procedures that can dump all users, role memberships, and permissions in a database, or copy them from one database to another.

Utilizing design patterns with SQL Server 2005 Service Broker enables you to assess and select appropriate solutions for all of your SQL Server 2005 asynchronous messaging needs.

To begin writing raw PDF files, you need a solid working knowledge of PostScript—and that's not pretty. In reality, you need a complete PDF library that handles all your document-creation needs.

Spell checkers for the Visual C++ and Visual Basic developer are plentiful and easy to integrate. So, why not enable your interactive applications to help users look a little smarter?

Microsoft Operations Manager 2005 (MOM) is a very capable monitoring tool, but it's limited when it comes to quality assurance. Learn how to use WMI and MOM's rules and notification capabilities to run automated data warehouse QA checks.

Learn about a new utility to analyse the data's structure on a DVD.

When handling a project with hundreds of tables, it takes some time to understand the flows. Learn how to create a simple tool for Visualizing database tables and relations.

There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them — specifically, Common Table Expressions (CTE), because they often come in handy.

Win32 has a built-in INI file API, but writing cross-platform code is difficult because these functions aren't available on Linux.

Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.

Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.

In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.