Skip to content

This Blog Has Moved!

Please Follow my new blog @

Steve Jobs, Thank You

October 6, 2011

No words can ever express how thankful this world is to you, Steve. You led the way. You left a mark. You left us a better world.

Apple Icon

Photo Courtesy of


FREE SQL Training In Los Angeles!

August 15, 2011

Red Gate’s “SQL in the City” will be in Los Angeles on October 28, 2011! That’s a Friday so make sure to check your schedule.

Verbatim from Red Gate’s Flyer:

Here are some facts about SQL in the City which may help convince your boss to let you attend this free SQL Server training event:
1. It’s a full day of SQL Server training for free.
2. You’ll meet SQL Server MVPs with years of SQL Server experience, who’ll provide you with training which you can put into practice back in the office.
3. You’ll learn new skills specific to SQL Server to help improve your daily tasks from top SQL Server experts.
4. You’ll meet the people who’ve developed the tools you use to help solve your problems.
5. This is your chance to ask Red Gate developers, product managers and other users questions, and get answers face-to-face.
6. You’ll be able to make suggestions and give your feedback about products that could influence the future development of Red Gate tools.
7. You’ll get to network with professionals who are as passionate about SQL Server as you are. 
8. Refreshments and lunch are included for free, so you won’t go hungry whilst you’re out of the office.
9. The event is in a great location with excellent transport links, so it’ll be no hassle to get there.
10. The event aims to be an awesome training experience unlike any you’ve experienced before.

Richard Branson’s Habit For Success

April 21, 2011

Warning: This is a non-tech post, but I’d say it’s an essential one. Read on…

It is seldom for small blogs (such as mine) to have a guest post coming from a high profile and well-established writer and author, such as Erik Calonius. Erik is a former writer and editor for Wall Street Journal and writer for Fortune.

The post is about a habit that contributes to the success of Richard Branson, Founder & Chairman of the Virgin Group of Companies.

Maybe you, too, can benefit from this habit.

I want to share this post with you for 2 reasons:

1. This is a habit being practiced by Richard Branson for many years. According to him this is what made him successful.

2. This is a simple habit you can incorporate in your system, regardless of the job description you have. This is a good habit to cultivate.

Read the post here:

How To Overcome Disruptions And Achieve Your Productivity Goals

April 7, 2011

How To Overcome Disruptions And Achieve Your Productivity Goals.

2010 in review

January 4, 2011

The stats helper monkeys at mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

About 3 million people visit the Taj Mahal every year. This blog was viewed about 57,000 times in 2010. If it were the Taj Mahal, it would take about 7 days for that many people to see it.


In 2010, there were 25 new posts, growing the total archive of this blog to 214 posts. There were 23 pictures uploaded, taking up a total of 1mb. That’s about 2 pictures per month.

The busiest day of the year was February 17th with 329 views. The most popular post that day was Find Active Sessions in Oracle Database.

Where did they come from?

The top referring sites in 2010 were,,,, and

Some visitors came searching, mostly for ssrs tutorial, oracle active sessions, isolation levels in sql server 2005, tsql cursor, and sql server 2008 triggers.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


Find Active Sessions in Oracle Database June 2008


How To: SQL Server Trigger 101 June 2008


How To: Set Your Oracle 10g Database to ARCHIVELOG Mode August 2008


How To: Report Authoring in SSRS 2005 – Part IV (Adding Parameters) May 2009


Isolation Levels and Locks in SQL Server 2005 May 2008
1 comment

Help Make SQL Server Better

October 27, 2010

If you’ve been working or tinkering with SQL Server and you think you can help make  SQL Server a better database platform, the SQL Server RDBMS Group needs your opinion via their online survey. This survey targets those who have jobs that involve the SQL Server Connectivity components – mainly developers.

If you think that SQL Server Connectivity components need to improve, you wouldn’t want to pass up this opportunity to participate in a survey that will have a great impact on the decision of the SQL Server RDBMS Group at Microsoft.

The purpose of these surveys, according to the SQL Server Team Blog, is to “provide the SQL Server Team with an ability to validate some of the requests they have got from developers, users and partners as well as ideas that they have gathered internally as a part of their development process.”

The survey will be available until November 2, 2010 @ 5PM PST. If you’re interested in taking the survey, you can access it here:

Microsoft Releases SQL Server 2008 SP2

October 6, 2010

From the download page:

Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. These packages may be used to upgrade any edition of SQL Server 2008. We remain committed to providing our customers with essential changes via Service packs. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8.  While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.

Release Notes:

Download Page Here:

As a side note, if you are still on SQL Server 2005 SP2, Service Pack Support for SQL Server 2005 SP2 has ended as of January 12, 2010. More info here:

  • Archives

  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video

  • Software Blogs - BlogCatalog Blog Directory