next

XMLFoundation
Rating: none
Brian Aberle - 08/17/2009
An Object Oriented approach to handling XML.

VIDEO: ASP.NET Dynamic Data
03/09/2009
This tutorial shows you how to use Visual Studio 2008 with SP1 to build your first Dynamic Data web application and explore its features.

[Updated] SQLiteTbl, a C++ Class that Provides a CRecordSet-Like Interface to SQLite
Rating: none
Brad Kremer - 12/10/2008
Explore a CRecordSet-like interface to a SQLite database table.

Deploying and Configuring SQL Server Integration Services Packages Without the Wizard
10/02/2008
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.

Code: XML Serializer
Rating: none
anuvk - 08/11/2008
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.

Faster and Friendlier Access to Oracle's OCI API
Rating:
Victor Volkman - 05/13/2008
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?

Libxml2: Everything You Need in an XML Library
Rating: none
Victor Volkman - 02/26/2008
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.

Create MySQL 5.1 Storage Engine Plugins Under Win32
Rating: none
Ludwig Ertl - 11/15/2007
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.

Importing Data into SQL Server
10/02/2007
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.

Hierarchical TableAdapters 301
Rating: none
William R. Vaughn - 08/08/2007
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.

Ponderings about the Tech Ed 2007 Keynote
Rating: none
Bradley Jones - 06/12/2007
The people at Microsoft are busy with lots of products. Did someone forget that they should be excited about them?

Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
Rating: none
Dmitry Tsuranoff - 05/31/2007
Follow an experiment and draw interesting conclusions on where and when to use temporary tables or table variables.

Report Solution Patterns and Recipes: Creating Sparklines
Rating:
Paul Turley - 05/15/2007
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.

Visual FoxPro: Its Day Has Finally Come
Rating:
Bradley Jones - 03/14/2007
If you thought the end of Visual FoxPro had already happened, then you are wrong. Its end is now.

Forging Transact SQL Code with CodeSmith
Rating: none
Jeffrey Juday - 02/28/2007
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.

SQL Server 2005 Compact Edition: The Little Engine That Can
Rating:
Josh Fitzgerald - 01/16/2007
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.

Tip: SQL Express Configuration Issue
Rating: none
Sushankar layak - 12/14/2006
Learn how to conquer a SQL Express 2005 remote connection issue.

News: Don't Embed That Database!
Rating:
Bradley Jones - 11/09/2006
Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?

Getting Started with SQL Server Service Broker
Rating: none
Mike Gunderloy - 10/31/2006
Learn how the Service Broker provides the "plumbing" to let you pass messages between applications, using SQL Server as the transport mechanism.

Designing a SQL Service Broker Control Bus
Rating: none
Jeffrey Juday - 10/02/2006
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.

Controlling an Object's Creation Based on Its Key Value Representing a Unique Resource
Rating: none
Boris Bromberg - 09/20/2006
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.

MySQL UDFs
Rating:
DarkLizener - 09/19/2006
Learn how to extend MySQL with your own functions in C/C++.

SQL Server 2005 Service Broker Plays Well with Older Relatives
Rating: none
Jeffrey Juday - 09/08/2006
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.

Creating Custom WPF Controls
Rating:
Chad Campbell - 08/28/2006
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).

[Updated] Extracting/Copying Users and Permissions Between Databases
Rating:
Mark McGinty - 08/17/2006
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.

Using SQL Server to Implement the Publish-Subscribe Integration Pattern
Rating: none
Jeffrey Juday - 07/31/2006
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.

A PDF Solution for All Programming Platforms
Rating: none
Victor Volkman - 07/12/2006
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.

[Updated] Help Your Application Users Become Great Spellers
Rating: none
Victor Volkman - 06/20/2006
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?

Incorporate Data Warehouse QA Checks into MOM 2005
Rating: none
Jeffrey Juday - 06/12/2006
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.

[Updated] DVD Explorer
Rating:
Georges Dumond - 06/12/2006
Learn about a new utility to analyse the data's structure on a DVD.

Database Visualization
Rating: none
VGirish - 06/07/2006
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.

SQL Server 2005 Programmability Enhancements — Common Table Expressions
Rating: none
Scott Klein - 05/16/2006
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.

Working with INI Configuration Files Cross-Platform (Win32/Un*x, MBCS/Unicode)
Rating: none
brofield - 04/25/2006
Win32 has a built-in INI file API, but writing cross-platform code is difficult because these functions aren't available on Linux.

[Updated] Microsoft Excel Automation Class
Rating:
Val Golovlev - 04/25/2006
Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.

User-Defined Functions: Powerful Alternatives to Views and Stored Procedures
Rating:
Jeffrey Juday - 04/14/2006
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.

Storing Session State in a SQL Server Database
Rating:
Bipin Joshi - 04/05/2006
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.

A Kick-Start to SAX with C++, Part 1
Rating:
Marius Bancila - 03/10/2006
Learn how to process XML documents' content with the Microsoft COM implementation of Simple API for XML (SAX).

Put Some "BAM" in Your Next BizTalk 2004 Project
Rating: none
Jeffrey Juday - 02/24/2006
Need to gather some metrics on the steps within your BizTalk 2004 Orchestration? Check out Business Activity Monitoring (BAM).

WinFS Basics: Working with a Data Store
Rating: none
Sahil Malik - 01/30/2006
Introducing the next step in information storage on the Windows platform: WinFS, an active storage platform. Learn the basic operations that you can perform on a WinFS data store.

[Updated] Data Replication Prototype Using ADO
Rating: none
Aliaksei Sanko - 01/17/2006
Learn about a data replication prototype that uses ADO.

Using the SQL Server 2005 Integration Services Class Library
Rating:
Jeffrey Juday - 12/02/2005
Learn how to extend SQL Server 2005 Integration Services (SSIS), the new ETL tool that ships with SQL Server 2005, to perform operations that aren't already bundled with the product.

Top 10 Must-Have Features in O/R Mapping Tools
Rating:
Iqbal2004 - 11/10/2005
Learn about 10 things your O/R mapping tools must have to be more efficient.

Solving the Mysteries of SQLCLR and System.Transactions
Rating: none
Sahil Malik - 10/17/2005
When you write to an underlying table via a CLR database object, a number of questions come up. Get the answers—along with a breakdown of how System.Transactions, a new .NET namespace, can help.

Using DDL Triggers to Manage SQL Server 2005
Rating: none
Jeffrey Juday - 09/28/2005
Get an introduction to the extended SQL Server 2005 trigger functionality that Data Definition Language (DDL) triggers provide for both databases and servers.

Accessing Your Database with C++ Is as Easy as DTL
Rating:
Victor Volkman - 09/23/2005
Go one step beyond the Standard Template Library (STL) with the Database Template Library (DTL), which offers many advantages over the traditional procedural approach to database access.

Writing Database Objects in CLR: Advanced Scenarios
Rating: none
Sahil Malik - 09/21/2005
When you write code to be run inside SQL Server 2005, you usually want to deal with other database objects. Learn how to write a CLR-stored procedure that uses a simple table valued function to handle that scenario in a couple of ways.

Writing Database Objects in CLR
Rating:
Sahil Malik - 09/14/2005
You can use CRL to author a number of database objects. Follow a canonical example that explains the main steps involved in using and creating a CLR object inside SQL Server 2005.

The Fundamentals of the SQL Server 2005 XML Datatype
Rating:
Jeffrey Juday - 08/31/2005
SQL Server 2000 developers and DBAs who've been yearning for better XML support in SQL Server will be pleased with the new XML datatype in SQL Server 2005. If you're one of them, learn the fundamentals of the datatype so you can get going.

How to Use DAO in Visual C++ without MFC
Rating:
Yuriy Tkachenko - 08/30/2005
Use the #import directive and discover the DAO type library.

An Intro to CLR Integration in SQL Server 2005
Rating:
Sahil Malik - 08/19/2005
Learn all you need to know about the CLR integration available in SQL Server 2005. Get a high-level introduction, followed by a discussion of the implications of writing database objects in CLR code and a comparison with existing alternatives such as T-SQL or extended stored procedures.

next