The DBA Blog by Tomer Lev

SQL information, scripts, tricks and more…

Good DBA must support his clients

It does not really important what kind of a DBA are you: applicative or infrastructure one… the one thing you will always need to do is giving support and help to your clients: a client can be a market sales man, analyst, programmer or your CTO. You need high skills of support, if you want to be a professional DBA (and more…, but this one is very important also). Your sales man will come and ask you to give him all reports on sales made yesterday, and on which hour and to slice in by community; the analyst will want a report on member’s usage and the programmer will need help in T_SQL. You must know how to help all your clients, even if they come all at once, you will need to know how to say politely to each one of them when you will be available for doing the requested work. If you will answer politely with no press – they will all say it is nice to work with you and that you look professional in your line of duty. You, from the other hand, will need to do all you have promised to your clients. A good DBA, even if he is very professional, it does not look good, if he does not know how to give service to his clients. For example, if a programmer comes to you and wants your help in writing a stored procedure, and you are very busy with other things, give him a service by telling him that you have 10 minutes for him now, and you will be happy to help him later. I saw the other example, that a programmer came to a DBA to ask him for this help, and the DBA told him he does not have the time for him and he does not do these things. The first thing this programmer did is telling his colleagues not to go to the DBA and ask for help – not just this made the DBA a “bad name”, but also the company he works in damaged, which can lead also to bad performance on servers, due to the fact the programmer will upload a stored procedure to production servers with no help from the DBA, because the DBA does not want to help – it’s a pity! And wrong!

Want to be a good DBA – you must know how to give service to your clients!

Advertisements

June 27, 2009 Posted by | General | , | Leave a comment

Defragmenting Indexes in SQL Server 2005

http://weblogs.sqlteam.com/tarad/archive/2008/09/03/Defragmenting-Indexes-in-SQL-Server-2005.aspx

I think this may come in handy…

June 26, 2009 Posted by | General, SQL SERVER, Tips | , , | Leave a comment

Tweet-SQL

Integrate your application in super quick time using Tweet-SQL. Tweet-SQL promises to allow fast and easy Twitter Integration through the use of CLR stored procedures on Microsoft SQL Server. A quick summary of Tweet-SQL…

http://sqlclrnews.blogspot.com/2008/09/easy-twitter-integration-with-tweet-sql_3653.html

June 26, 2009 Posted by | General, Scripts, SQL SERVER | , , | Leave a comment

Useful bit of code

create table #temp (spid int, status nvarchar(max), login nvarchar(max), hostname nvarchar(max), blkby nvarchar(max), dbname nvarchar(max), command nvarchar(max), cputime int, diskio int, lastbatch nvarchar(max), programname nvarchar(max), spid2 int, requestid int)

insert #temp exec sp_who2

select hostname, count(*)
from #temp
where hostname != ‘ .’ AND login = ‘your login’
group by hostname
order by hostname

drop table #temp

This way you can filter sp_who2.

enjoy 🙂

June 26, 2009 Posted by | Scripts, SQL SERVER | | Leave a comment

Sql server 2008 tools

find it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

June 26, 2009 Posted by | General, SQL SERVER | | Leave a comment

Craig Freedman’s SQL Server Blog

http://blogs.msdn.com/craigfr/

It seems like a very interesting blog. You might find it useful…

June 26, 2009 Posted by | General, Tips | , , | Leave a comment

Data Warehouse Query Performance

sql server 2008
Data Warehouse Query Performance:

http://technet.microsoft.com/en-us/magazine/2008.04.dwperformance.aspx

June 26, 2009 Posted by | Administration, General, SQL SERVER, Tips | , | Leave a comment

Internals Viewer for SQL Server

http://www.codeplex.com/InternalsViewer

Useful for extreme optimizations 🙂

June 26, 2009 Posted by | General, Scripts | Leave a comment

SQL Server 2005 SP3

check it out over here:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/18/my-latest-sp3-experiences-two-thumbs-acting-like-divining-rods.aspx

June 26, 2009 Posted by | General | Leave a comment

Microsoft SQL Server 2005 Integration Services Step by Step (Free E-Book)

check it out over here:

http://csna01.libredigital.com/?urrs4gt63d

enjoy 🙂

June 26, 2009 Posted by | SQL SERVER | Leave a comment