Click here to Skip to main content
14,021,962 members


Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
by Harmen Brouwer
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.

Latest Articles

by Mahsa Hassankashi
Best approach for have more secure channel to transfer user information throughout the web
by Mahsa Hassankashi
This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
by Amir Jalilifard
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.

All Articles

Sort by Score


27 May 2013
Tharaka MTR
This post will show you how to fix orphaned SQL users.
27 May 2013
Tharaka MTR
Generate insert statements from a specific table data using SQL Server
17 Feb 2013
Tharaka MTR
How to count consecutive dates using SQL
9 Jan 2013
aasim abdullah
SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
23 Aug 2010
This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.
18 Sep 2012
aasim abdullah
Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.
4 Dec 2016
Manjuke Fernando
It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.
12 Jan 2010
Martin Hinshelwood
From time to time your website structure may change. When this happens you do not want to have to start from scratch with your Google rankings, so you need to map all of your Old URLs to new ones.
23 Aug 2010
In this article I will explore the important features that can be configured to build comprehensive database unit tests.
26 Jan 2013
Shahriar Iqbal Chowdhury/Galib
This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017
4 Jul 2012
Leland Richardson
Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios
12 Nov 2010
Vivek Johari
Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.
22 Aug 2010
In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010.
20 Sep 2012
Manjuke Fernando
Briefly describing the features in SQL Server Data Tools.
15 Jun 2012
Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.
17 Nov 2010
Vivek Johari
Basic information about the different ways of creating a table
23 Jul 2012
Many a times we came across situation to merge records between two tables.
16 Nov 2013
Debopam Pal
Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.
16 Nov 2010
Vivek Johari
This article will try to show how to find duplicate values in a table.
20 Aug 2010
Steve Maier
The same database and the same RIA Services can be used as a Web Service by using some simple additions to the setup of your project.
16 Nov 2010
Vivek Johari
Introduction to SQL Server Views
1 Feb 2010
Sky Sanders
A strategy for implementing maintaining separation of concerns and implementation hiding.
16 Sep 2012
aasim abdullah
How to apply filter on sp_MSforeachDB
17 Aug 2012
Bryan O'Connell
Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.
19 Jul 2012
Tejas Vaishnav
Auto incremented ID using VARCHAR data type
31 Jul 2011
Manjuke Fernando
How to use the new MERGE statement feature in SQL Server 2008
15 Sep 2012
aasim abdullah
How to control SQL Server Log Information
17 Sep 2012
aasim abdullah
SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
18 Sep 2012
aasim abdullah
Smarter Way of Query Load Testing at Testing Server
18 Apr 2013
This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.
29 Jan 2014
Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!
12 Apr 2012
Sadeque Sharif
Easily trace all errors of Stored Procedures in MS SQL Server.

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