Click here to Skip to main content
14,033,822 members

SQL-Server-2008

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
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.
by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.

Latest Articles

by Mahsa Hassankashi
Best approach for have more secure channel to transfer user information throughout the web
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.
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
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.

All Articles

Sort by Updated

SQL-Server-2008 

11 Jan 2009
6opuc
Fast and easy to use data access class library.
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.
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.
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.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
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.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
28 Sep 2009
acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
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.
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.
6 Jul 2015
Alaa Ben Fatma
Explore your MMSQL server tables in a professional way .
10 May 2012
Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
24 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
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.
4 Jan 2010
Alexandru Cibotari
Set based and procedural approaches in examples tested on SQL Server 2008
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
16 Jan 2009
Alfredo_Fernandez
Performance comparison - Identity() x NewId() x NewSequentialId.
6 Feb 2010
Ali Marzban
Changing ConnectionString like an attribute in C#
10 Jan 2018
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.
2 May 2013
AmitGajjar
This website will help those people who actually need blood at the right time.
9 Oct 2009
Andy_L_J
Using Table-Value Parameters to perform Inserts in SQL Server 2008 from VB.NET.
7 Feb 2013
Anupama Agarwal
This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
15 Apr 2011
Ayaz Awan
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
6 Apr 2010
Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
23 Oct 2013
BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
26 May 2009
Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
31 Dec 2008
BobP1339
How to use a script component as a data source for multi-result set Stored Procedures.
31 Mar 2009
BobP1339
Explains how to do multi language reports in SSRS
15 Jan 2009
Brian C Hart
Builds on the Microsoft N-Tier Data Application walkthrough to add filtering and updating features.
18 Oct 2013
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!
4 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
22 Apr 2009
Christopher Geyer
Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...
10 Dec 2009
Christopher R Davis, Michael S Knight
Generate applications using Inversion of Control with the nHydrate code generator.
31 Dec 2009
Christopher R Davis, Michael S Knight
Extend nHydrate with your own custom generator templates.
19 Jul 2012
CrinaT
How to generate XML from SQL Server 2008 DB and update DB from XML.
23 May 2012
Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
21 Feb 2012
Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
20 Aug 2012
Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
16 Jun 2013
Darek Danielewski
The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arising from concurrent access to shared data.
24 Jan 2014
Darey
SQL Server Reporting services forms authentication implementation
8 Jan 2011
dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
19 Dec 2011
David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
11 Oct 2009
db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
30 Sep 2010
db_developer
This article describes how modern industrial RDBMSs solve hierarchy building task, by the way SyBASE ASE and Microsoft SQL Server SQL are compared
15 Jun 2013
defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
30 Apr 2012
DLM@TD
How SQL Server deletes records
2 Oct 2013
Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
13 Sep 2009
Donsw
Audit of SQL inserts, udpates, and deletes
1 Jan 2012
Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
24 Oct 2013
Eduard Keilholz
A quick help for storing images in SQL Server and displaying them on a ASP.NET Website
27 Feb 2009
emad_awad
How to use LINQ to SQL in N-Tier architectures.
28 May 2013
Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
19 Dec 2012
Enrique Albert
First draft version of the model, repository, and services.
5 Nov 2010
Enrique Albert
Introducing the RepositoryLocator pattern.
23 Oct 2012
Enrique Albert
Global and Request context pattern for server side resources
23 Oct 2012
Enrique Albert
Baseline WCF Client application using the MVVM pattern
11 Oct 2011
Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
11 Oct 2011
Enrique Albert
WPF ICommand implementation based on Josh Smith's pattern.
14 Oct 2011
Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
14 Oct 2011
Enrique Albert
Unit of work pattern on NHibernate using repositories.
18 Dec 2010
Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
7 Jan 2011
Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
15 Nov 2010
Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
27 Jun 2012
freedeveloper
A small control to control paging in Windows Presentation Foundation.
10 Aug 2009
Friedrich Brunzema
An article exploring integrating a fingerprint reader into a user's application
31 Jul 2009
fulcrumweb
This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications
20 Aug 2009
gaurav_verma_mca
How to send bulk data using table value parameters from C#
11 Oct 2009
gaurav_verma_mca
This article details out the best practices of transaction management across application domains
23 Nov 2009
gaurav_verma_mca
Configuration of .NET applications using database
18 Nov 2010
gaurav_verma_mca
An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.
26 Jan 2009
Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
25 May 2010
gjvdkamp
A step by step explanation of how a recursive CTE actually works.
8 Dec 2009
Gordon Kushner
Utility program for generating SQL Server INSERT scripts
11 Oct 2011
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.
3 May 2011
Green Mile
This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java
22 Aug 2014
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.
14 Aug 2013
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.
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
6 Jan 2014
Hasan Habib Surzo
Class, Database Connection, Login Winform
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
18 Sep 2016
inishant12
Using SSRS report, generate the PDF, save it into DB and send it through mail using C#
7 Aug 2017
JasonShort
Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
25 Aug 2009
Jeremy Likness
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
29 Apr 2013
JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.
5 Feb 2010
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.
29 Oct 2013
Juan Steyn
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
12 Feb 2009
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.
17 Mar 2009
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.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
27 Feb 2011
Kanasz Robert
1 alternative  
In this article, I will show you how to use the scripting functions of SMOs.
8 Nov 2011
Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
23 Sep 2010
Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
9 Apr 2011
Karthik. A
This article extends what was built in the previous article. This is a task manager application that uses the custom provider designed in the last part.
14 Jan 2011
KarthikAnbarasan
This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.
11 Feb 2011
KarthikAnbarasan
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
8 Mar 2011
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.
8 Mar 2011
Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
13 May 2011
Keshav Singh
SQL Server 2008 provides a very efficient SQL policy administrator which constantly monitors the server and reports errors appropriately. Administrators can define policies and ensure that they are being adhered to by evaluating the policies.
26 May 2011
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 first part.
26 May 2011
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.
25 Jan 2010
KevGUID
Generic grid search and data paging explained.
24 Jun 2015
Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
30 May 2012
Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
11 Oct 2011
KP Lee
Specific example for improving some SQL performance problems
23 Apr 2012
Kuthuparakkal
SSIS and Excel Automation
11 May 2009
Ladislav Nevery
Native MySql Client not requiring any special driver or library
24 Dec 2009
lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
22 Jan 2013
Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
20 Jun 2013
Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
3 Apr 2019
Mahsa Hassankashi
Best approach for have more secure channel to transfer user information throughout the web
3 Apr 2019
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.
8 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
10 Jun 2013
Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
3 Oct 2016
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.
18 Aug 2013
Maxim Rudoi
A simple way to create an XML file from SQL Server tables using SSIS
19 Jun 2013
Mayank Dubey
XQuery basics.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
19 Jul 2009
Md. Marufuzzaman
Get SQL Table Information
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
19 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
8 Sep 2009
Md. Marufuzzaman
How to generate SQL object script using C#.NET
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
24 Oct 2009
Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
21 Mar 2010
Md. Marufuzzaman
Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.
10 Jun 2011
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
12 Dec 2013
Mehmet Murat TANDOĞAN
How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.
28 Nov 2011
Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
2 Jan 2014
mihirj
This article explains database schema design for storing tree structure and an algorithm to compute its cost.
6 Nov 2009
mohamad halabi
Shows the new 1-Click deployment feature of VS2010.
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
6 Jan 2010
Mohammad Dayyan
With Persian Diary, you can navigate in Persian Calendar and store your memorandums
3 May 2013
Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
11 Mar 2014
Moises Barba
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
8 Sep 2009
Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
25 May 2010
Muhammad alaa
use date and time as separated components in SQL Server 2000 and above
11 Aug 2008
Muhammad Shujaat Siddiqi
Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)
6 Dec 2009
Muhusin Khan
Effective perfomance for database application uses database
5 Jun 2009
Mycroft Holmes
Using SQL Server 2008 Hierarchy ID data type to populate a TreeView
1 Sep 2016
NaibedyaKar
SQL Server database project creation using Visual Studio 2013
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
19 Feb 2010
Niladri_Biswas
Step by step introduction to Microsoft SQL AZURE
28 Apr 2011
Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
28 Apr 2011
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
10 May 2011
Niladri_Biswas
This article will describe in simple ways as how to work with Pivot and Unpivot transformation component
10 May 2011
Niladri_Biswas
This article will demonstrate as how to work with SSIS Script component with two live example
10 May 2011
Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
12 May 2011
Niladri_Biswas
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
12 May 2011
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 May 2011
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
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
3 Aug 2011
Niladri_Biswas
In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple
2 Sep 2011
Niladri_Biswas
In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective
31 Aug 2011
Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
2 Sep 2011
Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
3 Sep 2011
Niladri_Biswas
In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3


Advertise | Privacy | Cookies | Terms of Service
Web03 | 2.8.190423.1 | Last Updated 24 Apr 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid