Nadimitla Abbulu Posted October 18, 2011 Report Posted October 18, 2011 replications chesanu clustering lantivi ani pettu sql kabatti ssrs lo reports chesanu ani pettu ssis kuda kalipeyyi.. etl laga vadanu ani pettu db down aitey single user mode lo ki velli rectify chesi up chesam ani pettu query cost tuning chesanu ani cheppu idi nuvvu chesina position details ee kada
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='CaliStar' timestamp='1318953727' post='3003217'] charygaru me email id pm pettandi .... [/quote] [email protected] ade prasthutham vaduthunna mama inkokati naa official di daaniki ani office mails osthu untai
tom bhayya Posted October 18, 2011 Report Posted October 18, 2011 [font=Verdana, Arial, Helvetica, sans-serif][size=2] [size="2"]Depending on your environment dictates all of the items that should be reviewed on a daily basis as well as their criticality in your specific organization. Based on your environment, customize the list below to ensure it meets your needs:[/size][/size][/font] [font=Verdana, Arial, Helvetica, sans-serif][size=2] [i][b][size="2"]Daily Checklist[/size][/b][/i][/size][/font] [list] [*][size="2"]Backups - Check your backups to validate that they were successfully created per your process.[/size] [list] [*][size="2"]MSSQLTips.com Category: [/size][url="http://www.mssqltips.com/category.asp?catid=8"][size="2"]Backup and Recovery[/size][/url] [/list][*][size="2"]Nightly Processing - Review the nightly or early morning processes.[/size] [*][size="2"]SQL Server Error Log - Review the SQL Server error log for any errors or security issues (successful or failed logins) that are unexpected.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1021/sql-server-2005-log-file-viewer/"][size="2"]SQL Server 2005 Exposed - Log File Viewer[/size][/url] [/list][*][size="2"]Windows Event Log - Review the Application Event Log at a minimum to find out if any Windows or hardware related errors or warnings are being written.[/size] [list] [*][size="2"]Some of the hardware vendors write warnings to the Windows Event Log when they anticipate an error is going to occur, so this gives you the opportunity to be proactive and correct the problem during a scheduled down time, rather than having a mid day emergency.[/size] [*][url="http://www.mssqltips.com/sqlservertip/1021/sql-server-2005-log-file-viewer/"][size="2"]SQL Server 2005 Exposed - Log File Viewer[/size][/url] [/list][*][size="2"]SQL Server Agent Jobs - Review for failed SQL Server Agent Jobs.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1054/failed-sql-server-agent-jobs/"][size="2"]Finding SQL Server Agent Job Failures[/size][/url] [/list][*][size="2"]HA or DR Logs - Check your high availability and/or disaster recovery process logs. Depending on the solution ([url="http://www.mssqltips.com/sqlservertip/1158/sql-server-log-shipping/"]Log Shipping[/url], Clustering, [url="http://www.mssqltips.com/category.asp?catid=7"]Replication[/url], Database Mirroring, CDP, etc.) that you are using dictates what needs to be checked.[/size] [*][size="2"]Performance Logs - Review the performance metrics to determine if your baseline was exceeded or if you had slow points during the day that need to be reviewed.[/size] [list] [*][size="2"]MSSQLTips.com Category: [/size][url="http://www.mssqltips.com/category.asp?catid=9"][size="2"]Performance Tuning[/size][/url] [/list][*][size="2"]Security Logs - Review the security logs from a third party solution or from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.[/size] [*][size="2"]Centralized error handling - If you have an application, per SQL Server or enterprise level logging, then review those logs for any unexpected errors.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1152/standardized-sql-server-error-handling-and-centralized-logging/"][size="2"]Standardized Error Handling and Centralized Logging[/size][/url] [/list][*][size="2"]Storage - Validate you have sufficient storage on your drives to support your databases, backups, batch processes, etc. in the short term.[/size] [*][size="2"]Service Broker - Check the transmission and user defined queues to make sure data is properly being processed in your applications.[/size] [list] [*][size="2"]MSSQLTips.com Category: [/size][url="http://www.mssqltips.com/category.asp?catid=42"][size="2"]Service Broker[/size][/url] [/list][*][size="2"]Corrective Actions - Take corrective actions based on the issues and/or errors that you found.[/size] [*][size="2"]Improvements - Look for opportunities to improve your environment based on the review and analysis you have performed.[/size] [*][size="2"]Learn something new - Although this review and correction process could be time consuming, take some time every day to learn something new to improve your knowledge of the technology you work on every day.[/size] [/list][font=Verdana, Arial, Helvetica, sans-serif][size=2] [i][b][size="2"]Weekly or Monthly Checklist[/size][/b][/i][/size][/font] [list] [*][size="2"]Backup Verification (Comprehensive)- Verify your backups and test on a regular basis to ensure the overall process works as expected. What is meant by this is to:[/size] [list] [*][size="2"]Contact your off site tape vendor to obtain a tape[/size] [*][size="2"]Validate that the tape goes to the correct office[/size] [*][size="2"]Validate that the vendor delivers the correct tape[/size] [*][size="2"]Validate that the vendor delivers the tape in the correct time period[/size] [*][size="2"]Validate that the software version you use to perform the restore is compatible with the version from the tape[/size] [*][size="2"]Validate that the tape does not have any restore errors[/size] [*][size="2"]Validate that sufficient storage is available to move the backup to the needed SQL Server[/size] [*][size="2"]Validate that the SQL Server versions are compatible to restore the database[/size] [*][size="2"]Validate that no error messages are generated during the restore process[/size] [*][size="2"]Validate that the database is accurately restored and the application will function properly[/size] [/list][*][size="2"]Backup Verification (Simple) - Verify your backups on a regular basis.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1099/automate-sql-server-restore-verifyonly-process-with-maintenance-tasks/"][size="2"]Maintenance Tasks: Automating the RESTORE VERIFYONLY Process[/size][/url] [*][url="http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/"][size="2"]Verifying Backups with the RESTORE VERIFYONLY Statement[/size][/url] [/list][*][size="2"]Windows, SQL Server or Application Updates - Check for service packs/patches that need to be installed on your SQL Server from either a hardware, OS, DBMS or application perspective[/size] [list] [*][size="2"]MSSQLTips.com Category: [/size][url="http://www.mssqltips.com/category.asp?catid=41"][size="2"]Service Packs / Patches[/size][/url] [/list][*][size="2"]Capacity Planning - Perform capacity planning to ensure you will have sufficient storage for a specific period of time such as for 6, 12 or 18 months.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1128/easing-the-sql-server-database-capacity-planning-burden/"][size="2"]Easing the Capacity Planning Burden[/size][/url] [/list][*][size="2"]Fragmentation - Review the fragmentation for your databases to determine if you particular indexes must be rebuilt based on analysis from a backup SQL Server.[/size] [list] [*][size="2"]MSSQLTips.com Category: [/size][url="http://www.mssqltips.com/category.asp?catid=39"][size="2"]Fragmentation[/size][/url] [/list][*][size="2"]Maintenance - Perform database maintenance on a weekly or monthly basis.[/size] [list] [*][size="2"]MSSQLTips.com Category: [url="http://www.mssqltips.com/category.asp?catid=25"]Maintenance[/url][/size] [/list][*][size="2"]Security - Remove unneeded logins and users for individuals that have left the organization, had a change in position, etc.[/size] [*][size="2"]Shrink databases - If databases or transaction logs are larger, than necessary shrink those files to free up disk space.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/1016/sql-2000-database-maintenance-plan-vs-sql-server-2005-ssis-tasks/"][size="2"]SQL Server 2000 to 2005 Crosswalk - Database Maintenance Plan Wizard to SQL Server Integration Services (SSIS)[/size][/url] [/list] [/list][font=Verdana, Arial, Helvetica, sans-serif][size=2] [i][b][size="2"]Opportunities for Automation[/size][/b][/i][/size][/font] [list] [*][size="2"]Setup alerts for specific error levels or error messages that impact your SQL Servers in order to be notified automatically.[/size] [list] [*][url="http://www.mssqltips.com/sqlservertip/939/sql-server-database-backup-and-restore-failure-notifications/"][size="2"]Database Backup and Restore Failure Notifications[/size][/url] [/list][*][size="2"]Setup Jobs to query for specific conditions in your tables to validate data was loaded or data is being added to specific tables based on your business processes throughout the day.[/size] [*][size="2"]Setup notification on Job success, failure or completion.[/size] [list] [*][size="2"]One word of warning is to check your business critical Jobs on a regular basis just to be sure they are working properly. Nothing is worse than finding out a key process has been failing for days, weeks or months and the reason notifications have not been sent are due to an incorrect configuration, full mailbox, etc. It may be 30 minutes on a weekly basis that is time well spent.[/size] [/list][*][size="2"]Setup centralized error handling on a per SQL Server, application or enterprise basis then determine the business rules for specific error conditions.[/size] [/list][font=Verdana, Arial, Helvetica, sans-serif][size=2] [u][b][size="2"]Next Steps[/size][/b][/u][/size][/font] [list] [*][size="2"]Based on your environment and your needs, build the daily, weekly and monthly checklist that is needed.[/size] [*][size="2"]As a start it may be easier to manually check for specific business or data conditions, then as you build your scripts over time work towards assembling them for an automated process.[/size] [/list]
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [size=8]explain how the benificiary's education relates to the position [/size]i am trying to answer this question. all help appreciated
nickrayudu Posted October 18, 2011 Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318953960' post='3003232'] thank you so much mama oka sari naa problem chudu and daaniki answer emanna iyyagalguthavemo cheppu [b]the point is more like how is my education benefitting the position i am working on !![/b] [b]sql dba duties kante kuda masters lo nenu chesindi endi daani valla naaku origindhi endi ee job lo annadi important adi ekkada nunchi tevaalo ela raayalo ardham aythaledu[/b] [/quote] wait baa na deggara konni points unnay vesthuna
CaliStar Posted October 18, 2011 Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318954425' post='3003271'] [size=8]explain how the benificiary's education relates to the position [/size]i am trying to answer this question. all help appreciated [/quote] meeru masters la chesina computer courses.....emanna projects or research..........management courses aina........anni kalipi....mention chesi.......rayadaniki try cheyyandi......mee email ki rendu resumes pampina......
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='CaliStar' timestamp='1318954578' post='3003281'] meeru masters la chesina computer courses.....emanna projects or research..........management courses aina........anni kalipi....mention chesi.......rayadaniki try cheyyandi......mee email ki rendu resumes pampina...... [/quote] chusa mama kaani naa subjects in masters endo cheptha aagu satellite communications voip research methods project management issues and trends in software management network security internet protocols software engineering project
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='nickrayudu' timestamp='1318954569' post='3003280'] wait baa na deggara konni points unnay vesthuna [/quote] tondarga cheppu mama tension ochhesthundi [img]http://www.imageping.com/out.php/i22832_B15.gif[/img]
Nadimitla Abbulu Posted October 18, 2011 Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318955047' post='3003327'] tondarga cheppu mama tension ochhesthundi [img]http://www.imageping.com/out.php/i22832_B15.gif[/img] [/quote] query ki emanna answer chestunnava baa
tom bhayya Posted October 18, 2011 Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318954762' post='3003302'] chusa mama kaani naa subjects in masters endo cheptha aagu satellite communications voip research methods [b]project management[/b] issues and trends in software management [b]network security[/b] internet protocols [b]software engineering project[/b] [/quote] chary garu bold chesina vaati tho kontha lo kontha relate chesukovachu andi.. network security valla I learnt some basic administration of servers, software engineering valla SDLC ala.. Bachelors lo I already learnt RDBMS and it fascinated me so on top of it in Masters I used these concepts to groom my self in to DBA ani cheppi chinna script thayyaru cheyandi...adhi kastham anukuntey immihelp or murthy forums lo oka req pettandi sample format emanna vuntey share cheyamani..
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='Alexander' timestamp='1318955387' post='3003354'] chary garu bold chesina vaati tho kontha lo kontha relate chesukovachu andi.. network security valla I learnt some basic administration of servers, software engineering valla SDLC ala.. Bachelors lo I already learnt RDBMS and it fascinated me so on top of it in Masters I used these concepts to groom my self in to DBA ani cheppi chinna script thayyaru cheyandi...adhi kastham anukuntey immihelp or murthy forums lo oka req pettandi sample format emanna vuntey share cheyamani.. [/quote] ee matter antha ma manager gaadu raasi pampaali vaadiki nenu raasi ivvali but it should look like he wrote it !! naaku ee tension la chiraku la em raayalo enduku raayalo ardham ayathle anduke mimalni aduguthunna mama
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318955594' post='3003370'] ee matter antha ma manager gaadu raasi pampaali vaadiki nenu raasi ivvali but it should look like he wrote it !! naaku ee tension la chiraku la em raayalo enduku raayalo ardham ayathle anduke mimalni aduguthunna mama [/quote] deeiniki thodu inko punch endi ante nannu "computer support specialist" ani apply chesaru mama H1 ki adoka lolli ayyipoyindi DBA ni ayyi undi kuda DBA ani cheppukoleni sthithi
nickrayudu Posted October 18, 2011 Report Posted October 18, 2011 [quote name='charygaru' timestamp='1318955700' post='3003384'] deeiniki thodu inko punch endi ante nannu "computer support specialist" ani apply chesaru mama H1 ki adoka lolli ayyipoyindi DBA ni ayyi undi kuda DBA ani cheppukoleni sthithi [/quote] Chaary gaaru vethukuthunna oka resume undali adhi meeku use aithadhi nenu meeku PM chestha ..
charygaru Posted October 18, 2011 Author Report Posted October 18, 2011 [quote name='nickrayudu' timestamp='1318955895' post='3003404'] Chaary gaaru vethukuthunna oka resume undali adhi meeku use aithadhi nenu meeku PM chestha .. [/quote] chusinav kada mama how my education benefits the postion i am in anedani meeda emphasize cheyyali nenu atla edanna unte pampu
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts