Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / database / SQL-Server / SQL-Server-2008
Submit your article

SQL-Server-2008

SQL-Server-2008

Great Reads

Auto Generate Code (CRUD) for 3 Layered architecture
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
.NET 4.0 MemoryCache with SqlChangeMonitor
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
.NET WinForms ReportViewer: Non-printable Report Background (Elements)
by Nikita D. Sinelnikov
HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable
A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET
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.

Latest Articles

Auto Generate Code (CRUD) for 3 Layered architecture
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
.NET 4.0 MemoryCache with SqlChangeMonitor
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
.NET WinForms ReportViewer: Non-printable Report Background (Elements)
by Nikita D. Sinelnikov
HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable
A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET
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.

All Articles

top
Sort by Score
Title
Updated
Author
Score

SQL-Server-2008 

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET
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.
A general-purpose service engine for unattended processing execution
by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
A LINQ Tutorial: Adding/Updating/Deleting Data
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.
A LINQ Tutorial: Mapping Tables to Objects
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.
A LINQ Tutorial: WPF Data Binding with LINQ to SQL
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.
A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation
by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5
by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
A scheduler GUI for SQL Server Agent
by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
A simple example of SQL server admin tools.
by Md. Marufuzzaman
A simple example of SQL server admin tools.
A Simple Use of SQL CASE Expression
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.
A uniform interface for large texts for a C# SQL client
by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
Abstract Nonsense in Software Development. Databases
by Petr Ivankov
Application of abstract approach to database domain
An Alternative to Sync Data from SQL Server to MySQL
by 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.
An Easy But Effective Way to Split a String using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
An End-To-End LightSwitch HTML Example
by defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
An indespensible SSIS transformation component - Script Component
by Niladri_Biswas
This article will demonstrate as how to work with SSIS Script component with two live example
An Introduction to Sql 11 (Code Name Denali) –Part III (SSIS Features in CTP 1)
by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
An Introduction to Sql 11 (Code Name Denali) -Part IV (Contained Database in CTP 1)
by 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
An Introduction to Sql 11 (Code Name Denali) –Part VI (T-Sql Features in CTP 3)
by Niladri_Biswas
In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective
An Introduction to Sql 11 (Code Name Denali) –Part VII (Column Store Index in CTP 3)
by Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
An Introduction to Sql 11 (Code Name Denali) –Part VIII (Data Quality Services(DQS) in CTP 3)
by Niladri_Biswas
In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3
An Introduction to SSIS Balanced Data Distributor Transformation Component
by Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
Arabic currency conversion from numbers to letters
by Wael R. Mansour
Convert numbers to characters for Arabic applications.
Architecture Guide: Windows Forms, Generics, Auto-Mapper, Entity Framework, Framework Design, and many more..
by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
Audits on MS SQL Server 2008
by Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
Auto Adjusting Date Ranges on Entry of a New Range using SQL
by acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation
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.
AutoRefresh Entity Framework Data Using SQL Server Service Broker
by Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
Backup SQL Server with Relative File Path and Progress
by theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
Binary Copy files in T-SQL with helps of CLR
by Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
Build a Silverlight 2 Web Chat Application
by 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.
Building a Hybrid Active Directory and SQL Table DataSource View
by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
C# and Table Value Parameters
by gaurav_verma_mca
How to send bulk data using table value parameters from C#
C# Project on Database for Beginners
by Hasan Habib Surzo
Class, Database Connection, Login Winform
Cache IQueryable for Better LINQ-to-SQL Performance
by Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
Calculating simple running totals in SQL Server
by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
Calculating Tree Cost in Microsoft SQL Server
by mihirj
This article explains database schema design for storing tree structure and an algorithm to compute its cost.
Cancellable SQL Server Query
by Scott G Blood
A Cancellable threaded query for SQL Server using .net 3.5
Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode
by Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
CDC - Change Data Capture
by Donsw
Audit of SQL inserts, udpates, and deletes
Change Data Capture (SQL Server 2008)
by Muhammad Shujaat Siddiqi
Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)
CLR Stored Procedure and Creating It Step by Step
by Virat Kothari
CLR Stored procedures are very simple and can be used in most complex scenarios when dealing with database.
Code First Approach using Entity Framework 4.1, Inversion of Control, Unity Framework, Repository & Unit of Work Pattern and MVC3 Razor View
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.
Committable Transactions in C#/SQL
by skennedyny
Simple console app which shows how to use the .NET CommittableTransaction class
Common Table Expressions(CTE) in SQL SERVER 2008
by Sunitha Sudheesh
Coding in SQL with Common Table Expressions (CTE)
Configuring IIS, ASP.NET, and SQL Server
by Juan Davel
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
Configuring SQL Server Accent-Insensitivity
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.
Connection Pooling in ASP.NET
by Muhusin Khan
Effective perfomance for database application uses database
Connection Pooling in multithreaded applications
by User-Rock
Approaches describing a design to handle connection objects and pools in C#.
Connectivity to SQL Azure in Microsoft SQL Server 2008 R2 November CTP
by Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
Constructing Web Interfaces on the Fly
by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS
by 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
Consuming Webservice using JQuery ASP.NET Application
by Rajendra Malav
Consuming webservice using JQuery ASP.NET application
Continuous Integration for Databases with Visual Studio
by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
Copy Files from One Location to Another and Rename Them after Putting Time Stamp
by 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
Create and Populate Date Dimension for Data Warehouse
by Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Create custom transformation component(Email Validator) in SSIS- Step by step
by Niladri_Biswas
In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple
Create INSERT batch files easily with ScriptBuilder
by Gordon Kushner
Utility program for generating SQL Server INSERT scripts
Custom Membership Providers - Task Manager
by 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.
Custom paging with ASP.NET GridView
by tanweer
Easy way to implement ASP.NET GridView paging .
Custom Rule Engine in WPF - MVVM
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.
Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion
by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
Data Transformation from Rows to Columns Using Dynamic SQL
by Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
Database Documentation - Microsoft SQL Server 2005/2008
by pavan k vadlamudi
Creates database documentation table(s) schema
DataBinding in WPF Browser Application using SQL Server Compact
by RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
Date and Time as Separated Types
by iMuhamad
use date and time as separated components in SQL Server 2000 and above
DbExpressions - A Step Towards Independency
by seesharper
An abstract syntax tree implementation for SQL
DBMapper - A New ORM Tool
by Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
Delete duplicate entries from a data store while leaving a single copy
by Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
Deploying Reports in Reporting Services Programmatically
by Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
Detailed SQL Server data audit through a .NET (CLR) trigger
by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
Direct access to C++ native code from C++/CLI MSSQL Stored Procedure
by Peter Kovalchuk
Reading hardware information in Stored Procedure
Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth
by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
Duplicate Rows/XML-Nodes Identification and Clean-up from Database
by 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.
Dynamic Cross Tabs and Pivots, A Different Approach
by Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
Dynamic Excel file loading with SSIS
by Kuthuparakkal
SSIS and Excel Automation
Dynamically Create ASP Form from SQL Stored Procedure
by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005
by Venkat Chaitanya Kanumukula
Export SQL Server Tables to Excel Files Dynamically
Dynamics AX Data Maintenance & Migration Tips
by Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
Efficient Paging with Repeater and SQL Server 2005 / 2008
by perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
Enterprise Configuration Management
by gaurav_verma_mca
Configuration of .NET applications using database
Entity Framework Performance
by Not Active
A comparison of performance between ADO.NET and Entity Framework.
Event-Driven Architecture in the Clouds with Windows Azure
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.
Executing a Web Service in a CLR Based Table Valued Function and Representing its IEnumerable Type Output as a Table in SQL Server
by 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.
Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!
by Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
Exporting Stored Procedure Results into Tables Dynamically with T-SQL
by Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
Fast declarative typesafety with DynamicMethods for SQL
by tcassisi
Generating typed field accessors and applying them to object mapping and SQL Stored Procedures
Few Step(s) to Remove SQL Server Database User(s)
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.
Find multiple strings in selected columns
by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Fingerprint Reader Integration using the M2SYS SDK
by Friedrich Brunzema
An article exploring integrating a fingerprint reader into a user's application
FIPS Encryption Algorithms and Implementation of AES in C# and SQL Server 2008
by Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
FOR XML Basics (AUTO Mode): 2 of 4
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
FOR XML Basics (EXPLICIT Mode): 3 of 4
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
Generate Classes and CRUD Procedures
by ColinBashBash
Generate classes / CRUD procedures.
Generate SQL Script Programmatically
by Md. Marufuzzaman
How to generate SQL object script using C#.NET
Generate XML from SQL Server 2008 and update the database from XML
by CrinaT
How to generate XML from SQL Server 2008 DB and update DB from XML.
Generating Class Representations Of SQL Tables
by lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
Generic Database Access
by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
Generic grid search and data paging
by KevGUID
Generic grid search and data paging explained.
Get List of Extended storedProcedures that are Allowed to you for Common Use
by Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Get SQL Table Information
by Md. Marufuzzaman
Get SQL Table Information
Getting Started With SSIS Script transforms
by Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
Global Variables in SQL Server
by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Graphical Representation of Data in ASP.NET Web Page
by Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
Grouping Sets in MS SQL Server 2008
by Robin_Roy
New feature - SQL Server 2008 Grouping Sets.
Handling SOAP Exceptions in WCF Based Applications
by Nandha V
Using a custom exception handler component
HierarchyID Data Type in SQL Server 2008
by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
High fidelity printing through the SSRS Report Viewer control
by tcassisi
Discusses the limitations and undocumented high DPI printing capabilities of the local WinForms Report Viewer control.
How Do I Protect My Stored Procedure Code
by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
How Do I: Use SQL File Stream
by 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.
How Many Records Are There in your Database?
by Md. Marufuzzaman
How many records are there in your database?
How SQL Server deletes records
by DLM@TD
How SQL Server deletes records
How to access SQL database from an iPhone app Via RESTful WCF service hosted on IIS 7.5
by Samer M. Abdallah
Access SQL database from iPhone Via WCF and JSON hosted on IIS 7.5
How to change ConnectionString easily
by Ali Marzban
Changing ConnectionString like an attribute in C#
How to Config Linked Servers in a Minute
by Kamran Hazari
How to create Linked servers in a minute in an easy way
How to Create your First SQL Server Integration Services (SSIS) Package - Part 1
by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
How to execute multiple long running SQL Statements Asynchronously in small chunks
by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
How to export data from database tables to an XML file using SSIS
by Maxim Rudoi
A simple way to create an XML file from SQL Server tables using SSIS
How to Install and Configure SharePoint Server 2010 RTM
by Syed Adnan Ahmed
This article describes step by step details of how to install and configure SharePoint Server 2010 RTM
How to Integrate an OLE Object with SQL Server
by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
How to Non-alphabetically Sort GridView Columns with Text Data
by 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...
How to pass multiple records to a Stored Procedure
by Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
How To Store Any File into SQL Database
by Md. Marufuzzaman
An easy technique to store any file into SQL database
How to Use a Multi-Result Set Stored Procedure in SSIS
by Ponytail Bob
How to use a script component as a data source for multi-result set Stored Procedures.
How to Use SQL Server to Select Records for a Scheduled Date
by Vilhelms
Retrieving appointments without having to store all future occurrences
HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express
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!
Implementing Logging & Transaction for NHibernate through Configuration Files using Aspect Oriented Programming via Unity
by Niraj Bhatt
Applying AOP using Unity on NHibernate
Import Data from Excel to SQL Server
by 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.........
Improve Productivity by Redesigning DataBase Schema
by Riccardo Cervelli
Redraw database structure to improve productivity
Inside Recursive CTEs
by gjvdkamp
A step by step explanation of how a recursive CTE actually works.
Introducing the Boomerang Framework
by psined
Introduction to Boomerang Framework
Inversion of Control with nHydrate
by Christopher R Davis, Michael S Knight
Generate applications using Inversion of Control with the nHydrate code generator.
Jotdown
by Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
jQuery Mobile AutoComplete in ASP.NET with SQL Server Database Connection
by Mehmet Murat TANDOĞAN
How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.
Keep everyone away from breaking your database object naming convention with SQL Server Policy Based Management.
by Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
Kerosene Dynamic Data Services
by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
Layered Application Design Pattern
by Rajan Patekar
N-tier architecture of Project
Learn to Write Custom MDX Query First Time
by Mubin M. Shaikh
Learn Custom MDX Query Step by Step
Library for scripting SQL Server database objects with examples
by Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
Load More Records in ASP.NET Gridview on Button Click from SQL Server Table
by 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.
Loading a TreeView using HierarchyID
by Mycroft Holmes
Using SQL Server 2008 Hierarchy ID data type to populate a TreeView
Log Shipping MS SQL Server 2008 - Part I
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 first part.
Log Shipping MS SQL Server 2008 - Part II
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.
Making OUTER and CROSS APPLY work for you
by Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
Market Basket Analysis in SSAS 2005+
by Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
Merge Statement in SQL Server 2008
by Robin_Roy
Microsoft SQL Server 2008 new feature, Merge Statement
Microsoft SQL Server 2008 - Change Data Capture (CDC)
by 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.
Microsoft Visual Studio LightSwitch Business Application Development
by Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
Mimicking null-safe equal to operator in SQL Server
by Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Multi Language Reports in SSRS
by Ponytail Bob
Explains how to do multi language reports in SSRS
N - tier project with WCF OData service, Entity Framework, MVC3.0, Ninject DI, jSOn.net and Automapper
by Vijay Tanwar
N-Tier application with WCF Odata service and Entity Framework.
nHydrate Generator Template
by Christopher R Davis, Michael S Knight
Extend nHydrate with your own custom generator templates.
Optimization using SMO because of latency - SQL Server Management Object - To script table
by Hassan Boutougha
Workaround for SMO latency when scripting.
Optimized Paging and Sorting using Object Data Source
by Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
Overview of SQL Server 2005/2008 Table Indexing (Part-1)
by Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
Overview of SQL Server database Triggers
by Md. Marufuzzaman
Overview of SQL Server database Triggers
Overview of SQL Server Stored Procedure
by Md. Marufuzzaman
Overview of SQL server stored procedure
Passing an Array as Parameter to SQL Server Procedure
by Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
Peer to Peer File Sharing Through WCF
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.
Performance Comparison - Identity() x NewId() x NewSequentialId
by Alfredo_Fernandez
Performance comparison - Identity() x NewId() x NewSequentialId.
Persian Diary in WPF
by Mohammad Dayyan
With Persian Diary, you can navigate in Persian Calendar and store your memorandums
Physical location of a row in SQL Server
by Wendelius
This article describes the pseudo column to identify the unique physical location of a single row.
Policy Based Management in SQL Server 2008
by 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.
Powershell How-To - Part 1
by Rajib Bahar
This article is a part of a series of articles that shows HOW-TO do various tasks in powershell.
Procedure to Shrink the Database Transaction Log
by Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
by pinaldave
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
Quick Overview: Temporary Tables in SQL Server 2005
by Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
Reading sql_variant in Entity Framework
by dasblinkenlight
Working around an Entity Framework exclusion of sql_variant
Refering dlls in SSIS Script Task
by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Regular Expressions in MS SQL Server 2005/2008
by db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
Report Service 2008 R2 - Delivery Extension User Control
by Anupama Agarwal
This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.
RESTful WCF / EF POCO / Unit of Work / Repository / MEF: 1 of 2
by Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
Restoring SQL Server Express 2008 Database with Click Once
by Ferhat_Karatas
Restoring SQL Server Express 2008 Database with Click Once
Save and Retrieve PDF from SQL DB using SSRS and ASP.NET
by inishant12
Using SSRS report, generate the PDF, save it into DB and send it through mail using C#
Securing Data With Application Role
by 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.
Security on the Web by Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)
by Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web
Set Based and Procedural Approaches in Examples
by Alexandru Cibotari
Set based and procedural approaches in examples tested on SQL Server 2008
SharePoint 2010 Logging Database
by Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
Silverlight Application with WCF Service and Child Windows as Popups - Part 1
by Balwant.mnd
Silverlight application for scheduling a meeting
Simple Data Access in C#
by 6opuc
Fast and easy to use data access class library.
Simplify Database Operations with Generic Fluent NHibernate
by Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
Small Paging Control for Windows Presentation Foundation (WPF)
by freedeveloper
A small control to control paging in Windows Presentation Foundation.
SMO Tutorial 3 of n - Scripting
by Kanasz Robert
In this article, I will show you how to use the scripting functions of SMOs.
SMO Tutorial 3 of n - Scripting
by RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
SQL Alpha Numeric Sort Using CLR Integration
by shteff
How to do a sort on alphanumeric strings in SQL Server.
SQL And C#
by Ayaz Awan
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
SQL Browser
by Alaa Ben Fatma
Explore your MMSQL server tables in a professional way
SQL Framework
by 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.
SQL Query Optimization FAQ Part 1 (With video explanation)
by Shivprasad koirala
SQL Query Optimization FAQ Part 1 (With video explanation)
SQL recursive common table expression in Project Scheduling practice
by csabahegyi79
Project Scheduling Engine with recursive SQL common table expression
SQL SERVER – Order of Columns in Update Statement Does not Matter
by pinaldave
SQL SERVER – Order of Columns in Update Statement does not matter
SQL Server 2008 R2 Setup, Configurations & Remote Accessing using Java
by Green Mile
This article decribes SQL Server 2008 R2 setup, configurations & remote accessing using Java
SQL Server Database Development in Visual Studio
by NaibedyaKar
SQL Server database project creation using Visual Studio 2013
SQL Server Date Format Language
by Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
SQL Server Easy Column Search
by Divan van der Watt
Column search functionality that works as easy as sp_help.
Sql Server In Clause With Multiple Literal Values Performance Behaviour
by Neeraj Prasad Sharma
This article deals with performance difference with literal values
SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages
by KarthikAnbarasan
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
SQL Server Performance Impacted by New Features
by KP Lee
Specific example for improving some SQL performance problems
SQL Server Schema Comparison Tool in Visual Studio 2010
by 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.
SQL Wizardry Part 2 - Select, beyond the basics
by Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
SQL Wizardry Part Eight - Tally Tables
by Christian Graus
A description of the best way to create tally tables, and how to use them
SQL Wizardry Part Five - when not to use DISTINCT
by Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
SQL Wizardry Part Seven - PIVOT and arbitrary lists of data
by Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
SQL Wizardry Part Six - Windowing Functions
by Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
SQL Wizardry Part Three - Common Table Expressions (CTEs)
by Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
SqlTimeSpan
by Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
SSIS: By coding
by ThatsAlok
Step by Step creation of SSIS package using C#
SSIS: By coding Part 2
by ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
SSRS 2012 Forms Authentication
by Darey
SQL Server Reporting services forms authentication implementation
SSRS Downloading .RDL Files
by Patrick Harris
This examle shows you how to create a C# program to download SSRS reports from a server.
SSRS Series Part I: Various ways of Report creation, deployment and invocation
by Niladri_Biswas
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
SSRS Series Part II: Working with Subreports, DrillDown Reports, Expressions and Custom codes, Databars, Indicators, Custom Sorting and Paging and...
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
Step by Step Introduction to Microsoft SQL AZURE
by Niladri_Biswas
Step by step introduction to Microsoft SQL AZURE
Stored Procedure for Single & List Object in ASP.NET MVC with angularJS
by Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
Storing and Retrieving Images from SQL Server Using Strored Procedures and C#
by Thilina Chandima
An introduction on how to store and retrieve images from SQL Server 2008 by using Stored Procedures and C#.
Storing Images in SQL Server using EF and ASP.NET
by Eduard Keilholz
A quick help for storing images in SQL Server and displaying them on a ASP.NET Website
STSADM Backup Error: The backup is from a different version of SharePoint
by Soptik Dutta
Explains an alternative way of stsadm restoration of a Site Collection.
SyBASE ASE vs Microsoft SQL Server at Hierarchy Building Sample
by 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
T- SQL - How to get all descendants of a given element in a hierarchical table
by Paolo Costa
This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.
Table Data Sharing Across Stored Procedures
by ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Table Value Parameter in SQL Server 2008
by Robin_Roy
MS SQL Server 2008 new feature, Table Value Parameter.
Table Valued Parameter in SqlServer 2008
by Rahul Pratap Singh
How to create common procedure to insert the data in any table.
Table-Value Parameters in SQL Server 2008 - VB.NET
by Andy_L_J
Using Table-Value Parameters to perform Inserts in SQL Server 2008 from VB.NET.
Techniques for In-Clause and SQL Server
by Tim Schwallie
A few ways to work with In-Clause and Stored Procedures with SQL Server and C#.
Thinking in SQL - Generating Random Numbers
by Christian Graus
A discussion of ways to create random number sequences in SQL Server
Thinking in SQL - Working with dates
by Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
Thread-safety with SQL Server 2008
by 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.
Transaction Management Across Application Domains
by gaurav_verma_mca
This article details out the best practices of transaction management across application domains
T-SQL reporting engine
by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
Uncommon Common Table Expressions (CTEs)
by Jeremy Likness
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
Understanding Three Layer Architecture and its Implementation in C# .NET
by Debopam Pal
What is three layer architecture and how to implement it.
Upload and Download Files with SQL Server in ASP.NET
by Dr. Song Li
This article presents an example to upload and download files with SQL Server in ASP.NET.
Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs
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.
Use RegEx in SQL with CLR Procs
by 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!
Using Conditional Split data Transfer in SSIS 2008
by Surath Rath - 2010
This article introduces the fundamental concepts behind SQL Server 2008 Integration Services Conditional Split Data Flow Transformation element to transfer data from a set of flat files to SQL Server database tables...
Using Integrated Windows Authentication (IWA) in a Distributed Application Architecture
by 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.
Using LINQ to SQL in N-Tier Architectures
by emad_awad
How to use LINQ to SQL in N-Tier architectures.
Using Silverlight in Enterprise: RAD of User Friendly Database Access
by fulcrumweb
This article introduces FulcrumWeb RAD Framework - A Silverlight UI Engine to build user friendly database driven applications
Using SQL Bulk Load to Upload Fixed Width Text Files
by 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.
Using User Defined Functions in Table Inserts and Seeding with Stored Procedures
by Andy_L_J
Generate unique column values using UDFs and Stored Procedures
Using WCF REST HTTP to call Stored Procedures on SQL Server
by Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
Very fast test data generation using exponential INSERT
by weilidai2001
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
Visual Representation of SQL Joins
by C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
Visual Studio 2010 and Microsoft SQL 2008- Authentication System using ASP.NET (JQuery, Json and Web services)
by composeme
How to call server side methods or functions directly using JQuery in ASP.NET C#
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
by Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
VS2010 1-Click Publishing
by mohamad halabi
Shows the new 1-Click deployment feature of VS2010.
Walkthrough: Filtering and Updating in an N-Tier Data Application
by Brian C Hart
Builds on the Microsoft N-Tier Data Application walkthrough to add filtering and updating features.
WCF by Example - Chapter I - Baseline
by Enrique Albert
First draft version of the model, repository, and services.
WCF by Example - Chapter II - Repositories
by Enrique Albert
Introducing the RepositoryLocator pattern.
WCF by Example - Chapter IX - WPF Client - Notify Property Change
by Enrique Albert
WPF INotifyPropertyChanged implementation.
WCF by Example - Chapter V - Contexts
by Enrique Albert
Global and Request context pattern for server side resources
WCF by Example - Chapter VI - WPF Client - Baseline
by Enrique Albert
Baseline WCF Client application using the MVVM pattern
WCF by Example - Chapter VII - Decoupling of WCF Services from the ViewModel
by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
WCF by Example - Chapter VIII - WPF Client - Relay Command
by Enrique Albert
WPF ICommand implementation based on Josh Smith's pattern.
WCF by Example - Chapter X - Dependency Injection with Spring.Net
by Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
WCF by Example - Chapter XI - NHibernate Implementation
by Enrique Albert
Unit of work pattern on NHibernate using repositories.
WCF by Example - Chapter XII - WCF Implementation
by Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
WCF by Example - Chapter XIII - Business Domain - Parent and Child Relationships
by Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
WCF by Example - Chapter XIV - Validation & Exception Management
by Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
WCF by Example - Introduction
by Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
Weekly Thai Recipe! for Windows Phone
by Patrick Kalkman
A complete WP7 application with a central management website (ASP.NET MVC4) for recipe management and push notifications
Working with CLR Objects in SQL Server 2005 or Above Part 2
by Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
Working with CLR Objects in SQL Server 2005 or Higher: Part I
by Abhishek Sur
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
Working with Pivot and UnPivot Transformation
by Niladri_Biswas
This article will describe in simple ways as how to work with Pivot and Unpivot transformation component
XQuery basics
by Mayank Dubey
XQuery basics.
Zeta Backup Validator
by Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
Zip Rendering Extension for SQL Server Reporting Services 2005/2008/2012
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.



Privacy
Cookies
Terms of Use
Last Updated 22 Oct 2024
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-10-19:1