18 Apr 2012
Alexandros Pappas
This project implements caching of DataTables and provides functionality for testing performance.
Implementing and using an INCLUDE method in classic ADO.NET.
This is part 2 of a comparison on Data Access methods in the .NET environment.
9 Apr 2014
Jesús López Méndez
This article introduces you to EntityLite and explains how to use it
Generic Repository Framework (Generic Unit of Work)
This library is intended to "replace" ADO.NET by solving type mismatches and by creating typed readers that are faster and easier to use than DataTables.
This is the part 1 of a comparison on Data Access methods in the .NET environment.
When you override GetRowType, you also need to override NewRowFromBuilder().
19 Jan 2006
David Veeneman
In this second part of the article series, we will revisit the ADO.NET CRUD operations. Only this time, we will use an application with far better architecture. Once that is done, we will move on to data binding with objects.
Sometimes it is nice to prototype up a simple database application. This code may help, by providing the automatic transactional model of COM+ in a non-COM+ environment. This example uses "Interception" to provide automatic transactioning support for non-COM+ classes.
General purpose class to fill some or all of the DataTables of strongly typed DataSet from DataBase and to save some or all of the DataTables to DataBase by creating TableAdapters using reflection.
27 Mar 2009
Morshed Anwar
Implementing Audit Trail using Entity Framework's caching entries
27 Feb 2005
Declan Brennan
Allow your DataGrid to edit pictures and a whole range of other data types.
11 Oct 2012
Morshed Anwar
Undo Redo with DbContext of Entity Framework
5 Feb 2014
Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including design-time binding support.
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL Server Stored Procedure parameters from ADO.NET.
Generate DataReaders at run-time and get the best performance by avoiding repetitive code and by using the database's most appropriate Get methods.
12 Aug 2009
Perry Marchant
An article describing the best practices for Entity Framework performance
20 Jan 2006
Steve Michelotti
An article on nullable data readers for .NET 2.0 nullable types.
An application that creates a C# class to read/write data to/from an Access, SQLite, or XML database.
This article explains how to read a DataTable and return an inverted or pivot table depending on the column names provided.
8 Jan 2011
dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
With ADO.NET, a database can be regarded as a virtual XML document. XPath query and XSLT transformation are naturally available.
12 Jan 2007
Mark J. Miller
Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.
26 Feb 2012
Samuel Gonzalo
A code first real life data model case
This article is about the Light Object-Relational Mapping library.
17 Dec 2006
Marc Clifton, J. Dunlap
A row cursor implementation suitable for synchronizing and navigating a DataView against with object-mapped instance.
I've been recently working on a smart client (WinForms) application backed by Entitiy Framework 4 (EF4) on Visual Studio 2010. In this blog post I will try to give you some tips regarding some limitations and points to be careful about EF4.
26 Jan 2006
Peter Huber SG
Saving a changed row in the DataGridView automatically to the database seems to be a basic task, but is challenging to implement. Read here why the most intuitive approaches fail and how to get it working.
DefiningQueries are a very useful elements that you can use in Entity Framework in order to create views from the model against your database. The article will explain the DefiningQuery element.
6 Apr 2012
Rahul Rajat Singh
A beginner's tutorial for understanding ADO.NET using a simple application.
23 Aug 2003
Chris Maunder
Accessing database information using the DataReader class from ADO.NET in C#
Basic CRUD methods with some other interesting features
This article tries to fit all levels of readers by covering both basic database concept and the practical tips for Entity Framework’s handling.
10 Aug 2003
Majid Shahabfar
Mixing managed and unmanaged code and using .NET library in MFC projects
12 Sep 2005
Huseyin Altindag
ADO.NET for beginners.
A component providing Copy functionality to a Windows Forms DataGrid. Copied data can then be pasted in Excel or a text editor.
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
An article about Custom Businessobjects in conjunction with the DataSet to Retrieve Data
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
16 Oct 2011
Perry Marchant
An article describing the best practices for Entity Framework performance.
Looking at the EF and database association patterns.
23 Aug 2007
PIEBALDconsult
A simple base class that encapsulates basic database access functionality
31 Jul 2011
Alaric Dailey
Building an O/R Mapper: step 3.
The article explains what Table Per Hierarchy Inheritance is and how to apply it in Entity Framework.
Sending a DataTable to a Stored Procedure using Table Valued Parameters.
Explains how to fill a dataset with the information stored in a delimited text file
5 Jan 2013
Rahul Rajat Singh
This article is a beginner's tutorial for understanding what are transactions and how can transactions be implemented using .Net framework and ADO.NET for any ASP.NET web application or any other database driven application.
16 Mar 2003
Mauricio Ritter
This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.
Extend generated Strong Typed Datasets, add your own business-specific functionality to a real DataSet object. Binding to forms and updating to a database is all done by the .NET framework. This is built on Shawn Wildermuth's a.k.a. ADO Guy's DataSetGenerator.
18 Sep 2008
Vishal Shukla
This article shows how easily we can create occasionally connected WinForms application using ADO.NET Sync services.
10 Feb 2006
David Veeneman
In this article, we will see how to use ADO.NET to serialize an object model. Once we have finished with serialization, we will look at how to bind our object model to user controls.
19 Jan 2006
David Veeneman
This article will show how to accomplish these goals—use ADO.NET as a thin data transport layer, while still taking advantage of the data-binding capabilities of .NET user interface controls. As it turns out, it’s pretty easy.
A description of how how to convert a .NET DataSet to an ADODB Recordset.
This article shows how to use CLR integration to compress data in SQL Server 2005
This article presents an example on how to control the transaction isolation level in ADO.NET Entity Framework.
17 Dec 2006
Marc Clifton, J. Dunlap
Generate an object mapping class from a schema definition.
The article shows how to use SQL features of Microsoft LogParser with ADO.NET
5 Jan 2009
Petrovik Aleksandar
How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command
9 Feb 2006
PIEBALDconsult
Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter.
19 Oct 2011
DavidSherwood
Added property change notification and validation code to Microsoft’s VB.NET text transform files that create the POCO classes and DBConext class.
An enhanced DataSet Visualizer for Visual Studio 2005.
In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5.
25 Jan 2007
Kadir Camoglu.
An article about copying data to SQL within your application.
The article explains how to define custom functions in Entity Framework
Select data from SQL databases into Excel spreadsheet, with headings and formatting
Write database independent ADO.NET applications
2 Apr 2014
PIEBALDconsult
Using the ADO.NET Interfaces to build a small framework to simplify Database Access
26 May 2009
Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
This is the part 3 of a comparison on Data Access methods in the .NET environment.
SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, Transferring Data Using SqlBulkCopy - SqlBulkCopy - Copy Table Data Between SQL Servers at High Speeds, perform bulk copies with .NET 2.0's SqlBulkCopy class, SqlBulkCopy tutorial
28 Jun 2010
Vincent-Philippe Lauzon
Overview of the OData protocol: what it is, how it works, and where it makes sense to use it.
11 Sep 2006
Anthony Queen
This article will attempt to explain and demonstrate how Microsoft has simplified the approach to writing provider-independent code. Switching between Oracle, SQL Server, or any OLEDB or ODBC data source is now as easy as changing a configuration setting.
SQL bulk copy with strongly typed data including validation.
This article will explain the class library I created and how you can use it in your code. The aim of this class library is to simplify coding of data access and/or manipulation by encapsulating the core components of ADO.NET.
31 Jul 2002
Bill Ferreira
A primer on using ADO.NET with Managed extensions for Visual C++ .NET
An example of using an XML document to generate a typed DataSet and load it.
Using .NET 2.0 DeflateStream and GZipStream to compress persisted DataSets.
30 Oct 2009
sarvesh.upadhyay
ADO.NET Entity Framework as Data Access Layer
22 Mar 2011
David Thielen
If you are having trouble connecting to a database using a program that uses an ADO.NET connector, this program is a great way to test it step by step.
Simple sample with entity framework in 3 layers with ASP.NET
31 May 2001
John McTainsh
An easy introduction to accessing databases using the ADO classes. It includes how to read and write integers, strings and dates.
Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used.
Implementing Audit Trail using Entity Framework's caching entries
This is a dialog window that allows filtering a DataGridView. It can build filters with any depth of parentheses.
WQL DataProvider for ADO.NET
An API to simplify access to databases through ADO.NET.
A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.
1 May 2009
Antonello Genuario
A class library that helps to create WHERE clauses in a SQL statement or a filter expression for a System.Data.DataRow select operation.
18 Jul 2009
Benzi K. Ahamed
Presents a simple utility framework that helps in converting DataSets to generic Lists.
A simple data access component for connecting with different types of data sources.
17 Oct 2009
Mark Ericksen
Don't Repeat Yourself (DRY) when working with your database. Simple and easy code that makes it harder to make common mistakes.
An article to explain the use of SqlBulkCopy class in ASP.NET
Purely object oriented ADO code component to get your project running, no matter what database you are using at the backend. Specialised for SQL Server.
4 May 2001
Naveen K Kohli
How to use the event handlers for various ADO.NET connection & data objects.
Remove those strings from your .NET 4.0 applications using the dynamic feature.
14 Nov 2005
Karthik Krishnaswami
This article describes how to add custom validation to a data column in ADO.NET.
Function to check if a table or field exists in an MS Access or SQL Server database.
20 Mar 2012
Shivprasad koirala
Ado Dot Net Interview Question Part 1
13 Mar 2008
Brice Schagane
An article on using Transactions with Strongly Typed Datasets and multiple Table Adpaters while taking advantage of Partial Classes.
5 Nov 2008
Sandeep Aparajit
This article tells you how to save data from a DataSet into T-SQL tables.
1 Mar 2007
Henri G Demers
Generating a delegate at runtime that reads from a DataReader. By reflection, it’s possible to bind directly a simple query to a list of objects.
Classes to build insert and update statements for Microsoft SQL, OleDb and ODBC dataprovider
Allows you to perform a Distinct query against a DataTable.
Utility to manage multiple DB connection strings for an application.
Protecting ADO.NET applications
5 Jan 2007
lost in transition
This article demonstrates how perform a bulk 'Insert' with MS Access.
24 Nov 2007
Murali Krishna .Y
This article summarises the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0.
9 Jun 2009
Balamurali Balaji
This article explores the usage of InfoMessage event of SqlConnection object
This article explains how to generate DLinq entities mapped on SQL Server database objects, using an Add-In application on VS.NET.
15 Mar 2007
Aravind Rajagopal K
Schema.ini override and bulk upload using SQLXML
16 Dec 2004
Arul Nayagam C A
This article demonstrates the DataGrid , ADO.NET components, and storing data into the database and retrieving from the same.
26 Sep 2005
balazs_hideghety
Working with disconnected DataSets that contain autoincrement count.
12 Feb 2010
S Satheesh Kumar
Transpose DataTable rows into columns and vice versa using C#.
A solution managing InterBase DB's with C# .NET
4 Jul 2011
Alexander Galkin
Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.
This article demonstrates the first version of a DataTable Generator. This generator uses information found in custom attributes on any class and transforms the class, or several instances of it, to a System.Data.DataTable.
29 Sep 2008
Sunny Ahuwanya
This tool helps developers generate their ADO.NET stored procedure wrapper methods and any related strongly-typed data object class.
This article includes a few tips which can be considered while working with ADO.NET.
12 Sep 2013
Shivprasad koirala
ADO.NET interview questions: Part 2.
Cutting your code time in half using a smart SQL frontend.
Architectural overview of the MacroScope portable SQL ADO.NET provider
This article exemplifies how to use the Data Relation of ADO.NET with Data Table to create the in memory Data Relation between two tables.
An article on using ADO.NET programmatically.
How to Create an Application to Access Data
How to understand data access in .NET.
Put language-dependent column captions in the DataSet itself and use it in your code wherever you need it!
This article explains how to filter rows in a DataSet/DataTable. The example provided will help you get information faster.
A class that encapsulates SQL connection classes to make queries and stored procedures very easy to run in .NET. Contains methods like ExecuteStoredProcedure and ExcuteSelectStatement to return DataSets.
DataQuicker takes the transparent level, speeds up your application building and reduces the coupling between application and database. It supports convertion from table/view to DAL directly with accessional tools. It can nearly cut off all your efforts on DAL design and coding...
22 Feb 2011
Mostafa Kaisoun
This is a program for phone index to see how we can use the alphabetical English characters (A..Z) to search a customer name which begin with any character.
Explains how to send bulk records to a database using OPENXML.
The alxBase classes for work with dbf files.
13 Sep 2003
Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
An investigation into different data entry modalities and the need for a transaction sandbox.
19 Nov 2007
IVAN MARTINEZ HERNANDEZ
Mapping business objects and Store Procedures
IDataReader implementation illustrated with SqlBulkCopy class usage
Load Treeview From Database Table
29 Aug 2011
MerijnDeJonge
This document presents a new, graph-based, way for expressing and executing Microsoft ADO.Net Entity Framework queries. Using an extensive performance comparison, we show that Graph-based Querying (GBQ) easily outperforms traditional querying with LINQ in terms of expressiveness and performance.
How to create a Master Detail or Summary Detail report in SSRS 2008
In this video you will learn to deploy SSIS package in both SQL Server (MSDB) format and File System format
This article describes how to pass values from parent package to a child in SSIS.
13 Feb 2012
Chinthala Upender
Bouncy Castle provide encrypt/decrypt your personal data such as password, SSN, credit card numbers etc. using Simple JASYPT framework.
Outlines the construction of a simple data dictionary utility for MS-SQL using extended properties.
Implement Repository, UnitOfWork with Audit support in Composable Service End
18 Apr 2012
Duong Ba Hong Minh
In this article I want to give a solution to work with an Oracle database has a large number of Columns
This SSIS training video will explain data viewers.
This video explains conditional split transformation for SSIS.
3 Feb 2013
S. M. Ahasan Habib
Database script execution with unit test
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
An Integrated Development Environment (IDE) for the Relationship Oriented Programming Tool.
An easy to use .NET library to read/write strong typed data from files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Acces, SqlServer, MySql)
The sixth incarnation of a dynamic and self-adaptive ORM library, with full support for POCO objects, that doesn't require any mapping and configuration files, and providing support for natural SQL-like syntax from plain C#
1 Dec 1999
Shekar Narayanan
8 Apr 2014
Nick Sagriotis
You want to customize the database connection string at run-time? Here is how.
Combining de-normalization, transformation, replication, and awesome-ness.
This article describes a server and client side code including explanations of a generic database frontend web application.
Presents a SQL Server Extended Stored Procedure wrapper around the author's C++ implementation, and discusses use of Double Metaphone with relational databases in general.
27 Sep 2004
Scott McMaster
This article demonstrates the best technique for databinding the ListBox and ComboBox controls in .NET Windows Forms
A C++ wrapper around the SQLite embedded database library.
Start your project from Visual Studio and say GoodBye to SQL Server and Tables
A deep dive tutorial on Kerosene ORM Entity Maps, extending its capabilities to provide a no-compromises Entity Framework for POCO entities
Kerosene ORM support for complete database-alike WCF services and connections
31 Oct 2007
David Veeneman
A simple, straightforward tutorial that will get you up to speed on the fundamentals of NHibernate as quickly as possible
11 Dec 2013
Shivprasad koirala
Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.
View and edit your XML database schema and data
Smallest full text search engine (lucene replacement) built from scratch using inverted WAH bitmap index, highly compact storage, operating in database and document modes
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
8 Jun 2011
Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
21 Mar 2010
Md. Marufuzzaman
Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.
23 Jan 2005
Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
16 Feb 2011
Sadeque Sharif
Easiest way to delete more than one duplicate row from a table in SQL Server
Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes.
This article would describe how to read column values based on column names, using SQLDataReader.
8 Nov 2013
DaveDbViewSharp
Using lightweight server and database components, the article builds a REST server that returns serialised JSON objects to a single-page web application written in JQuery or AngularJS.
4 Feb 2010
Martin Aathanya
Microsoft Enterprise Library Data Access Block [DAAB] on Oracle Provider [ODP.NET]
ORDER BY what-the-user-said
Automated generation of PostgreSQL data transfer classes.
17 Feb 2014
Jörgen Andersson
A propertymapping extension for DataReaders
14 Nov 2004
Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
21 Jul 2002
Ed Gadziemski
How to create a basic WTL database application using an ATL wizard-generated OLE DB consumer and WTL's version of Dynamic Data Exchange (DDX)
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
20 Dec 2005
Rakotomalala Andriniaina
This article provides two files that contain a Membership Provider and a Role Provider for ASP.NET v2.0.
A deep dive tutorial on Kerosene ORM Dynamic Records and core concepts of the library
An article on implementing complex data binding (DataSource and DataMember) on a custom control.
An article and source code regarding the implmentation of B-Trees in C++.
17 Jan 2011
KarthikAnbarasan
This article explains the new Data Comparison tool in Visual Studio 2010.
23 Jan 2014
Christian Graus
The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
23 Jul 2007
Emmanuel Nuyttens
An article on building an agile multi-tiered business framework
23 Aug 2005
Patrice Borne
This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.
Access Stored Procedures using Code First.
Describes SQL server 2005 Integration Service object model and different data flow components
16 Aug 2012
Abdul Quader Mamun
Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.
An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column
10 Jan 2005
Kim Sheffield
The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
An article which describes how to use the data-access tier, generated by the free, open source data-access tier generator for .NET: LLBLGen. The sourcecode for LLBLGen v1.2 in C# is included, plus the generated data-access tier used in this article (C# and T-SQL) and the creation script for the data
This article introduces import and export functions between a flat CSV file and a SQL server.
Persistance to business objects through attributes and reflection
The code compacts and repairs an MS Access database from C# code using a JRO.JetEngine COM-object. Binding occurs at runtime, no references, no interops. Pure System.Reflection.
11 Jul 2006
Chris Tillotson
Convert UTC to local time
An article on how to view a database structure using C#
27 Aug 2003
Philip Patrick
Web-based administration toolkit for MS Access databases
Intercepting .NET SQL queries at runtime - SQL Management Studio case.
29 Nov 2010
Stephen Boissiere
Part 2 of 3 in a series of articles about generating SQL from an XML file format. This part describes the development of a code model for the new file format.
10 Jun 2013
Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
6 Jun 2007
Mark J. Miller
Provide array functionality in SQL Server using T-SQL or the CLR
How to manage database connection strings and connection string encryption for a web farm, in ASP.NET 2.0.
6 Oct 2013
sankarsan parida
This project discusses the concepts of connection, insert, update, delete in MVC with mongodb
A Class to Read and Write to Excel and Text Delimited Spreadsheet
28 Sep 2003
Gareth Edwards
This article describes how to pass the equivalent of an array, into a stored procedure, showing a number of different data types. This technique doesn't have the size limitations that a number of other techniques suffer from.
A simple technique for selecting random records from a table.
9 May 2001
George Poulose
A tool to generate class files to implement stored procedures
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
Data Access Component - thin wrapper of ADO.NET eliminating the need for the transactional support provided by COM+, supplying a uniform interface to different data sources thus allowing for easy switching to another data source eventually
Describes an extension to DDX that can read and write blobs using OLE DB providers. Includes sample WTL OLE DB database projects for SQL Server "Pubs" and MS Access "Northwind"
22 Mar 2006
Michael Vanhoutte
This article explains how to give a user the minimum rights required for SqlDependency to work
16 May 2012
Smitha_Prabith
How can we configure our foreach loop container, even when the task inside it failed
Too much data is breaking the system, we need a fix!
In this article we will learn basics about DW, BI, SSIS and ETL Process
14 Jan 2007
AnOldGreenHorn
A C++ wrapper to SQLite database
22 Jun 2000
Konstantin Vasserman
How to display multiple pages of records in ASP
23 Oct 2003
Jonathan de Halleux
Yet another DAL generator with SQL generation, multi database support, C# code generation, etc...
A tool for querying all types of databases.
13 Jun 2005
Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Simple C# code to convert an ADO.NET (System.Data) DataTable to an ADODB Recordset.
28 Aug 2001
Bjornar Henden
A grid control for ASP written in JavaScript to display recordsets.
28 Apr 2010
Stephen Boissiere
Part 1 of 3 in a series of articles about generating SQL from an XML file format. This part describes the background to the project and talks about the development of the file format and an XSD schema.
A class for Printing and Viewing MS Access Reports
A solution to the problem of storing hierarchical data in a relational database.
18 Nov 1999
Robert Pittenger, MCPD-EAD
11 Jul 2011
Kumar, Ravikant INDIA Bangalore
ABCs of NHibernate, a small application to demonstrate save and load of objects to and from Database.
22 Sep 2004
Eugene Lepekhin
How to get all power of trees in SQL
Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface
Generic data access component for different datasources, sprocs/SQL, implicitly propagated transactions, explicitly managed transaction contexts etc.
Generate strongly typed datasets
9 May 2007
Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
28 Nov 2005
vivekthangaswamy
How to use a MySQL 4.1 database from an ASP.NET application and some ODBC basics.
This stored procedure will generate all the C# code for calling any Stored Procedure
10 Jun 2007
Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
Code which allows you to update any number of records with yes/no type values using checkboxes
28 May 2007
Liam Cavanagh
The purpose of this article is to help developers who are looking to access and store images on Windows Mobile applications using C# and UltraLite.
19 Jan 2012
Patrick Ribbing
How to update a database when the application starts.
Persistance to business objects through attributes and reflection
ODBC Manager class that retrieves System and User DSNs and driver list.
This article will explore some solutions for dynamic connection string and cursor handling using Enterprise Library 2.0 in an ASP.NET 2.0 applications with an Oracle database.
A comparison of performance between ADO.NET and Entity Framework.
This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class
Run-time data accessor generation
An introduction to object persistence with db4o, an object-oriented database management system. Topics include storing, updating, deleting, and querying objects. All three db4o's query APIs will be explored.
5 May 2004
Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
13 Jan 2000
Alexander Mikula
A discussion and demonstration of reading Excel files using ODBC
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
30 Aug 2006
Ashley van Gerven
A simple ASP.NET application to run queries against your databases. Stores history and favourites.
Manage SQL Server Database within Visual Studio Team System
SQL Server ISS can simplify database mirrors across multiple vendors
31 Aug 2011
Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
This article shows how to construct a custom business object helper that will populate business objects from a datareader using generics, reflection, and custom attributes
3 May 2005
Emmanuel Kartmann
This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.
An article on replication in MS SQL Server
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
29 Nov 2005
Mukund Pujari
This article shows how to distribute or install MSDE with a .NET application.
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
18 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
18 Apr 2007
balazs_hideghety
Supporting LocalTransactions only with TransactionScope by avoiding escalation to MSDTC.
Using ADOX to insert field into a MS Access table.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
InkCollector Signiture as a String Made Easy
Persistance to business objects through attributes and reflection
Use different database providers without tying implementation to one.
A framework for writing sample data generators and a GUI that allows these generators to be effectively used
Logging of data changes in relational databases
An easy graphical way to create complex nested SQL Join queries.
22 Oct 2009
Antonello Provenzano
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
16 Nov 2006
Galin Iliev [Galcho]
How to build a business object with the option to discard changes
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
This article explains how to connect to Microsoft Excel 2007 using a connection string and populate DataGridView
13 Jan 2000
Alexander Mikula
Writing to Excel spreadsheets using only ODBC
27 Apr 2000
Chris Maunder
A simple introduction to using Access .mdb databases in your ASP pages
22 Jun 2007
Serioja Sidorov
The focus is on how one can test the content of a database to see if it adheres to certain assumptions
A distributed database management system, having a main server-LookupServer, several DatabaseServers and Clients, using java.nio for communicating.
Geocoding with SQL-Server
How to connect to database using AngularJS
A guide for beginners - SQL Server configuration manager
25 Jul 2007
Michael Ceranski
This generic function will allow you to copy data between any two ADO.NET providers with one simple method call
A set of classes to encapsulate DB2 CLI APIs in ADO style.
This article is mainly focused on reading text files efficiently. It includes log, csv, tab delimited, fixed length files, etc. Instead of using StreamReader(.NET)/FileSystemObject (VB 6.0), we consider the file as a database table and read the data by querying it.
1 Sep 2006
Galin Iliev [Galcho]
Creating many-to-many relationships in LINQ for SQL.
This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.
10 Apr 2007
Sean Chambers
This article walks through setting up a SqlCE test bench when using TDD
25 Aug 2005
Mukund Pujari
This article shows how to import CSV data and store it in database.
Getting the correct column ordinals of an ADOX Table object.
Extends DataGrid Functionalities
Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.
6 Jul 2005
Hayder Marzouk
A strongly typed collection that implements CollectionBase and IBindingList interfaces with interesting features (sort, filter, getchanges).
Design for data integrity, simplified SQL, and programming ease.
10 Apr 2007
Peter Weissbrod
An introductory approach to synchronizing database schema versions
29 May 2007
Tetyana Loskutova
This article shows an example implementation of a database used over a Web-Service
Client side data provider for data importing to a relational data service build for StackExchange data dump.
I invite anyone who doesn't know about Microsoft Access MDB files safety (specially compact and repair) to read this, before it's too late!
14 Feb 2004
Reza_Allamehzadeh
How to pass an array of integers to a stored procedure.
2 Aug 2009
Pham Dinh Truong
Circular reference can make your data inconsistent and potentially hazardous even if you have been following up on normal forms and constraints strictly
A short article on recovering orphaned users when moving a database from one server to another.
The purpose of this tutorial is to provide an introduction of SSIS items.
3 Feb 2006
Rafael Mizrahi, Laurence Moroney
When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.
A class for automatically generating SQL INSERT for Typed Datasets.
How to Display/Store and Retrieve Image Data from Database to Gridview, and also on mouse over
18 Nov 1999
Robert Pittenger, MCPD-EAD
This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
24 Jan 2006
Olivier Giulieri
Just 200 lines of VB.NET to document your SQL Server databases.
6 Feb 2014
Mr. Xie.G.Gang 谢桂纲
Using LINQ script to query the Object-Oriented Biological database
The article describes how to move a database onto Bamboo Prevalence
25 Oct 2004
Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.
15 Apr 2004
Muffadal Jaorawala
This article shows how to save a master-details form using XML.
Convert delimited text files to XML file or DataSet object
An introduction to SQL Server transactions and how to use them in ADO.NET.
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
24 Jun 2003
Daniel Aioanei, Adi Malinaru
Persisting general trees in relational databases with fast path-finding capabilities.
This article describes the usage of SQL DMO to automate few aspects of DB maintenance.
SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.
13 Mar 2007
Patrickquinn1212
Automation of command parameter building targeting Microsoft Access
28 Nov 2011
Bangla Gopal Surya Prakash
Basics of SSRS (Microsoft SQL Server Reporting Services)
12 Dec 2012
Venkata Turlapati
Automated process of downloading a XML file and inserting the contents into a database.
15 Jan 2007
Aaron VanWieren
How to copy data from a modified dataset into a SQL Server Database
View and update any database table and metadata. Includes sample databases.
This article explains about building and executing a Dynamic SQL in a stored procedure.
Describes how to add custom script to install project
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
22 May 2012
Gautam Sharma
Code that will show you the active connections to a database.
A tutorial on connecting to SQL 2000 Server.
9 Dec 1999
Vachik Hovhannisyan
Two classes that provide support for asynchronous SQL execution.
A simple example using MySQL 5 and stored procedures with ObjectDataSources and Generics, in ASP.NET 2.0.
15 Apr 2007
wallace turner
An effective utility to securely backup an SQL Server database and/or a group of files to a remote machine
5 Dec 2006
Michael Milonov
Using ADO.NET conrurrent model in Oracle databases.
This application can be used to create databases, tables, stored procedures during the installation of .NET applications.
Discussion of concurrency using the IOC and DI Design Patterns with the PostgreSQL database.
21 Jun 2007
Fuad Bin Omar
An article on exporting large data to Excel files
OpenClient++ is a thread safe, cross platform C++ wrapper for Sybase Open Client API.
19 Mar 2007
Dimitar Madjarov
An article which describes an alternative way of cooperation between Oracle PL/SQL and C#
19 Nov 2004
Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
This article shows how to create a .pdb file to use as database on Palm devices.
23 Mar 2006
AnOldGreenHorn
An embedded database library in C++.
14 Dec 2013
C Grant Anderson
SQL CLR function to find the nth instance of a string within a string
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
An easy to use framework with multi-tier, user types, and LINQ support.
9 Dec 2005
Todd Denlinger
Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.
22 Mar 2004
M L Viñas Livschitz
HyperNetDatabase is a single process multithreading and blackout safe database
Managing portability of your source code among different RDBMS, reducing developing time and maintenance.
16 Oct 2001
Ciprian Miclaus
An article on how to improve SQL hierarchies
Useful tool to script database objects using SMO and check in Visual Source Safe
Collection of information on optional paramters in Stored Procedures, as well as passing null values into the Fill method of a stongly typed data adapter.
Integer and string indexing of System.Data.DataRow columns - head to head
An ADO.NET toolbox that is meant to serve as the lowest level database IO layer for an application based on an Access, Microsoft SQL Server, or Oracle database.
17 May 2005
Huseyin Altindag
Personal address book using ADO.NET and C#.
Article describing how to build pluggable data access components.
11 Jan 2006
Mukund Pujari
This application can be used to create database, tables, and stored procedures during the installation of a .NET application.
Modification of the Osql Batch Scripter
2 Dec 2011
Bangla Gopal Surya Prakash
How to add chart control to reports defined in SSRS
This video shows the essence of parallel processing in SSIS.
This is a very simple and brief video on variables, expression and casting of them in SSIS. It will also teach developers to pass result sets in SQL task.
This video introduces Package Configurations to the SSIS developers, you will learn: XML Configuration a.) Direct b.) Indirect (Using Environment Variables), Environment Variables, and SQL Server Configuration
20 Aug 2012
Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
24 Apr 2013
Gouri Sancroj
An article that lists the steps to import MDF files to Microsoft Access
1 Mar 2007
Zakaria Bin Abdur Rouf
A Simple Multi User Contact Management System that will help programmers to use some tricks
This project presents an Access Database Editor written in C#
1 Nov 2006
matrix_resident
Modification to the nettiers code generator template to make the generated stored procedure for search more powerful(supports the like operator of Transact-sql) and searching the datetime/smalldatetime datatyped columns more smartly
Presenting a lightweight method to cut out most of the repetitive work of creating data classes.
This article explores the client-server and transaction features of db4o.
25 Jun 2012
Andre Pieterse
This article demonstrates how to implement a parse function within a C# WPF application.
A simple example which connects to an Oracle database to retrieve data with a DataSet, and then show a web report using CrystalReportViewer
A simple Data Link Property Dialog that can create connection strings used in ByteFX.MySqlClient provider.
26 May 2004
Rodney S. Foley
Shows a way to access one or more databases in a "Connected" way by demonstrating the use of SqlReader, SqlTransaction, and SqlCommand. Provides a re-useable algorithm for dynamically accessing one or more databases to move or manipulate data.
Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities
11 Jan 2008
David Catriel
An extremely fast and efficient way to import a table from any ODBC-capable database into MS Access (while running in a C# project), by using the Microsoft Access built-in import functionality.
3 Mar 2007
Erwin@Attentia
Getting limited recordsets from various databases.
Dynamically export data to Flat File using SSIS
15 Feb 2004
Ahmed Alhosaini
Generate database schema information from C# classes.
18 Mar 2003
Bjornar Henden
Online administration of your database. Create or modify tables, keys, and indexes. Edit or insert data.
16 Jan 2008
Robert Pittenger, MCPD-EAD
This article presents a naming scheme for database tables and fields.
Displaying vertical rows in a datagrid by flipping the tables horizontally
13 Nov 2001
Anthony Roach
This is the second in a series of articles about using the OLE DB Consumers.
24 Aug 2005
Maxim Alekseykin
Explains how to load a BLOB data into a DB table and how to get it from the DB table.
20 Mar 2007
Jeremy T. Fuller
A simple method that compacts and repairs a Microsoft Access database file using the Microsoft Jet library and C# COM interop. The example code is meant to be integrated into an ASP.NET web site.
28 May 2003
Tingz Abraham
Searching a Lotus Notes Database and locating notes in the database using Lotus C APIs and MFC.
This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.
16 Nov 2006
Neil Barnwell
An article describing a simple way to provide transaction support to an application designed using the DataSet wizard, and avoiding the DTC requirement with using TransactionScope and SQL Server 2000.
17 Sep 2004
Duncan Edwards Jones
An extensible tool to package and deploy database schema objects.
Sample code describing how to retreive statistical information about the T-SQL commands executed.
10 Mar 2004
Jochen Jonckheere
A view of how ADO.NET can be used in a multi-database, multi-tier environment.
A library to convert a JET database to SQL 'CREATE TABLE' statements
An article on Microsoft SQLXML
Accessing DataLinks from a .NET program to get or edit a connection string.
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
Allows you to perform a Distinct query against a Datatable
Demonstrates how to Add/Delete/Edit/Update image, and save to SQL database table, and also how to create a menu like an Outlook with faded in slide show
Describes how to use the SSIS object model for importing data to SQL server 2005
How to truncate log file in SQL Server 2005
An article on Cubes, MDX, Analysis Services and ADOMD in .NET
8 May 2007
Mark Pryce-Maher
An article on adding a MySql connector into Enterprise Library for .NET Framework 2.0
3 Dec 1999
Martin-Pierre Frenette
An alternative to Microsoft's typesafe DataSet
13 Nov 2009
P. Ganesh Kumar
An alternative technique to store multiple bit (boolean) fields using a single value in database tables.
22 Nov 2002
Gevik Babakhani
This demo shows how to populate a treeview from a self-joined table
26 Apr 2003
Sriram Chitturi
This article gives a simple architecture of using StreamReaders and DataSets together to read data from arbitrarily formatted flat files into DataSets, using ini files as an example
An article on communicating with a database and generating SQL queries on the fly
A simple class to dynamically add DSN-names to your system.
2 Feb 2004
Mihail Stefanov
Binding a two dimensional array to a DataGrid
10 Mar 2007
Udhaya Kumar.D
A GUI for SQLite in .NET
24 May 2006
arie_schwartzman
Manage small database tables with lightweight and simple C# code. Best suited for PocketPC and Windows Mobile devices
A service that scans for DBX files and adds their contents to a main Access database
1 Jul 2004
Nikolai Serdiuk
This article describes creating indexed search systems using relational databases
27 Jul 2007
Paul Reynolds
This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions.
An article for converting DBF files to dataset XML files
10 Feb 2009
le quang anh - leadershipqa
This is a sample that guides you to create reports with Crystal Reports using C# and MySQL RDBMS.
31 May 2006
Thomas Haller
A quick start tutorial on how to manage your Microsoft SQL Server 2000/2005 with C# and the Microsoft's SQL Server Management Objects (SMO)
This stored procedure grants execute privilege on all procedures to specified user
This load the "ECB" xml file and parse it into a dataset. From that we can calculated the Exchange rate between difference countries.
GridView Image order page shopping cart page
3 Feb 2004
Stephan Johnson
This article covers the Vector Data Language, an XML-based language to manipulate XML data from ODBC sources.
23 Sep 2004
Miloslav Beno
Simply implement events and CacheDependency with the database
10 Feb 2006
Chris Stefano
Generate loader classes for faster operation using Reflection.Emit
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
19 Oct 2004
Huseyin Altindag
Populate data from database in a ComboBox.
24 Mar 2004
Emmanuel Kartmann
This MySQL extension library provides an aggregate function that concatenate strings (for use with SELECT...GROUP BY clause).
This tool would help anyone to create insert\update query based on values in a table, without any data or with custom data
Solving the collation mix with SAP (SQL_Latin1_General_CP850_BIN vs. Latin1_General_CI_AS).
Passing multiple values as a single Parameter to a Stored Procedure
Calculates Annualized Sharpe Ratio and Sortino Ratio for a Portfolio Trading History in SQL
A HowTo on getting DataSource information from CSession object
4 May 2007
Mohammed Ghouse Barq
APPLY operator is a new feature in SQL Server 2005 used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments.
Article explaining how to access a web service using SQL Server integration with VS 2005 (SQLCLR)
Produces SQL filter clauses using C# objects
An article on building database with ADO.NET application for a beginner.
11 May 2005
Pankaj A. Chitriv
An article which gives an overview of SQL Server DB clustering using MSCS.
This code replaces the buggy ADOMD.NET DataAdapter and DataReader.
An article on how to pass parameters to Crystal reports from Windows Form at runtime
A beginners guide to displaying records from a database in a table using ASP
Manage SuspendBindings and ResumeBindings for all CurrencyManagers in your app.
This article demostrates how to access MS Access databases from Java.
18 Jul 2007
Padoor Shiras
Computed Column Specification for populating nth column
10 Mar 2007
Manjushree Das
The target audience of the article are novice 4D developers. It aims at explaining the usage of Triggers in 4D databases.
Inserting value of Collection into Database
In this article, the ability of Microsoft SQL Server database in storing and retrieving trees will be described.
Caching Data in Application or Session objects is a good idea. Caching Database connections in Application or Session objects however is not a good idea. This article explains why and how to best use your database connections.
This will create a set of classes that generate a set of C# class files which map into the database tables. They will have the class name same as the table name and they will have a set of properties that are same as the table attributes.
Dynamically set TextBox.MaxLength based on the SQL column size.
11 Jan 2007
Mustafa Magdy
A very powerful tool that generates SqlServer Stored Procedure Statments to build N-Tier applications
A foray into a specific problem while discovering at the same time the reasons for why OOP often fails us.
26 Apr 2002
Fernando Finelli
ASP can save binary data to a table in SQL Server
17 Apr 2004
Cláudio de Vasconcelos
Implement a simple class to store multiple queries and run against a MySQL database.
This article will educate you about the various important features that a good O/R mapping tool would provide you and how it can be beneficial to you.
24 Apr 2007
lost in transition
Extracts data from database, manipulates extracted data, and then updates the database
21 Sep 2004
Ahmed jamil Kattan
An article explaining how to link your home database in your C# application.
17 Jan 2002
Anthony Roach
Using the OleDbDataAdapter and OleDbCommands objects to consume OLE DB providers
18 Nov 2007
BSRK, AHILABALU
Generate an organization chart from employee database using ASP & Microsoft Excel
A solution to the problem of exporting data from database in different formats
29 Apr 2007
Dimitar Madjarov
An article which describes an alternative way of cooperation between Oracle PL/SQL and C#
A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".
Use SQL-DMO Object Library for quick searching and generating stored procedures script
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
Use this Windows application to generate complete Data Access Layer for your applications.
17 Oct 2007
Renan Rodrigues Duarte
This article tries to explain how we could use a TextFile as a simple DataBase.
1 Aug 2006
Ennis Ray Lynch, Jr.
Methods for accessing row based data in C# (.NET)
13 Aug 2006
Mohammad Ali Azam
An API to persist business entities without writing database centric code or mapping schema in an external XML File
10 Jun 2005
Paul S Ganney
A class to easily do count() queries.
17 Apr 2002
Shawn Wildermuth
A Class Library that holds a Managed Provider to retreive Load DataSets from Xml sources.
This article describes how to administer remote database via XMLHTTP and ADOX. It is useful to webmasters who use virtual hosting. Source code is downloadable.
15 Nov 2006
AnOldGreenHorn
A template class for creating sequential access record files
An article on introducing how to use SQLDMO
Changing ConnectionString like an attribute in C#
21 Feb 2012
databaseobjectmodel
A Sample ORM project
4 Oct 2007
Maruf Maniruzzaman
Start using DLinq in easy steps
14 Sep 2004
Pawel Zarzycki
Simple class that helps accessing and managing SQL Connection Strings.
22 May 2007
ehanthalingam
This article will help you to add an image into a blob field of oracle database, This will also help in retrieving the image from the blob field using C#.Net
8 May 2006
RB Changanacherry
This is an Oracle Data Layer class for connecting to Oracle Database from a .net application based on Oracle Data Provider.NET
BoneBoxes is a data access library that provides you with SQL statements and data validation based on the data set's properties
16 Jun 2005
Thomas Lykke Petersen
Enable persistance and population of objects without writing ADO.NET code.
12 Oct 2006
DEEPCHAND KOSTA
Create a Dynamic Pie Graph with Export in the Excel file Without Creating an Excel Object
An article on how to write SQL that runs against all(?) data bases
Configure MS SQL Server 2005 Remote Access ( mixed mode )
30 Jun 2005
Nishith Pathak
Enhancements done for storing connection strings in Visual Studio 2005.
27 Oct 2003
stephanpeters4000
Data access components to interact with any database.
Database factory using C# Generics.
A generalised method for calling parameterized stored procedures
23 May 2007
Szymon Pobiega
An article on wrapping stored procedure invocations in strongly typed intefaces
1 Jan 2007
Akshay Srinivasan2
This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table.
A sample program to demonstrate how to save or store images in SQL server
6 Dec 2006
lost in transition
This article illustrates a helpful database library.
An article on an efficient method to determine missing values in an IDENTITY() sequence.
25 Jan 2003
Samar Aarkotti
Connecting to Database using C# and ADO.NET
1 Aug 2005
Syed Asif Iqbal
Article that helps writing SQL in XML to provide better support
This article describes on building a Database from scratch using Batch File from the existing Database
Using and extending the data access classes, and runtime selection and instantiation using a factory and XML configuration file.
How to develop a database structure designer use C#
This component is used for forms that have too many textboxes which change their focus with Enter key.
This article gives an overview of Microsoft Application Block for Data Access, its advantages and specifies its usage in a .NET application.
A class to allow easy running of T-SQL code against .NET data sources.
26 Oct 2005
Himanshu Kumar Sinha
I will discuss the Try & catch error handling feature of the SQL SERVER 2005 (Yukon)
14 Mar 2005
prabhu.subbiah
To compress large SQL Server reports and allow the user to download the same in ZIP format.
This article is about using MFC CodeProject Grid, ATL and MS Access together.
1 Mar 2008
Prasad Bhalekar(PP)
Way to search record in relational tables to get search count on a search string
This article speaks about how to use SQLDataAdapter and its update method without using SQLCommandBuilder
How to make simple Database driven application with XML plain text. Portable, easy and light weight!
Browse for folder on computer with MS SQL Server from a remote computer.
This article describes how to write a relational database using C#.
Using SQL trigger to create unlimited unique id's
22 Aug 2007
Sarfraz Munna
Debugging a SQL Stored Procedure in SQL Server 2000 Query Analyzer
9 Aug 2002
Victor M. Valenzuela
MFC classes to fill ComoBoxes & ListBoxes with MySQL data.
This procedure can be called in another Stored procedure or function and quite handy in debugging and development
for database project developer
18 Jun 2004
Tamer Ahmed Farrag
this dll help users to convert between any object and byte array which will be very useful when using to insert objects into a DataBase
24 Jun 2006
Vivek Singh - IN
It will generate insert statement as per the tables selected by the user, and it also take cares of Identity inserts in the table.
Here is some cool stuff to call .NET assembly from SSIS
This article will drive you, how deploy and debug CLR store procedure
27 Aug 2005
Mark Williamson
DBInspector is a swiss army knife for database developers. DBInspector helps you generate all types of code based on your database schema.
An article to demonstrate the creating of business document ids without using stored counters.
Creating dynamic connection string on a remote site.
Object oriented applications usually have inheritance as an important part of their design, including in their domain objects. However, the corresponding data model has no built-in mechanism for specifying inheritance. Therefore, domain objects must be mapped to relational database intelligently.
Use the correct data access classes for the current version of the database
Remove comment in SQL to make it easy to execute with MS Access.
5 Apr 2006
Waleed Al Tamimi
A generic Data Access Component implementation written in C# that supports SQL, Oracle, OLEDB and ODBC data providers. Using the Factory design pattern for instantiating the data provider correct and specific objects determined at run time.
A means to deploy Visual Studio database projects, ordering SQL files using a List that yields in the order of dependency.
This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface.
11 Sep 2006
René Paw Christensen
How to solve the error when assigning a DateTime to a IDbDataParameter.
26 Feb 2004
Pradeep Fernandes
This article sorts to illustrate one of the ways by which data table changes can be detected through the use of available aggregate functions like BINARY_CHECKSUM and CHECKSUM_AGG.
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
18 Feb 2007
Danko Greiner
Use TableAdapters with transactions.
12 Jun 2006
Sandip Dalvi Tung
This code is very useful when you want to auto increment number using A-Z and 1-9 with possible combinationYou can pass any string and system will return next possible number e.g. You can Pass number "PRO01A9" then You will get "PRO01B1"
16 Dec 2004
Adam Klobukowski
Class that creates INSERT INTO SQL queries.
This article tries to show the pros and cons of using INT or GUID types on primary keys.
16 Nov 2006
KRISHNA PRASAD.N
Article to export MS DTS packages from one server to another.
This article will give you a brief introduction on various system stored procedures and how you can write your own queries instead of using the system procedures.
Connecting to SQL Express Manualy
A simple explanation on how to build pluggable data access components.
How to Call or Executive Store Procedure (Oracle ) in vc++
18 May 2006
Muhammad Kashif Akram
Facilitating efficient Sql Server paging by giving T-SQL query as input to this generic stored procedure
25 Apr 2007
Arek Suroboyo
This is a SQL Query Builder which is could be used for further purposes. This was developed under C#.NET. This application will allow us to design a query. It will check any relationship of the tables so there's a little possibility generating query from unrelated tables
9 Nov 2007
Pavan Gayakwad
An article on using DataTable as Generic Data Transfer Object (DTO) for varied data views
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
26 Apr 2002
Fernando Finelli
dump the transaction log
Add/drop Linked Servers using SQL Server 2005 SMO
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
An article on implementing a customized business transaction class based on LLBLGen Pro.
A usefull tool to control the database, easy to use and easy to control.
This article explains in short what Materialized Views are and how to create read-only Materialized Views in Oracle.
27 Oct 2005
Darko@Ilumnis
C# MS SQL user / role / right manipulation
An asembly that provides a way to retrieve, store, and manipulate data in a SQL Server or Access database.
This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML
This article will drive you, how to get list of SSIS packages and executing them using .NET assemblies
This article will drive you, how to create CLR store procedure
17 Jan 2005
Tadas Budvytis
Explains a mechanism of deleting a record when the selected record has related records in other tables.
14 Dec 2007
Islam ElDemery
A simple speed comparison.
15 Jul 2004
Romelard Fabrice (Alias F___)
A Stored Procedure for Create a Time Table with all interesting details
25 Aug 2004
Vivek Shaurya
Investigating the database created by SharePoint for use in your .NET application.
11 May 2006
LockonFlamingCliffs
Shows the basics of working with ADO.NET disconnected data.
30 Dec 2004
interface Mirror
The easier way of accessing data using intermidiate classes between basic ADO.NET classes and your own application.
How to access a dBase file
This article shows you how to take a date string and use it in a parameterized sql server query
21 Aug 2006
ganesan balachandar
The tool can generate the specified number of rows for any table. Can be used for stress testing the application
5 May 2003
Goncalo Oliveira
A set of C++ classes for working with the MySQL library.
How to write multiple filters on a WHERE clause on a sql sentence
Generate code classes to access stored procedures via web services.
A Key ShortCut for 'SELECT * FROM' for tables and to see text of the stored procedures.
19 Apr 2007
sarvesh.upadhyay
In this articleI am going to show how to create log file for stored Procedure
3 Nov 2005
Ezhilan Muniswaran
This database script provides a template for properly maintaining multiple versions of a database.
Learn how to export database fields to XML document
This user-defined function will allow you to capitalize the first character of any string passed to it.
This small utility generates code to call store procedure or C# class from Table
18 Aug 2005
satya.rapelly
Window application generates the document with Sql Server database tables
Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server
20 Jul 2006
Ennis Ray Lynch, Jr.
Just how many customers can you have in your database?
Perfect interface design for common database which would be used to easily connect to the most kinds of database, such as MS Access, MS SQL Server,..., and so on. Do not worry again about the terrible complex interface of ADO COM, take it easy to implementing your operation logical codes...
Codes to help to connect VS 2005 to SQL Express manualy
This class helps with connecting to DB engine and with returning of resultsets.
Create command for getting comma seperated value
A FireBird .NET data access block completely written in C#. Supports Embedded SQL, INI File SQL and Stored Procedure
Basic understanding of Pro*C
8 Sep 2005
Member 2260574
Connect and close a sql database with internal error reporting using Event Logs
The use of mj10777.DataBase to Connect, Create (Database/Table), Read and Fill Tables, Update, Insert and Delete Records and show results in a TreeView / ListView Application.
Format any Number to 2 decimal Number without Rounding
DatasetAdaptor encapsulates a dataset and permits automating the work between the database and the dataset.
SqlDbAdaptor hides underlying database and makes very easy to switch database without a single line of code change
An alternative approach to database modeling.
An easy way to call and manage Stored Procedures in .NET.
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
This video demonstrates a standard extract-transform-load in SSIS
27 Jul 2012
Kourosh K Tari
How to duplicate a record in MySQL table with auto increment key
9 Aug 2012
Alexandros Pappas
This article provides a program to measure the performance of the different transaction isolation levels. It also examines the effect of using the UPDLOCK hint in SQL.
Application of abstract approach to database domain
How to add a "select all" option to your parameter lists in SQL Reporting.
15 Dec 2008
Enrique Albert
A log4Net example: how to consolidate SQL scripts using log4Net.
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
30 Jul 2009
Gio Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
9 Jan 2010
Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
A Finale of Series discussing Computed Columns, Storage and Performance
22 Sep 2010
Hossein Ghahvei Araghi
This article is about DSL and SQL Server Modeling
Integrating database development into Visual Studio to collaborate application development team and the database designers
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
A Quick Guide to Find Potential Peformance Issue
15 Dec 2011
Mika Wendelius
Some simple scenarios to calculate running totals in SQL Server.
21 Feb 2012
Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
This video explores how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired.
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
23 Feb 2012
Santosh P Umarani
Columnstore Index
Database development with Server Data Tools
23 Apr 2012
Kuthuparakkal
SSIS and Excel Automation
23 May 2012
Manar Ezzadeen
Create CLR Stored Procedure with Visual Studio Express edition
Data Auditing Trigger Generator
29 Jul 2012
Anup Ghosh for C# & SQL SERVER
The steps to migrate on-premise database data to SQL Azure.
7 Sep 2012
Shivprasad koirala
This article will discuss about SQL Server governer.
This tip demonstrates how table data can be shared in two stored procedures.
27 Aug 2012
Satnam B Singh
Setting up Transactional Replications in SQL Server 2005.
Find multiple strings (delimenated by space) in all selected columns.
1 Oct 2012
DaveDbViewSharp
Develops an analogy between database table and file directory information and argues that it could be very useful if it were possible to have a similar application to Windows Explorer for database tables. Demonstrates how to obtain the information from Sql Server system tables and dynamic management
Dynamically restore full and all transaction log backup.
If you wanted to check the status of all your database backup then this script will do the task.
A custom solution to transform data from rows to columns using dynamic SQL.
How to execute SQL from a file for various purposes.
Implementation of relative database constraints and permissioning using triggers and shadow tables.
20 Feb 2013
Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
9 Apr 2013
Shining Dragon
How to effectivley version your SQL Server databases using SQL Server Data Tools
11 Apr 2013
Ivan Paniagua
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models and not just Tabular Models.
One of the things that drew me to SQL Server 2012 was the FileTable feature. It seemed to be a great fit for my need, and to relatively easy to implement. Here’s my scenario, the solution I chose, the “gotchas” I ran into, and how I dealt with them.
29 Sep 2013
Gyanendra Jaiswal
Dimension loading using SQL task gives better performance than SCD transformation.
10 Jun 2013
Aleksei Tuiman
Data extraction from XML fields with different namespaces
15 Jun 2013
Bhushan W. Juare
How to build you first analysis service cube
24 Jun 2013
Syed Asif Iqbal
A Practical approach for implementing Interactive query based systems using MSOLAP
Step by Step creation of SSIS package using C# with Conditional Split
A simple way to create an XML file from SQL Server tables using SSIS
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
22 Apr 2004
Armen Hakobyan
Using SQL-DMO to shrink SQL Server transaction logs.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Date and Time Data Types and Functions with Sample SQL Statements. Data Type Tables, Function Tables
11 Jun 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
29 Oct 2008
Gio Bejarasco
A walkthrough in UDT programming with primary focus on database concepts.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
26 Jan 2010
BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
11 Jan 2012
Huisheng Chen
monitor sql server processes and jobs, analyse performance, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach etc
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.
Step by Step creation of SSIS package using C#
13 Jul 2010
Md. Marufuzzaman
Overview of SQL server stored procedure
SQL-Server change tracking on a table without triggers.
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
23 Aug 2011
Kanasz Robert
In this second part of series of articles about database performance optimization I will discuss about index maintenance.
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
24 Mar 2009
Al-Farooque Shubho
Exploring Set based and Procedural approaches to write better SQL in SQL Server.
26 Mar 2007
Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
They might seem like just another not entirely required feature, but actually table variables are a very handy extension to SQL Server
In this article, I will show you how to backup and restore databases using Server Management Objects
23 Nov 2010
Kanasz Robert
In this second part of the tutorial, I will show you how to create objects not used for data storage (logins, users, roles ...) using SMO
15 Nov 2010
Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
In this article, I will show you how to create a basic DB schema comparison tool for SQL Server 2005 and SQL Server 2008.
26 Mar 2011
Mika Wendelius
SQL Server not having the aggregates you need? Why not build your own.
This article explains how to migrate data between different SQL Server environments.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
SQL Server's Logical Functions (IIF() and CHOOSE()), New functions in SQL Server, Examples for IIF and CHOOSE, Comparison
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
8 Jun 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using some advanced indexing techniques and using de-normalizations to optimize data access.
22 Apr 2010
Christopher Ayroso
Windows application that compares stored procedures between two SQL Server database
22 Jan 2012
Kanasz Robert
In this fourth part of the tutorial, I will show you how transfer objects and catch trace messages using SMO.
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
In Part 2, we saw how to pinpoint bottlenecks related to the database server hardware - memory, disks, and CPU. In this last Part 8, we'll look at fixing those hardware issues.
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
29 Dec 2006
Hari Prasad K
The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.
1 Jun 2009
Al-Farooque Shubho
As part of a series of articles on data access optimization steps in SQL Server, this article focuses on refactoring and applying TSQL best practices to improve performance.
An extended stored procedure for SQL Server that implements an optimized MD5 hash algorithm. Very small DLL (barely 7 KB).
14 Sep 2008
Muhammad Shujaat Siddiqi
Grouping Sets, a new feature in T-SQL in SQL Server 2008.
14 Mar 2013
Shivprasad koirala
In this article we will talk about the next 5 interesting SQL Server 2012 features.
Monitor SQL Server processes and jobs, view executing SQL query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach, object version control & compare
20 Aug 2011
Kanasz Robert
In this first part of series of articles about database performance optimization I will discuss about indexing strategies and index maintenance.
13 Nov 2010
Kanasz Robert
In this first part of the tutorial, I will show you how to create data storage objects (databases, tables, Views ...) using SMO.
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
9 Nov 2012
Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
Part 1 of an 8 part series on improving database performance.
10 Jun 2011
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
27 Oct 2007
Cedric Baelemans
Discussion of audit trail techniques and a script to automate audit trail implementation on a Microsoft SQL database
An article about unravelling a large database
21 Feb 2011
Christopher R Davis
Use model driven development to keep your API and database in sync.
27 Feb 2011
Kanasz Robert
In this article, I will show you how to use the scripting functions of SMOs.
2 Dec 2008
Mika Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
14 Mar 2013
Shivprasad koirala
In this article I will discuss 5 features of SQL Server 2012 and the rest will be followed in other parts..
8 Nov 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps, this article focuses on diagnosing performance problems in SQL Server.
6 Aug 2011
Mika Wendelius
This article shows few examples for using Table-Valued Functions.
28 Mar 2012
Thilina Chandima
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
28 Apr 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using indexing to optimize data access.
A detailed look at SQL CLR procedures and how to create one that does serious work.
21 Nov 2011
Rabb Moshe Plotkin
How to use the Dac Export Service from code
20 May 2012
Mika Wendelius
This article describes a mechanism how trigger actions bypassed based on database user information
Utility for comparing two SQLite database files for both structure and data
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005.
19 Dec 2011
David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
How to do a sort on alphanumeric strings in SQL Server.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
17 Jan 2005
Sumit Amar .
1 alternative
Stored procedure to generate INSERT..VALUES statements in SQL Server.
15 Apr 2012
Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a T-Sql perspective
10 May 2011
Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
9 Aug 2012
Mika Wendelius
Article describes basic information about transaction log behavior and truncation of the log.
In part 1, you saw how to identify missing indexes. In part 3, you'll see how to add those indexes.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
T-SQL script to generate the document of SQL 2000/2005 database
24 Jan 2014
Sander Rossel
The second of two; everything you need to create the most amazing queries!
19 Jul 2009
Md. Marufuzzaman
Get SQL Table Information
Data transfer tools to transfer data and database scripts between two SQL Server databases.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
This article focuses on how MS SQL Server uses indexes to read and write data.
15 Feb 2010
Tim Schwallie
A few ways to work with In-Clause and Stored Procedures with SQL Server and C#.
Change collation order for all text columns in a database
This article gives a brief introduction about Triggers in Sql Server 2000/2005.
An Extended Stored Procedure to use regular expressions in T-SQL.
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
An article on how to handle deadlock
19 Apr 2007
Frank Kerrigan
Using SQL Server to do paging of sql results.
8 Nov 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps, this article focuses on organizing files/file-groups and applying partitioning in SQL Server databases.
Proven techniques to speed up expensive SQL queries.
A VBScript which creates Delete and Insert statements to backup data from SQL Server.
8 Mar 2010
Surath Rath - 2010
This article introduces the fundamental concepts behind SQL Server 2008 Application Role and illustrates its use in securing data and database objects.
11 Feb 2011
Mika Wendelius
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
16 Jun 2013
Darek Danielewski
The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arrising from concurrent access to shared data.
Basic overview of temporary Tables in SQL Server 2005
7 Oct 2011
Sunitha Sudheesh
Coding in SQL with Common Table Expressions (CTE)
General tips and guidelines for performance improvement
3 Jan 2009
Mika Wendelius
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
Overview of Log Shipping in SQL Server 2005
How to create simple SQL time zone functions to use in queries.
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
12 Mar 2013
Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
5 Sep 2008
Niklas Henricson
Migrate MySQL to Microsoft SQL Server in just a few simple steps
This article describes implementing and manipulating a tree structure by means of SQL
Automated Windows DTS Package for SQL Server 2005 Database Backup
Overview of Views, system Views, creation of Views, and binding and securing Views.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
23 Dec 2009
Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
29 Jan 2010
Alaric Dailey
Working around issues when using SQL Server indexed views.
How to save and retrieve an image from a SQL Server database in VB.NET.
7 Nov 2007
Syed Mujtaba Hassan
A simple, ready-to-use control for C# beginners to detect all SQL Server instances in a network and then list all the databases hosted on the selected server
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
25 Feb 2011
Mika Wendelius
This article describes the pseudo column to identify the unique physical location of a single row.
23 Jan 2014
Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
9 Mar 2009
Muhammad Shujaat Siddiqi
This article discusses some unknown feature of SQL LIKE operator e.g. using set, range, exclusion and escape sequences
27 Dec 2011
Mika Wendelius
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
The first of two, everything you need to create the most amazing queries!
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers
25 Sep 2013
Mubin M. Shaikh
Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse
An application that seeks to emulate the F4 object search function from Query Analyser
When you create a backup, you must be able to restore this backup into the same database and same location. But this code also helps you to restore a backup into a new database or existing database.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
An article on locating MS SQL Server instances on the local network, and retrieving information about them.
SQL Mirroring made easy - setting up a mirror for a database
This sample project demonstrates how to save a file to a SQL Server database and also how to pull a file out of the database.
18 Mar 2010
Mohammad Elsheimy
Learn the details of how to work with SQL Server logins.
2 Jul 2003
Saumendra Poddar
SQL Server Transactions and Error Handling
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
Generate unique column values using UDFs and Stored Procedures
CDC is a new feature for logging DML changes. In this article, we will see how CDC could be put to use and how efficiently it could serve our purpose.
This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java
23 Dec 2003
Michael Potter
Locating MS SQL Servers by using ODBC through C# PInvoke calls.
10 May 2011
Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a SSMS perspective
6 Aug 2012
Abhijit Jana, Abhishek Sur
This Table of Contents and articles is editable by all Silver members and above. Please update the article with as many as function you aware in SQL Server 2005/2008 that we are used generally. This will put all of them under a single article.
26 Feb 2014
Shivprasad koirala
This article will discuss about 11 important database designing rules.
2 Sep 2011
Niladri_Biswas
In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective
This article explains working with SQL Server 2012 Express LocalDB.
Overview of Error and Exception Handling in SQL Server 2005 using @@Error and Try-Catch
Provides an insight into creating automated process for Backups and Restorations
19 Aug 2008
khatri.hitesh
The article explains how to fetch data from Microsoft Analysis Services 2005 (OLAP) Cube using ADOMD.NET and MDX, and display it in the form of a grid.
SqlServer Backup/Restore Utility helps to backup and restore database
28 May 2007
Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
28 Aug 2008
Muhammad Shujaat Siddiqi
shujaatsiddiqi.blogspot.com
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
MS SQL Server 2008 new feature, Table Value Parameter.
19 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
Backup System Databases in SQL Server
30 Mar 2011
Frank Kerrigan
SQL Server domain modeling with Oslo CTP and the "M" language.
20 May 2011
Niladri_Biswas
In this article we will look into the basics of Contained Database that has been shipped with Sql 11 (Code Name: Denali) CTP 1
Looks at fixing any locking issues you found in Part 2. You'll see how to determine which queries are involved in excessive locking delays, and how to prevent those delays from happening.
How to generate XML from SQL Server 2008 DB and update DB from XML.
This is a technical article for new bees on how to upload/update/download files (picture/mp3/excel/doc) into sql server database.
Setting up a lightweight audit function for a SQL Server db.
This article describes SQL Server Replication
Using SQL Server 2005 and SqlDependency to keep your application's data updated.
18 Dec 2008
Mycroft Holmes
A workaround for the limitation of only being able to pivot one column.
14 Sep 2007
Frank Kerrigan
Move SQL Server 2005 databases back to SQL Server 2000.
2 Sep 2011
Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
2 Oct 2012
Shivprasad koirala
Many developers think stored procedures are precompiled so they are faster. I have a different story to tell.
How SQL Server deletes records
19 Jun 2008
Matt Whitfield
A side by side text comparison control with T-SQL syntax highlighting.
4 Mar 2007
Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
22 Mar 2013
Shubham Choudhary
OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
28 Jul 2013
Dino Konstantopoulos
Running MapReduce in a SQL Server database.
29 Oct 2004
Alexandru Ghiondea
Describes how to upload and download pictures to and from a SQL Server database.
Learn how to store data with a version history.
An article on how to transfer data using SQLBulkCopy
24 Mar 2014
Chandra Sekhar - Raparthi
CT is a new feature in SQL Server 2008 which allows us to track information about changes that we have made to tables in which CT is enabled.
An incremental database upgrade utility for SQL Server.
26 Jul 2008
Ali Daneshmandi
Creating a CLR Persian date convertor function for SQL Server.
Validate existence of Sql Server
16 Jan 2009
Vivekananda Swamy.M
This article mainly describes how to import data from Excel sheet to SQL Server, Viewing the data from SQL Server using the Gridview Control, Deleting the Data. In case the Excel sheet does not contain data (null values), those values are replaced by zero.........
With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.
SQL Server database best practices
23 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
A C# Windows application to store and retrieve photos from a SQL Server database.
This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.
1 Jul 2005
Kazim Sardar Mehdi
Storing and retrieving images from SQL Server using Microsoft .NET.
20 Jul 2007
Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
16 Apr 2010
Christopher Liu
When you copy a row with a primary key, bring other tables that reference it along for the ride!
A step by step explanation of how a recursive CTE actually works.
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
3 Aug 2011
Niladri_Biswas
In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple
In Part 2, we looked at what fragmentation is and how to pinpoint excessive fragmentation. In this Part 7, we'll look at fixing excessive fragmentation.
27 Aug 2007
Kamal Singh Kharayat
Article describes all the problems and constraints defined to use managed code under SQL Server 2005.
An approach to creating an aggregate report with a set of dynamic columns based on dates.
In part 2, we'll pinpoint a number of other bottlenecks, including locking issues, lack of execution plan reuse, fragmentation, and hardware issues.
Describes a method for loading data objects using SQL Server 2005's new FOR XML PATH mode and XML serialization.
An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.
16 Jan 2012
Venkat Chaitanya Kanumukula
Export SQL Server Tables to Excel Files Dynamically
This article describes how to use RAISERROR in SQL Server 2005
Monitoring Free Space on Microsoft SQL Server
How to call a Web Service from a SQL Integration Services package.
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
SQL Server Express Automated Backup Console Application
An introduction to SQL Server Indexed Views.
In this article, I will show some of SQL Server 2012 T-SQL new features and compare them with alternative SQL script in previous version SQL Server.
27 Nov 2013
S. M. Ahasan Habib
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
21 Jun 2008
JustChiragPatel
No need to create web service for SSIS package call
26 Jun 2008
HightechRider
Demonstrates SQL Management Objects, LINQ to XML, and more.
Import, export and move your SQL diagram around using sysdiagrams
In part 2, we saw how to identify suboptimal reuse of execution plans. In this part 6, we'll look at improving this.
13 Oct 2006
Ewout Stortenbeker
This tool (ScriptDB4Svn) enables you to add your SQL Server databases to Subversion (SVN) source control.
Simple example to show how Composable DML works in SQL Server 2008.
4 Oct 2013
Mubin M. Shaikh
Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
5 Database Worst Practices which can be fatal to any business
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
A introduction to the flexibilities provided by the use of SQL extended properties in business layer code templates.
Using Variables in SSIS Package to dynamically set flat file names
A very exciting feature in Microsoft SQL Server
2 Sep 2011
Niladri_Biswas
In this article we will explore on the new features that Denali CTP3 has offer us from SSIS perspective
30 Jun 2011
Deepti Saxena
The purpose of this tutorial is to provide detailed steps on how to create a SSIS Package.
24 Oct 2009
Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
24 Jan 2008
Igor Krupitsky
The Table Data Exporter creates a SQL script for data in a table.
29 Mar 2010
Surath Rath - 2010
This article introduces the fundamental concepts behind SQL Server 2008 Integration Services Conditional Split Data Flow Transformation element to transfer data from a set of flat files to SQL Server database tables...
An article discussing how to accomplish paging and sorting in Microsoft SQL Server 2000 without using concatenated SQL.
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
Iteration without curser is one of database programmig arts, in this article i have tried to calculate exponential function with taylor series
A beginners guide to accessing a SQL or MSDE Server with C#
Moving from Relational Data to Spatial Data in SQL Server 2008
This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers.
An introduction to the database snapshot functionality in MS SQL Server. It is one of the important tools used for generating data for reporting purposes.
These articles are on prioritizing and improving query performance in SQL Server.
22 Jul 2013
Sivaraman Dhamodharan
Joins are useful for bringing data together from different tables based on their database relations. First we will see how the join operates between tables. Then we will explore the Order of Execution when Join and where condition both exists. Finally we will move our exploration to the Importance o
11 Feb 2011
KarthikAnbarasan
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
Writing extended stored procedures in C++ for SQL Server.
13 Nov 2007
Bruce Chapman DNN
Writing a SQL script to generate insert or update scripts for a table full of data.
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
27 Oct 2009
hussain.attiya
DEVELOPING SSIS to import oracle records to sql server
Limitations of the View Many and Many
How the Copy Database Wizard can be helpful to users working on upgrades and migration projects.
SQL Server 2008 provides a very efficient SQL policy administrator which constantly monitors the server and reports errors appropriately. Administrators can define policies and ensure that they are being adhered to by evaluating the policies.
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the first part.
3 Sep 2011
Niladri_Biswas
In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3
23 May 2012
Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
22 Jan 2013
Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
13 Mar 2008
Bryan Kowalchuk
Proper Key Column Design
3 Sep 2008
Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.
Learn how to load and execute a SQL Server 2005 Integration Services package from C# code
An article on how to create user defined data types using .NET languages for SQL Server 2005.
30 Aug 2008
Ahmad Eid Salim
Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of a database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the source database.
17 Jan 2014
Mubin M. Shaikh
Learn Custom MDX Query Step by Step
Using TableAdapter to display Pivot result without code.
Reseed Identity of Table - Table Missing Identity Values - Gap in Identity Column
Merge replication step by step procedure for SQL Server 2000.
New feature - SQL Server 2008 Grouping Sets.
This article explains database schema design for storing tree structure and an algorithm to compute its cost.
4 Jun 2008
Ashutosh Phoujdar
Utility to generate schema description from existing SQL Server databases.
13 Nov 2012
Michael Abramovitch
A flexible way to generate unique numbers for things like invoice numbers.
Microsoft SQL Server 2008 new feature, Merge Statement
4 Dec 2013
Sergey Syrovatchenko
This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.
22 Aug 2010
Samrat Banerjee
Difference between SQL @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT functions
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
A handy command line tool that checks whether stored procedures, views and functions in a database compile
22 Aug 2008
Michael Ceranski
Powerful SQL Server stored procedures useful for day to day administration
6 Apr 2010
Indrajeet Sutar
All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.
11 Sep 2008
George Tryfonas
An on-screen visualizer for the SQL Geometry type
31 Jul 2008
Haider Ali Khan
This software generates Insert, Update, Delete, and Select stored procedures (whichever you want) for selected tables.
Gives an introduction of how to create SQL CLR managed objects in SQL server.
9 Nov 2012
Ashrafur Rahaman
From this article, developers will get some useful guidelines on bulk data insertion in SQL Server.
11 Jun 2007
Dmitry Tsuranoff
Examining the effects of column encryption on SQL Server performance
Implement a full text engine by using Stored Procedures for all MS SQL Server editions.
28 Aug 2013
Software Developer's Journal
The goal of this article is to present elements of security in SQL Server such as: restrictive access to the server, blocking and safe configuration of services, and reduction of attack space for new elements. Techniques for creating and managing users and for securing data are illustrated.
17 Dec 2008
Rupesh Tarwade
Setup a connection string by allowing the user to select the server and database
16 Sep 2009
Igor Krupitsky
This article explains how to do Paired T-Test in SSAS 2005 (Microsoft SQL Analysis Services).
This article is nothing but a very critical real time scenario that I have faced for a Delta Derivation warehousing project where I found the newly incorporated Merge keyword in SQL Server of immense importance.
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.
Basic difference between Sql Where and Having Clause
Using Table-Value Parameters to perform Inserts in SQL Server 2008 from VB.NET.
6 May 2008
Igor Krupitsky
Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds) is not automatically created by SSAS (Microsoft SQL Server Analysis Services). This article explains how to create and use Time Dimension in Microsoft SQL Server Analysis Services.
Performance comparison - Identity() x NewId() x NewSequentialId.
30 May 2006
Chris_Martinez
How to pass an array of integers to SQL Server
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
15 Oct 2010
Ganesan Krishnan
Data Synchronization in SQL Express
12 Jun 2008
Srinath G Nath
How to handle an array parameter in a Stored Procedure [SQL Server].
This article discusses binding a gridview/repeater control from a dataset using a stored procedure
28 Sep 2012
AdamNThompson
A data access component for SQL Server in VB.NET.
Command line tool to check validity of objects in SQL Server databases
4 Dec 2009
Appusamy.subbian
Understanding the database Indexes with real life scenario
An easy and strongly-typed way to invoke queries and stored procedures from your code
Show a progress dialog when you execute your DTS Package at runtime.
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
An interface that can be used to build robust applications that extend the power of MS SQL Server.
An easy way to truncate Transaction Log files to your desired size.
How to add a modified on column in SQL Server using triggers.
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
This video discusses a typical scenario where mirroring and replication happens hand in hand on the same database. It is important for those who implement mirroring as high availability solution for their database and also replicate/publish some articles (tables). There are certain settings which al
Asynchronous processing of triggers using cursors
MS SQL Server 2008 new feature, the HierarchyID data type.
16 Jun 2010
Akbar Ali Bhatti
Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.
17 Feb 2005
Jay Kulaindevelu
To change the row colors in reports.
17 Feb 2009
jQuery By Example
How inner queries work in SQL Server
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
3 Nov 2012
Mika Wendelius
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems.
17 Jul 2009
Erode Senthilkumar
How to handle the errors effectively in SQL Server?
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
A tool that facilitates the truncation of SQL log file
Get a list of SQL Servers to which you can connect.
8 Jan 2009
Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
This article is about exception handling improvements in SQL Server 2005.
4 Apr 2007
Fitim Skenderi
Very Lightweight Data Access Layer in C# and .NET 2.0
SQL Server 2005 database backup and restore using C#, .NET 2.0, and SMO.
13 Dec 2008
Enrique Albert
Console and GUI utility application that executes SQL scripts against SQL Servers (7, 2000, and 2005) - version 2.0.1.2 is now available.
software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.
26 Jan 2006
balazs_hideghety
Fast recursion in DB.
Automatic SQL Server Backup Utility using sqlserveragent
How to start using SQL Server Everywhere in C# programs.
A class that helps enumerate SQL servers, databases and languages.
6 Aug 2008
Ziyad Mohammad
How To: Read and write BLOB data by using ADO.NET through ASP.NET 2.0.
13 Mar 2008
Bryan Kowalchuk
Formatting telephone numbers in SQL Server.
The article explains adding a user in SQL Server programmatically, using VC++
An article on how to use SQLDMO to enumerate SQL Server instances.
15 May 2006
Jason Selburg
How to implement data driven subscriptions in SQL RS 2000, Standard edition.
27 Aug 2006
Patrick Spieler
Manage and profile SQL Express 'User Instances'.
24 Aug 2008
Muhammad Shujaat Siddiqi
Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
4 Jan 2010
Alexandru Cibotari
Set based and procedural approaches in examples tested on SQL Server 2008
11 Jan 2012
Venkat Chaitanya Kanumukula
Export SQL Server tables to HTML/Excel/Word Document files dynamically.
In this video you will learn to make adhoc reports on the fly with the help of MS excel. You will be able to connect to SQL Server Databases or SQL Server Analysis Server Cubes and generate reports for specific business
20 Aug 2012
Santhosh Kumar Jayaraman
How to use the new conversion and datetime functions in SQL Server 2012.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
29 Jul 2008
George Zabanah
Take a look at two new patterns to help with database concurrency: SIP and SUP.
Retrieving child records from an hierarchical table
Monitoring and Recording DDL changes in SQL SERVER 2005
Create a simple, scalable XML-consuming rules engine in just a few minutes, using OpenXML.
Validate MS SQL Server scripts with NAnt to improve continuous integration.
Shows a way to map tables, relations between tables, and columns info of a SQL Server 2000/2005 database; also generates INSERT, UPDATE, DELETE, and SELECT SQL statements at runtime using C# (TableReader).
13 Apr 2003
Vinod Kumar M
This article shows the power of using SQL-DMO with SQL Server 2000 to script out objects. In this example we would script out tables.
19 Feb 2008
Clement Prashant Baker
An easy approach to access SFTP sites from SSIS packages.
12 Aug 2008
Muhammad Shujaat Siddiqi
Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)
28 Dec 2011
koolprasad2003
his article explains you how to deal with Case Sensitive search with SQL
2 Jul 2003
S. Vijaya Raghavan
An example of inserting data into SQL Server using OpenXML + ADO.NET
12 Feb 2009
Mohammad A Gharakhanlou
this application is answer for ;How to encrypt sql server procedures and functions at a time
25 May 2010
Muhammad alaa
use date and time as separated components in SQL Server 2000 and above
SQL Server Interview Questions and Answers Complete List Download
Browse MS SQL Server Information Schema Catalog
22 Jun 2004
faisal abdul aziz
This article explains Parent-Child insertion into SQL Server 2000 using XML Support provided by SQL Server 2000 and Visual Studio.NET
30 Jan 2010
Mohan H Prajapati
It shows how to write custom paging procedure
This video describes how to generate table scripts with/without data in SQL Server 2008.
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.
24 Mar 2014
Christian Graus
Covering how to use the new Distribution functions in SQL Server 2012
20 Sep 2008
Morteza Naeiamabadi
this article demonstrate how to insert a audio file into SQL Server and how to get the audio file from SQL Server and play it in .Net
Information about Unicode implementation in SQL Server.
Get or find Primary Key or ID column of Table in SQL Server 2000/2005
Simple export of data from database a to database b using identical tables (SQL Server).
Demonstrates methods for creating and validating MD5 encrypted passwords in MSSQL 2000.
This article demostrates how you can achieve a function recursion effect in SQL.
When you want to get the data script from sqlserver, use this, it can be fun.
Implementing Triggers in SQL Server 2000.
30 Sep 2009
Aruna Randeni
Recover SQL server 2005 database from SUSPECT mode
24 Apr 2013
Nguyen Thanh Phuong
Create a SQL Server database using C#.
Using SQL Server 2008 table valued parameters to insert multiple records (VS 2008).
This article talks about CLR integration and how to program database objects using managed code by using this cool feature of SQL Server 2005.
SQL Server 2005 now offers the possibility to partition tables and indexes. Using this feature can boost your DWH load.
I have tried to accommodate all of them in last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer at convenience.
This function gives dates for a day between two dates (e.g. All sundays from Jan-08 to Aug-08)
Building a hybrid Active Directory and SQL table DataSource view.
Many time we face problem in SQL Query when performing operation with IN clause to check values seperated by ,(commas) in a parameter.
Do you want to know what your DB programmers are doing?
25 Oct 2006
Jeremy Mullinax-Hill
A generalized stored procedure that performs constraint checks before performing deletes.
An introduction to basic data mining with SQL Server 2005.
T-SQL string maker for backup with a MEDIAPASSWORD database.
A Microsoft SQL Server database documentor, using Crystal Reports.
30 Jan 2009
Three Nine Consulting
An explanation of Views in SQL server 2000/2005 and the advantages of them
11 Jan 2007
Pete O'Hanlon
The first in a series of articles on prioritizing and improving query performance in SQL Server.
14 May 2002
Amol Kakhandki
This article explains how to connect to an SQL Server and pass a string.
An article that describes lightweight C# wrapper for SQLite
27 Oct 2008
Enigmatic Texan
MD5 Digest XSP with error trapping and full Unicode support, in and out.
A Big Downloadable List of SQL Server 2008 Questions and Answers
This article shows some samples using SMO with SQL Server 2005 to perform some administrative tasks.
This library allows a user to use functions in SQL Server to encrypt and decrypt text.
Application to show differences between two SQL Server databases.
13 May 2007
Eugene Ochakovsky
A generic procedure to retrieve and delete duplicate records from MS SQL Server tables.
25 Apr 2005
Rod VanAmburgh
SQL Server extended stored procedure to send UDP messages.
This is an article about backup utility of SQL server from Command prompt
A cursor for dynamic query.
18 Jun 2008
Igor Krupitsky
A script that lets you run many XMLA files against a SSAS 2005 database.
Demonstrates how to debug a Stored Procedure in Visual Studio .NET 2005.
Am article on how to send multiple rows to SQL Server 2005 database for data modification.
This guide will show you how to enumerate through the stored procedures in MSSQL 2000, as well as retrieve parameter information for a stored procedure.
16 Jan 2008
Rajaraman.net05
SSIS package integration with C# .NET.
A simple Windows screen host utility that returns connection information (server name and port number) for all instances of SQL Server 2005, 2000, and 7.0 on a local machine.
CLR hosted in Microsoft SQL Server 2005
SQL SERVER – Order of Columns in Update Statement does not matter
SQL Server manager for remote monitering and managing.
13 Mar 2008
Bryan Kowalchuk
Efficiently storing telephone numbers in SQL Server.
14 Dec 2004
R. Senthil Kumaran
Using tranasaction on distributed servers and querying them - Linked Servers in SQL Server.
19 Mar 2008
Daniel Ch. Bloch (MCSD, MCAD, MCTS)
SQL 2005+ changes behaviour of order by in relation to Select top 100%
How to use SMO to copy database schema and data using C#.
6 Oct 2006
Andrew Timberlake-Newell
Basic VB.NET example for generating a hash value and using SQLClient to store to a binary column in SQL Server.
A real example of database migration (MS SQL -> FireBird).
21 Nov 2008
Michael Erasmus
An add-in for SQL Server 2005 Management Studio that will run all the scripts in the selected project.
Invoking an External ADO.NET DLL to connect and execute queries on a SQL Server database from within the Meta Trader Platform
5 Nov 2003
Steve Brailsford
An article showing how to display the sp_who info and sort on a column.
An article on efficiently adding rows in a database
CodeSmith template for creating Audit Log Triggers on SQL tables.
Query paging by one trip to MS-SQL Server 2005 via a simple query. Without using a Stored Procedure, View, or others features. Only uses T-SQL and .NET.
This article is a part of a series of articles that shows HOW-TO do various tasks in powershell.
6 May 2007
Gaurav K Singh
This article aids in rapid application development for database handling, for desktop and web applications
Format Excel Sheet from DTS when Excel is not installed on SQL Server
Introduction to using CLR .NET assemblies in Microsoft SQL Server.
18 Oct 2006
Sergey Sorokin
This article discusses a method for retrieveing hierarchical data from a relational database
13 Dec 2007
Vijaya Pulugurta
searching for a pattern such as "code project" within the text in a column and replacing it with another text such as "Code Project Article"
23 Jun 2009
Kuldip Rindani
This script calculates size of every user database with summary
3 Jun 2010
Richard Espinoza
Explains basic SQL Server concepts and some best practices to build Transact SQL Stored Procedures.
Tricky Sql Queries most asked in SqlServer/.NET Job Interviews.
4 Apr 2007
Rajaraman.net05
This article will explian store / retrive the word documents, excel files, Images and xml to Sql server database.
An article on configuring an SSIS Package.
17 Apr 2006
Ujwal Watgule
The article discusses threats to application in the absence of proper validation procedure.
18 Mar 2008
Dima Kostikov
implementing pagination and sorting in MS SQL Server 2000 without using dynamic queries
Inserting Bulk Data in SQL Server from Text file
13 Aug 2008
JustChiragPatel
Brief Intro of how out t-SQL is parsed and submitted to SQL Engine to retrive data
19 Apr 2005
Ahmed_EL Sayed
How to set up SQL Server Integrated Security for using with SMS.
The uploaded .NET solution includes the implementation of a database change management process that, if applied correctly, can dramatically reduce the time you spend synchronizing various versions of application databases in development, staging, and production environments.
How to solve the age-old problem of passing complex structures as parameters to sprocs
How to find if only one particular column has been modified in a trigger.
20 Jun 2009
S.Vinothkumar
Sum of previous row values in SqlServer
This SQL Server 2005 Table values function returns a table with all dates of a month for a provided date.
28 Jun 2007
harry_kochhar
This SQL Server function helps to get the nth day of the nth week.
Perform phonetic search on MS SQL Server using Soundex.
12 Dec 2007
Seifedine kadry
Run an SqlServerr Job from MS Access
SQL Server Integration Services (SSIS) best practices.
9 Mar 2011
santosh poojari
This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis
25 Nov 2011
Sagar Sengupta
Implement audit trail technique using XML column in SQL Server 2005
7 Oct 2012
Hassan Boutougha
Workaround for SMO latency when scripting.
Deadlock analysis in SQL Server 2000.
How to use a script component as a data source for multi-result set Stored Procedures.
27 Apr 2009
Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
11 Jun 2009
ColinBashBash
Templates to fix changes in sort-order as they occur.
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.
20 Sep 2011
Mika Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Specific example for improving some SQL performance problems
10 Nov 2011
Phani Krishna Kollapur Gandla
How to solve performance issues in data migration to SQL Server.
Determining sunrise and sunset values for a certain latitude and longitude with SQL Server 2005
10 Jun 2012
Manar Ezzadeen
PowerShell script that generates an HTML report displaying different information about the SQL Server databases, their CLR assemblies and owners.
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
Submit an article or tip
Post your Blog
CodeProject.TV