July 2009 - Posts

0
Comments

OUTPUT…INTO… Extension in SQL Server 2008 MERGE Statement by Kasim.Wirama

OUTPUT…INTO… Extension in SQL Server 2008 MERGE Statement By : Kasim Wirama, MCITP, MCDBA If you read my recent article titled MERGE Statement in SQL Server 2008 , you will agree with me that MERGE statement make your query shorter and will do more than...
Filed under:
0
Comments

Solution for Blocking Problem in SQL Server 2005/2008 by Kasim.Wirama

Solution for Blocking Problem in SQL Server 2005/2008 By : Kasim Wirama, MCITP, MCDBA If you read my recent article titled : Detect Database Blocking Issue with SQL Server Dynamic Management View , you probably further question how to avoid and reduce...
Filed under:
0
Comments

I Pass All SQL Server 2008 Exams for MCTS (Technology Specialist) and MCITP (IT Pro) by Kasim.Wirama

I Pass All SQL Server 2008 Exams for MCTS (Technology Specialist) and MCITP (IT Pro) By : Kasim Wirama, MCITP, MCDBA This morning, 29 July 2009, I have pass last exams to get MCITP SQL Server 2008 in Designing, and Optimizing Database Solutions. Here...
Filed under:
3
Comments

Passing Table-Valued Parameter Using ADO.NET by Kasim.Wirama

Passing Table-Valued Parameter Using ADO.NET By : Kasim Wirama, MCITP, MCDBA SQL Server 2008 introduce table valued parameter feature so you can pass bulk of data into input parameter of stored procedure or user defined function. But how to pass table...
Filed under:
0
Comments

How to Migrate Non XML Column into XML Column by Kasim.Wirama

How to Migrate Non XML Column into XML Column By : Kasim Wirama, MCITP, MCDBA You might store xml data in text or varchar column type in SQL Server 2000 or previous version because it doesn’t support XML data type for storage. Now SQL Server 2005 and...
Filed under:
1
Comments

Detect Database Blocking Issue with SQL Server Dynamic Management View by Kasim.Wirama

Detect Database Blocking Issue with SQL Server Dynamic Management View By : Kasim Wirama, MCITP, MCDBA DBA has responsibility to maintain database from backup-restore, data integrity until smooth database daily operation. Most common problem regarding...
Filed under:
2
Comments

MERGE Statement in SQL Server 2008 by Kasim.Wirama

MERGE Statement in SQL Server 2008 By : Kasim Wirama, MCITP, MCDBA In TSQL area, SQL Server 2008 has some enhancements; one of them is ability to wrap several DML statement into one by MERGE statement. Syntax for MERGE statement is : MERGE <target...
Filed under:
1
Comments

Viewing Big Data in Excel 2007 by Kasim.Wirama

Viewing Big Data in Excel 2007 By : Kasim Wirama, MCITP, MCDBA SQL Server Integration Services (SSIS) is excellent ETL platform to do export import data from and to heterogeneous data source. In this posting, I would like to give my thought about exporting...
Filed under:
0
Comments

SQL Server 2008 PowerShell by Kasim.Wirama

Normal 0 false false false EN-US X-NONE X-NONE /* 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:99; mso-style-qformat...
Filed under:
0
Comments

Concatenate Multi Row Column Value into One Row by Kasim.Wirama

Concatenate Multi Row Column Value into One Row By : Kasim Wirama, MCDBA, MCITP Sometimes you need concatenate multiple rows into 1 string value separated by delimiter (usually comma). For example to get orderdescription from same customerid like the...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems