Fine Tuning your SQL code

Here is a great webpage that any SQL developer should read once in a while. It is a refresher course on some of the things you might have learned in college but forgot. sometimes we get in the habit of coding a certain way and get lazy

Tonight I was doing a little coding (girlfriend and I had a huge fight so I went back to the office) I just happened to change a couple things in the where clause around and noticed that the speed was improved. Since I was amazed and confused at the same time. My ADHD got the best of me and I quickly ignored my script I needed to write before tommorrow morning and spent the next 2 hours of my life solving this little puzzle.

IQA on the sidemenu

If you attended the 2006 Discovery conference. I spoke in a short but sweet workshop on the very last day on the very last timeslot about how to display various IQA queries on the dashboard.

Well that was only a step in my goal, which is to provide my users a way to quickly access their favorite IQA queries at any time during their iMIS workload.

I have developed a pretty neat way to include the IQA queries on every module's sidemenu without having to update each client's machine after every new IQA query is created.

Screenshot below

Basic workflow

I have two files stored in the ../system framwork directory

  • MyIQA-Submenu.html
  • Department-Submenu.html

For each sidemenu I want my IQA menu options to appear
I just add the raw html syntax not to forget to include the javascript that ASI uses to interact the popup window.

Inside each Submenu.html file contains an object tag. For those HTML coders out there: Since ASI uses windows.createpopup for their menus, a popup window does not render all html tags including the useful iframe.

the object tag just calls an .ASP page that pulls the names of the queries from the iMIS DB and displays the list.

How does it know the queries to pull

In our shop, we have organized our IQA into various folders. every iMIS users has their own folder Report view/Personal/userid and every department has their own folder Report view/Department/departmentname. I have create a SQL view that includes all the iMIS userids. their matching iMIS ID and their department.

Download iBO for .NET

Can someone let me what to do to download iBO for .NET?

Handy utility for Windows XP users: Taskbar Shuffle

If you’ve ever wished you could change the order of your application buttons in the task bar, or have ever wanted to just drag and drop your taskbar buttons around so you could have them in the order you want, this utility is for you.

Also, if you’ve ever wished you could have control over taskbar button grouping and when/if they ever collapse into one button, this utility is for you.

SQL Prompt - Free

There is still one day to get your free copy of SQL Prompt

SQL Prompt provides Intellisense® style auto-completion for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation. SQL Prompt can be downloaded free until the release of version 3, and Red Gate are providing forum support on the SQL Prompt support forum. A web help file is also available.

IE 7 Automatic Updates

Automatic delivery of Internet Explorer 7 (IE7)

Internet Explorer 7 will be distributed as a high-priority update via Automatic Updates shortly after the final version of the browser is released. Organisations can use a non-expiring Blocker Toolkit to block delivery to their users.

Searching for knowledge that doesn't exist - Yahoo! Answers

Went to session with Bradley Horowitz - VP of Technology Development Group for Yahoo! and heard him talk about the acquisiton of flickr and how to lower barriers to partipation in collaborative environments...all very interesting...but then he started talking about Yahoo! Answers.

As product manager for eSeries/eCM, i am on a daily basis both intrigued and haunted by search. It's the inevitable siren calling - the lure of a better and more precise search experience. I hear it from customers, partners, anyone who does anything on any website....My favorite from back in my consulting days has to be the inevitable comparison to google where I would hear...

Quick Poll: How well do we work together?

Just back from User Experience Week 2006 - which is a great intersection of practioners/industry experts from both profit/non-profit worlds of user experience/interaction designers/product managers/information architects....anyone involved in excperience design. more on conference to come as I get time.

Attended a great session by Chris Conley of Gravity Tank, ITT Professor about how we have really lost teh ability to work together creatively and collaboratively with organizations. I'm curious to hear your thoughts?

Workshop: Discovering requirements from use cases

Not summarizing the class contents, but just recording some thoughts. My disappointment is not with the instructor, who has great knowledge and interest and integrity -- a career focused on transforming software development art into repeatable craft; rather, I felt let down (as I so often am with methodologies) by the fundamental impracticality or impossibility of the methods being taught.

His premise was all about the primacy of requirements, that deeply comprehensive and accurate requirements make true engineering possible. I believe that. Yet human language-based requirements are wildly difficult to disambiguate, even with exhaustive effort; therefore, he proposes use case development and many other mapping activities to flesh out these details until validity/verifiability is fully realized.

Training Summary: Managing Multiple Priorities

Training Summary: Managing Multiple Priorities
Instructor: Anne Pritchard
MicroAssist July 31, 2006
Topic: How to become effective and efficient in handling multiple goals.

General Comments: The class was held at the Norris Conference Center next to Beall’s at Northcross Mall. MicroAssist provided a nice lunch. The instructor followed the agenda in her handout, but she didn’t read her handout. She aligned the topic with appropriate analogies and solicited input from the students. She was prepared and enjoyable. This was a nice refresher course.

Syndicate content