Click here to Skip to main content
15,434,217 members
Everything / Database Development / SQL Server

SQL Server


Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

by Telegram:@ArastoAhmadi
Tutorial to monitor database changes without using tools and by using a simpler trick
by DiponRoy
Run Raw SQL Query - Entity Framework Core 6
by DiponRoy
Options to customize EF Core migration table
by DiponRoy
Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause

All Articles

Sort by Score

SQL Server 

18 Jan 2017 by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
24 Aug 2009 by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
22 Oct 2017 by thangchung
Learn to organize clean architecture to modular patterns
27 Nov 2009 by Max Paulousky
This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.
3 Sep 2008 by Ahmed Negm
This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.
16 May 2013 by dale.newman
Google your SQL.
5 Nov 2002 by Alexey
The alxBase classes for work with dbf files.
14 Aug 2013 by Harmen Brouwer
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
28 Apr 2022 by KristianEkman
An online Angular, .NET 5 Web API, SQL Server on Azure backgammon game
6 Sep 2007 by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
9 Oct 2018 by Akhil Mittal
Entity framework core, code first migrations and data annotations in EF Core
1 May 2018 by Shashangka Shekhar
In this post, we will get an overview and generate a basic level code using our database table column that will help in development.
11 Oct 2011 by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
10 Jan 2019 by Andi Kleinbichler
Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.
25 Oct 2008 by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
17 Aug 2009 by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
5 Nov 2018 by Jovan Popovic(MSFT)
In this article, I will show you how to create powerful REST API with just a few lines of C# code using MsSql.RestApi package. If you follow this approach, it might be a huge time saver for you.
13 Mar 2021 by Sergii Syrovatchenko
How to omit many restrictions on SQL Server Express Edition
23 Apr 2012 by Kuthuparakkal
SSIS and Excel Automation
27 Jun 2012 by freedeveloper
A small control to control paging in Windows Presentation Foundation.
17 Jul 2017 by Vadim Loboda
Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order
7 Sep 2012 by Shivprasad koirala
This article will discuss about SQL Server governer.
17 Apr 2012 by Nadege Rouelle
Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.
22 Feb 2013 by Scott Burkow
An exercise in algorithm analysis and design.
31 Mar 2006 by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
21 Dec 2007 by Bruno Sonnino
This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.
15 Sep 2008 by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
25 Nov 2016 by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
7 Sep 2009 by Tamer Oz
PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.
3 Feb 2013 by S. M. Ahasan Habib
Database script execution with testing
12 May 2017 by DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
27 Feb 2018 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
17 Jun 2009 by Sacha Barber
SQL Server CLR functions
14 Mar 2000 by Tom Archer
A class to dynamically read data from any ODBC data source
9 Oct 2009 by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
25 Oct 2012 by Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
26 Jul 2017 by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
4 Nov 2016 by Wendelius
Few CLR procedure concepts to write into a file from SQL Server database
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
27 Jul 2009 by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
21 Feb 2012 by 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.
13 Sep 2012 by Wendelius
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
4 Nov 2015 by Fred Song (Melbourne)
Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
12 Mar 2003 by Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
2 Aug 2009 by Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
27 Apr 2011 by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
19 Dec 2007 by Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
28 Sep 2012 by J.Jash
Data Auditing Trigger Generator
6 Dec 2016 by _Asif_
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
23 Mar 2019 by Minh Tuan Do
A considerable method to speed up query running time
4 Nov 2021 by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
28 Jul 2000 by Len Holgate
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
8 Nov 2016 by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
7 May 2017 by Michael Lockwood
How to call a web service using SSIS, store XML results and then query XML using XQuery
25 Jul 2021 by Sergii Syrovatchenko
Here's everything you need to know about high-performance JSON parsing for SQL Server
9 Jan 2010 by Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
8 Apr 2013 by Shining Dragon
How to effectivley version your SQL Server databases using SQL Server Data Tools
20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
8 Oct 2015 by DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
29 Aug 2018 by Micah Nikkel
SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.
31 May 2015 by Milan Matějka
Compare likenesses and differences between Temporary Tables and Temporary Variables
8 Jun 2015 by Dirk_Strauss
LEADTOOLS Recognition Imaging SDK - I had the pleasure of taking the SDK for a spin, and let me tell you it was well worth it.
27 May 2016 by Aless Alessio
Reat time Spreadsheet, updating and retrieving data through a Web Service. Using SQL Server DB.If two or more users are working on the same spreadsheet, they can see what the other users are doing. Mouse pointing is highlighted by filling the cell with diagonal stripes, while data saved is highlight
13 Mar 2017 by defwebserver
You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.
19 Sep 2017 by Igor Krupitsky
Application lets you copy tables from Paradox to SQL Server
17 Nov 1999 by Robert Pittenger, MCPD-EAD
30 Jul 2009 by Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
21 Dec 2012 by mparvez
If you wanted to check the status of all your database backup then this script will do the task.
19 Feb 2013 by Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
4 Jul 2013 by Zafar Sultan
An article describing general functionality in GridView.
19 Sep 2013 by G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
10 Feb 2016 by Jesus Carroll
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
18 Apr 2016 by Ankita Biswas Bhattacharya
Here, I will explain how you can work with SQL views in lightswitch and how you can save data on screens which are created on Views.
10 Feb 2018 by Changming Wang
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
20 Nov 2019 by Igor Krupitsky
Application lets you copy tables from folder with DBF files to SQL Server
30 Dec 2019 by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
26 Oct 2000 by Massimo Colurcio
Explore the structure of tables (and views)
14 Mar 2000 by Tom Archer
A class for Printing and Viewing MS Access Reports
3 Jul 2002 by roboo
An OLE-DB DLL that you can use in ANSI-C
16 Oct 2007 by Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
20 Apr 2009 by András Slyuch
This class collects data rows in the memory and saves them into a Microsoft SQL database with SqlBulkCopy.
28 Aug 2012 by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
17 Dec 2012 by AshishChaudha
There are many scenarios in which the data can be bound in a Gridview, in which various operation other than provided by default by gridview needs to be implemented. In this article we will try to bind such operations with some more features.
5 Feb 2013 by Gokulnath007
To get instant control over Outlook and various operations of outlook.
24 Jun 2013 by Scott Burkow
We build the physical design from the logical design.
31 Jul 2013 by apmyhr
Job Match helps job seekers find employment with the right company
6 Nov 2013 by Sichen D
How to build system availability timeline in SSRS
24 Jun 2015 by Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
4 Oct 2016 by Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
30 Sep 2017 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
17 Nov 2018 by Terence Wallace
A brief article on how to utilize NBA Stats API in a WinForm application
19 Nov 2018 by Vivek Johari
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
26 Dec 2018 by Wendelius
This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
18 Oct 2016 by Wendelius
Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure
21 Feb 2016 by Abdullah Al-Muzahid
This is a RAD tool which can be used to generate codes for CRUD operation in ASP.NET and C# automatically based on Database Model Diagram.
9 Mar 2021 by #realJSOP
This library is intended for use in a multi-environment system, but it certainly be used under less stringent environmental confines, even down to a single desktop machine taht needs to connect to a single database server.
16 Apr 2009 by MiamiCoder
How to create a real-world BlackBerry application.
27 Sep 2010 by venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
1 May 2012 by Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
7 Aug 2012 by ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
8 Jan 2013 by mparvez
How to execute SQL from a file for various purposes.
10 Apr 2015 by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
22 Jan 2016 by Kevin Griffin
Why could there not be another tool that allowed a development team to harness their existing source control systems, but make database changes a part of the workflow? Enter SQL Source Control by Redgate.
7 Dec 2016 by Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
30 Sep 2017 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Architecture and design decisions
30 Sep 2017 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Job Scheduling Code
14 Jul 2019 by Viswanatha Swamy
In this article, we will be looking at how to use SQL Server 2017 Docker image for Local Web API development.
20 Oct 2019 by Ravi K. Acharya
Second part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus
20 Oct 2019 by Ravi K. Acharya
Third and final part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
4 Jun 2018 by Shayne P Boyer
Why should we care about containers for development
21 Apr 2016 by Emmanouil Gimissis MSc ICSD
Calculating progressive sums in T-SQL
28 Jul 2000 by Len Holgate
Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.
29 Oct 2001 by simulant
Transform any XML persisted ADO Recordset into a delimited text file.
23 Feb 2009 by Walid Abdulrazik
An extension to the Microsoft SqlProfileProvider, to provide a search interface. This article is based on Shawn Wildermuth's - "a.k.a. ADO Guy" - work.
9 Nov 2010 by Sergei Dumnov
It explains how to display business intelligence dimension table using Silverlight TreeView
13 Jun 2011 by AlexCode
Converting INTs to BINARY in SQL Server
28 Nov 2011 by Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
29 Jul 2012 by Anup Ghosh for C# & SQL SERVER
The steps to migrate on-premise database data to SQL Azure.
1 Oct 2012 by 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
20 Dec 2012 by mparvez
Dynamically restore full and all transaction log backup.
2 Jan 2013 by Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
4 Jan 2013 by mparvez
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
15 May 2013 by h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
17 Jul 2013 by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
29 Jul 2014 by Ajit Kumar Thakur Microsoft
This article explains the step by step process to learn MDX query. It will help user to read data from OLAP cube.
24 Mar 2015 by Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
30 Sep 2017 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - The CSV and Excel Importer Code
30 Sep 2017 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - How Packages Are Run
8 Feb 2018 by Viral Surani
Snapshot Isolation Level in SQL Server
30 Apr 2018 by Ryan G Conrad
Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database
25 Nov 2018 by Vivek Johari
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
27 May 2019 by DiponRoy
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
20 Oct 2019 by Ravi K. Acharya
The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
11 Apr 2011 by Ben Demes
A demonstration of how you can quickly create a simple help desk application using modern development tools with little to no hand coding required.
10 Jun 2021 by Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
1 Feb 2018 by Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
15 Dec 2008 by Enrique Albert
A log4Net example: how to consolidate SQL scripts using log4Net.
31 Mar 2009 by BobP1339
Explains how to do multi language reports in SSRS
24 Jun 2009 by Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
26 Jul 2009 by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
26 Oct 2009 by dougturn
An overview of the Microsoft interoperability story for Open Source community and PHP Developers.
6 Apr 2010 by Rainer Halanek
A Connection Scope for the Entity Framework that allows to execute commands in a single connection
20 Apr 2011 by pinaldave
A Quick Guide to Find Potential Peformance Issue
29 Jun 2012 by Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
8 Aug 2013 by h_wiedey
An approach using updatable views with check option and deferred constraint checking.
26 Jun 2013 by ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
18 Jan 2014 by Petr Ivankov
Application of abstract approach to database domain
11 Dec 2015 by Jovan Popovic(MSFT)
In this article, you will see how to compress data in SQL Server using GZip algorithm and send it via node.js to browser.
24 Jan 2016 by RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
6 Jun 2018 by Gunnar S
Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric
13 Nov 2018 by Vlad Neculai Vizitiu
ASP.NET Core 1.1 and Identity Adventures
14 Feb 2019 by Melick
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller
10 Dec 2020 by Leif Simon Goodwin
Simple WPF app that shows how to use PetaPoco library to manage an SQL database
7 Jan 2007 by William Brewer
With SQL Server, it is strange how some of the most radical improvements that have been introduced over the years have been slipped in almost unnoticed.
2 Apr 2012 by Sanjay_Bhatia
With the advent of abundant memory, the majority of user requirements can be delivered without having to build separate data warehouses or using modeling technologies like MDX. This article shows how to use time compression to deliver rapid analysis of enormous data volumes using simple SQL views.
20 Feb 2000 by Len Holgate
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
5 Feb 2007 by Pman75
A 2 tier menu generator that can be navigated forwards and/or backwards.
15 Oct 2007 by Tijoy Tom
Deadlock analysis in SQL Server 2000.
17 Dec 2007 by mfmaneef
Explains how to send bulk records to a database using OPENXML.
29 Apr 2009 by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
27 Apr 2009 by Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
13 May 2009 by Paul S. Chapman
Windows Azure, TDS, WCF, Silverlight and a few problems on the way
11 Jun 2009 by ColinBashBash
Templates to fix changes in sort-order as they occur.
26 Jun 2009 by David O'Sullivan
See how Catharsis can help you rapidly develop robust enterprise level applications.
17 Nov 2009 by Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
25 Dec 2009 by db_developer
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
11 Jan 2010 by Divan van der Watt
Column search functionality that works as easy as sp_help.
16 Apr 2010 by Rabb Moshe Plotkin
How to make a responsive application by not having to wait for your LINQ to SQL to return from the server
13 Apr 2010 by Abdul_Rafay
SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
10 Dec 2010 by Beavis Killer
This article demonstrates how to generate plain old class objects (POCO) from the Entity Framework v4 (EF4) and use them through RIA Services in SilverLight version 4.
26 May 2011 by Keshav Singh
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.
13 Jun 2011 by Steinar Moen from Norway
This article describes an implementation on BizTalk 2006/R2/BizTalk 2009 where a received message is split and sent to many different destinations.
20 Sep 2011 by Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
20 Sep 2011 by Soptik Dutta
Explains an alternative way of stsadm restoration of a Site Collection.
11 Oct 2011 by KP Lee
Specific example for improving some SQL performance problems
10 Nov 2011 by Phani Krishna Kollapur Gandla
How to solve performance issues in data migration to SQL Server.
22 Dec 2011 by Keshav Singh
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
10 Jun 2012 by Manar Ezzadeen
PowerShell script that generates an HTML report displaying different information about the SQL Server databases, their CLR assemblies and owners.
24 Feb 2013 by gmaran23
Create an EventHandler in SSIS, add a ScriptTask to it, add code files to the ScriptTask and compile the solution - programmatically in C#
28 Apr 2013 by JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.
28 Apr 2013 by freshbreeze
Cloud Solution to help Patients to get rid of Drug Addiction and take medicines on time. Failing to take drug will trigger notifications to Doctors. Drug reminders will be available in Live Calendar and Proofs for taken medicines will be stored in SkyDrive.
30 Apr 2013 by Brian Legg
Danger Dodger will keep track of the amount of danger you're in at any given point in time and help you to avoid it.
29 Apr 2013 by rodney128
A windows Azure development to showcase online geocoding and mapping.
29 Apr 2013 by Super Nubes
2 May 2013 by DThrasher
Converting a Windows 7 desktop application to Windows 8 and Azure.
13 May 2013 by Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
3 Jun 2013 by Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.
5 Mar 2014 by bconlon
XSD 1.1 support in Liquid XML 2014
25 Aug 2015 by bconlon
XSD 1.1 support in Liquid XML 2014
16 Jun 2016 by Jovan Popovic(MSFT)
How to easily compare two rows in SQL Server using new JSON functionalities
13 Mar 2017 by yuvalsol
Keep the view state out of the web page and store it in SQL Server
6 Jul 2018 by Manjuke Fernando
How to replace sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities
11 Sep 2018 by Steven L. Wentworth (12896862)
Using combination arithmetic to improve quality of SQL table design and execution
30 Dec 2018 by mohghaderi
Add Debug/Release deployments to SQL Server database projects using build events and powershell
27 Jan 2019 by Melick
How to resolve the issue: AppFabric installation failed because installer MSI returned with error code: 1603
3 Feb 2019 by Melick
SharePoint 2016 Installation using AutoSPInstaller Online - how to set up the environment and service accounts
12 May 2019 by Manjuke Fernando
Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values
3 May 2013 by Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
24 Jun 2004 by Redgate Software
A simple solution to scripting when sysdepends are damaged
13 Jun 2005 by IronSpeed Inc.
Taking full advantage of the built-in infrastructure services of the Microsoft .NET Framework - without taking months to learn new languages, APIs and protocols - is one of the most pressing challenges faced by enterprise application developers today.
20 Oct 2005 by Redgate Software
Using a combination of iScala, SQL Server and Red Gate's software tools to manage data processes.
3 Feb 2006 by Redgate Software
Essential tools for easy migration to SQL Server 2005.
2 May 2006 by Petr Palas
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
30 Jun 2006 by Redgate Software
SQL Dependency Tracker allows you to graphically visualize database object dependencies. This means that users can track down potential "collateral damage" before pushing database changes through. With this ingeniously simple to use tool, you can also document database dependencies.
1 Nov 2006 by Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
7 Nov 2006 by Daniel Wood
Learn how changing the way you write queries can make them run faster. This article will describe the automated approach to optimizing SQL. DBA's have been doing it for years, now it's available for developers.
7 Dec 2006 by James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
21 Dec 2006 by Redgate Software
Database professionals have a special role in their workplace because they bear responsibility for customer database integrity. This article argues that the 'online' or 'lock ladder' database development model, which uses live instances is the only way to ensure true database integrity.
7 Jan 2007 by Robyn Page
Some seemingly simple requirements such as getting the DATETIME for the "start of the month" can be surprisingly tricky.
10 Apr 2007 by Petr Palas
Do you spend days and nights developing dynamic web sites in ASP.NET? Do you need to simplify your job, get more sites done and gain more clients? Kentico CMS for .NET will help you.
15 Jun 2007 by Atanu Banerjee
A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)
7 Jan 2008 by Visual Numerics, Inc.
This document focuses on the combination of VSTO 2005 and Visual Studio 2005 Team Edition.
20 Sep 2010 by DBI Technologies Inc.
What’s the best method for binding schedule controls to a database? A response is normally focused on the needed implementation; however, business rules can be used to define strategic implementations. This Showcase uses Warehouse Shipments and Dock Scheduling as a metaphor for exploring the topic
14 Mar 2011 by Redgate Software
Continuous integration makes development more efficient – allowing bugs to be caught earlier, and providing rapid validation. But for too long, it hasn’t been standard practice for databases. This is an overview of implementing CI so you can bring database code in line with application development.
10 Aug 2015 by Alessandro Alpi
MVP and DBA Alessandro Alpi discusses the advantages of source controlling databases, and shows why SQL Source Control is the best tool for SQL Server Management Studio users.
4 Jun 2014 by rapidagiledevelopment
The Software Development process can be time consuming and stressful. Outlined here are some practical tips on how to ease the strain with kissIT!® applications within the context of Prototyping / Agile methods for SQL, C# & VB.NET.
14 Jul 2014 by Redgate Software
If you’re thinking about adopting database source control, or have a system but aren’t using it consistently yet, here are seven tips to avoid deployment disasters.
1 Aug 2014 by Chris_Yates
When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.
13 Oct 2015 by Ben Emmett
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server with ANTS Performance Profiler.
28 Oct 2014 by Grant_Fritchey
Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.
12 Sep 2016 by Redgate Software, Dan Nolan
In this article, I’m going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the challenges of the Code First approach.
23 Sep 2016 by Lee Stott
The Microsoft Data Science Virtual Machine jump starts your analytics project. It enables you to work on tasks in a variety of languages including R, Python, SQL, and C#.
9 Feb 2017 by Redgate Software
A case study where Republic Bank introduced Redgate SQL Compare; the industry standard for comparing SQL Server schemas and creating deployment scripts in minutes.
30 Jan 2018 by Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
7 Nov 2021 by Sergii Syrovatchenko
Open source index maintenance tool for SQL Server and Azure
23 Nov 2021 by Rick Drizin
Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework
24 Jun 2012 by Patrick Kalkman
A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration
3 Apr 2019 by Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web
12 Jan 2014 by Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
21 Apr 2004 by Armen Hakobyan
Using SQL-DMO to shrink SQL Server transaction logs.
8 Dec 2015 by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
21 Mar 2017 by Dave Clemmer
Mo+ is the first technology that fully supports model oriented development, allowing software developers to powerfully scale the work they already do.
12 Sep 2003 by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
16 Jan 2014 by Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
26 May 2021 by Giovanni Bejarasco
A walkthrough in UDT programming with primary focus on database concepts
12 Mar 2015 by TarikHuber
SQL Table Toolkit is a Class Library offering a quite large amount of tools for fast and easy work with SQL Tables
28 Apr 2005 by emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
8 Apr 2020 by Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
20 May 2010 by Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
11 Sep 2010 by Renil Joy, Bangalore
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
11 Jun 2011 by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
3 Apr 2019 by Mahsa Hassankashi
This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
11 Mar 2020 by Dan Letecky
Create an AJAX monthly event calendar (with drag and drop support) displaying data from SQL Server database in just 10 minutes (including a coffee break).
19 Jun 2012 by David Catriel
How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation
28 Sep 2018 by Akhil Mittal
Code First Approach and Migrations in Microsoft .NET Entity Framework
12 Apr 2018 by Saineshwar Bageri
How to create a simple API in Node.js and use MS SQL as a data source to perform CRUD operation
19 Apr 2012 by Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
25 Mar 2018 by Ryan G Conrad
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
28 Dec 2011 by Evoluteur
A look at the minimal metadata needed (database mapping and user interface) for generic CRUD applications using the example of a to do list.
24 Nov 2021 by Rick Drizin
An overview of how to design a scalable Multi-Tenant Database using Row-Level Security Predicate Functions and DDL triggers to enforce that all shared tables are always restricted according to the tenant.
26 Apr 2016 by Jose Segarra
Support routines for handling JSON in SQL Server
11 Jun 2011 by Omar Al Zabir
Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance
6 Aug 2013 by Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
25 Sep 2012 by _Amy
Dynamic menu generation according to user privileges from database.
12 Feb 2008 by Muigai Mwaura
Use LinqToSql to query these popular RDMS products
25 Feb 2015 by Todd Christell, Canin Christell
Creating a Microwave Oven IoT Application
10 Jan 2012 by 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
11 Jul 2005 by Chester Ragel
A tool which can be used to do common tasks which Microsoft Content Management Server API provides.
12 Jul 2016 by Wendelius
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
22 Aug 2009 by Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
26 Jan 2021 by Kemal Erdogan
Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases
1 Mar 2015 by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
21 Sep 2009 by Apriorit Inc, Oleksandr Dodatko
This article describes the process of initial configuration and basic work with Palm Web OS on the lower level than it's described in Palm SDK docs.
6 Mar 2012 by Gautam Sharma
SQL-Server change tracking on a table without triggers.
30 Nov 1999 by Shekar Narayanan
16 Aug 2005 by Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
1 Mar 2015 by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
21 Jan 2014 by Christian Graus
A description of the best way to create tally tables, and how to use them
2 May 2020 by Kalvin Lawrence Ernst
A sample application code which is an alternative to using libraries such as AngularJS, React, Vue, etc. Only jQuery and bootstrap are used in conjunction with vanilla JavaScript, HTML and CSS.
23 Apr 2002 by Eugene Khodakovsky
A class to dynamically manipulate databases data using ATL/OLE DB technology
1 Jun 2009 by Dan-el Khen
An open source utility that synchronizes your database structure with a LINQ to SQL model.
21 Dec 2011 by Matt Perdeck
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.
29 Oct 2008 by Ahmad Eid Salim
Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.
23 Aug 2011 by Kanasz Robert
In this second part of series of articles about database performance optimization I will discuss about index maintenance.
30 Nov 2015 by Sreekanth Mothukuru
The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings
2 May 2016 by Android on Intel
In this article, I will talk about applications’ good performance and three developers’ behaviors that prevent it.
24 Oct 2012 by Enrique Albert
WCF service response message patterns
11 Jun 2008 by Billy McCafferty
This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.
11 Oct 2011 by Enrique Albert
WPF ICommand implementation based on Josh Smith's pattern.
3 Feb 2009 by C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
31 Mar 2017 by CHill60
Alternatives to using procedural loops in Transact SQL, demonstrated by examples.
17 Nov 2013 by Phil Lee NZ
A site for managing and delivering virtual conferences - complete with embedded live streaming and chat. Showcasing the best Azure has to offer!
25 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
2 Oct 2013 by Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
23 Nov 2010 by 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
26 Mar 2011 by Wendelius
SQL Server not having the aggregates you need? Why not build your own.
23 Oct 2012 by Enrique Albert
Global and Request context pattern for server side resources
26 Mar 2007 by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
14 Jan 2010 by alex turner
They might seem like just another not entirely required feature, but actually table variables are a very handy extension to SQL Server
7 Feb 2013 by Anupama Agarwal
This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.
30 Jan 2010 by Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.
3 Jun 2011 by Kanasz Robert
In this article, I will show you how to create a basic DB schema comparison tool for SQL Server 2005 and SQL Server 2008.
12 May 2011 by Niladri_Biswas
In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples
19 Jun 2002 by Carlos Antollini
Simple database catalog access using a set of ADOX classes
5 Feb 2010 by John Mokkosian-Kane, Daniel Hsu
To demonstrate Azure and EDA, this article will show you how to build a flight delay management system for all US airports in clouds with Windows Azure.
18 Oct 2013 by Brian C Hart
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!
9 Nov 2012 by Abdul Quader Mamun
To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.
22 Apr 2010 by Christopher Ayroso
Windows application that compares stored procedures between two SQL Server database
14 Dec 2011 by Matt Perdeck
Part 1 of an 8 part series on improving database performance.
17 Aug 2002 by Tomaž Štih
A solution to the problem of storing hierarchical data in a relational database
24 Jul 2014 by dale.newman
Combining de-normalization, transformation, replication, and awesome-ness.
10 May 2012 by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
3 Oct 2016 by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
11 Dec 2009 by Abby Fichtner (Hacker Chick)
A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.
10 Jan 2018 by Amir Jalilifard
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.
19 Aug 2009 by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008 by johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
8 Mar 2012 by Manjuke Fernando
Locks and duration of transactions in SQL Server
19 Mar 2007 by Adam Nelson
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.
15 Nov 2010 by Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
28 Apr 2005 by Thomas Kurek
Unsatisfied with the accuracy of code online that assumes the Earth is a sphere, I have implemented the oblate spheroid model used in GPS.
2 Apr 2017 by Wendelius
This is an alternative for "What You See Is What You Update"
15 Jun 2013 by defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
22 Apr 2015 by lakhdarr
Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern
30 Dec 2013 by Monjurul Habib
Introduction to Agile software development methodologies and how to apply them. It is about how to work together to achieve a common goal. This article focus on how technology team work together well to plan, build and deliver software.
30 Nov 2006 by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
2 Jun 2014 by Woong Gyu La
This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"
13 Jan 2013 by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
16 May 2013 by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
1 Jan 2012 by Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
16 Aug 2013 by Karthik. A
sBlog.Net is a minimalistic blog engine created using the ASP.NET MVC 3 framework.
21 Feb 2015 by Wendelius
How to log information into a table from inside a transaction, even if the transaction is rolled back.
9 Feb 2012 by Rahul Rajat Singh
YaBlogEngine is a Tiny Blog Engine written in ASP.NET/C#
14 Oct 2011 by Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
16 Oct 2013 by tcassisi
Generating typed field accessors and applying them to object mapping and SQL Stored Procedures
12 Dec 2013 by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
27 Oct 2007 by Cedric Baelemans
Discussion of audit trail techniques and a script to automate audit trail implementation on a Microsoft SQL database
7 Aug 2006 by craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
21 Mar 2019 by John-ph
Microservices sample architecture for .NET Core Application
4 Oct 2009 by lepipele
Generate Word documents by appling XSLT on XML data.
11 Mar 2014 by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
29 Dec 2006 by 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 Aug 2008 by Jammer
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
2 Jun 2017 by AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
22 Aug 2004 by Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
8 Nov 2011 by Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
12 Apr 2016 by DataBytzAI
How to bring CSV and XML data into MS SQL server
9 May 2011 by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a SSMS perspective
23 Oct 2012 by Enrique Albert
Baseline WCF Client application using the MVVM pattern
28 Jul 2009 by Shivprasad koirala
This FAQ article is dedicated to LINQ to SQL.
6 Jun 2017 by VINEET MISHRA 086
This article explains how to use data source for representation of data in TreeView structure using ASP.NET MVC and Gijgo treeview JQuery plug-in, The TreeView control can display a hierarchical (or nested, or recursive) collection of data in a tree of expandable nodes.
1 Nov 2010 by Kanasz Robert
In this article, I will show you how to backup and restore databases using Server Management Objects
20 May 2010 by Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
7 Mar 2005 by Vic Mackey
An extended stored procedure for SQL Server that implements an optimized MD5 hash algorithm. Very small DLL (barely 7 KB).
10 Dec 2008 by Wael Alghool
Gathering of various algorithms into one library to transform Hierarchical trees between various formats, and allows them to be represented into SQL 2005, the formats supported are TreeView, Textual, Tabular, Modified Preorder Tree Traversal and Graphical.
10 Jun 2013 by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
4 May 2014 by Shuqian Ying
Service based, multi-application ASP.NET custom membership, role and profile providers with a hierarchical role system.
24 Jun 2011 by Rob Groves
A C++ wrapper around the SQLite embedded database library.
6 Sep 2005 by Carlos Antollini
Simple database access using an ADO class.
23 May 2017 by Alejandro Xalabarder
An efficient and flexible layout manager
13 Jul 2010 by Md. Marufuzzaman
Overview of SQL server stored procedure
31 Oct 2013 by Relly Rivlin
This article describes a server and client side code including explanations of a generic database frontend web application.
27 Jun 2013 by Pål Thingbø
How to get SQL Server XML data to JSON objects in your browser via webservice
8 Jul 2016 by Jovan Popovic(MSFT)
How to build REST services with ASP.NET Core Web API and Azure SQL Database
29 Oct 2013 by Juan Davel
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
27 Feb 2011 by Kanasz Robert
In this article, I will show you how to use the scripting functions of SMOs.
15 Jun 2009 by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
4 Jan 2005 by DGoins
This article explains a brief introduction to SOA and a Subscriber-Publisher model, along with how to implement one using WSE SOAP Receiver and WSE SOAP Sender classes inside a Windows .NET application.
8 Jun 2009 by 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.
23 Jul 2002 by Carlos Antollini
A list of ODBC DSN Connection Strings.
2 Dec 2011 by Huisheng Chen
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
15 Aug 2016 by Suvendu Shekhar Giri
How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking
17 Mar 2012 by Václav Slavíček
Integration of fuzzy OWL ontology modelling with .NET
17 Jan 2011 by Bert O Neill
Get updates to your browser immediately when a change has occurred within the database.
11 Jun 2010 by theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
26 May 2013 by C. Dunn
View and rate box art for your favorite Xbox games!
23 Oct 2013 by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
5 Aug 2004 by Jasmin Muharemovic
An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET
4 Sep 2014 by Dukhabandhu Sahoo
Explore the Entity Framework Code First convention and configuration for creating primary key
15 Mar 2013 by Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
6 Feb 2015 by Richard Protzel
I decided to create my own sample project which connects to a named server (anSQL 2008 R2 server on my local machine – will also work on SQL Server 2012Express
6 Jan 2010 by hussain.attiya
A database-driven banner rotator control rotating based on a specific time (and not on page refresh). Each banner will have a display time (in seconds) to move to the next one.
24 Oct 2018 by HHerzl
Creating Web API in ASP.NET Core 1x
8 Mar 2009 by Adrian Pasik
This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.
31 Oct 2016 by Mercede
Generic data manager provides thread specific IUnitOfWork repository tailored for your entities and takes care of all the plumbing and cleaning in a thread safe way.
6 Jul 2012 by Patrick Kalkman
A complete WP7 application with a central management website (ASP.NET MVC4) for recipe management and push notifications
5 Jul 2016 by Sreekanth Mothukuru
The idea is to implement the latest and first of its kind “Always Encrypted” feature provided by Microsoft SQL Server 2016 designed to encrypt/decrypt sensitive data on back-end database engine
20 Jan 2017 by Ole Oren
Fast and simple REST development for SQL devs
6 Aug 2011 by Wendelius
This article shows few examples for using Table-Valued Functions.
14 Oct 2011 by Enrique Albert
Unit of work pattern on NHibernate using repositories.
9 Dec 2010 by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
21 Feb 2011 by Christopher R Davis
Use model driven development to keep your API and database in sync.
20 Oct 2009 by trantrum
An article about unravelling a large database
1 Jun 2009 by 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.
2 Dec 2008 by Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
8 Nov 2009 by 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.
28 May 2013 by Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
7 Jun 2011 by Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
27 Dec 2011 by Wendelius
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
11 Aug 2009 by Tanzim Saqib
Turn your current static website or blog into a lifestreaming portal with all your social activities with ASP.NET 4.0, C# 4.0, PLINQ, Task Parallel Library, Dependency Injection, and plug-in architecture.
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
27 Mar 2009 by Morshed Anwar
Implementing Audit Trail using Entity Framework's caching entries
23 Jun 2008 by Samir NIGAM
This article describes how to create a slide-show user control with the help of the DataList control.
19 Dec 2018 by Herman<T>.Instance
In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
19 Dec 2011 by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
10 Jul 2017 by Wendelius
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
6 Apr 2005 by Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
1 Mar 2016 by Akhil Mittal
Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.
25 Aug 2009 by Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
5 Oct 2014 by Antonio Ripa
A real world implementation of a Many to Many relation using MVC5 and Entity Framework
24 Jan 2014 by Sander Rossel
The second of two; everything you need to create the most amazing queries!
20 Jul 2012 by StianSandberg
This article will explain how to securely store users passwords in a database.
26 Jan 2016 by Jörgen Andersson
A propertymapping extension for DataReaders
6 Jan 2001 by Stefan Chekanov
CODBCRecordset class is intended to be a full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
20 Mar 2010 by 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.
19 Aug 2010 by martin.nedopil
Map your database table as network disk
17 Dec 2011 by Matt Perdeck
Proven techniques to speed up expensive SQL queries.
2 Sep 2001 by Rashid Thadha
Use the MS DataGrid control in your C++ app with ADO
26 Jan 2010 by BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
4 Jul 2010 by Amit Kumar Tiwari
This code sends automatic SMS to birthday boys/girls :) from phone
10 Jun 2009 by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
14 Jul 2013 by ThatsAlok
Step by Step creation of SSIS package using C#
4 Jan 2015 by Suffyan Asad
Percolator Analysis Services is a LINQ to MDX ORM that enables writing MDX Queries in LINQ instead of using hard-coded strings of MDX code, resulting in cleaner, easier to read and easier to maintain code.
8 Nov 2018 by Srinivasa Dinesh Parupalli
Importing Documents from SQL Server to Azure Cosmos DB
16 Dec 2011 by Matt Perdeck
In part 1, you saw how to identify missing indexes. In part 3, you'll see how to add those indexes.
7 Apr 2019 by Stefan Timovski
A short tutorial on how to get started with creating SSMS extensions
16 Jan 2005 by Sumit Amar .
Stored procedure to generate INSERT..VALUES statements in SQL Server.
23 Jan 2012 by Dylan Morley
A WinForms UI using WCF services, Entity Framework, repository data access, repository caching, Unit of Work, Dependency Injection, and every other buzz work you can think of!
30 Apr 2017 by Wendelius
This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
23 Mar 2009 by Al-Farooque Shubho
Exploring Set based and Procedural approaches to write better SQL in SQL Server.
23 Aug 2010 by Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
20 Aug 2011 by Kanasz Robert
In this first part of series of articles about database performance optimization I will discuss about indexing strategies and index maintenance.
27 Nov 2012 by CoperNick
This article provides an example solution for presenting data in "real-time" from Microsoft SQL Server in an HTML browser. The article presents how to implement Comet functionality in ASP.NET and how to connect Comet with Query Notification from SQL Server.
30 Jun 2008 by junnark
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
15 Apr 2006 by Raj Lal
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.
28 Apr 2009 by 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.
3 Feb 2016 by DataBytzAI
Useful things to know for developers put in charge of an MS database server
7 Sep 2009 by Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
5 Jun 2005 by smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
1 Mar 2015 by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
23 Jan 2005 by 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.
12 Dec 2014 by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
26 Jun 2015 by Stefan Wloch
An introduction to Custom Roles Based Reporting for ASP.NET MVC applications using the Entity Framework. Protecting confidential information is a business requirement and in many cases also an ethical and legal requirement.
11 Dec 2009 by Abby Fichtner (Hacker Chick)
A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.
26 Nov 2014 by Akhil Mittal
My effort in this article was to put some light on building a generic multilayered architecture using Entity Framework 4.1 and MVC3 razor view engine.
30 Jan 2008 by Sam Shiles
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005
14 Jan 2015 by Helmut Obertanner
In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
13 Nov 2010 by Kanasz Robert
In this first part of the tutorial, I will show you how to create data storage objects (databases, tables, Views ...) using SMO.
4 Oct 2009 by lepipele
Overview of deployment techniques using example WSE 3 enabled solutions
18 Apr 2005 by earmitage
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.
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
27 Aug 2001 by Carlos Antollini
Two classes that make easy to work with ODBC
29 Apr 2009 by Kamran Hazari
How to create Linked servers in a minute in an easy way
9 Jun 2011 by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
31 Oct 2014 by Darek Danielewski
Up until version 1.26 of Dapper, it was not possible to utilize TVP.
13 Aug 2019 by Benktesh Sharma
Demonstrate how to add EF support in .NET Core project
20 May 2012 by Wendelius
This article describes a mechanism how trigger actions bypassed based on database user information
26 Apr 2010 by Stephan Johnson
This article demonstrates a basic Twitter client as a Genesis Hosted Application for the Genesis Smart Client Framework
21 Nov 2011 by Rabb Moshe Plotkin
How to use the Dac Export Service from code
6 Aug 2007 by Omar Al Zabir
Learn about 13 production disasters that can bring down your business
2 Mar 2015 by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
15 Aug 2010 by Shivprasad koirala
ASP.NET authentication and authorization
1 Jan 2010 by Shakeel Iqbal
Manage your daily tasks and To-Do list using some exciting features of Windows 7.
14 Apr 2012 by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a T-Sql perspective
28 Mar 2013 by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
27 Sep 2005 by Mikael Håkansson
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.
4 Aug 2005 by Doga Arinir
Using Microsoft's tracing infrastructure for ODBC.
3 Mar 2014 by Shivprasad koirala
Azure FAQ Part 1
29 Aug 2012 by Shivprasad koirala
Nine simple steps to enable X.509 certificates on WCF.
30 Dec 2007 by Rama Krishna Vavilala
This article builds a web based message board and uses several new technologies introduced with Visual Studio 2008 such as LINQ, WCF Web Programming, WCF Syndication, ASP.NET ListView, ASP.NET DataPager etc.
31 Aug 2014 by Mark J. Caplin
AngularJS and the MVC/MVVM design patterns
12 Mar 2012 by Not Active
A comparison of performance between ADO.NET and Entity Framework.
8 Jan 2011 by dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
27 Feb 2009 by emad_awad
How to use LINQ to SQL in N-Tier architectures.
2 Dec 2009 by Akram Mellice
Generate strongly typed datasets
13 Apr 2009 by shteff
How to do a sort on alphanumeric strings in SQL Server.
1 Sep 2016 by NaibedyaKar
SQL Server database project creation using Visual Studio 2013
8 Nov 2009 by 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.
22 Aug 2014 by Gurdeep Singh Toor
A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.
16 Nov 2007 by pinaldave
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
10 Sep 2004 by mysorian
A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.
9 May 2011 by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
28 Jul 2013 by Dino Konstantopoulos
Running MapReduce in a SQL Server database.
30 Nov 2008 by robertford
How to create simple SQL time zone functions to use in queries.
12 Dec 2009 by Abby Fichtner (Hacker Chick)
A beginner's LINQ tutorial that walks you through mapping your SQL Server database tables and relationships to objects, and how to retrieve that data via simple LINQ queries.
26 Jul 2008 by Shakeel Iqbal
A powerful tool for rapid application development.
30 Jan 2017 by Dan Letecky
How to build an AJAX Event Calendar (Scheduler) using the open-source DayPilot Lite for ASP.NET MVC library (Apache License 2.0).
29 Jan 2009 by Nitesh Maharaj
How to create simple and advanced pivot tables in C# and ASP.NET
22 Jan 2012 by Kanasz Robert
In this fourth part of the tutorial, I will show you how transfer objects and catch trace messages using SMO.
3 Jun 2006 by Shabdar Ghata
Restore/backup selected objects in SQL Server.
10 Sep 2009 by gbd77rc
How to use asynchronous calls to SQL to receive progress information
11 Oct 2011 by Enrique Albert
WPF INotifyPropertyChanged implementation.
8 May 2008 by Danilo Corallo
An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!
4 Sep 2013 by Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
11 Jan 2008 by Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
29 Dec 2010 by santosh poojari
The article provides a code base for implementing dynamic hierarchical data structure with ASP.NET Treeview control
8 Jul 2004 by Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
3 Mar 2008 by Alex Baker
Change collation order for all text columns in a database
7 Mar 2016 by dale.newman
Importing Excel & Delimited Files into a Junk Database
27 Jul 2015 by syed shanu
How to create simple web app using MVC 5, Angular JS, WEB API with stored procedure
4 Jun 2010 by Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
22 Sep 2009 by Nitin Chilka
An article on how to handle deadlock
19 Jun 2012 by Samer M. Abdallah
Access SQL database from iPhone Via WCF and JSON hosted on IIS 7.5
3 Sep 2008 by pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
10 Jan 2006 by darkoman
An article on a simple ODBC SDK wrapper library.
12 Aug 2014 by Thilina Chandima
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
20 Jul 2014 by Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
13 Sep 2008 by Muhammad Shujaat Siddiqi
Grouping Sets, a new feature in T-SQL in SQL Server 2008.
1 Apr 2012 by Torsten Tiedt
Database development with Server Data Tools
27 Nov 2003 by nickadams
A set of classes to encapsulate DB2 CLI APIs in ADO style.
23 Jun 2013 by _Asif_
A Practical approach for implementing Interactive query based systems using MSOLAP
26 Jun 2014 by Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
19 May 2015 by aureolin
Access Stored Procedures using Code First.
1 Nov 2011 by Keshav Singh
CTE In SQL Server
15 Dec 2015 by databaseobjectmodel
A sample infrastructure project such as erp, mrp, crm, admin panel.
16 Mar 2005 by Dan Farino
An Extended Stored Procedure to use regular expressions in T-SQL.
20 Jul 2002 by 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)
18 Aug 2006 by _oti
Automated generation of PostgreSQL data transfer classes.
9 May 2009 by Shivprasad koirala
Eight basic steps by which we can enable Windows authentication security on BasicHttpBinding.
23 Aug 2016 by Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
14 Nov 2004 by Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
14 May 2016 by yuvalsol
POCO generating application for SQL Server
8 Jan 2009 by Paw Jershauge
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
11 Dec 2016 by Wendelius
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
27 Jan 2010 by Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
9 Nov 2012 by Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
7 Jan 2011 by Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
12 Nov 2001 by Anthony Roach
This article is the first of a series OLE DB articles that cover database access using the OLE DB Templates
26 Jun 2008 by HightechRider
Demonstrates SQL Management Objects, LINQ to XML, and more.
16 Oct 2014 by Thomas Yee
How to implement exception logging and trace logging using global MVC filters
29 Dec 2008 by Tomz_KV
Introduces a methodology for authenticating user in cross domain/platform and transferring user data from one site to another during the authentication process.
5 Apr 2020 by DiponRoy
Select data as DataTable object for a database using Entity Framework
5 Feb 2014 by V.
First article on creating a reusable framework
26 Dec 2004 by Gavi Narra
An implementation of Google suggest using remote scripting.
5 Sep 2008 by Niklas Henricson
Migrate MySQL to Microsoft SQL Server in just a few simple steps
28 Jul 2009 by Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
12 Feb 2009 by junnark
We are going to build a simple web chat application using Silverlight 2 and the technologies surrounding it like, ASP.NET 3.5, C#, WCF, and LINQ-to-SQL. We will use MS SQL Server to store user details and messages from this chat room.
20 Nov 2005 by Jason Witty
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.
14 Aug 2012 by Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
18 Oct 2013 by Roger Martin
Gallery Server Pro is a complete, stable ASP.NET gallery for sharing photos, video, audio and other media. This article presents the overall architecture and major features.
5 Jul 2009 by Shivprasad koirala
Optimizing LINQ Queries using DataLoadOptions
16 Jun 2013 by 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 arising from concurrent access to shared data.
10 Oct 2017 by Vincent Maverick Durano
This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core.
18 Dec 2010 by Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
17 Jan 2000 by George Poulose
A tool that allows you to query OLE DB sources
4 Jul 2007 by Padoor Shiras
Automated Windows DTS Package for SQL Server 2005 Database Backup
3 Apr 2013 by Pierre Kellerman
Explaining different ways to join tables
23 May 2012 by Manar Ezzadeen
Create CLR Stored Procedure with Visual Studio Express edition
9 Dec 2009 by Shivprasad koirala
This article has 12 important FAQ’s which covers unit testing, automated testing, data driven test, load/ performance test, code coverage , database testing and ordered testing.
24 Oct 2006 by Jürgen Bäurle
This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.
29 Jun 2006 by _oti
An article and source code regarding the implmentation of B-Trees in C++.
31 Jul 2008 by Anton Ponomarev
By following steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
19 Apr 2007 by Frank Kerrigan
Using SQL Server to do paging of sql results.
12 Feb 2009 by Sandeep Mewara
How to localize the SQL Server Reporting Services Reports
29 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 May 2007 by Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
27 Jul 2007 by Tomas Petricek
CLinq project is a library that makes it possible to use LINQ technologies from the C++/CLI language
31 Aug 2013 by TheCodeKing
Everything you ever wanted to know about why SimpleMembershipProvider does not work as a MembershipProvider.
15 Feb 2010 by Tim Schwallie
A few ways to work with In-Clause and Stored Procedures with SQL Server and C#.
7 Mar 2008 by Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
20 Apr 2008 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
22 Dec 2009 by Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
26 Jul 2015 by Sumit Tech Brain
Fluent Migrator makes the database migration very easy. It is a database migration framework for .NET and uses fluent interface to manipulate database.
6 Jan 2014 by Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
16 Dec 2011 by Keshav Singh
In this video article
7 Jul 2013 by Nikfazan
DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API
30 May 2012 by Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
29 Jun 2011 by michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
9 Sep 2011 by Pieter Van Parys
Explains the principles of profiling a DbProvider using proxy classes.
22 Jun 2009 by SteveHarrisBeast
How to make a password verification form in VB that uses LINQ and SQL
3 Mar 2016 by Gene R. Browning
Get a quick look at your data characteristics using this tool.
10 Mar 2009 by Rudi Breedenraedt
A generic method for attaching detached object graphs to an Entity Framework context
21 Mar 2016 by Dan Letecky
How to display AJAX Gantt Chart in ASP.NET application.
3 Jan 2014 by Sander Rossel
The first of two, everything you need to create the most amazing queries!
15 Jun 2020 by Vadim Loboda
ADO.NET Micro-ORM to SQL Server
24 Jan 2014 by Darey
SQL Server Reporting services forms authentication implementation
4 Nov 2006 by Uwe Keim
An application to manage support request with tickets and events
5 Apr 2016 by SQLMonger
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
23 Nov 2010 by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
18 Aug 2008 by Anton Ponomarev
By following the steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
14 Jun 2017 by
In this article, we will learn how to create/edit Role
8 Feb 2015 by SupperSlonic
The Web API token based authentication via OWIN OAuth2 middleware supported by Facebook, Google, Microsoft.Extracting additional user's information from social networks.
14 Mar 2013 by Shivprasad koirala
In this article I will discuss 5 features of SQL Server 2012 and the rest will be followed in other parts..
11 May 2006 by Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
25 Feb 2011 by Wendelius
This article describes the pseudo column to identify the unique physical location of a single row.
22 Aug 2007 by Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
9 Jan 2009 by Frauke
Tutorial on how to add custom permissions to a module's settings.
9 Sep 2009 by Virat Kothari
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
20 Sep 2006 by DarkLizener
Tutorial on writing your own MySQL User Defines Functions
11 Jan 2012 by Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
7 Sep 2006 by Shahed.Khan
This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today such as C#, .NET 2.0, Microsoft® SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.
9 Aug 2013 by Azim Zahir
This article explains working with SQL Server 2012 Express LocalDB.
2 May 2011 by Keshav Singh
This article focuses on how MS SQL Server uses indexes to read and write data.
25 Jul 2012 by Wusheng Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
14 Jul 2014 by Misha1964
Learn how to validate complex web forms using business rules engine
31 Jul 2005 by _Asif_
Article that helps writing SQL in XML to provide better support
19 Jan 2008 by salysle
An article on how to view a database structure using C#
12 Aug 2010 by Shivprasad koirala
In this article, we will look at how we can do database operations using SilverLight.
15 Feb 2011 by Sadeque Sharif
Easiest way to delete more than one duplicate row from a table in SQL Server
21 Dec 2011 by Uwe Keim
An application that helps you in starting tasks at predefined times and with various dependencies.
30 Aug 2010 by Petr Kozelek
Logging of data changes in relational databases
26 Apr 2008 by Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
27 Apr 2011 by Niladri_Biswas
A program to demonstrate the copy files from one location to another and rename them after putting time stamp by using Sequence Container, Foreach Loop Container, File System Task and Script task
23 Dec 2009 by Dr. Song Li
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.
12 Feb 2009 by Kemal Erdogan
An implementation of role-based authorization control (RBAC) model with row-level access control capabilities at the database server level
12 Jan 2007 by 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.
3 Nov 2012 by Abhishek Sur
The article demonstrates how you can use SQL Server Query Notification feature to get notification from database whenever the result of a command gets changed. Sample application demonstrating SqlDependency and SqlCacheDependency is also included.
11 Oct 2009 by db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
22 Sep 2009 by Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
9 Nov 2021 by Daniele Fontani
That is the question. A comparison between these two technologies and some tips to choose the best that suits your needs.
9 Sep 2011 by ray_mayukh
User friendly query designer and data manipulation tool for SQL Server CE
4 Apr 2006 by Salvatore Vetro
The art of swap from a database to another changing a flag
24 Sep 2010 by David Veeneman
This article discusses how to create a private installation for SQL Compact
9 Jan 2005 by 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.
9 May 2011 by Niladri_Biswas
This article will describe in simple ways as how to work with Pivot and Unpivot transformation component
6 Feb 2017 by Anuja Pawar Indore
Multi-Tenancy means same instance shared amongst all customers.
19 May 2007 by Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
27 Nov 2012 by Tom Cook (UK)
Hook SaveChanges and see exactly what T-SQL is hitting your database without attaching a profiler
4 Sep 2013 by Nandha V
Using a custom exception handler component
13 Nov 2018 by Vlad Neculai Vizitiu
LINQPad - a developer’s best friend
4 Mar 2015 by DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
16 May 2012 by Smitha_Kalakoduvath
How can we configure our foreach loop container, even when the task inside it failed
25 Jan 2017 by Nesreen Maged
Angular 2 Type Script Custom Controls Integrated with ASP.NET Core web API
8 Oct 2010 by Sergey Busel
This article is about the Light Object-Relational Mapping library.
9 Jan 2009 by sudhanvag
Grouping repeated data in a GridView control.
11 Mar 2013 by Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
12 Mar 2014 by Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
28 Sep 2005 by Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
1 Jun 2009 by Dwayne Macadangdang
An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library
7 Oct 2011 by Sunitha Sudheesh
Coding in SQL with Common Table Expressions (CTE)
15 Aug 2004 by Elvin Cheng
Solve the ViewState problems using the industry well-known pattern - Provider Model design pattern.
19 Dec 2012 by Enrique Albert
First draft version of the model, repository, and services.
16 May 2006 by Koushik Biswas
How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++? Think it should be easy to find on the internet or make it work with a little luck? Not before this article was posted!
21 Jul 2014 by 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
17 Oct 2009 by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
4 Nov 2008 by András Slyuch
This article introduces import and export functions between a flat CSV file and a SQL server.
11 Jul 2006 by Chris Tillotson
Convert UTC to local time
5 Mar 2011 by Amir Mahfoozi
This article describes implementing and manipulating a tree structure by means of SQL
7 Mar 2010 by 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.
25 Aug 2012 by Mihail Mateev
One of the highly-anticipated features in the Entity Framework 5 is a Spatial support.
27 Nov 2013 by Tharaka MTR
Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.
25 Dec 2006 by Danilo Mendez
SmartCode is a template based code generator.This tutorial describes the process of building a templates to SmartCode
20 May 2012 by Jigar Bagadai
Easy approach to implement AJAX in ASP.NET without using an AJAX control
10 Oct 2005 by Michael.Piccolo
How to add DataGrid columns dynamically with ITemplate, XML and templated controls.
9 May 2011 by Niladri_Biswas
This article will demonstrate as how to work with SSIS Script component with two live example
17 Aug 2009 by P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
27 Apr 2010 by Stephan Johnson
Read this article if you are new to developing with the Genesis Smart Client Framework. It will guide you through the process of setting up your development environment and executing your first Genesis Hosted Application.
29 Jan 2010 by Alaric Dailey
Working around issues when using SQL Server indexed views.
26 Jul 2008 by Ali Daneshmandi
CLR Function for Persian Date Converter in Microsoft SQL Server
5 Nov 2010 by Enrique Albert
Introducing the RepositoryLocator pattern.
11 Jan 2008 by Irfan Baig
General tips and guidelines for performance improvement
23 Jan 2014 by Christian Graus
The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
31 Jul 2009 by fulcrumweb
This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications
17 Apr 2005 by Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
30 Oct 2009 by mstruys, dougturn
Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.
7 Sep 2019 by Shameel
This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.
27 Sep 2010 by psined
Introduction to Boomerang Framework
27 Feb 2012 by BillLange1968
Solution for creating a Leaderboard for a Windows Phone 7 (WP7) XNA game
13 Dec 2008 by Steve Abraham
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
15 Jan 2014 by Gregory Gadow
Database access and management can be a chore in .Net. This toolbox can make it easier.
23 Jan 2014 by Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
10 Jan 2008 by Shivprasad koirala
An article listing SQL Server Interview Questions
25 Mar 2008 by Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
11 Oct 2011 by Keshav Singh
Views In SQL Server
16 Aug 2010 by Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
28 May 2007 by Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
6 Jan 2010 by Mohammad Dayyan
With Persian Diary, you can navigate in Persian Calendar and store your memorandums
18 Mar 2010 by Mohammad Elsheimy
Learn the details of how to work with SQL Server logins.
23 Dec 2007 by Daniel Cohen Gindi
I have created classes to wrap the SQLite3 library, to remove many headaches...
23 Oct 2006 by Igor Tkachev
Run-time data accessor generation
23 Oct 2005 by Phorozan
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.
5 Jan 2005 by Teo Lachev
Introducing Microsoft Reporting Services.
27 Jun 2013 by Greg Osborne
Validate existence of Sql Server
22 Nov 2004 by Dave Handley
A library of template classes that enables the rapid production of client-side database code.
25 Feb 2014 by Shivprasad koirala
This article will discuss about 11 important database designing rules.
1 Jul 2003 by Saumendra Poddar
SQL Server Transactions and Error Handling
30 May 2007 by Hayder Marzouk
A small framework to design and print documents containing shapes, text, images, bar codes...
30 Dec 2015 by Daniel Miller
This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.
24 Nov 2005 by James Curran
An article on locating MS SQL Server instances on the local network, and retrieving information about them.
26 Jul 2009 by Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
8 Mar 2011 by Keshav Singh
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.
20 Dec 2008 by T MacLachlan
SQL Mirroring made easy - setting up a mirror for a database
7 Sep 2016 by Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
12 May 2011 by santosh poojari
This article will illustrate the approach to open SSRS report in ASP.NET UI using URL command and IFrame Method.
17 Sep 2016 by Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
23 Jan 2014 by Christian Graus
A discussion of ways to create random number sequences in SQL Server
11 May 2011 by Niladri_Biswas
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
1 Apr 2014 by formlesstree4
Another article on C# .NET SQL, but with smarts
24 Sep 2008 by Sandeep Mewara
How to build reports from Report Builder and save it on the Report Server.
9 Mar 2015 by bob.bumsuk.lee
Web app that manages customer complaints and demonstrate how to use Web API, SignalR and AngularJS technologies
16 May 2013 by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
27 Jan 2014 by Kareem.S
This article describes SQL Server Replication
22 May 2006 by Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
23 Feb 2016 by Sreekanth Mothukuru
A look at the free SQL Server Schema Comparison Tool in VS2013
25 May 2008 by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
6 Oct 2018 by Vincent Maverick Durano
A step-by-step demo on how to build and dockerize ASP.NET Core and Blazor apps on MacOS
15 Feb 2002 by Yap Chun Wei
A Class to Read and Write to Excel and Text Delimited Spreadsheet
10 Aug 2009 by Friedrich Brunzema
An article exploring integrating a fingerprint reader into a user's application
17 Jan 2000 by George Poulose
A tool that allows you to query ODBC sources
10 Nov 2014 by x3F
An incremental database upgrade utility for SQL Server.
9 Aug 2009 by Wael R. Mansour
Convert numbers to characters for Arabic applications.
21 Feb 2005 by Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
14 Sep 2006 by ShirleySW
How to use the ASP.NET 2.0 ReportViewer control in Local mode.
28 Mar 2008 by Ivan Svogor
Simple database project, C# frontend for Microsoft Access movie database
2 May 2013 by Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
10 Dec 2018 by Vivek Johari
This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.
9 Jun 2011 by Prasanta_Prince
Gridview inside Gridview in ASP.NET C# or Nested Gridview and Update, Delete from Gridview
13 Feb 2007 by Vlad Hrybok
This article describes how to run DotNetNuke content management system on UltiDev Cassini web server, which unlike IIS can run on Windows XP Home and can be redistributed along with the DotNetNuke applications.
13 Mar 2013 by jchoponis
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.
30 Dec 2013 by Kareem.S
This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers.
29 Aug 2012 by mbarbac
Describes how to use C# dynamics to convert a delegate into an expression tree
20 Aug 2009 by gaurav_verma_mca
How to send bulk data using table value parameters from C#
19 May 2011 by tcassisi
Discusses the limitations and undocumented high DPI printing capabilities of the local WinForms Report Viewer control.
18 May 2008 by defwebserver
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
30 Jul 2012 by mgoad99
Create a SQL Reporting Services report to show the status of all SQL Jobs and drill down to the status of the steps within each job.
26 Aug 2009 by Andy_L_J
Generate unique column values using UDFs and Stored Procedures
28 Feb 2009 by Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
28 Apr 2016 by Sharad Chandra Pyakurel
Generic repository application of employee with documents
18 Dec 2008 by Mycroft Holmes
A workaround for the limitation of only being able to pivot one column.
19 May 2011 by andrewwasfy
An introduction to SQL Server Indexed Views.
17 Jan 2014 by Mubin M. Shaikh
Learn Custom MDX Query Step by Step
24 Dec 2009 by lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
18 Apr 2005 by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
17 Mar 2008 by Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
28 Jul 2008 by John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
4 Mar 2007 by Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
14 Sep 2012 by Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
5 Jan 2013 by Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
22 May 2013 by cesar_boucas
IDataReader implementation illustrated with SqlBulkCopy class usage
30 Oct 2008 by Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
18 Dec 2011 by Matt Perdeck
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.
16 Feb 2015 by DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
28 Oct 2004 by Alexandru Ghiondea
Describes how to upload and download pictures to and from a SQL Server database.
13 Nov 2017 by Haroon Ashraf
This article helps beginners to generate over million records of random test data for a database object like books in SQL.
11 Dec 2007 by Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
16 Aug 2018 by Narapareddy Shyamprasad
SQL Dynamic Pivots
19 Aug 2008 by 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.
11 Aug 2010 by Shivprasad koirala
FAQs about bindings, layouts, consuming WCF services, how to connect to DB through Silverlight
20 Jul 2011 by Mihaly Sogorka
Schedule timed tasks through ASP.NET administration pages.
15 Apr 2008 by Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
16 Oct 2014 by Omar Al Zabir
SQL Server Performance Dashboard (SSPD) is a small open source web app that shows you performance & problems of one or more SQL Server instances and their databases in near real time.
6 Jul 2007 by Nguyen-Thanh-Tung
Use SOAP to communicate with a remote DB Server (Here I use SQL Server) on the Internet and get information or interact with the database
19 Mar 2008 by Dennis Betten
Export all tables and data to an Excel file.
28 Jul 2009 by jpaulino
This article shows some tips to improve Microsoft Reports like embedded reports, showing stored images, and images from a path, using custom code and custom assemblies, exporting reports, and printing reports without the ReportViewer control.
7 Dec 2016 by Kuv Patel
A quick and simple way of generating POCO classes and EF mappings for database tables.
3 Jul 2007 by Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
15 Dec 2011 by Matt Perdeck
In part 2, we'll pinpoint a number of other bottlenecks, including locking issues, lack of execution plan reuse, fragmentation, and hardware issues.
30 Jan 2014 by B. Clay Shannon
Overview and Usage of a Util for testing REST methods
18 Dec 2011 by Jigar Bagadai
Add interactivity to Shopping Cart Using JQuery and ASP.NET MVC
10 Aug 2012 by Patil Kishor
How to save and retrieve an image from a SQL Server database in VB.NET.
22 Dec 2008 by Neeraj Kr
Provides an insight into creating automated process for Backups and Restorations
10 Feb 2009 by ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
8 May 2001 by George Poulose
A tool to generate class files to implement stored procedures
2 Oct 2008 by Andrew J Dixon
Explaining Database deadlocking to non-technical people
7 Jun 2007 by hoquet
A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.
15 Oct 2010 by Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
13 May 2005 by Anand Santhanam
In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.
4 Jan 2008 by Mustafa Ismail Mustafa
An alternative approach to blogging engines
31 Oct 2008 by Todd Smith
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.
6 Nov 2006 by adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
8 Dec 2008 by Anas Karkoukli
A new implementation of the Custom Profile Provider for ASP.NET 3.5, using LINQ, Workflow Foundation, and the Responsibility-Centric-Singleton DataContexts pattern.
3 Mar 2016 by Eric Lapouge
An other way to export data from a SQL-Server to use them to call a web service
28 May 2009 by Matt Sollars
How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.
4 Oct 2013 by Mubin M. Shaikh
Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
13 Feb 2004 by Reza_Allamehzadeh
How to pass an array of integers to a stored procedure.
19 May 2011 by Niladri_Biswas
In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS
19 May 2011 by 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
6 May 2008 by 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.
30 Oct 2009 by Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
23 Jan 2016 by Shashangka Shekhar
In this article we will get a short overview on AngularJS, then we will create a ASP.Net MVC-5 CRUD application using AngularJS(v1.4.8).
9 Dec 2019 by Kanishka Basak
Analysis and troubleshooting a database performance bottleneck
10 Jun 2009 by Robin_Roy
MS SQL Server 2008 new feature, Table Value Parameter.
9 Oct 2009 by Sujit Mandal
Backup System Databases in SQL Server
6 Apr 2010 by Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
30 Mar 2011 by Frank Kerrigan
SQL Server domain modeling with Oslo CTP and the "M" language.
28 Aug 2008 by Muhammad Shujaat Siddiqi
19 Sep 2009 by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
16 Apr 2010 by Christopher Liu
When you copy a row with a primary key, bring other tables that reference it along for the ride!
2 Apr 2012 by Keshav Singh
This is a technical article for new bees on how to upload/update/download files (picture/mp3/excel/doc) into sql server database.
16 Aug 2012 by Andy Taw
Setting up a lightweight audit function for a SQL Server db.
10 Dec 2017 by Steven L. Wentworth (12896862)
Straightforward generation of and ensuring accuracy for DimDate values
25 Oct 2008 by Mohamed Zaki
This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.
11 Jun 2013 by Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
9 Nov 2006 by Howard Richards
Techniques for using the XML data type for storing data.
13 Feb 2009 by SHRIDHAR TL
Allows to maintain and backup your contacts and also maintains a reminder. You can store data in any of the three different databases like Microsoft SQL Server, MySql, Microsoft Access
25 May 2015 by Acharya Raja Sekhar
This tool helps in cloning/copying the database from a source environment/server to a target server (usually developers can use it for setting up local DB with production code)
25 Sep 2019 by Edwig Huisman
A hibernate framework for C++
12 Jan 2000 by Alexander Mikula
A discussion and demonstration of reading Excel files using ODBC
25 Jan 2016 by Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
23 Jun 2021 by Shivprasad koirala
6 steps to enable transactions in WCF
12 Jun 2005 by Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
16 Oct 2006 by Sean Goodpasture
An article describing a way to find the differences between two database instances
12 Jan 2014 by Christian Graus
Ways to pass an arbitrary list of values to SQL Server
12 Dec 2006 by ShirleySW
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
27 Jan 2006 by Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
11 Mar 2007 by Mohammad Akbarizadegan
This article demonstrates how to implement web applications based on AJAX and ClientScriptCallBack as it presents a simple example. Also, the article tries to point at the key features of working with ASP.NET ClientCallback and AJAX.
7 Feb 2005 by BlackDice
A tool for querying all types of databases.
17 Jul 2007 by Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
5 Sep 2004 by Jose A. Gonzalvo
A small command prompt utility to help you document your SQL Server/MSDE database
1 Sep 2011 by Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
9 Jan 2016 by Snorri Kristjansson
Active Directory change auditing solution. A Windows Service that stores selected AD change events from the Security log of all Domain Controllers to an SQL database.
27 Apr 2011 by Roger Martin
Complete, production-ready Membership, Role, and Profile providers for SQLite. Includes instructions for migrating data between SQL Server and SQLite.
14 Sep 2008 by Steven A. Lowe
Dashboards are immensely useful not only for business data but also for business applications, but only if they display metrics that can be used to "drive" (or "steer") in real-time.
29 Apr 2013 by Dan Kearney
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.
17 Oct 2007 by Rohit Gadagkar
A discussion about architectural patterns for using LINQ to SQL in enterprise applications, along with performance implications
1 Feb 2012 by Ashish Tripathi
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.
30 Jul 2005 by Klaus Salchner (Canada)
Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.
13 Feb 2006 by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
19 Dec 2011 by Matt Perdeck
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 2002 by dapeng lin
An article on using parameterized SQL statement and stored procedure with ODBC
9 Dec 2016 by Riccardo Cervelli
Redraw database structure to improve productivity
16 Aug 2012 by 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.
15 Oct 2007 by Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
21 Aug 2007 by Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
29 Nov 2010 by Shahriar Iqbal Chowdhury/Galib
Easy approach to implement bulk CRUD operation using Xquery, reflection in ASP.NET with example
19 Jul 2006 by Dan Radu
This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.
19 Aug 2003 by AnOldGreenHorn
An easy to use C++ wrapper class for ODBC.
20 Mar 2013 by MdAsifBd
Repository Pattern with Entity Framework using EntityTypeConfiguration
2 Sep 2016 by JamesAmos
Microsoft .NET 4.5 introduced new "async and await" methods to provide an easy way of implementing asynchronisity using .NET tasks objects.
24 Jan 2007 by Kadir Camoglu.
An article about copying data to SQL within your application
15 Feb 2007 by Ben Allfree
Learn how to store data with a version history.
12 Dec 2006 by ShirleySW
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
13 Jan 2007 by AnOldGreenHorn
A C++ wrapper to SQLite database
3 Sep 2008 by Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
31 Jan 2010 by skennedyny
Simple console app which shows how to use the .NET CommittableTransaction class
23 Jan 2008 by Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
16 Sep 2013 by Bruno Terkaly
This post will cover the whole spectrum of downloading data from a government site, loading it into an on premise SQL Server database, migrating this on premise SQL Server database to SQL database in Windows Azure.
8 Mar 2011 by Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
3 Aug 2011 by Niladri_Biswas
In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple
22 Aug 2011 by RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
29 Nov 2019 by Weifen Luo
The new way to develop LOB applications
27 Sep 2010 by venugopalm
A guided tour of the distributed enterprise application design in .NET
7 Aug 2009 by Md. Marufuzzaman
Overview of SQL Server database Triggers
28 Jun 2006 by Not Active
Using SQL Server 2005 and SqlDependency to keep your application's data updated.
29 Mar 2001 by zhaque
This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class
6 Nov 2007 by Navdeep Bhardwaj
Concatenate field values in one string using CTE in SQL Server.
22 Mar 2006 by Michael Vanhoutte
This article explains how to give a user the minimum rights required for SqlDependency to work
15 Nov 2010 by venugopalm
Database and Library Design for Customer Order Management System
23 Feb 2005 by Ken Mazaika
An object oriented OpenGL particle engine, for the simple creation of advanced particle effects.
2 Oct 2004 by Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
20 Feb 2006 by PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
27 Nov 2013 by 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.
10 Jun 2001 by M. Shokuie Nia
A simple introduction to using ADO
23 Sep 2005 by Mike Ellison
An approach to creating an aggregate report with a set of dynamic columns based on dates.
22 May 2008 by aleksisa
Developing Facebook Application with .NET - part 2 - FBML tabs, setFBML, FB:multi-friend-selector, setRefHandle, PublishAction and much more...
21 Jan 2008 by Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
8 Jun 2008 by Evaldas Jocys
Provides required tables and data for multilanguage projects
22 Sep 2009 by Niladri_Biswas
Access multiple databases by a single SSRS report.
18 Aug 2016 by Vincent Maverick Durano
A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.
4 Oct 2009 by Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
13 Jan 2014 by Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
18 Jan 2014 by John Bhatt
Let's learn how to make a scrollable GridView and Fix headers with simple steps.
12 Jan 2000 by Alexander Mikula
Writing to Excel spreadsheets using only ODBC
9 Nov 2012 by Ashrafur Rahaman
From this article, developers will get some useful guidelines on bulk data insertion in SQL Server.
26 Jun 2012 by tanweer
Easy way to implement ASP.NET GridView paging .
4 Jun 2006 by r.stropek
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.
30 May 2012 by Joshi, Rushikesh
Retrieve hierarchical data from database in effective way!
16 Nov 2009 by Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
8 Nov 2002 by Daniel Turini
SQL Server database best practices
13 Nov 2007 by Bruce Chapman DNN
Writing a SQL script to generate insert or update scripts for a table full of data.
9 Nov 2013 by Damijan Vodopivec
Sample Code First project with SQL CE 4.0 database
3 Mar 2006 by Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
21 May 2012 by Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
8 Nov 2007 by John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
1 Sep 2011 by Niladri_Biswas
In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective
22 Jun 2010 by gstolarov
Geocoding with SQL-Server
11 Nov 2014 by Bert O Neill
Create unit tests for your stored procedures\triggers\functions and integrate into TFS continuous integration cycle
16 Aug 2012 by scott_liu
It employs a dynamic trigger, a CLR Stored Procedure, and a Web Service to sync data from a MS SQL Server to MySQL.
17 Jun 2007 by Geek2Simon
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
11 Jun 2008 by Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
16 Mar 2009 by junnark
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
15 Jul 2019 by DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
10 Jun 2009 by Robin_Roy
Microsoft SQL Server 2008 new feature, Merge Statement
18 Mar 2008 by Jason Witty
In this article I walk through an example that binds a gridview control to an ObjectDataSource and uses Linq queries to paginate to achieve true data pagination.
22 Sep 2016 by Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
10 Jun 2007 by Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
22 May 2009 by Md. Marufuzzaman
An easy technique to store any file into SQL database
1 Dec 2005 by Shahed.Khan, David.Grinberg
This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.
16 Sep 2008 by santosh poojari
This article demonstrate the step by step procedure to create SSIS Package and Execute the same using
11 Sep 2008 by George Tryfonas
An on-screen visualizer for the SQL Geometry type
11 Oct 2004 by Rajesh Pillai
This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.
12 Oct 2013 by Dr. Song Li
This is the part 3 of a comparison on Data Access methods in the .NET environment.
21 Oct 2005 by perlmunger
This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.
17 May 2002 by Adrian Bacaianu
How to perform different computations for each row of a certain table, with each computation involving several columns.
10 Sep 2004 by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
31 Mar 2006 by Nagasai Mattegunta
An article on Database Driven Dynamic multiple Treeviews
5 Apr 2006 by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
19 Jun 2013 by Mayank Dubey
XQuery basics.
20 Jul 2007 by Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
16 Dec 2011 by perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
3 Dec 2001 by Rashid Thadha
Show a progress dialog when you execute your DTS Package at runtime.
5 Dec 2011 by snp157
Controlling IP traffic from Internet to DMZ or Intranet
3 May 2005 by Stephen Huen
Review of MCMS Connector for SharePoint Technologies.
25 Nov 2005 by Tommi G
How to create runtime backups from SQL Server 2005 and restore them.
28 May 2007 by 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.
12 Jul 2007 by Vishu Gurav
AJAX, ASP Suggest like page using
3 Aug 2009 by senguptaamlan
This article and code sample briefly describe the creation of User Defined Function in SQL Server 2005 by using CLR Hosting Feature
19 Feb 2011 by Christopher R Davis
How to use the nHydrate ADO.NET generator and keep your database in sync.
23 May 2012 by Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
11 May 2009 by GrapeCity-Inc
Boundaries between .NET reporting and business intelligence are fast blurring and customer expectations are high. Developers who opt for mature, cross-functional .NET reporting tools can hope to exceed present and future needs of their customers. Today, over 50,000 developers are using the ActiveRep
26 Nov 2012 by Ashrafur Rahaman
This article will give you an overview of how to use an ASP.NET GridView completely, and how to use RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination in a DataGrid. From this article, you will have a clear view of GridView data inserting, deleting, and
10 Dec 2007 by Le Sourcier
How to use LINQ to SQL
16 Jul 2005 by TylerBrinks
Geo-Locating C# Smart Client Application using the 2.0 Framework
23 Nov 2007 by adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
24 Oct 2012 by Enrique Albert
Generic transaction and exception manager for server side services
24 Oct 2013 by Mehdy Moini
Iteration without curser is one of database programmig arts, in this article i have tried to calculate exponential function with taylor series
19 Aug 2009 by 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.
8 Jun 2010 by Evoluteur
Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.
28 Nov 2005 by Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
18 May 2006 by Dimitar Madjarov
How to use a WebService as a data source to build a report with Microsoft Reporting Services 2005.
20 Nov 2007 by BoneSoft
Describes a method for loading data objects using SQL Server 2005's new FOR XML PATH mode and XML serialization.
16 Jan 2008 by Bryan Avery
I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Server 2005, both on the server and for use within your development environment.
28 Jun 2008 by Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
23 Feb 2008 by Nanaa
An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.
11 Oct 2011 by GraemeKMiller
This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.
16 Jul 2009 by Shivprasad koirala
Tips to improve your LINQ query performance.
12 Jun 2007 by Psycho-*Coder*-Extreme
This article covers pitfalls found while doing a merge replication in SQL 2000
10 Feb 2011 by KarthikAnbarasan
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
14 Jul 2011 by pinaldave
5 Database Worst Practices which can be fatal to any business
7 Mar 2017 by csharpbd
Data transfer tools to transfer data and database scripts between two SQL Server databases
12 Oct 2007 by Vincent-Philippe Lauzon
Using XML data types in SQL Server 2005, we can pass an array of values from an application server to the database.
28 Feb 2011 by Keshav Singh
Monitoring Free Space on Microsoft SQL Server
23 Apr 2009 by krysstof
Tool developped to manage and analyse disk space on multiple fileserver in my company
28 Jul 2009 by Slava Khristich
How to deliver GPS data asynchronously to the server over the internet without queues.
8 Jul 2011 by Dr Bob
SQL Server ISS can simplify database mirrors across multiple vendors
15 Aug 2009 by Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
5 Apr 2010 by 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.
15 Jan 2012 by Venkat Chaitanya Kanumukula
Export SQL Server Tables to Excel Files Dynamically
24 May 2017 by Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
14 Jun 2011 by Keshav Singh
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.
8 Mar 2006 by Brian Bayless
A central key manager for multiple web server clients in a web farm.
9 Jan 2008 by Muigai Mwaura
An article on LINQ To SQL Transformations.
2 Jun 2003 by Ferdie
Using ADOX to insert field into a MS Access table.
1 Jun 2014 by
In this article, I am going to demonstrate how to get more data on demand i.e. On every click of button fetch more records from SQL Server database table and load in GridView with wait/progress/loading image as shown in image in ASP.NET using both C# and VB languages.
10 May 2007 by FrankNight
The article shows how to use SQL features of Microsoft LogParser with ADO.NET
3 Jul 2016 by Shashangka Shekhar
In this article, we are going to explore the security issue which will help us to prevent unauthorized access of web API access using custom Authorization Filter.
19 Sep 2005 by msalmank
A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....
1 Feb 2006 by rajiv404
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.
20 Sep 2005 by Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
9 Dec 2005 by Todd Denlinger
Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.
10 Dec 2012 by Vijay Tanwar
N-Tier application with WCF Odata service and Entity Framework.
23 Jul 2007 by Benedict Chan
Using .NET 2.0 to get the SQL Server schema and generate insertion statements.
23 Jun 2011 by Keshav Singh
An article on replication in MS SQL Server