SQL Server mySQL Hosting

There are many database hosting providers out there but reliability and validity is always an issue specially when you dont have physical access to server.  I always wanted one specialized database hoster who does one thing and do it best. I guess some one heard my cry for help and sent me link for sql server hosting and mysql hosting company.

I used them for few months and just loving it. The price is not cheap but with all the features available including database administration services makes a big difference.

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.

Search Engine Optimization

Recently i needed some search engine optimization for a SQL DBA website after looking at few SEO firms i decided to go with a florida search engine optimization or florida seo firm they are already famous for real estate seo because of having great results and most of all there pricing was very acceptable for me, i honestly was looking for very basic optimization with lowest cost possible.

The greatest thing about this adventure is that, just after 2 months the site got on first page where the competition was 48 million i thought its a joke but when the traffic increased i was amazed with the service provided in such a cheap cost. Another SEO company asked me above $25,000 for it and i paid nothing compared to 25K with better results.  I am impressed with the level of service and SEO results.

What Does SQL Server DBA Do ?

The main task of SQL Server DBA is managing sql server, depending on type of DBA position they hold it can be programing i.e. writing sql scripts as development dba, review others scripts like QA. If they are production DBA then no much programing work is involve on daily basis but lot of responsibility, monitoring of performance, moving of objects from QA to Production, backups and optimization.

First SQL Server DBA Post

Welcome to SQL Server DBA website. This is my first post, i am a SQL Server DBA with experience in SQL Server, Oracle, MySQL and SAP database administration. I am also certified MCDBA, MCSD, MCSE and MySAP Admin. I have 8 plus years of experience in computer programing, database administration and web development.