Happy is a good way of describing it. However it goes beyond that. I am grateful that I have been chosen as a speaker in Atlassian’s 2014 Summit! If you are reading this before the conference you can find me here: Atlassian Summit 2014 Take a quick look: All these years working hard with Agile and Jira pay off! Silicon Valley, here I go!
This is just a quick rant/question. Does anyone know why you have to type your password twice when setting up the Application Pool Identity in IIS? It seems an extremely dumb feature as #1 you can copy paste the password or #2 just type it but given you usually include service accounts here with stupidly complicated passwords then why do you have to suffer typing it twice? Windows “evolves” but the underlying things are exactly the same. Can’t Microsoft spare a little bit of time making Windows more usable and fix little itty bitty things like this one that overall will have a better user experience? Oh well, who cares about devs anyway!
So I am taking databases offline and I need to find out which ones have active connections to them. People usually do a sp_who However that brings a lot of info that I don’t need. I prefer to use this query so I see the DBs with number of connections! SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame ; Brilliant query!
We had a spaghetti of database owners so I decided to get this straightened out. How to do it? Simple! – Open New Query in SQL Server Management Studio in the database that you want to change the owner – Run EXEC sp_changedbowner ‘domain\owner’ – Wait for Command(s) completed successfully. As simple as that!
So Google Drive’s price hits rock bottom killing everyone else, $2 for 100GB and $10 for 1TB monthly. Should I stay or should I go? So I have explained before why Google Drive sucks, but now at this price the name of the game changes. So there were two blockers for me: – No throttling which dropbox does brilliantly – No LAN sync Ok, so Google Drive is still a B product against the competition and can’t do LAN sync. But there is a way to do throttling. Not built in, but it lets me use Google Drive without being shot (kind-a) by IT Get NetBalancer by SeriousBit. I am not affiliated with them in any way but they have a killer product! You can throttle your processes And check this out. This is instant gratification for a geek like me! It even has a very small gadget plus another one in the task bar just with the ups and downs. Now only one thing pending, LAN sync! C’mon Google! Make it worth it! One detail about LAN Sync: Nothing to do at this point. Google Drive is even so dumb that if you copy the files first it does […]
Today I find myself removing a stored proc from our dbml because it is no longer in use. This stored proc updates the document information to be exported. I check our source code and indeed no one uses it. So I go ahead and remove it. Is that the end of the story? Usually it is, but I decided to use a bit of common sense to find out if this is the last step or no. It wasn’t. Let me explain and get to the moral of the story quickly: – We have a requirement to export the information of up to several tens of thousands of documents into Excel/Word/XML in a single go. – We used to need to make sure that the document information is up to date, and given the source is in XML and XPath is rather slow, we built an intermediate SQL Server table to be able to have speedy exports. – We made a change and now information is always up to date in the intermediate exports table, however the code that CHECKS if the information is up to date was not removed. – So the info is not updated as it is […]