Click here to Skip to main content
14,884,185 members
Everything / Database Development / SQL Server / SQL Server 2008

SQL Server 2008

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 Tecfield
This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Latest Articles

by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
by Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
by Alaa Ben Fatma
Explore your MMSQL server tables in a professional way
by Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web

All Articles

Sort by Score

SQL Server 2008 

Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
11 Oct 2011
Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
Please Sign up or sign in to vote.
23 Apr 2012
Kuthuparakkal
SSIS and Excel Automation
Please Sign up or sign in to vote.
27 Jun 2012
freedeveloper
A small control to control paging in Windows Presentation Foundation.
Please Sign up or sign in to vote.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
Please Sign up or sign in to vote.
27 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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
Please Sign up or sign in to vote.
19 Feb 2013
Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
Please Sign up or sign in to vote.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Please Sign up or sign in to vote.
24 Jun 2015
Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
Please Sign up or sign in to vote.
1 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
Please Sign up or sign in to vote.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Please Sign up or sign in to vote.
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Please Sign up or sign in to vote.
28 Nov 2011
Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
Please Sign up or sign in to vote.
2 Jan 2013
Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
Please Sign up or sign in to vote.
17 Jul 2013
Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
Please Sign up or sign in to vote.
31 Mar 2009
BobP1339
Explains how to do multi language reports in SSRS
Please Sign up or sign in to vote.
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
Please Sign up or sign in to vote.
29 Jun 2012
Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
Please Sign up or sign in to vote.
26 Jun 2013
ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
Please Sign up or sign in to vote.
18 Jan 2014
Petr Ivankov
Application of abstract approach to database domain
Please Sign up or sign in to vote.
24 Jan 2016
RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
Please Sign up or sign in to vote.
17 Nov 2009
Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
Please Sign up or sign in to vote.
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
20 Sep 2011
Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Please Sign up or sign in to vote.
20 Sep 2011
Soptik Dutta
Explains an alternative way of stsadm restoration of a Site Collection.
Please Sign up or sign in to vote.
11 Oct 2011
KP Lee
Specific example for improving some SQL performance problems
Please Sign up or sign in to vote.
28 Apr 2013
JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.
Please Sign up or sign in to vote.
13 May 2013
Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
Please Sign up or sign in to vote.
3 May 2013
Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
Please Sign up or sign in to vote.
3 Apr 2019
Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
Please Sign up or sign in to vote.
11 Sep 2010
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.
Please Sign up or sign in to vote.
11 Jun 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Apr 2012
Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
Please Sign up or sign in to vote.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
Please Sign up or sign in to vote.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
Please Sign up or sign in to vote.
11 Oct 2011
Enrique Albert
WPF ICommand implementation based on Josh Smith's pattern.
Please Sign up or sign in to vote.
3 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.
Please Sign up or sign in to vote.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
Please Sign up or sign in to vote.
2 Oct 2013
Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
Please Sign up or sign in to vote.
23 Oct 2012
Enrique Albert
Global and Request context pattern for server side resources
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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!
Please Sign up or sign in to vote.
10 May 2012
Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Please Sign up or sign in to vote.
15 Nov 2010
Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
15 Jun 2013
defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
Please Sign up or sign in to vote.
1 Jan 2012
Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
Please Sign up or sign in to vote.
14 Oct 2011
Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
Please Sign up or sign in to vote.
16 Oct 2013
tcassisi
Generating typed field accessors and applying them to object mapping and SQL Stored Procedures
Please Sign up or sign in to vote.
12 Dec 2013
Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
Please Sign up or sign in to vote.
11 Mar 2014
mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
23 Oct 2012
Enrique Albert
Baseline WCF Client application using the MVVM pattern
Please Sign up or sign in to vote.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
Please Sign up or sign in to vote.
10 Jun 2013
Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
Please Sign up or sign in to vote.
13 Jul 2010
Md. Marufuzzaman
Overview of SQL server stored procedure
Please Sign up or sign in to vote.
27 Feb 2011
Kanasz Robert
1 alternative  
In this article, I will show you how to use the scripting functions of SMOs.
Please Sign up or sign in to vote.
29 Oct 2013
Juan Davel
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
Please Sign up or sign in to vote.
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
Please Sign up or sign in to vote.
11 Jun 2010
theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
Please Sign up or sign in to vote.
23 Oct 2013
BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
Please Sign up or sign in to vote.
6 Jul 2012
Patrick Kalkman
A complete WP7 application with a central management website (ASP.NET MVC4) for recipe management and push notifications
Please Sign up or sign in to vote.
14 Oct 2011
Enrique Albert
Unit of work pattern on NHibernate using repositories.
Please Sign up or sign in to vote.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
Please Sign up or sign in to vote.
2 Dec 2008
Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
Please Sign up or sign in to vote.
28 May 2013
Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
Please Sign up or sign in to vote.
23 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
Please Sign up or sign in to vote.
20 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.
Please Sign up or sign in to vote.
10 Jun 2009
Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
Please Sign up or sign in to vote.
14 Jul 2013
ThatsAlok
Step by Step creation of SSIS package using C#
Please Sign up or sign in to vote.
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
Please Sign up or sign in to vote.
7 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.
Please Sign up or sign in to vote.
12 Dec 2014
Wendelius
Some simple scenarios to calculate running totals in SQL Server.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
Please Sign up or sign in to vote.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
Please Sign up or sign in to vote.
9 Jun 2011
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
Please Sign up or sign in to vote.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Please Sign up or sign in to vote.
12 Mar 2012
Not Active
A comparison of performance between ADO.NET and Entity Framework.
Please Sign up or sign in to vote.
8 Jan 2011
dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
Please Sign up or sign in to vote.
27 Feb 2009
emad_awad
How to use LINQ to SQL in N-Tier architectures.
Please Sign up or sign in to vote.
13 Apr 2009
shteff
How to do a sort on alphanumeric strings in SQL Server.
Please Sign up or sign in to vote.
1 Sep 2016
NaibedyaKar
SQL Server database project creation using Visual Studio 2013
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
9 May 2011
Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Please Sign up or sign in to vote.
19 Jun 2012
Samer M. Abdallah
Access SQL database from iPhone Via WCF and JSON hosted on IIS 7.5
Please Sign up or sign in to vote.
12 Aug 2014
Thilina Chandima
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
Please Sign up or sign in to vote.
7 Jan 2011
Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
5 Jul 2009
Shivprasad koirala
Optimizing LINQ Queries using DataLoadOptions
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
18 Dec 2010
Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
Please Sign up or sign in to vote.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
Please Sign up or sign in to vote.
15 Feb 2010
Tim Schwallie
A few ways to work with In-Clause and Stored Procedures with SQL Server and C#.
Please Sign up or sign in to vote.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Please Sign up or sign in to vote.
30 May 2012
Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
Please Sign up or sign in to vote.
22 Jun 2009
SteveHarrisBeast
How to make a password verification form in VB that uses LINQ and SQL
Please Sign up or sign in to vote.
24 Jan 2014
Darey
SQL Server Reporting services forms authentication implementation
Please Sign up or sign in to vote.
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
Please Sign up or sign in to vote.
25 Feb 2011
Wendelius
This article describes the pseudo column to identify the unique physical location of a single row.
Please Sign up or sign in to vote.
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
Please Sign up or sign in to vote.
27 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
Please Sign up or sign in to vote.
11 Oct 2009
db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
Please Sign up or sign in to vote.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
Please Sign up or sign in to vote.
9 May 2011
Niladri_Biswas
This article will describe in simple ways as how to work with Pivot and Unpivot transformation component
Please Sign up or sign in to vote.
5 Apr 2021
Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
7 Oct 2011
Sunitha Sudheesh
Coding in SQL with Common Table Expressions (CTE)
Please Sign up or sign in to vote.
19 Dec 2012
Enrique Albert
First draft version of the model, repository, and services.
Please Sign up or sign in to vote.
7 Mar 2010
Surath Rath - 2010
This article introduces the fundamental concepts behind SQL Server 2008 Application Role and illustrates its use in securing data and database objects.
Please Sign up or sign in to vote.
9 May 2011
Niladri_Biswas
This article will demonstrate as how to work with SSIS Script component with two live example
Please Sign up or sign in to vote.
5 Nov 2010
Enrique Albert
Introducing the RepositoryLocator pattern.
Please Sign up or sign in to vote.
31 Jul 2009
fulcrumweb
This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications
Please Sign up or sign in to vote.
16 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
Please Sign up or sign in to vote.
6 Jan 2010
Mohammad Dayyan
With Persian Diary, you can navigate in Persian Calendar and store your memorandums
Please Sign up or sign in to vote.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
Please Sign up or sign in to vote.
11 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
Please Sign up or sign in to vote.
10 Aug 2009
Friedrich Brunzema
An article exploring integrating a fingerprint reader into a user's application
Please Sign up or sign in to vote.
9 Aug 2009
Wael R. Mansour
Convert numbers to characters for Arabic applications.
Please Sign up or sign in to vote.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
Please Sign up or sign in to vote.
20 Aug 2009
gaurav_verma_mca
How to send bulk data using table value parameters from C#
Please Sign up or sign in to vote.
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
Please Sign up or sign in to vote.
24 Dec 2009
lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
Please Sign up or sign in to vote.
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
Please Sign up or sign in to vote.
19 May 2011
tcassisi
Discusses the limitations and undocumented high DPI printing capabilities of the local WinForms Report Viewer control.
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
30 Oct 2009
Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
Please Sign up or sign in to vote.
10 Jun 2009
Robin_Roy
MS SQL Server 2008 new feature, Table Value Parameter.
Please Sign up or sign in to vote.
6 Apr 2010
Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
Please Sign up or sign in to vote.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
11 Jun 2013
Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
Please Sign up or sign in to vote.
1 Sep 2011
Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
Please Sign up or sign in to vote.
9 Dec 2016
Riccardo Cervelli
Redraw database structure to improve productivity
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
31 Jan 2010
skennedyny
Simple console app which shows how to use the .NET CommittableTransaction class
Please Sign up or sign in to vote.
8 Mar 2011
Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
22 Aug 2011
RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
Please Sign up or sign in to vote.
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers
Please Sign up or sign in to vote.
27 Nov 2013
S. M. Ahasan Habib
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Please Sign up or sign in to vote.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
Please Sign up or sign in to vote.
26 Jun 2012
tanweer
Easy way to implement ASP.NET GridView paging .
Please Sign up or sign in to vote.
16 Nov 2009
Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
Please Sign up or sign in to vote.
21 May 2012
Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
Please Sign up or sign in to vote.
1 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
Please Sign up or sign in to vote.
16 Aug 2012
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.
Please Sign up or sign in to vote.
16 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.
Please Sign up or sign in to vote.
10 Jun 2009
Robin_Roy
Microsoft SQL Server 2008 new feature, Merge Statement
Please Sign up or sign in to vote.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
Please Sign up or sign in to vote.
4 May 2009
Shivprasad koirala
4 steps to create free SSL certificate for development
Please Sign up or sign in to vote.
19 Jun 2013
Mayank Dubey
XQuery basics.
Please Sign up or sign in to vote.
16 Dec 2011
perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
Please Sign up or sign in to vote.
23 May 2012
Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
10 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
Please Sign up or sign in to vote.
1 Jun 2014
Webcodeexpert.com
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.
Please Sign up or sign in to vote.
19 Sep 2014
Konstantin Tchoumak
Reading hardware information in Stored Procedure
Please Sign up or sign in to vote.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
Please Sign up or sign in to vote.
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
Please Sign up or sign in to vote.
3 May 2011
Green Mile
This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java
Please Sign up or sign in to vote.
30 Aug 2011
Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Apr 2012
DLM@TD
How SQL Server deletes records
Please Sign up or sign in to vote.
16 Jan 2009
Vivekananda Swamy.M
This article mainly describes how to import data from Excel sheet to SQL Server, Viewing the data from SQL Server using the Gridview Control, Deleting the Data. In case the Excel sheet does not contain data (null values), those values are replaced by zero.........
Please Sign up or sign in to vote.
27 Nov 2013
S. M. Ahasan Habib
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Please Sign up or sign in to vote.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
Please Sign up or sign in to vote.
26 Jun 2012
tanweer
Easy way to implement ASP.NET GridView paging .
Please Sign up or sign in to vote.
16 Nov 2009
Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
Please Sign up or sign in to vote.
21 May 2012
Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
Please Sign up or sign in to vote.
1 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
Please Sign up or sign in to vote.
16 Aug 2012
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.
Please Sign up or sign in to vote.
16 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.
Please Sign up or sign in to vote.
10 Jun 2009
Robin_Roy
Microsoft SQL Server 2008 new feature, Merge Statement
Please Sign up or sign in to vote.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
Please Sign up or sign in to vote.
4 May 2009
Shivprasad koirala
4 steps to create free SSL certificate for development
Please Sign up or sign in to vote.
19 Jun 2013
Mayank Dubey
XQuery basics.
Please Sign up or sign in to vote.
16 Dec 2011
perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
Please Sign up or sign in to vote.
23 May 2012
Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
10 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
Please Sign up or sign in to vote.
1 Jun 2014
Webcodeexpert.com
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.
Please Sign up or sign in to vote.
19 Sep 2014
Konstantin Tchoumak
Reading hardware information in Stored Procedure
Please Sign up or sign in to vote.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
Please Sign up or sign in to vote.
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
Please Sign up or sign in to vote.
3 May 2011
Green Mile
This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java
Please Sign up or sign in to vote.
30 Aug 2011
Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Apr 2012
DLM@TD
How SQL Server deletes records
Please Sign up or sign in to vote.
16 Jan 2009
Vivekananda Swamy.M
This article mainly describes how to import data from Excel sheet to SQL Server, Viewing the data from SQL Server using the Gridview Control, Deleting the Data. In case the Excel sheet does not contain data (null values), those values are replaced by zero.........
Please Sign up or sign in to vote.
23 Oct 2009
Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
Please Sign up or sign in to vote.
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
Please Sign up or sign in to vote.
12 Dec 2013
Mehmet Murat TANDOĞAN
How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.