Click here to Skip to main content
15,614,270 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 Andriy Protskiv
Workaround for performance issues with AT TIME ZONE
by Venkat Chaitanya Kanumukula
Tableau is one of the powerful reporting tool which is on the market for over a decade. Here's a quick tour in designing BI reports with Tableau using Microsoft Dynamics AX 2012 R3/ Microsoft Dynamics 365 Finance and Operations.
by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
by Sergei Y.Kitáev
Introduction to statically parameterized SQL language

All Articles

Sort by Title

SQL Server 

16 Aug 2010 by Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
26 Jul 2008 by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database
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
24 May 2007 by Liam Cavanagh
The purpose of this article is to help get a user started in building a mobile database application using SQL Anywhere and Visual Studio .NET (C#)
22 Dec 2011 by Keshav Singh
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
25 Feb 2014 by Shivprasad koirala
This article will discuss about 11 important database designing rules.
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.
6 Aug 2007 by Omar Al Zabir
Learn about 13 production disasters that can bring down your business
16 Mar 2011 by dingoishere
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.
11 Jan 2006 by Petr Palas
Did you know there’s an easier way how to create dynamic web sites? Learn how Kentico CMS for ASP.NET will increase your productivity and help you win more clients.
23 Jun 2021 by Shivprasad koirala
6 steps to enable transactions in WCF
20 May 2010 by Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
23 May 2007 by Petr Palas
What is a content management system? Does it really work? Why should I use it? How does it help me? This article answers the most common questions developers ask about content management systems (CMS).
12 Aug 2010 by Shivprasad koirala
In this article, we will look at how we can do database operations using SilverLight.
26 Feb 2014 by Shivprasad koirala
7 simple steps to run your first Azure Blob Program
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
1 Oct 2009 by Deepankar Malik
Generates SQL Server Stored Procedure and Table Defination Scripts
15 Aug 2009 by Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
12 Oct 2013 by Dr. Song Li
This is the part 3 of a comparison on Data Access methods in the .NET environment.
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.
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.
20 May 2005 by zhengdong jin
It's very easy to use and the most conventient DataGrid pager control.
11 May 2007 by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
30 Aug 2009 by marcominas
A Windows Service that uses interface to work like the Linux Crontab service
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.
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
8 Apr 2020 by Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
14 Apr 2005 by poodull76
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
6 Apr 2005 by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
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....
10 Sep 2004 by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
28 Jun 2008 by Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
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.
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.
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.
25 Nov 2005 by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
9 Mar 2011 by santosh poojari
This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis
26 Jan 2021 by Kemal Erdogan
Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases
16 Jan 2008 by Robert Pittenger, MCPD-EAD
This article presents a naming scheme for database tables and fields.
5 Jun 2007 by Fadrian Sudaman
This article shows how to easily extend the GridView to support custom paging and remove the restriction of using ObjectDataSource as the data source.
21 Jun 2004 by gamitech
A not so simple firewall if I can call it so. This application will ask you if you want a certain program to start.
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.
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.
22 Jul 2008 by Mike Borozdin
Tutorial on using LINQ, ListView, LinqDataSource, DataPager, ASP.NET AJAX
19 Sep 2009 by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
26 Jan 2016 by Jörgen Andersson
A propertymapping extension for DataReaders
20 Mar 2006 by Naveen Karamchetti
This article describes the new functoids in BizTalk Server 2006.
10 May 2012 by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
12 Sep 2003 by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
6 Sep 2005 by Carlos Antollini
Simple database access using an ADO class.
19 Jun 2002 by Carlos Antollini
Simple database catalog access using a set of ADOX classes
16 May 2013 by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
27 Aug 2001 by Carlos Antollini
Two classes that make easy to work with ODBC
10 Jun 2005 by Paul S Ganney
A class to easily do count() queries.
18 Apr 2005 by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
25 May 2008 by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
28 Apr 2005 by Stephan Pilz
A tool to generate/manage news and provide news via RSS.
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.
20 Oct 2005 by codeajay
A simplified SQL-CSV import/export functionality.
20 Apr 2008 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
6 Jan 2012 by Keshav Singh
This video demonstrates a standard extract-transform-load in SSIS
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.
26 Feb 2009 by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
26 Jul 2009 by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
26 Sep 2006 by code-frog
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
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.
23 May 2007 by vipulparmar
9 Aug 2012 by Wendelius
Article describes basic information about transaction log behavior and truncation of the log.
18 Jan 2014 by Petr Ivankov
Application of abstract approach to database domain
8 Jul 2013 by JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
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.
8 Oct 2006 by Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
8 Oct 2006 by Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
1 Jul 2003 by thomask
2 Mar 2003 by CT CHANG
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
26 Mar 2007 by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
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
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.
17 Sep 2016 by Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
25 Apr 2009 by yairrose
Active directory tool - helps manage active directory oparations (query, update and delete) with easy to use GUI
29 Jun 2011 by michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
2 Aug 2003 by xiaojin
The article explains adding a user in SQL Server programmatically, using VC++
15 Dec 2010 by hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
31 Jan 2006 by arunpv
Add/drop Linked Servers using SQL Server 2005 SMO
30 Oct 2008 by Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
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.
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.
13 Aug 2019 by Benktesh Sharma
Demonstrate how to add EF support in .NET Core project
6 Jun 2007 by Ganesan Sankaran
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
18 Feb 2005 by rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
10 Jun 2001 by M. Shokuie Nia
A simple introduction to using ADO
23 Jul 2002 by Carlos Antollini
A list of ODBC DSN Connection Strings.
27 Sep 2000 by Ly Nguyen
11 Aug 2002 by Tim Kohler
ADO classes that closely resemble CDatabase and CRecordset.