Well basically it happened to me today! Mainly because of Memorial Day, I had the chance to clean up my inbox. However this does not mean only reading or glancing one email after another or “Mark all as read:. Do the following (some taken from the “Getting things done” book by David Allen, just a bit modified for my needs) – If there is nothing you can do about it, simply mark as read and let it go. This is the most difficult one of all categories because it is hard to accept that there is nothing you can actually do about it. Accept it – If you can do something but not now and it is not that importante, then [create a task in Jira (I have my own) or some other task tracking/Kanban/post it/whatever system you use] so that you can take care of it later. This is your “do it later, not important queue”. – If it is important, you can complete it now and it is (relatively) quick then – If it is important but you can’t complete it now, then schedule it in your important queue. Use Kanban when possible. No more than 5 important […]
My last post was about taking databases offline, which if in use can be very problematic. So before doing anything that can be interrupted if there is an open connection just run this: CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255), Login VARCHAR(255),HostName VARCHAR(255), BlkBy VARCHAR(255),DBName VARCHAR(255), Command VARCHAR(255),CPUTime INT, DiskIO INT,LastBatch VARCHAR(255), ProgramName VARCHAR(255),SPID2 INT, REQUESTID INT) INSERT INTO #sp_who2 EXEC sp_who2 SELECT * FROM #sp_who2 -- Add any filtering of the results here : WHERE DBName 'master' -- Add any sorting of the results here : ORDER BY DBName ASC DROP TABLE #sp_who2 Please note that sp_who2 is undocumented by Microsoft so it might change
Taking a database offline is a very simple task. Right click on it and select ‘Take offline’. However, if the database is being used at the moment the action will fail and your database may remain in limbo for a (sometimes long) while. Msg 952, Level 16, State 1, Procedure sp_who, Line 79 Database ‘UATdb’ is in transition. Try the statement later. Try this instead: ALTER DATABASE UATdb SET OFFLINE WITH ROLLBACK IMMEDIATE
Simply because Google Drive is crap. Here is a list of things it did to me: – No LAN sync, don’t know if already fixed but it is impossible to sync 100GB on each machine, and they are next to each other in the same LAN – Duplicated my files, when I reformatted the computer and tried to install it again. Dropbox recognizes it is the same folder and files so no need to redownload the 100GB again – Have two computers, next to each other, and they show different file counts. I reported to Google and they said just restart Google Drive. No luck – And last but not least, I turned if off a few days and not tried to turn it on again. Guess what… It “forgot” I had already downloaded my many GBs of files and is trying to set up a new folder. Which will duplicate my files again and again and simply just make me lose my time. Bye Google Drive, welcome 200 GB Dropbox
IMHO Jira is the best bug tracking system all around. It is very user friendly, it is extremely extensible, there are tons of add ons to customize to your needs and GreenHopper brings Agile to Jira. There are many other things worth looking for, but the one great feature where I needed some help was in the worklogs. Basically when you have a task assigned to a developer, you would like to be able to know what kind of effort/time went into completing it. Well, there is one flaw with this plan and that is that developers need to be very disciplined into entering their hours daily. Also, they need to make sure that they did not leave any tasks out. So for me the easiest way to make sure that a dev did fill in all of their hours properly was by adding the “Recent Worklogs” add on to their tasks dashboard. Click here to get the add on Check it out: Now devs do not have any excuse of forgetting to fill in their work logs. They can see this dashboard and immediately know which day they left out.
An image is worth a thousand words I’ve heard. Look at the following image. It is VERY SIMPLE. I have two computers which even more are in the same network, actually sitting one next to each other (which works wonderfully in Dropbox’s LAN sync) and they are showing a different number of files, about 4GB difference. So why do you want to use a Google Drive for syncing files, when it can’t sync files?!?!?!?!? 1071 files in one computer, 1041 in the other one! Google: you need to try harder. Not criticizing you, but don’t release a product that works with users files and that does not work! I reported the problem here https://productforums.google.com/forum/#!msg/drive/TZ4pq4fInaY/QG3VFDTlI88J