SQL Server Blocking Script

Here is a handy script to check sql server blocking.

SELECT p.spid
, DB_NAME(p.dbid) AS [DB Name]
, p.program_name
, SUSER_SNAME(p.sid) AS [Login Name]
, p.hostname
, p.cmd
, p.status
, p.blocked
, login_time
, last_batch
, p.spid
FROM master..sysprocesses p
WHERE p.blocked <> 0
AND EXISTS ( SELECT 1
FROM master..sysprocesses p2
WHERE p2.blocked = p.spid )

I got it from a dba for arabic dating site. They have millions of users and all pages are served from database, this can become very useful to monitor blocking.

The site is back

Well my site SQL Server DBA is back online. I am thinking of creating a new job section which should be comming soon. I have to work on it and like always lack of time kills my plans.

Still i am hoping to finish it soon. The main part of SQL DBA JOBS is still pending, database jobs are increasing every day because companies are collecting more and more data and need someone to manage it for them.

Now the next project which i find interesting is the arab dating website database optimization, the site is not bad at all fun to work, staff is friendly. We are going to make some major changes to it…. I like funny work like my freaky life kind of sites and working on their systems.

the horoscopes world

The world of zodiac signs and horoscopes, recently i did some work for a astrology website. It was fun just basic mysql database, later i bought two of their products now the amazing part is that it was so close to unbelieveable

The horoscopes world did a great job even i am skeptic and not a big believer on horoscopes but it was money well spent. Now i am thinking how does this whole horoscopes and planet stuff works any way, may be need to buy a book to read in my spare time.