Getting it done with Doit.im and GTD

Nice GTD App

If you like GTD, check this one out

I can’t think of many products that incorporate a period in the name of their product, but Doit.im isn’t like any other product I’ve seen. I believe that I’ve finally found a tool that works for me on all levels of GTD (Getting Things Done). There are multiple clients so that regardless of where you are capturing data you should be covered. I stumbled across this software in the form of an Adobe Air application while looking for something else for project management. Turns out, this product met a bigger need than what I had been looking for. It offers clients for the iPhone, iPad, and Android so you’ll have your mobile device covered if you are using a non-Microsoft format. There’s also a download for Windows, but I tend to prefer the web client. The web interface offers an old version and a beta version, and I tend to gravitate towards the old version a bit more. The best part of all of this is that the software is free. I’m not sure how long it will stay that way since it’s a pretty slick tool in my mind and way better than some of the other implementations of GTD that cost money. It’s all in the cloud as well, so your data is accessible from multiple places. They are located in China, so you might want to check out the privacy and terms so that you feel comfortable. I would advise to always be careful what info you put out there with new software.

Drop by their site and give it a go, and I’m sure you won’t be disappointed. You can read more about them on their website. Check out the API and see what you can do with it.

Doit.im FAQ Center
Doit.im Dev Center (API info)

Comments { 0 } Posted on August 29, 2011 in General, GTD, Tech, Windows

The downside to being in IT

slouching

Can't be good on the back

How many times have you found yourself slouching or basically stuck to your office chair. If you are anything like me, you spend an average of 10-12 hours a day in a desk chair while in front of a computer. I was amazed when I first saw this planning worksheet that would help you determine the proper position for your desk, monitors, keyboard and even chair. The first time I measured I was so far off that I figured there was no wonder my back was hurting. You can go to the Ergotron website and fill out the form to print a copy or you could just print some blank ones out to hang up on the corkboard at your office. I hung up one copy last week, and someone made copies and pinned them beside  it. Hope this helps you not feel so sore from sitting in a chair all day, and maybe it’ll convince you to get up out of your chair more.

Comments { 0 } Posted on August 22, 2011 in Education, General, Life, Tech

Beginning SQL Joes 2 Pros Giveaway

My Books

Laptop, stickers, and artsy fartsy photo filter from camera+ not included 🙁

If you haven’t heard about the excellent giveaway that Pinal Dave (Blog|Twitter) is putting on then you are missing out. I had a little more time in the beginning to participate so I was very fortunate to receive my prize yesterday. I remember reading Pinal’s review last year and wanting to check it out for myself. I’ve got a few of the series on the Kindle and I highly recommend it to those starting out with SQL Server. Pinal also did an interview with Rick A. Morelan (Blog|Twitter), who authored the books and I would encourage you to check that out as well.

Don’t forget to head on over to Pinal’s blog and get in on the contest as there is plenty of time left to learn more about SQL and possibly win something in the process.

I’m starting to be more vocal about getting my readership up on the blog, so I’m going to start asking more questions about how I can improve things. Please feel free to add comments in the meantime if you see something that I’m doing that isn’t working or a way that I can reach more people. Ideas for posts are always welcome as well.

Comments { 1 } Posted on August 18, 2011 in SQL, SQLServer, SQLServerPedia Syndication

Deleting Data in Small Chunks on SQL Server

Chunky Shirt

I’ve had this post on the backburner for a bit of time, but Glenn Berry (Blog|Twitter) recently posted on gradually deleting data in SQL Server and that made me think of it again. I would advise looking at his post for guidance on how to effectively clean up your data in chunks, but I want to give you a little more background on what made me want to post this.

For some time, I’ve been using the following code to perform the task:


SET ROWCOUNT 10000
--DECLARE @Text varchar(255)

--SET @Text = 'Deleted 10000 rows'
DELETE  FROM [database].[dbo].[table]
WHERE   DateChecked < '2011-01-01'
WHILE @@rowcount > 0
BEGIN
DELETE  FROM [database].[dbo].[table]
WHERE   DateChecked < '2011-01-01'
--PRINT (@Text)
END
SET ROWCOUNT 0
GO

So when I answered a post on ask.sqlservercentral.com that seemed to be fitting for my answer, I got the opportunity to learn a few things that I wasn’t aware of. Pavel Pawlowski (Blog|Twitter) pointed out that it’s better not to use SET ROWCOUNT.

On SQL Server 2005+ it’s better to use DELETE TOP 10000 instead of SET ROWCOUNT 10000. Also you can read on MSDN SET ROWCOUNT (Transact-SQL).

He mentions SQL Server 2005 and later, but what about SQL 2000? Does anyone have a preferred method when dealing with SQL Server 2000 that’s different? Is there a one size fits all?

Comments { 0 } Posted on August 16, 2011 in SQL, SQL Server 2000, SQL Server 2005, SQLServer, SQLServerPedia Syndication

Fill up my Kindle

I finally broke down and got a Kindle 3G Wireless 6″ from Amazon. I’ve been reading a few titles from the Kindle for PC software trying to determine how tech books would show up to see if I would lose anything by not getting the real book but it’s hard to tell. I asked on Twitter a while back and only got one response saying that there weren’t many tech books on the Kindle.

Well, here’s your chance to post your first comment on the ol’ blog. Are you an author who’s book on Kindle show’s up beautifully? Are you an MVP who carries your Kindle around with you? Hoping SQL Server MVP Glenn Berry (Blog|Twitter) gets his way and more great books come to the Kindle. I’ll help him by clicking the link on the Amazon page for his book telling the publisher we want the book on the Kindle. I’ll probably buy the hard copy anyway because of the rave review Brent Ozar (Blog|Twitter) gave it, and the fact that it’s the only book of its kind that I’ve seen. Maybe Glenn can right all the wrongs in the SQL Server building world. I’m pulling for him.

So, if you have a tech book (SQL or not) that you can say for sure looks great on the Kindle and doesn’t lose content or readability by being on the Kindle then please post it here in the comments.

As always, if you have comments or suggestions on how I can make this blog a better resource then please feel free to share. And for the few brave souls who’ve made it to the last sentence of this post…I’ll let you know there’s a big redesign of the blog coming up which will hopefully improve the focus and readability.

Update: Not sure why I didn’t get the email notifying me that Glenn had responded to my comment on his blog, but the book is now available on the Kindle.

Comments { 2 } Posted on August 5, 2011 in SQLServer, SQLServerPedia Syndication