Click here to Skip to main content
14,544,533 members

SQL-Server

Great Reads

by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Jovan Popovic(MSFT)
Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.
by Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Latest Articles

by Theo Kand
An original AngularJS implementation of the most famous video game ever
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.
by DiponRoy
Store all data change history in a table using Entity Framework Core
by Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#

All Articles

Sort by Updated

SQL-Server 

28 Nov 2011
Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
8 Sep 2005
Member 2260574
Connect and close a sql database with internal error reporting using Event Logs
2 Jul 2008
Member 3209760
Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document
27 Mar 2015
Member 11459717
An application used to manage applications which are categorized by functionality which also prioritizes tasks necessary to manage a household. The application is back-end managed, controlled and operated through Microsoft's Azure cloud platform.
17 Mar 2000
Daniel Kaminski
A class used to serialize object into a database field
26 Oct 2000
John Bevilaqua
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
4 Nov 2003
Megan Forbes
A short article on recovering orphaned users when moving a database from one server to another.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Architecture and design decisions
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Job Scheduling Code
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - How Packages Are Run
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - The CSV and Excel Importer Code
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
27 Feb 2018
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
25 Sep 2012
_Amy
Dynamic menu generation according to user privileges from database.
23 Jun 2013
_Asif_
A Practical approach for implementing Interactive query based systems using MSOLAP
6 Dec 2016
_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.
4 Jul 2007
_JERKER_
Example of implementing many-to-many multiple choice functionality the declarative way.
18 Aug 2006
_oti
Automated generation of PostgreSQL data transfer classes.
29 Jun 2006
_oti
An article and source code regarding the implmentation of B-Trees in C++.
27 May 2006
| Muhammad Waqas Butt |
Show Crystal Report On Selection Base
9 Oct 2008
R. Giskard Reventlov
Simple export of data from database a to database b using identical tables (SQL Server).
26 Jun 2013
ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
14 Jul 2013
ThatsAlok
Step by Step creation of SSIS package using C#
9 Oct 2018
Akhil Mittal
The intent of this article is to explain the concept of entity framework core, code first migrations and data annotations in entity framework core.
1 Mar 2016
Akhil Mittal
Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.
26 Nov 2014
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.
2 Nov 2019
Alaa Ben Fatma
Explore your MMSQL server tables in a professional way
2 Jul 2019
DiponRoy
Creating CLR in SQL Server
11 Jul 2019
DiponRoy
Populating DateTime range in SQL Server
15 Jul 2019
DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
5 Apr 2020
DiponRoy
Select data as DataTable object for a database using Entity Framework
4 Mar 2015
DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
11 Apr 2020
DiponRoy
Store all data change history in a table using Entity Framework Core
27 May 2019
DiponRoy
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
10 Feb 2009
Eddy Vluggen
How to import a database-dump from GeoNames.org into SQL Server
29 Mar 2015
Manoj K Bhoir
Lookup web user control with some basic properties and functionalities
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
27 Jul 2009
Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
18 Nov 2008
Shivprasad koirala
RFC Architecture for Finance Projects (The Invoicing Part)
20 Aug 2008
Shivprasad koirala
Some caching interview questions: Part 1.
12 Sep 2013
Shivprasad koirala
ADO.NET interview questions: Part 2.
9 May 2009
Shivprasad koirala
Eight basic steps by which we can enable Windows authentication security on BasicHttpBinding.
9 Aug 2009
Shivprasad koirala
In this article, we will understand the WCF transaction protocol, the two phases in WCF transactions, transaction options, and finally simple samples for WCF transactions.
5 Jul 2009
Shivprasad koirala
One-many and one-one relationships using LINQ to SQL.
7 Jul 2009
Shivprasad koirala
Six simple steps to use a Stored Procedure in LINQ.
11 Jul 2009
Shivprasad koirala
CRUD operations using LINQ Entities
28 Jul 2009
Shivprasad koirala
This FAQ article is dedicated to LINQ to SQL.
11 Aug 2010
Shivprasad koirala
This article discusses 12 FAQ’s which revolve around bindings, layouts, consuming WCF services and how to connect to database through Silverlight.
16 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
10 Jan 2008
Shivprasad koirala
An article listing SQL Server Interview Questions
14 Mar 2013
Shivprasad koirala
In this article I will discuss 5 features of SQL Server 2012 and the rest will be followed in other parts..
25 Feb 2014
Shivprasad koirala
This article will discuss about 11 important database designing rules.
7 Sep 2012
Shivprasad koirala
This article will discuss about SQL Server governer.
5 Mar 2014
Shivprasad koirala
Steps to use a logging utility in your projects using Application Blocks.
9 Dec 2009
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.
9 Nov 2008
Shivprasad koirala
A quick FAQ of Agile.
12 Aug 2010
Shivprasad koirala
In this article, we will look at how we can do database operations using SilverLight.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
26 Jul 2009
Shivprasad koirala
How to migrate simple .NET classes to LINQ classes.
29 Aug 2012
Shivprasad koirala
Nine simple steps to enable X.509 certificates on WCF.
9 Oct 2009
Sujit Mandal
Backup System Databases in SQL Server
26 Jun 2012
tanweer
Easy way to implement ASP.NET GridView paging .
12 Apr 2016
DataBytzAI
How to bring CSV and XML data into MS SQL server
3 Feb 2016
DataBytzAI
Useful things to know for developers put in charge of an MS database server
12 Apr 2018
Saineshwar Bageri
In this article, we are going to learn how to create a simple API in Node.js and using MS SQL as a data source on which we are going to perform CRUD operation.
12 Feb 2009
Sandeep Mewara
How to localize the SQL Server Reporting Services Reports
24 Sep 2008
Sandeep Mewara
How to build reports from Report Builder and save it on the Report Server.
4 Oct 2009
Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
22 Aug 2007
Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
11 Jan 2009
6opuc
Fast and easy to use data access class library.
23 Oct 2008
aakanksh
Some useful tips on using Reporting Services
11 Dec 2009
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.
12 Dec 2009
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.
11 Dec 2009
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.
9 Nov 2012
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.
16 Aug 2012
Abdul Quader Mamun
Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.
4 Aug 2010
Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
13 Apr 2010
Abdul_Rafay
SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
21 Feb 2016
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.
23 Dec 2003
Abhay Dubey
This procedure can be called in another Stored procedure or function and quite handy in debugging and development
25 Oct 2008
Abhijit Jana
Overview of Log Shipping in SQL Server 2005
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
15 Aug 2009
Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
28 Jul 2009
Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
22 Feb 2008
Abhijit Jana
SQL Server Profiler Step by Step: SQL Server 2005
9 Sep 2010
Abhijit Mahato
This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
2 Aug 2009
Abhishek Sur
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
3 Nov 2012
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.
30 Sep 2005
Abi Bellamkonda
ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper
5 Oct 2005
Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
27 Sep 2009
acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
25 May 2015
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)
7 Jun 2007
Adam Hurwitz
Using a modified Adjacency List model in SQL, can you retrieve a depth-wise ordered subtree?
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
19 Mar 2007
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.
13 Jun 2017
Adam O'Neil (Travelers Rest, SC)
Introduction to Postulate, a code-first ORM for SQL Server made with Dapper
16 Oct 2007
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.
6 Nov 2006
adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
23 Nov 2007
adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
28 Sep 2007
AdamNThompson
Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.
31 Mar 2006
Addison-Wesley
This chapter covers what's new in enterprise database administration. It doesn't just look at the product from a feature list, but groups the features according to some tasks common to database administration.
4 May 2004
Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
17 Apr 2009
Adnan Faisal
In this article, we will learn how to create a JavaScript popup window, how to use the MultiView control to move between two views, and also to use the GridView control with paging.
19 May 2002
Adrian Bacaianu
This article shows how to use directly in your Microsoft SQL, an extended stored procedure that makes conversions between Unicode and code page data.
17 May 2002
Adrian Bacaianu
How to perform different computations for each row of a certain table, with each computation involving several columns.
8 Mar 2009
Adrian Pasik
This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.
11 Aug 2014
Afzaal Ahmad Zeeshan
This article explains how you can use ASP.NET (C#) and search for related queries in your Database.
30 Jan 2006
Agha.net
This is a series of articles providing Building Blocks for any ASP.NET application.
30 Aug 2008
Ahmad Eid Salim
Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of a database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the source database.
29 Oct 2008
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.
25 May 2008
Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
3 Sep 2008
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.
19 Apr 2005
Ahmed_EL Sayed
How to set up SQL Server Integrated Security for using with SMS.
1 Apr 2009
Ahmet Göktaş
T-SQL string maker for backup with a MEDIAPASSWORD database.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
29 Jul 2014
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.
16 Jun 2010
Akbar Ali Bhatti
Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
24 Jun 2008
akjoshi
Implementing a tab control like structure in SQL Server 2005 reporting services report using tables and text boxes
28 Sep 2005
Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
2 Dec 2009
Akram Mellice
Generate strongly typed datasets
29 Jan 2010
Alaric Dailey
Working around issues when using SQL Server indexed views.
7 Aug 2007
albert arul prakash
XSS gaining popularity to hack into websites. This article describes how to power yourself against XSS
20 Jul 2005
Albert Pascual
I wrote this short article to improve your ASP.NET application Sessions using Cache.
10 May 2012
Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
23 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
2 Oct 2004
Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
14 Feb 2005
Alberto Venditti
An alternative and flexible way to manage config settings for multiple web applications.
20 Dec 2010
Albin Abel
Simple Pattern Matching Technique for Search Suggest Boxes
3 Mar 2009
Alden John Snow
This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.
23 May 2017
Alejandro Xalabarder
An efficient and flexible layout manager
10 Jun 2013
Aleksei Tuiman
Data extraction from XML fields with different namespaces
13 Mar 2008
aleksisa
Build simple and sophisticated Facebook Apps with FBML, ASP.NET
22 May 2008
aleksisa
Developing Facebook Application with .NET - part 2 - FBML tabs, setFBML, FB:multi-friend-selector, setRefHandle, PublishAction and much more...
27 May 2016
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
10 Aug 2015
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.
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
19 Jan 2010
alex turner
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
14 Jan 2010
alex turner
They might seem like just another not entirely required feature, but actually table variables are a very handy extension to SQL Server
3 Jul 2011
Alexander Galkin
Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.
19 Nov 2004
Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
7 Mar 2008
Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
12 Jan 2000
Alexander Mikula
Writing to Excel spreadsheets using only ODBC
12 Jan 2000
Alexander Mikula
A discussion and demonstration of reading Excel files using ODBC
25 Sep 2007
Alexander Nowak
In SSRS2005, a new provider is available: XML Data provider. This enables you to create reports from ADO.NET datasets or XML documents from URL-addressable resources, e.g. Web services. This article shows a step-by-step example (basic report, no parameters) how to use this new SSRS 2005 feature.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
12 Mar 2003
Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
16 Aug 2016
Alexandros Pappas
An SQL script to see the table hierarchy in a database.
27 Jun 2011
Alexandros Pappas
This tool reads the descriptions of the columns of the SQL server and creates a Word document using SoftArtisans' WordWriter.
22 Sep 2016
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.
4 Jan 2010
Alexandru Cibotari
Set based and procedural approaches in examples tested on SQL Server 2008
28 Oct 2004
Alexandru Ghiondea
Describes how to upload and download pictures to and from a SQL Server database.
13 Jun 2011
AlexCode
Converting INTs to BINARY in SQL Server
13 Mar 2008
Alexei Fimine
Shows how to set various styles to rows in MS SQL Reporting Services reports based on row sequence or on data.
7 Jul 2009
Alexei Fimine
SQL code to traverse self-referencing tables with parent-child relationships. Recursive SQL written without special proprietary commands.
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
8 Jun 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using some advanced indexing techniques and using de-normalizations to optimize data access.
8 Nov 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps, this article focuses on diagnosing performance problems in SQL Server.
23 Mar 2009
Al-Farooque Shubho
Exploring Set based and Procedural approaches to write better SQL in SQL Server.
28 Apr 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using indexing to optimize data access.
1 Jun 2009
Al-Farooque Shubho
As part of a series of articles on data access optimization steps in SQL Server, this article focuses on refactoring and applying TSQL best practices to improve performance.
8 Nov 2009
Al-Farooque Shubho
As part of a series of articles on several data access optimization steps, this article focuses on organizing files/file-groups and applying partitioning in SQL Server databases.
16 Jan 2009
Alfredo_Fernandez
Performance comparison - Identity() x NewId() x NewSequentialId.
26 Jul 2008
Ali Daneshmandi
CLR Function for Persian Date Converter in Microsoft SQL Server
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
21 Mar 2006
Ali Khan (OKC)
This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.
6 Feb 2010
Ali Marzban
Changing ConnectionString like an attribute in C#
7 Oct 2007
Ali Ozgur
Sample code describing how to retreive statistical information about the T-SQL commands executed.
1 Feb 2007
Ali Ozgur
This article describes how NHSessionManager can be configured to use multiple NHibernate assemblies
2 Feb 2007
Ali Ozgur
How to create DaoFactory instances with Castle/MikroKernel in NHibernate applications
15 Jun 2007
alifaraze
A trick to use config file for Custom assembly in reporting services
21 Feb 2005
Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
30 Sep 2008
alon1980
An open source password manager with some advanced features and cool interface
20 Mar 2010
Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2
A Windows Mobile C# reader for the popular Password Safe archive files.