With a number of clients, I have been provided a sample format for a transactions along with instructions to develop a process to load it into a database as quickly and painlessly as possible. This usually comes with the requirements that the XML data file can have any number of records from 1 to n. This example demonstrates the most efficent and scalable way that I have found to solve this. Not to mention that it can be maintained without rebuilding the solutions each time the data format changes.
The purpose of a Database Properties Health Check is to determine what your database’s properties are currently set to for each of your SQL Server instances and to determine if the settings are appropriate for your particular environment.
In this article we will see how easy it is to use NHibernate in a real world application. We will create, with minimal effort, a fully working sample that allows us to write to and subsequently, read data from a database.
This article describes how to retrieve information from an SQL table via an HTTP service built on the Microsoft .NET framework. After defining the service model via introspection, you will bind a service operation to a Flex component to use the data in the Flex application.
This article provides an architectural overview of SQL Azure Database, compares it with SQL Server and describes how you can use SQL Azure to augment your existing on-premises data infrastructure or as your complete database solution.
A SQL Server stored procedure, sometimes referred to as a stored proc or procedure, allows you to write one or more TSQL statements and store them within your database so that they can be called over and over again without having to write that code a again. This article shows you how to create a stored procedure for the Microsoft SQL Server database.