[Show all top banners]

JayNir
Replies to this thread:

More by JayNir
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 SQL DBAs

[Please view other pages to see the rest of the postings. Total posts: 60]
PAGE: <<  1 2 3 NEXT PAGE
[VIEWED 21089 TIMES]
SAVE! for ease of future access.
The postings in this thread span 3 pages, View Last 20 replies.
Posted on 11-11-08 10:00 PM     Reply [Subscribe]
Login in to Rate this Post:     1       ?     Liked by
 

Any SQL DBAs here??!!



 
Posted on 11-14-08 2:38 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Rawbee

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


 
Posted on 11-14-08 6:04 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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!!!!!!!

 


 
Posted on 11-14-08 6:16 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.

 


 
Posted on 11-15-08 10:39 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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. 

 


 
Posted on 11-16-08 8:06 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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,


 
Posted on 11-16-08 11:22 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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


 
Posted on 11-16-08 11:55 AM     Reply [Subscribe]
Login in to Rate this Post:     1       ?     Liked by
 

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...

 


 
Posted on 11-16-08 11:59 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

nmsake!!

Very True!!

 

thanks


 
Posted on 11-16-08 10:55 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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!

 
Posted on 11-18-08 9:52 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Hello!!

 

How to track log files in SQL server 2005??

 

 

 


 
Posted on 11-18-08 10:02 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.


 
Posted on 11-18-08 10:17 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.


 
Posted on 11-18-08 10:31 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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?


 
Posted on 11-18-08 6:00 PM     Reply [Subscribe]
Login in to Rate this Post:     1       ?     Liked by
 

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.


 
Posted on 11-18-08 10:38 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

thanks Smooth!!
 
Posted on 11-19-08 7:48 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.


 
Posted on 11-19-08 9:47 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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!!


 
Posted on 11-20-08 7:19 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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?


 
Posted on 11-20-08 11:31 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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!!


 
Posted on 11-21-08 9:49 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.


 



PAGE: <<  1 2 3 NEXT PAGE
Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 200 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
ChatSansar.com Naya Nepal Chat
Toilet paper or water?
TPS EAD auto extended to June 2025 or just TPS?
Biden out, Trump next president, so what’s gonna happen to TPS, termination?
and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants
Tourist Visa - Seeking Suggestions and Guidance
From Trump “I will revoke TPS, and deport them back to their country.”
I hope all the fake Nepali refugee get deported
Anybody gotten the TPS EAD extension alert notice (i797) thing? online or via post?
advanced parole
TPS Renewal Reregistration
Sajha Poll: Who is your favorite Nepali actress?
Biden said he will issue new Employment visa for someone with college degree and job offers
Why Americans reverse park?
Nepali Passport Renew
Driver license help ASAP sathiharu
They are openly permitting undocumented immigrants to participate in federal elections in Arizona now.
ढ्याउ गर्दा दसैँको खसी गनाउच
To Sajha admin
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters