Wednesday, December 23, 2009

SQL Azure

Microsoft now offers a “cloud” version of SQL Server called SQL Azure. Cloud in this context means SQL Server lives out on the internet, on equipment managed by Microsoft. We access SQL Azure as a service over the internet either programmatically with Dot Net, or through the command line using SQLCMD. SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This article will demonstrate the use of TSQL commands to create SQL Azure objects.

Monday, November 16, 2009

Installing SQL Server 2005 Reporting Services 32-bit on a 64-bit Windows Server system

We have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine since there are other applications where we are using IIS on the 32-bit version. This article from MSSQLtips outlines the steps you need to take for this installation....

Read More

Tuesday, November 03, 2009

AJAX Guestbook

Unobtrusive AJAX Guestbook.XML is easy to use ajax and php guestbook application. Guestbook.XML is crossbrower, skinnable guestbook and web 2.0 script Read More

Monday, November 02, 2009

SharePoint 2010 Videos Reveal Development Experience

If you are curious what the development experience will be in SharePoint 2010, there are now 10 modules with multiple videos per module that go through the details of using Visual Studio 2010 to customize your SharePoint solution.

Read More

Thursday, October 29, 2009

Log on to Internet explorer as a different user

Here is a script that you can use to logon to Internet Explorer as a user that is not the same as the logged in user.

This script is a dos command --
runas /noprofile /user:domain\user "c:\program files\internet explorer\iexplore.exe"

This is particularly useful when you have limited user licences on a web based application.

Thursday, October 22, 2009

Making speedometers in Excel

I was wanting to create a speedometer gauge in excel and started researching on the internet. Here are the links that I came with...

Interesting article titled Make Excel Charts interactive with sliders, gauge, dials and more by Ashish Mohta

There are several add-ins available that can be used to create speedometers in excel. The one that I liked the most was at Mrexcel.com

The link that I most found useful was this -- Hack together a Gauge Chart in Excel without sweat

Wednesday, October 21, 2009

Project Gemini gets a new Name........

Microsoft has now given a new name for Project Gemini. It is called Power Pivot.

The official blurb about it is: "PowerPivot provides business users with BI at their fingertips while enabling organizations to efficiently monitor and manage collaboration using Microsoft SharePoint 2010 and SQL Server 2008 based management tools"

You can find more information at the powerpivot site.

Tuesday, October 20, 2009

Getting rid of overtype mode in word 2007

I had a very annoying 10 min. with Word 2007 today where the Insert key did not disable the insert mode.

Here are the steps I followed to get it back to working.


Click the Microsoft Office button
click Word Options.
Select Advanced.
Click the option to Use Insert key to control overtype mode.
Make sure the Use Overtyp mode is unticked.
Click OK.

Friday, October 02, 2009

Flade (Flash Dynamics Engine) is an open source actionscript 2.0 library for simulating 2D physics using Verlet integration. It currently features rectangular, circular, & wheel primitives, spring & angular constraints, and surfaces composed of line segments, circles, & rectangles. Read More

Wednesday, September 30, 2009

Creating a scorecard using Performance Point Server 2007

Microsoft is offering Performance Point SErver as part of its Sharepoint Enterprise edition 2007.

This is a very handy application to create some nice dashboards and scorecards for a company.

Here is a link from mssqltips.com that provides a step by step guide to create a scorecard using Performance Point Server 2007.

Friday, September 25, 2009

Scrum 101

Yesterday I attended the Girl Geeks Dinner in Auckland. There were 2 presenters Carolyn Sanders and Sarah both on Agile Development.

Presentation 1:
Carolyn Sanders. The core of the practice of Agile is the delivery of individual projects; it's where most practitioners start out and it fundamentally changes the way a project team works together and works with their stakeholders. Scrum is one of the most popular Agile delivery approaches at the moment. In this presentation, Carolyn Sanders uses one of her recent projects as a way to illustrate each facet of Scrum and how it panned out in real life, from start to finish. This talk is directed at developers, testers, project managers, PMO managers and CIOs - who are relatively new to Scrum and want to explore the practical detail at the day-to-day level of a single project. The session will end with a Q&A to allow you to explore how Scrum integrates with other parts of the practice of Agile, or dig deeper into how it worked for one team.

Presentation 2:
Sarah Fairbairn. Sarah is a senior developer who has worked on Agile projects in the past and is currently working on an Agile project. Sarah will give a presentation about development in an Agile environment, the pros & cons and pitfalls to look out for based upon real world examples.


I have embeded the link of Carolyn's presentation here

Saturday, September 05, 2009

Delete all data from a database

I had a requirement today to delete all data from a sqlser ver database. This database has about 350 tables with a lot constraints. I manually started identifying the order of deletion absed on the constraints and realsied that this can't be done in a day. So I hit the good old google for help.

Here I found a very detailed explanation of how to easily achieve this by Susan Sales Harkins. Read More

Wednesday, August 26, 2009

Tips for resizing an image in photoshop

I was having a problem resizing an image yesterday. When I did a search, I found this great article that retains the quality of the image. Read More

Thursday, August 06, 2009

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.

Monday, August 03, 2009

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

Tuesday, July 21, 2009

Project Gemini

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

Monday, July 20, 2009

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

Monday, July 13, 2009

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

Wednesday, July 08, 2009

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

Saturday, July 04, 2009

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]

Saturday, June 20, 2009

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

Thursday, June 18, 2009

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

Monday, June 08, 2009

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

Sunday, May 31, 2009

Thursday, May 28, 2009

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

Wednesday, April 08, 2009

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

Thursday, March 05, 2009

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

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

13 Most Desirable Collection Of Free Resources For Designers

Here are countless free stuffs available for designers which everyone should review at least once. In this post, I have collected 13 Most Desirable Collection Of Free Resources For Every Designer.

read more | digg story

How to use Icons to Support Content in Web Design

This article showcases beautiful examples and best practices of using icons to support content in web design. Please feel free to take a look at the showcases of navigation menus, search boxes, blockquotes and web forms.

read more | digg story

How to use Icons to Support Content in Web Design

This article showcases beautiful examples and best practices of using icons to support content in web design. Please feel free to take a look at the showcases of navigation menus, search boxes, blockquotes and web forms.

read more | digg story

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...