Tags » Database Administrator

Execute a Stored Procedure when SQL Server Instance starts

As a DBA it may be a challenging task to gather some system level or at business level some specific or few data needs to be check at SQL Server startup level. 222 more words

Database Administrator

Pertemuan 7

Application Performance

1.designing application for relational access
2.relational optimaztion
3.additional optimization consideration
4.sql coding & tuning

Fokus:

mengoptimalkan kode aplikasi dan pernyataan SQL, memastikan aplikasi berinteraksi dengan DBMS secara tepat dan efisien… 216 more words

Database Administrator

Why is the DBA the happiest job - in-spite of stress?

Last week, I shared a story about stress. It’s called How to deal with IT and programming stress IT and programming stress. In the story, it mentions that programming is one of the most… 517 more words

Technology

Pertemuan 6

SYSTEM DAN DATABASE  PERFORMANCE

Database performance Tuning atau biasa disebut Kinerja Database adalah kinerja dan prosedur yang dirancang untuk mengoptimaztion database .

DBMS Instaltion and configuration isues : Sebuah DBMS adalah bagian kompleks software yang membutuhkan perencanaan di muka untuk instalasi untuk menjadi sukses… 264 more words

Database Administrator

Pertemuan 5

Database Performance adalah optimalisasi penggunaan sumber daya untuk meningkatkan throughput dan meminimalkan pertentangan, memungkinkan kemungkinan terbesar beban kerja untuk diproses

Masalah yang bisa menyebabkan Performa Database Menurun… 253 more words

Database Administrator

SP_HELPTEXT showing old Store Procedure name after rename

Today morning, my one friend call me, saying there is a bug with SQL Server. As per his statement after renaming a Stored procedure name from SSMS, SP_HELPTEXT showing old name in script while SSMS is showing changed name, I think it’s not a system bug because its happens when the store procedure is renamed using right click and rename in GUI or using SP_rename <object name>, the sys.syscomments system table is not getting updated and SQL statement shown by sp_helptext is from sys.syscomments. 72 more words

Database Administrator

Performance Monitoring through Management Data Warehouse

It’s a very common and sometime frustrating/irritating task for a DBA to trouble shoot SQL Server performance issues. With SQL server 2008 a very useful concept i.e. 466 more words

Database Administrator