SQL Server 2008

SQL-Server-2008

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

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.

Rename a Database and its MDF and LDF files in SQL Server

by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Latest Articles

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

SQL Browser

by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

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

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.

All Articles

top

SQL Server 2008

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

SQL

.NET

Windows

SQL-Server-2005

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

9 Jan 2013 by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

How to unit test SQL Server 2008 database using Visual Studio 2010 – Part 3

23 Aug 2010 by atverma

This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.

SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem

17 Sep 2012 by 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.

SQL-Server

SQL-Server-2008

SQL-Server-2005

How to Multicast messages with SQL Server Service Broker

22 Jul 2011 by rusanu

How to Multicast messages with SQL Server Service Broker

Using the MERGE Statement in SQL Server 2008

31 Jul 2011 by Manjuke Fernando

How to use the new MERGE statement feature in SQL Server 2008

SQL Server: Controlling SQL Server Log Information

15 Sep 2012 by aasim abdullah

How to control SQL Server Log Information

SQL Server: Script to Generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

17 Sep 2012 by aasim abdullah

SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

SQL-Server

SQL-Server-2008

SQL-Server-2005

SQL Server: Smarter Way of Query Load Testing at Testing Server

17 Sep 2012 by aasim abdullah

Smarter Way of Query Load Testing at Testing Server

SQL-Server

SQL-Server-2008

SQL-Server-2005

DMV-6: How Well Is My Stored Procedure Doing?

18 Apr 2013 by Rohitmssqlfun

This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.

SQL-Server-2008

SQL-Server

Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!

29 Jan 2014 by Rohitmssqlfun

Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!

Windows

SQL-Server-2008

SQL-Server

Do you know how to maintain your Google ranking while moving to a new site structure?

12 Jan 2010 by 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.

How to Unit Test SQL Server 2008 Database Using Visual Studio 2010 – Part 2

23 Aug 2010 by atverma

In this article I will explore the important features that can be configured to build comprehensive database unit tests.

How to Solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

26 Jan 2013 by Shahriar Iqbal Chowdhury/Galib

This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

Three Tricks to Get More Out of SQL Server in Common Web Scenarios

3 Jul 2012 by Leland Richardson

Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios

Sql Server - How To Write a Stored Procedure in SQL Server

12 Nov 2010 by 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.

Generic Repository Pattern MVC

29 Apr 2016 by Mayur V Lohite

Generic Repository Pattern MVC

.NET4

.NET4.5

.NET