Recent Posts

0
Comments

Calculating Number of Hierarchy Levels in Clustered Index by Kasim.Wirama

Calculating Number of Hierarchy Levels in Clustered Index By : Kasim Wirama, MCDBA, MCITP This posting, I would like to describe the way to calculate number of hierarchy level of an index in SQL Server. Before I delve into calculation discussion how to...
Filed under:
9
Comments

Eksplorasi Kebutuhan Bisnis dengan Transact SQL by Kasim.Wirama

Eksplorasi Kebutuhan Bisnis dengan Transact SQL Transact SQL memiliki kapabilitas query database relasional yang memiliki performance terbaik dalam hal akses data berbasis set oriented. Bila tertarik mengasah problem-problem dunia bisnis yang diterjemahkan...
Filed under:
0
Comments

Detailed Training Materials of SQL Server 2008 by Kasim.Wirama

Detailed Training Materials of SQL Server 2008 David Lean, a Microsoft SQL guru, has posted detailed training material of SQL Server 2008. For detail, please visit his blog at : http://blogs.msdn.com/davidlean/archive/2009/04/16/sql-server-2008-jumpstart...
Filed under:
2
Comments

Launch of First Ebook From SQL Server Indo by Kasim.Wirama

Launch of First Ebook From SQL Server Indo With pride, we (I, Hendrik and Yudhi) announce launching of SQL Server 2008 Business Intelligence ebook. For link to download, please go to http://sqlserver- indo.org/ files/folders/ ebook/entry308. aspx (When...
Filed under:
0
Comments

SQL Server 2008 Administration Best Practice by Kasim.Wirama

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority...
Filed under:
0
Comments

Null or Empty Value in SQL Server Integration Services by Kasim.Wirama

Null or Empty Value in SQL Server Integration Services By : Kasim Wirama, MCDBA, MCITP It is quite common you receive flat file where contains columns list where some of them don’t have value. Such as this example below : customerid,firstname,middlename...
Filed under:
1
Comments

Belajar Menulis sebagai Bentuk Berbagi by Kasim.Wirama

Belajar Menulis sebagai Bentuk Berbagi By : Kasim Wirama, MCDBA, MCITP Cuma sekedar renungan, setelah sekian lama saya menulis tanpa terasa sudah ratusan artikel (kebanyakan SQL Server) yang saya publish lewat portal INDC. Setiap menuangkan tulisan ke...
Filed under:
0
Comments

Looking Back What SQL Server Analysis Services Has Achieved so Far by Kasim.Wirama

Looking Back What SQL Server Analysis Services Has Achieved so Far By : Kasim Wirama, MCDBA, MCITP Current SQL Server now is SQL Server 2008. Speaking about business intelligence specifically by looking back to 8 years when Microsoft BI began to climb...
Filed under:
2
Comments

Things to Consider for Successful Log Shipping by Kasim.Wirama

Things to Consider for Successful Log Shipping By : Kasim Wirama, MCDBA, MCITP Log shipping in SQL Server has been introduced since SQL Server 4.21a. But it is still good to used in replicating database in either another location or same server box. It...
Filed under:
1
Comments

Dynamic Management View Categorization in SQL Server by Kasim.Wirama

Dynamic Management View Categorization in SQL Server By : Kasim Wirama, MCDBA, MCITP Dynamic management view (DMV) is one of system object in SQL Server. It is the way how you look at SQL Server metadata. It is introduced since SQL Server 2005 and it...
Filed under:
0
Comments

Shrink Database Troubleshooting by Kasim.Wirama

Shrink Database Troubleshooting By : Kasim Wirama, MCDBA, MCITP There is a need to make your database more compact by shrinking it. Shrink database is applicable to scenario where you just drop big table either by delete or truncate command. But it is...
Filed under:
0
Comments

Setting Package Configuration in SSIS with SQL Server Configuration Type by Kasim.Wirama

Setting Package Configuration in SSIS with SQL Server Configuration Type By : Kasim Wirama, MCDBA, MCITP SSIS is completely replacement of DTS and it becomes first class SQL Server components along with database engine, analysis services, and reporting...
Filed under:
0
Comments

List of Threshold Value for SQL Server Performance Counters by Kasim.Wirama

List of Threshold Value for SQL Server Performance Counters By : Kasim Wirama, MCDBA, MCITP Monitoring database performance is proactive task that a DBA should do. Possible bottleneck for SQL Server is memory, processor, I/O subsystem, tempdb database...
Filed under:
2
Comments

Split String Array into Table by Kasim.Wirama

Split String Array into Table By : Kasim Wirama, MCDBA, MCITP A common database development task which is always encountered is how to pass array of string into parameters. If you use previous version of SQL Server 2008 you need no other ways except to...
Filed under:
1
Comments

Implementing Access to SQL Server Analysis Services 2008 by Parameterization feature on SQL Server Reporting Services 2008 by Kasim.Wirama

Implementing Access to SQL Server Analysis Services 2008 by Parameterization feature on SQL Server Reporting Services 2008 By : Kasim Wirama, MCDBA, MCITP, SQL Server MVP This posting, I would like to show you how you could create report parameter on...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems