September 2008 - Posts

0
Comments

Securing Database Backup with Transparent Database Encryption by Kasim.Wirama

Securing Database Backup with Transparent Database Encryption (TDE) in SQL Server 2008 By : Kasim Wirama, MCDBA Data is vital asset for an organization. Imagine if data could be restore in other sql server without consent of the organization, all company...
Filed under:
0
Comments

New Auditing Feature in SQL Server 2008 by Kasim.Wirama

New Auditing Feature in SQL Server 2008 By : Kasim Wirama, MCDBA In auditing area, SQL Server 2008 introduces Auditing feature for server and database. This audit feature together with existing C2 Audit Mode brings options for database administrator to...
Filed under:
0
Comments

Maximum and Effective Maximum Resource Percentage by Kasim.Wirama

Maximum and Effective Maximum Resource Percentage in Resource Governor (SQL Server 2008) By : Kasim Wirama, MCDBA Resource governor is cool feature of SQL Server 2008 to provide predictable database performance by allocating resource consumption for database...
Filed under:
0
Comments

Mohon Maaf atas Hilangnya 4 artikel terakhir di SQL Server Knowledge Center by Kasim.Wirama

Mohon Maaf atas Hilangnya 4 artikel terakhir di SQL Server Knowledge Center By : Kasim Wirama, MCDBA Sebagaimana yang diketahui oleh komunitas .NET dan Microsoft bahwa beberapa hari lalu server komuniti Indonesia mengalami gangguan, dan sebagai akibatnya...
Filed under:
0
Comments

Table Valued Parameter and Grouping Set in SQL Server 2008 by Kasim.Wirama

Table Valued Parameter and Grouping Set in SQL Server 2008 By : Kasim Wirama, MCDBA Through this article, I would like to describe 2 T-SQL enhancements in SQL Server 2008. First is table valued parameter and second is grouping sets. There are still some...
Filed under:
1
Comments

Components of Reporting Services in SQL Server 2008 by Kasim.Wirama

Components of Reporting Services in SQL Server 2008 By : Kasim Wirama, MCDBA This article, I would like to dissect about reporting services architecture in SQL Server 2008. There are 7 components of reporting services. 1. Report Server database 2. Report...
Filed under:
0
Comments

Editions of SQL Server 2008 Reporting Services by Kasim.Wirama

Editions of SQL Server 2008 Reporting Services By : Kasim Wirama, MCDBA This article, I would like to share about reporting services edition in SQL Server 2008. There 5 editions of Reporting Services. They are workgroup edition, web edition, standard...
Filed under:
1
Comments

Filtered Index and Statistics in SQL Server 2008 by Kasim.Wirama

Filtered Index and Statistics in SQL Server 2008 By : Kasim Wirama, MCDBA Up to SQL Server 2005, there is no way to create index for only subset rows in a table though some value is needed to query. Imagine that a table has million number of rows and...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems