Recent Posts

0
Comments

Fitur T-SQL Window Function Terbaru dari SQL Denali by Kasim.Wirama

Fitur T-SQL Window Function Terbaru dari SQL Denali By : Kasim Wirama, MCDBA, MCITP Di sisi perkembangan fitur T-SQL Window function, SQL Denali menghadirkan pengembangan lebih lanjut dari window function. Yang anda butuhkan untuk menjalankan contoh-contoh...
Filed under:
0
Comments

Bermain-main dengan Fitur T-SQL Denali : SEQUENCE by Kasim.Wirama

Bermain-main dengan Fitur T-SQL Denali : SEQUENCE By : Kasim Wirama, MCDBA, MCITP SQL Denali memperkenalkan fitur T-SQL baru yaitu sequence yang mempunyai fungsi menghasilkan nomor urut seperti fungsi T-SQL yang ada sekarang yaitu IDENTITY. SEQUENCE ini...
Filed under:
0
Comments

Renungan atas artikel "Being a SQL Server Pro Is Hard Work!" by Kasim.Wirama

Saya menemui artikel menarik mengenai SQL Server di http://www.sqlmag.com/content1/tabid/461/catpath/sql-server/topic/sql-server-pro-hard-work-140312 SQL Server sekarang bukan lagi sekedar database, namun sudah merupakan platform data yang mencakup database...
Filed under:
0
Comments

Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot by Kasim.Wirama

Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot By : Kasim Wirama, MCDBA, MCITP SQL Denali menghadirkan banyak fitur baru yang siap di-explore. Kali ini saya akan share mengenai fitur baru di sisi Analysis...
Filed under:
1
Comments

Fitur-fitur yang tidak disupport di SQL Denali by Kasim.Wirama

Fitur-fitur yang tidak disupport di SQL Denali Kasim Wirama, MCDBA, MCITP Sekitar sebulan atau 2 bulan lalu, Microsoft me-release SQL Denali CTP 3 (Community Technology Preview ke 3), versi berikutnya setelah SQL Server 2008 R2. Banyak sekali fitur-fitur...
Filed under:
0
Comments

Different role of IT architects by Kasim.Wirama

http://dwbi1.wordpress.com/2010/06/16/data-architect-data-warehouse-architect-and-bi-solution-architect/ http://www.sqlmag.com/article/sql-server/What-s-the-Difference-Between-a-Data-Architect-and-an-Enterprise-Architect-.aspx Share this post: | | | ...
Filed under:
0
Comments

Pertanyaan Mengenai SQL Query Optimizer by Kasim.Wirama

Pertanyaan Mengenai SQL Query Optimizer Pertanyaan dan jawaban dari milis sql server indo. From: sn mailist <sn.mailist@gmail.com> To: sqlserver-indo@yahoogroups.com Sent: Tue, March 8, 2011 11:54:01 PM Subject: Re: [sqlserver-indo] Mencari Stock...
Filed under:
0
Comments

Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL by Kasim.Wirama

Solusi dan Pemrograman Transact-SQL Convert Comma Delimited String into Resultset with Transact-SQL By : Kasim Wirama Very often, you will need to parse one line of string delimited by comma and convert it into resultset. How do you achieve that? Conventional...
2
Comments

Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution by Kasim.Wirama

Solusi dan Pemrograman Transact-SQL UNPIVOT Problem and Solution “Applicable to SQL Server 2005 and above” PIVOT and UNPIVOT are T-SQL feature that have been introduced since SQL Server 2005. PIVOT a row means rotating data from state of rows into state...
1
Comments

Solusi dan Pemrograman Transact-SQL by Kasim.Wirama

Solusi dan Pemrograman Transact-SQL Table-Valued Constructor “Applicable to SQL Server 2008 and above” SQL Server 2008 introduces new T-SQL syntax called table-valued constructor. Before I show what exactly table-valued constructor is, I show how to do...
0
Comments

Foreign Key in SQL Server by Kasim.Wirama

Foreign Key in SQL Server By: Kasim Wirama So far I think a foreign key is same as index in term of join between primary key-foreign key between 2 tables. But this is not true. It’s good start if you put index on foreign key. The additional benefit besides...
Filed under:
2
Comments

Gaji Pekerja IT Indonesia Paling Rendah by Kasim.Wirama

Gaji Pekerja IT Indonesia Paling Rendah http://tekno.kompas.com/read/2011/01/07/16033924/Gaji.Pekerja.IT.Indonesia.Paling.Rendah ZDNet Asia IT Salary Benchmark 2010 http://www.zdnetasia.com/zdnet-asia-it-salary-benchmark-2010-62204873.htm Ini Dia Rata...
Filed under:
1
Comments

Peer to Peer Replication SQL 2008 on Youtube by Kasim.Wirama

It has been 2 years ago when first time I presented it before audience and I uploaded it about 1 year ago. Today I receive one of feedbacks. Though my English seems to have strong Indonesian accent, I still let you know the link: http://www.youtube.com...
Filed under:
2
Comments

Will I be hired for 300 Poundsterling/day as SQL Contractor? by Kasim.Wirama

http://shaun-j-turner.blogspot.com/2010/12/question-of-day.html http://shaun-j-turner.blogspot.com/2010/12/interview-questions.html Share this post: | | | |
Filed under:
6
Comments

Mengenai Iklan Lowongan IT by Kasim.Wirama

Seputar Gaya Iklan Lowongan IT Sering saya melihat lowongan IT seperti berikut : - pria umur maksimal 25 thn. - bisa networking, VB, C#, VB.NET, SQL Server, .NET 2/3/3.5/4, Java, Windows XP/Vista/7, Windows Server 2003/2008/2008R2, Linux, Unix, IIS, Apache...
Filed under:
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems