SQL Server knowledge center
everything about SQL Server
See also:
Other Geeks@INDC
Sign in
|
Join
|
Help
Home
Contact
About
RSS
Atom
Comments RSS
Search
Recent Posts
Fitur T-SQL Window Function Terbaru dari SQL Denali
Bermain-main dengan Fitur T-SQL Denali : SEQUENCE
Renungan atas artikel "Being a SQL Server Pro Is Hard Work!"
Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot
Fitur-fitur yang tidak disupport di SQL Denali
Different role of IT architects
Pertanyaan Mengenai SQL Query Optimizer
Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL
Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution
Solusi dan Pemrograman Transact-SQL
Tags
ASP.NET
Business Intelligence
C Sharp
General/motivation
LINQ
Rubrik Solusi dan Teknik Pemrograman Transact SQL
SharePoint and Microsoft Office 2007 SharePoint Server
solusi
SQL Server
SQL Server Reporting Services
Windows Communication Foundation (WCF)
Windows Workflow Foundation
News
Your database is crawling like turtles? I can turn it like sport car, contact me if you need help. My email : sologuyfromrolla@gmail.com
Navigation
Home
Blogs
Videos
Curriculum
eBooks
Jobs
Forum
Downloads
Archives
September 2011 (3)
August 2011 (2)
March 2011 (3)
February 2011 (1)
January 2011 (4)
December 2010 (2)
June 2010 (4)
May 2010 (5)
March 2010 (2)
January 2010 (10)
December 2009 (11)
November 2009 (3)
August 2009 (5)
July 2009 (10)
June 2009 (1)
April 2009 (3)
March 2009 (3)
February 2009 (11)
January 2009 (7)
December 2008 (17)
November 2008 (11)
October 2008 (5)
September 2008 (8)
August 2008 (2)
July 2008 (16)
June 2008 (15)
May 2008 (16)
April 2008 (20)
March 2008 (19)
February 2008 (16)
January 2008 (21)
December 2007 (31)
November 2007 (30)
October 2007 (16)
September 2007 (4)
August 2007 (8)
April 2007 (19)
March 2007 (1)
February 2007 (1)
July 2006 (1)
May 2006 (29)
April 2006 (11)
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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...
Filed under:
Rubrik Solusi dan Teknik Pemrograman Transact SQL
,
solusi
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...
Filed under:
Rubrik Solusi dan Teknik Pemrograman Transact SQL
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...
Filed under:
Rubrik Solusi dan Teknik Pemrograman Transact SQL
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:
SQL Server
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:
General/motivation
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:
SQL Server
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:
SQL Server
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:
General/motivation
More Posts
Next page »