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 […]
Y pasa con todo. La regla general es que si vale $50 en USA vale 50 000 colones en Costa Rica qie son basicamente el doble. Que aguevado vivir en un pais tercermundista con salarios variables pero no tanto como pais de primer mundo y aun asi pagar todo a precio “premium”. Este es solo un ejemplo de hoy:
Conference calls can be a pain. Nothing replaces face to face conversations however cost can be prohibitive sometimes. Does this sound familiar? or http://conferencecall.biz/ And if it does, then take a bit to look at this site and identify if you are a freelancer, consultant or simiar: http://clientsfromhell.net/ And of course fun for geeks: http://thedailywtf.com/
A couple of years ago I wrote what I thought about meetings. Today I will add another thought If you have a 30 meeting where there are 10 people sitting down with you, this is not actually a 30 minute meeting. It is instead a 30 min * 10 people = 5 hours loss of potentially very productive time. Moral of the story: keep meetings short and only invite those who really need to be there.