February 2009 - Posts

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:
1
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:
0
Comments

Enable File Stream on SQL Server 2008 by Kasim.Wirama

Enable File Stream on SQL Server 2008 By : Kasim Wirama, MCDBA, MCITP, SQL Server MVP SQL Server 2008 has filestream feature. It marries best world power of file management by windows file system and database transaction atomicity. If you have LOB files...
Filed under:
2
Comments

Read the Most Updated Knowledge of SQL Server 2008 From SQL Server Internals Guru, Kalen Delaney by Kasim.Wirama

Read the Most Updated Knowledge of SQL Server 2008 From SQL Server Internals Guru, Kalen Delaney Kalen Delaney, an expert of SQL Server, is a regular contributor of SQL Server Magazine and author for Inside SQL Server series. Recent book is SQL Server...
Filed under:
0
Comments

Backup and Restore master Database in SQL Server by Kasim.Wirama

Backup and Restore master Database in SQL Server By : Kasim Wirama, MCDBA, MCITP, SQL Server MVP SQL Server contains system databases. They are master, model, msdb, tempdb and distribution databases. Distribution databases exist only when you enable replication...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems