October 2008 - Posts

2
Comments

Finally, I've Got MCITP SQL Server 2008 by Kasim.Wirama

Finally, I've Got MCITP SQL Server 2008 By : Kasim Wirama, MCDBA, MCTS, MCITP I just received notification from Microsoft that I am entitled for MCITP for SQL Server 2008. If you are interested to gain full database certification path (MCITP), please...
Filed under:
0
Comments

Dynamic XML Construction by Kasim.Wirama

Dynamic XML Construction By : Kasim Wirama, MCDBA, MCTS XML as data type since SQL Server 2005 is a big coverage area, it is because it has XQuery and XPath capability and XML DML has enable XML update. This posting, I would like to show you dynamic capability...
Filed under:
1
Comments

Update Rows in Big Table by Kasim.Wirama

Update Rows in Big Table By : Kasim Wirama, MCDBA, MCTS Update rows for all record in a table would not be an issue for small table. But it will be an issue for big table because table lock is applied to it which reduces concurrency. What you can do is...
Filed under:
6
Comments

My New MCTS for SQL Server 2008 by Kasim.Wirama

My New MCTS for SQL Server 2008 By : Kasim Wirama, MCDBA, MCTS I have passed 2 SQL Server 2008 exams. Now I have MCTS (Microsoft Certified Technology Specialist) for SQL Server 2008 besides my MCDBA (Microsoft Certified Database Administrator) for SQL...
Filed under:
0
Comments

XPath and XQuery in XML data type by Kasim.Wirama

XPath and XQuery in XML data type By : Kasim Wirama, MCDBA, MCTS I am interested with XML data type which becomes first class since SQL Server 2005. Learning process for XML is steep learning but it is worthwhile because it is native data type in SQL...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems