Sometimes operations (like drop, etc) will fail on your DB if someone running a command and locking a resource.
So I came up (or found somewhere) a query to tell me what’s currently running.
SELECT P.spid as SPID, P.kpid as KPID, P.dbid as DBID, D.name, convert(varchar, P.last_batch, 5) as StartDate, convert(varchar, P.last_batch, 8) as StartTime,
P.hostname as HostName, P.nt_domain as Domain, P.nt_username as Username,P.cmd as Command, P.waitresource, P.status as [Status],P.cpu as CPU,P.memusage as MEM,P.physical_io as IO
FROM sys.sysprocesses P
JOIN sys.databases D
ON P.dbid = D.database_id
ORDER BY D.name, P.cpu
This will return all the processes, sometimes you just want the processes for a specific user. Then you just need to add a where clause.
WHERE nt_username = ‘<username>’
I was using live mesh to sync my favorites, and some folders. I had to switch live mesh accounts and when I tried to use mesh with my new I got the following error
“This folder can’t be synced. It is already being synced, contains folders that are already being synced, or is in a folder that is already being synced. Please select a different folder or move this folder to another location.”
In order to solve this I deleted everything I could from the directory C:\users\<MYUSERNAME>\AppData\Local\Microsoft\Windows Live Mesh
Then I stopped and restarted live mesh. Then I had to setup what was synced, but I had no trouble after that.
When I first started blogging I wanted to blog on asp.net. I have a friend who already blog’s on asp.net (David Mccollough) and I asked him what the steps were (because they are not on asp.net).
Here is what he told me.
Well it’s a multistep process.
1st you have to create an account to be able to login, which I assume you have already done.
4th Before you first post you need to read this: http://www.misfitgeek.com/WeblogsaspnetNewBloggerFeedGrowth.aspx
Here is the original link to his blog post that outlines the process: http://www.misfitgeek.com/2008/06/16/JoinUsWithABlogOnWeblogsaspnet.aspx
Outlook is the one application I have open all day long. I don’t like most twitter apps.
So I was happy to find an add-in for outlook that will tweet for you. It can stuff all your new tweets in a folder (or your inbox) and you can save everything you tweet in a folder (like sent mail)
If puts a new toolbar in Outlook.
Here is the link
A coworker of mine (David Mccollough) told me about Community Credit. You use the website to track how your giving back to the developer community, ex. any blog posts or presentations you give at user groups, etc.
There is also a live writer plug-in, so when your posting it automatically updates Community Credit.
Here is the link that explains how to install the plug-in for 32 bit windows.
If you have 64 bit windows the path to the plug-in directory is “C:\Program Files (x86)\Windows Live Writer\Plugins”.
A co-worker of mine showed me Expresso, a regular expressions development tool.
If you need to create some regular expressions (which are a pain to create) from scratch expresso is the best tool.
Of course there is also http://regexlib.com/ if you want a great site to search for regular expressions.
More than once I have searched for something on Google and gotten back too many results that don’t matter. One of the problems with IT is that everything moves and improves quickly. It’s such a pain when get results that over 2 years old and don’t matter because the technology has moved on.
Use the advanced search of Google to get results that are relevant. You can tell Google what date range to use (how recent the page is), for example past week, past month, past year. That way you will only get pages in the results that are from the your date range. This helps when you’re working with bleeding edge technologies.