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
Database Integrity Check with SMO
Performing Database Restore by SMO
Performing Database Backup by SMO
Get User Database Properties with SMO
Get List of SQL Server Instances with SMO
Building First SMO (SQL Server Management Object) Application
SMO (SQL Server Management Object) in SQL Server 2005/2008
Passing Table-Valued Parameter in SSIS 2008
Practical Steps of Configuring Transparent Data Encryption
Get Spatial Position for Geography Data Type in SQL 2008
Tags
Business Intelligence
C Sharp
General/motivation
LINQ
SharePoint and Microsoft Office 2007 SharePoint Server
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
Kurikulum
Pustaka
Facebook
Twitter
Forums
Downloads
Archives
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)
December 2007 - Posts
4
Comments
Workflow Logging in WWF
by
Kasim.Wirama
Workflow Logging in WWF By : Kasim Wirama, MCDBA Many aspects you need to consider when you will deploy your workflow. Faced by diverse possibility of user interaction in real world, you need to consider some aspects. They are workflow logging , workflow...
Filed under:
Windows Workflow Foundation
1
Comments
SQL Server 2005 Query Hints
by
Kasim.Wirama
SQL Server 2005 Query Hints By : Kasim Wirama, MCDBA, MVP SQL Server In general, without hints SQL Server performs best, but in some cases default execution plan is not so appropriate, if you are sure that uses of query hints will have control over query...
Filed under:
SQL Server
1
Comments
Condition and Rule Activities in Workflow
by
Kasim.Wirama
Condition and Rule Activities in Workflow By : Kasim Wirama, MCDBA, MVP SQL Server On my previous article (implement multiple activities in workflow), on last passage, I talk a bit about Condition property on IfElse and While activities. Not only these...
Filed under:
Windows Workflow Foundation
0
Comments
Implement Multiple Activities in Workflow
by
Kasim.Wirama
Implement Multiple Activities in Workflow By : Kasim Wirama, MCDBA, MVP SQL Server It is seldom to find single activity inside a workflow. More often than not, you will find multiple activities inside a workflow. Generally you can straight away drag and...
Filed under:
Windows Workflow Foundation
1
Comments
Create Simple Workflow
by
Kasim.Wirama
Create Simple Workflow By : Kasim Wirama, MCDBA, MVP SQL Server Workflow is series of activities that are linked one another. You can see many samples about workflow. For me, workflow looks like procedures that I should follow from beginning until the...
Filed under:
Windows Communication Foundation (WCF)
1
Comments
How to Read Execution Plan
by
Kasim.Wirama
How to Read Execution Plan By : Kasim Wirama, MCDBA, MVP SQL Server Many of you have ever read execution plan, and some of you get confused how to gather information from existing execution plan. I would like to give some practical guidance how to read...
Filed under:
SQL Server
1
Comments
Examining Query Plan from Plan Cache
by
Kasim.Wirama
Examining Query Plan from Plan Cache (SQL Server 2005) By : Kasim Wirama, MCDBA, MVP SQL Server I would like to show you about examining plan cache and how you get insight after examining this plan. In SQL Server versions before SQL Server 2005, I could...
Filed under:
SQL Server
2
Comments
Detecting Locking and Transaction Conflict with Begin Try Handler in SQL Server 2005
by
Kasim.Wirama
Detecting Locking and Transaction Conflict with Begin Try Handler in SQL Server 2005 By : Kasim Wirama, MCDBA, MVP SQL Server SQL Server 2005 introduces new error handling construct, it is more robust compare to previous version of SQL Server. The error...
Filed under:
SQL Server
1
Comments
Running Your Workflow in MOSS 2007
by
Kasim.Wirama
Running Your Workflow in MOSS 2007 By : Kasim Wirama, MCDBA, MVP SQL Server After I share how to create workflow from existing Approval workflow template (see my article : http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2007/12/26/create-workflow...
Filed under:
SharePoint and Microsoft Office 2007 SharePoint Server
7
Comments
Create Workflow in Microsoft Office 2007 SharePoint Server
by
Kasim.Wirama
Create Workflow in Microsoft Office 2007 SharePoint Server By : Kasim Wirama, MCDBA, MVP SQL Server Workflow has been implemented by most organizations for a long time, and before .NET era, workflow was a custom made application with all custom workflow...
Filed under:
SharePoint and Microsoft Office 2007 SharePoint Server
1
Comments
Authorization in WCF
by
Kasim.Wirama
Authorization in WCF By : Kasim Wirama, MCDBA, MVP SQL Server Authorization is action to verify authenticated user whether to allow on requested operation. It is no exception in WCF. In WCF service, user gets authenticated, once authenticated, WCF service...
Filed under:
Windows Communication Foundation (WCF)
0
Comments
Authentication with HTTPS in WCF
by
Kasim.Wirama
Authentication with HTTPS in WCF By : Kasim Wirama, MCDBA, MVP SQL Server Message encryption should be combined with authentication and authorization wcf client by wcf service. Usually message level security provides authentication, so wcf service can...
Filed under:
Windows Communication Foundation (WCF)
0
Comments
Implementing WCF Message Level Security over HTTP
by
Kasim.Wirama
Implementing WCF Message Level Security over HTTP By : Kasim Wirama, MCDBA, MVP SQL Server You can secure your message confidentiality by encryption either in transport level security or message level security. For transport level security, you can set...
Filed under:
Windows Communication Foundation (WCF)
0
Comments
Types of Subqueries
by
Kasim.Wirama
Types of Subqueries By : Kasim Wirama, MCDBA, MVP SQL Server As database developer, you must have ever written subqueries in either SQL Server or any other database platform. This article will describe shortly about types of subquery. A subquery is inner...
Filed under:
SQL Server
3
Comments
Securing message with HTTPS in WCF
by
Kasim.Wirama
Securing message with HTTPS in WCF By : Kasim Wirama, MCDBA, MVP SQL Server Message encryption could be achieved with message level or transport level security. For message level security, you can see my article titled : Encrypt Message with TCP-based...
Filed under:
Windows Communication Foundation (WCF)
More Posts
Next page »