January 2010 - Posts

2
Comments

Database Integrity Check with SMO by Kasim.Wirama

Database Integrity Check with SMO By : Kasim Wirama, MCITP, MCDBA The last series of SMO postings, I would highlight one of SMO capabilities in term of database administration. For DBA, database integrity check is one of must-have database maintenance...
Filed under:
0
Comments

Performing Database Restore by SMO by Kasim.Wirama

Performing Database Restore by SMO By : Kasim Wirama, MCITP, MCDBA This series of SMO posting, I would like to show how to do database restore with SMO. Backup operation is represented by Microsoft.SqlServer.Management.Smo.Restore class. The example I...
Filed under:
0
Comments

Performing Database Backup by SMO by Kasim.Wirama

Performing Database Backup by SMO By : Kasim Wirama, MCITP, MCDBA This series of SMO posting, I would like to show how to do database backup with SMO. Backup operation is represented by Microsoft.SqlServer.Management.Smo.Backup class. The example I show...
Filed under:
0
Comments

Get User Database Properties with SMO by Kasim.Wirama

Get User Database Properties with SMO By : Kasim Wirama, MCITP, MCDBA Still with SMO discussions, this time I would like to show how we easily get properties of a user database with SMO (Server Management Object). As brief explanation, SMO is an SQL Server...
Filed under:
1
Comments

Get List of SQL Server Instances with SMO by Kasim.Wirama

Get List of SQL Server Instances with SMO By : Kasim Wirama, MCDBA, MCITP Sometimes there are requirements where you need to get list of SQL Server instances. For example you need to do database health check on each databases of each SQL Server instances...
Filed under:
0
Comments

Building First SMO (SQL Server Management Object) Application by Kasim.Wirama

Building First SMO (SQL Server Management Object) Application By : Kasim Wirama, MCDBA, MCITP With limitless idea exposed by classes in SMO, you could build full-fledged administrative tool which is similar or even more complete than SQL Server Management...
Filed under:
0
Comments

SMO (SQL Server Management Object) in SQL Server 2005/2008 by Kasim.Wirama

SMO (SQL Server Management Object) in SQL Server 2005/2008 By : Kasim Wirama, MCITP, MCDBA SMO has been introduced since SQL Server 2005. The earlier version of SMO is DMO (Distributed Management Object) which is used by previous version of SQL Server...
Filed under:
1
Comments

Passing Table-Valued Parameter in SSIS 2008 by Kasim.Wirama

Passing Table-Valued Parameter in SSIS 2008 By : Kasim Wirama, MCITP, MCDBA One of new TSQL enhancements in SQL Server 2008 is table-valued parameter. The challenge is how to pass table valued parameter into stored procedure from SSIS. This process involves...
Filed under:
0
Comments

Practical Steps of Configuring Transparent Data Encryption by Kasim.Wirama

Practical Steps of Configuring Transparent Data Encryption (SQL Server 2008) By : Kasim Wirama, MCITP, MCDBA Transparent Data Encryption (TDE) is new feature of SQL Server 2008. I can say it is security feature. The feature will encrypt database files...
Filed under:
0
Comments

Get Spatial Position for Geography Data Type in SQL 2008 by Kasim.Wirama

Get Spatial Position for Geography Data Type in SQL 2008 By : Kasim Wirama, MCITP, MCDBA SQL Server 2008 introduces new data type, one of them is regarding to position and area, which are geometry and geography data type. Geometry data type covers could...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems