Converting DTS to SSIS in SQL SERVER 2005

The easiest way to convert your SLQ SERVER 2000 DTS packages to SSIS is to use a tool called 'DTS xChange' that is available for download here

Here is link to the webcast by Brian Knight of Pragmatic works explaining in detail as to how to proceed with the DTS xChange tool.

One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach.

Also, this information can be used to shrink data files as needed if there is a lot of free space in the files. In this tip from MSSQLTIPS they take a look at a few ways to find the current free space within a database, so you can better manage your database files.... Read More

Project Gemini

Project Gemini is a powerful data analysis tool. Here is the link for the sneak preview of Project Gemini.

Building a dashboard using SSRS

Here is a tip from MSSQLTips I found useful on how to create a dashboard using Sql Server Reporting Services.

Read More

Introduction to AJAX

This is an excerpt of Chapter 1 from the book, ASP.NET 3.5 AJAX Unleashed, authored by Rob Foster.

Here is the link that was posted on codeguru

CSS Forums

If you are intermediate in CSS and looking to enhance your CSS knowledge then this post going to help you. By joining any of the following CSS forums will help you to boost your CSS knowledge.

Read More

Browsercap.ini update for IE 8

As soon as the Internet Explorer 8.0 was released and our customers have updated to IE 8.0 I started having queries about crystal reports compatibility with IE 8.0

The fist step I took was to update the browsercap.ini The code I used to update is as follows:

[code]
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; IE 8.0

[IE 8.0]
parent=IE 7.0
version=8
majorver=8
minorver=0

[*(*MSIE 8.*Mac*)*]
parent=IE 8.0
platform=Mac

[*(*MSIE 8.*Win 1*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 2*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 3*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win 9*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win N*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Win X*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 1*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 2*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 3*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows 9*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows N*)*]
parent=IE 8.0
platform=Win

[*(*MSIE 8.*Windows X*)*]
parent=IE 8.0
platform=Win





[/code]

How Ajax works

AJAX has gotten more and more popular over the years, and has allowed web applications to act more and more like desktop applications. AJAX can provide a lot of additional functionality that could not be accomplished any other way.

Read More

Substring syntax in sql

Yesterday I was trying to get a part of a string from a field where the first comma occurs.

For example there is a field named 'Descriptor' which is a combination of "full name, Date of birth, unique number of the record" in that order. I wanted to get the full name using a select statement.

Here is the syntax I used.


select substring(descriptor,1,charindex(',', descriptor)-1) as [fullname]
from contacts

CSS Bubble Tooltips

Avoid cross-browser javascript when you can use css to make tooltips with less code. Honestly you were going to use css to style your tooltips anyway right? Your probably already have most of this code in your css already too. You can hover over meThis is my Bubble Tooltip with CSS to see how well these bubble tooltips work. Besides that if you have an advanced site in the first place you probably have enought javascript already.

For more info click here

Coding a Clean Web 2.0 Style Web Design from Photoshop

Here is a tutorial link for creating a clean web 2.0 style web design in photoshop.

Read More

20 best tutorials to convert Psd to Html/CSS

Here is a list of 20 best tutorials to convert Psd to Html/CSS. These tutorials should help you learn how to find the best way to code it.

Read More

Getting started with Sql Server Analysis Services

Here is a tutorial from MSSQL Tips on SQL SERVER Analysis Services.


Read more

In most organizations today, business critical and confidential data resides in some type of database, increasingly, SQL Server. As a result, SQL Server database security and compliance have become critical issues that must be effectively addressed to ensure an organization’s overall security. The goal is simple - minimize business risk, data theft, and data losses through good security practices. This whitepaper gives an overview of 10 key areas you need to focus on in order to ensure SQL Server security, and avoid finding your company in the headlines.

Click here to download the whitepaper

7 Free Resources for Eye-Popping Graphics and Animation

A picture will always be worth a thousand words. The good news is that in the open source world, there are many excellent, free graphics and animation tools, plus free resources for getting started with them right away.

read more | digg story

7 Free Resources for Eye-Popping Graphics and Animation

A picture will always be worth a thousand words. The good news is that in the open source world, there are many excellent, free graphics and animation tools, plus free resources for getting started with them right away.

read more | digg story

Paper+Color+Concept=40 Creative & Inspirational Piece of Art

40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attention and effectively convey the message.

read more | digg story

Paper+Color+Concept=40 Creative & Inspirational Piece of Art

40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attention and effectively convey the message.

read more | digg story

7 Fresh and Simple Ways to Test Cross-Browser Compatibility

This post is written for designer, developers, or anyone else who has struggled with testing their websites across multiple browsers.

read more | digg story

10 Steps To The Perfect Portfolio Website

You may have a personal portfolio website for a number of reasons. If you’re a freelancer, then you’d need one to showcase your work and allow people to contact you. If you’re a student (or unemployed), then you’d need one to show prospective employers how good you are and what you can do, so that they might hire you.

read more | digg story