Click here to Skip to main content
15,860,972 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 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
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.

All Articles

Sort by Score

SQL Server 2008 

14 Aug 2013 by Harmen Brouwer
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
11 Oct 2011 by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
23 Apr 2012 by Kuthuparakkal
27 Jun 2012 by freedeveloper
A small control to control paging in Windows Presentation Foundation.
25 Oct 2012 by Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
2 Aug 2009 by Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
27 Apr 2011 by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
21 Feb 2012 by Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
2 Jun 2017 by AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
30 Jul 2009 by Giovanni Bejarasco
28 Aug 2012 by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
24 Jun 2015 by Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
1 Jun 2017 by AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
7 Aug 2012 by ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
10 Apr 2015 by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
28 Nov 2011 by Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
2 Jan 2013 by Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
17 Jul 2013 by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
31 Mar 2009 by BobP1339
Explains how to do multi language reports in SSRS
26 Jul 2009 by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
29 Jun 2012 by Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
26 Jun 2013 by ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
18 Jan 2014 by Petr Ivankov
Application of abstract approach to database domain
24 Jan 2016 by RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
17 Nov 2009 by Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
11 Jan 2010 by Divan van der Watt
Column search functionality that works as easy as sp_help.
26 May 2011 by Keshav Singh
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.
20 Sep 2011 by Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
20 Sep 2011 by Soptik Dutta
Explains an alternative way of stsadm restoration of a Site Collection.
11 Oct 2011 by KP Lee
Specific example for improving some SQL performance problems
3 May 2013 by Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
3 Apr 2019 by Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web
12 Jan 2014 by Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
16 Jan 2014 by Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
11 Sep 2010 by Renil Joy, Bangalore
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
11 Jun 2011 by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
3 Apr 2019 by Mahsa Hassankashi
This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
19 Apr 2012 by Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
6 Aug 2013 by Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
21 Jan 2014 by Christian Graus
A description of the best way to create tally tables, and how to use them
11 Oct 2011 by Enrique Albert
WPF ICommand implementation based on Josh Smith's pattern.
3 Feb 2009 by C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
25 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
2 Oct 2013 by Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
23 Oct 2012 by Enrique Albert
Global and Request context pattern for server side resources
7 Feb 2013 by Anupama Agarwal
This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.
12 May 2011 by Niladri_Biswas
In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples
5 Feb 2010 by John Mokkosian-Kane, Daniel Hsu
To demonstrate Azure and EDA, this article will show you how to build a flight delay management system for all US airports in clouds with Windows Azure.
18 Oct 2013 by Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
10 May 2012 by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
3 Oct 2016 by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
11 Dec 2009 by Abby Fichtner (Hacker Chick)
A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.
10 Jan 2018 by Amir Jalilifard
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.
19 Aug 2009 by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
15 Nov 2010 by Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
15 Jun 2013 by defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
1 Jan 2012 by Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
14 Oct 2011 by Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
16 Oct 2013 by tcassisi
Generating typed field accessors and applying them to object mapping and SQL Stored Procedures
11 Mar 2014 by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
8 Nov 2011 by Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
23 Oct 2012 by Enrique Albert
Baseline WCF Client application using the MVVM pattern
10 Jun 2013 by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
12 Dec 2013 by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
13 Jul 2010 by Md. Marufuzzaman
29 Oct 2013 by Juan Davel
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
27 Feb 2011 by Kanasz Robert
In this article, I will show you how to use the scripting functions of SMOs.
15 Jun 2009 by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
11 Jun 2010 by theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
23 Oct 2013 by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
6 Jul 2012 by Patrick Kalkman
A complete WP7 application with a central management website (ASP.NET MVC4) for recipe management and push notifications
14 Oct 2011 by Enrique Albert
Unit of work pattern on NHibernate using repositories.
9 Dec 2010 by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
2 Dec 2008 by Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
28 May 2013 by Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
7 Jun 2011 by Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
19 Dec 2011 by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
25 Aug 2009 by Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
20 Mar 2010 by Md. Marufuzzaman
Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.
10 Jun 2009 by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
14 Jul 2013 by ThatsAlok
Step by Step creation of SSIS package using C#
23 Aug 2010 by Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
7 Sep 2009 by Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
12 Dec 2014 by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
11 Dec 2009 by Abby Fichtner (Hacker Chick)
A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.
26 Nov 2014 by Akhil Mittal
My effort in this article was to put some light on building a generic multilayered architecture using Entity Framework 4.1 and MVC3 razor view engine.
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
29 Apr 2009 by Kamran Hazari
How to create Linked servers in a minute in an easy way
9 Jun 2011 by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
28 Mar 2013 by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
12 Mar 2012 by Not Active
A comparison of performance between ADO.NET and Entity Framework.
8 Jan 2011 by dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
27 Feb 2009 by emad_awad
How to use LINQ to SQL in N-Tier architectures.
13 Apr 2009 by shteff
How to do a sort on alphanumeric strings in SQL Server.
1 Sep 2016 by NaibedyaKar
SQL Server database project creation using Visual Studio 2013
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.