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

Looking Inside SQL Server Data Row for Variable Length Column by Kasim.Wirama

Looking Inside SQL Server Data Row for Variable Length Column By : Kasim Wirama, MCITP, MCDBA I have shown information on hexadecimal value on fixed length column in my recent posting Looking Inside SQL Server Data Row . Now let’s have a look how variable...
Filed under:
0
Comments

Integrity Check Order in SQL Server by Kasim.Wirama

Integrity Check Order in SQL Server By : Kasim Wirama, MCITP, MCDBA SQL Server has 7 table constraints. They are DEFAULT constraint, NOT NULL constraint, CHECK constraint, FOREIGN KEY constraint, UNIQUE constraint, PRIMARY KEY constraint and trigger....
Filed under:
0
Comments

Question and Answer about SQL Server I/O Subsystem Issue by Kasim.Wirama

Question and Answer about SQL Server I/O Subsystem Issue By : Kasim Wirama, MCITP, MCDBA In SQL Server Indo mailing list, there was question about slow query performance on one SQL Server instance but not for the other SQL Server instance. This is something...
Filed under:
0
Comments

Determine Row Size in SQL Server by Kasim.Wirama

Determine Row Size in SQL Server By : Kasim Wirama, MCITP, MCDBA To be able to determine the number of rows for a page, you need to determine the row size for respective row. SQL Server could give you information through catalogue view. First let’s we...
Filed under:
1
Comments

Looking Inside SQL Server Data Row by Kasim.Wirama

Looking Inside SQL Server Data Row By : Kasim Wirama, MCITP, MCDBA If you have read my 2 previous postings ( Review SQL Server Data Page via Undocumented DBCC Command and Locate SQL Server Data in SQL Server Storage Engine ) about the use of DBCC PAGE...
Filed under:
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems