Any SQL DBAs here??!!

Rawbee

Waiting for your video tutorial abt Sql.Please post it asap.

Hey SQL gurus.....I m really happy to see all the SQL Server gurus and they are ready to help the starter....I am taking training in SSRS, SSIS and SSAS.....I just follow the book and some appdev vid tutorial.....But I heard there is total different world in real life scenario...and the end clients also ask the scenario based questions.....I am in the market right now but the prob is I am not getting any requirement right now......the market is really bad ....so sooner or later I ll get the requirement ....I am just wondering if somebody can post real world scenario on SSRS, SSIS and SSAS...that would be great help for a starter like me.....thanx to jaynir bro for creating this thread...So SQL gurus help us out!!!!!!!

 

Well I have never worked with SSAS but have good experience with SSRS and SSIS

1) For SSRS,

a) You have to be good in T-SQL( New features of SQL 2005)

b)It will be basically based on Quarterly,Monthly and Yearly Reports that works in real time scenerio.

c) Learn about Layout and how it works (like formatting) for Reporting Services

d) Learn about Report Manager,Subscriptions

2) For SSIS,

a) It involves with getting  files from legacy system(Mainframe) in form of CSV and flat files and you have import into SQL Server and loop back again .

b) Getting data from Different database platform(Sybase,DB2,Oracle) depending on clients requirement.

c) Learn to practically use it.

Well I am SQL DBA but have exposure on these. I hope this helps.

 

that's interesting..!!

how important is T-SQL for DBA. I know having knowledge of T-SQL is good....but most of the things i prefer GUI, I don't know much about T-SQL. 

 

Hey JayNir,

If you are a DBA and want to automate jobs, autmate Database Tasks,  if you are working on SSRS you must know T-SQL.  If you know all sysobjects and architecture of SQL Server, it would be great and you will know all of their functionality. If you do not know T-SQL tha i would say you do lack something to be a perfect DBA....For me T-SQL is the most because let us take an example, if you are trying to count the records of  say 500 tables at a time, how you are going to do it? You cannot go to SSMS an right click and see the count or go for each table. In this scenario, you have to write a script, if you wish you can write a Stored procedure.  Also, if you are doing replication, you can set up a job to synchronize the data between two servers( source and target server). Thefore, i rely on T-SQL rather than GUI. We can do everything using T-SQL pertaining Database Admin and Dev also. 

It is just my thought and how i feel about using T-SQL and GUI.

 

Thanks,

Hi SQL gurus

How important it is to learn some .net codes for SSRS developer??? I heard SSRS developer should also learn some codes...Any idea!!!

Thanx

see this guys. It is really helpful

http://sajha.com/sajha/html/openThread.cfm?forum=2&threadid=65979

As a DBA,

You have to know about T-SQL for Reporting Services and DBA basics routine.

T-SQL is important.

1)When you have to deal with developers about their code and how to improve performance.

2) When working with SSRS

3)When you have to write scripts for DBA tasks like monitoring blocking, backup,Server-side traces

and more...

 

nmsake!!

Very True!!

 

thanks

jaynir, thanks for the link and the PM, much appreciated!

Guys, if you are looking for any materials on Oracle, let me know and I will try to see if I can hook you up. If you need any materials on SQL Server I know jaynir and smoothcriminal are the go-to people!

Cheers!

Hello!!

 

How to track log files in SQL server 2005??

 

 

 

You can Either use SQL profiler or Performance monitor to track log file growth. You need to frequently do transactional log backup to reduce log file growth.

For the beginners in DBA, where do they start from friends? I am interested in GUI part more. I know the basics of SQL. From where should I start my walk in DBA? what are the possible alternatives?

1. dba developer
2.  ssis
3. ssrs

which has the more marketing opportunities? please shade some light in it.

smoothcriminal..

how do u do that using perf monitor and profiler?? isn't there any dbcc sqlperf command to do so?? dont we need to use third party application to do that?

Jaynir,

You can do it with Performance monitor by choosing Database-Log growth Counter and log growth event  in SQL Profiler. Well DBCC SQLperf  doesn't give how it is growing . You can query sys.master_files to object size and growth. Yes, there are many third-party tools to monitor log growth and read log file like Luminent Log Explorer. We use MOM to monitor  log growth  which sends email to DBA if it is consuming huge space.

thanks Smooth!!

I m just done with my degree. I m thinking to get training on SQL Server. But confused, whether i should do SQL developer or SQL DBA. Please do suggest me.

Depends!!

I am into SQL Server DBA Because;

              I had 5 years of Experience in System Administration- 

             It really helps!!

I am not into SQL Server Developer Because;

             I don't like to write codes, script.

Scope wise, Developer and DBA both are good!!

hey!!

Do anybody know which replication is implemented when? How to make a decision trade off  between different replications? And What are the things to consider while implementing replication? What are the real time difficulty that DBAs face during replication implementation?

ay, what's good son!

came through to show your thread some love, keep it on top, keep the streets on lock, help the DBAs, Sajhaite DBAs United ORACLE/MS SQL/MYSQL/DB2 ... we takin ova one city at a time...... repping KTMC since '84, you already know!!

ImDevil,

Replication are very important for Reporting and Warm-standy purposes. In real time scenerio, you have to be good extensively in Transactional Replication and Merge Replication

a) Transactional Replication: We use this type when there are less subscribers and data has to replicated in transaction basis. You will come with issue like network disconnectivity,jobs are failing, Performance is really bad in publisher.

b) Merge replication: In my current project We are using it.  We have 1 central publisher and 15 Subscribers that synchronize on nightly basis. It is big headache when you have to deal with Conflicts and check connectivity and performance of each subscriber.