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)
March 2008 - Posts
0
Comments
Guideline for Resolving Deadlock
by
Kasim.Wirama
Guideline for Resolving Deadlock By : Kasim Wirama, MCDBA In shared database resource where concurrent access always occurs, you might see deadlock. If you want to get more information about deadlock in SQL Server 2005 such as latest SQL statement before...
Filed under:
SQL Server
0
Comments
Scalability Improvement with Temporary Table Caching in SQL Server 2005
by
Kasim.Wirama
Scalability Improvement with Temporary Table Caching in SQL Server 2005 By : Kasim Wirama, MCDBA SQL Server 2005 has made interesting improvement on tempdb database. Probably, it will apply as well to SQL Server 2008. Pressure on tempdb database that...
Filed under:
SQL Server
0
Comments
Type of Deadlocks
by
Kasim.Wirama
Type of Deadlocks By : Kasim Wirama, MCDBA When concurrent accesses go to shared resource, there might be potentially deadlock issue. There are 2 conditions whether a deadlock might happen. First, deadlock needs at least two tasks or more and at least...
Filed under:
SQL Server
3
Comments
Tempdb Space Planning and Space Monitoring
by
Kasim.Wirama
Tempdb Space Planning and Space Monitoring By : Kasim Wirama, MCDBA Most of time, users don’t have to worry about running out space on tempdb as long as you have enough disk space to dealing with tempdb growth. Sometimes your tempdb has grown to considerably...
Filed under:
SQL Server
3
Comments
TempDB Improvement in SQL Server 2005
by
Kasim.Wirama
TempDB Improvement in SQL Server 2005 By : Kasim Wirama, MCDBA In performance tuning area in SQL Server, there are five resources that are potential to contribute performance bottleneck. They are CPU, memory, I/O, tempdb and blocking. I will talk about...
Filed under:
SQL Server
0
Comments
Consideration to Choose between T-SQL and CLR-SQL
by
Kasim.Wirama
Consideration to Choose between T-SQL and CLR-SQL By : Kasim Wirama, MCDBA .NET integrates to SQL Server commenced from SQL Server 2005, and it will tighter in subsequent versions of SQL Server release (2008 and so on). I see that this architecture is...
Filed under:
SQL Server
4
Comments
Pro and Cons between Ad Hoc SQL and Stored Procedure
by
Kasim.Wirama
Pro and Cons between Ad Hoc SQL and Stored Procedure By : Kasim Wirama, MCDBA Before I give the pro and cons between Ad Hoc SQL and stored procedure, I would like to define what Ad Hoc SQL is. Ad Hoc SQL is SQL statements that is emitted from application...
Filed under:
SQL Server
0
Comments
Database Interoperability
by
Kasim.Wirama
Database Interoperability By : Kasim Wirama, MCDBA You need to consider your SQL syntax among database platform accessed from your application such as .NET, Java, etc. Interoperability in database is some of database issue that you need to consider and...
Filed under:
SQL Server
7
Comments
Implement Concurrency-Safe Stored Procedure for Update and Delete
by
Kasim.Wirama
Implement Concurrency-Safe Stored Procedure for Update and Delete In SQL Server 2005 By : Kasim Wirama, MCDBA Concurrency happens when two or more users access and modifies same resource. In this article, I would share would how you should develop UD...
Filed under:
SQL Server
4
Comments
MCDBA (Microsoft Certified Database Administrator) is Only Paper Certified?
by
Kasim.Wirama
MCDBA (Microsoft Certified Database Administrator) is Only Paper Certified? By : Kasim Wirama, MCDBA In offline discussion, some mailing list user asks what the proper salary is appropriate for a MCDBA. I think it depends on level that the use expects...
Filed under:
SQL Server
5
Comments
Status Pembuatan Buku Pemrograman Transact SQL
by
Kasim.Wirama
Status Pembuatan Buku Pemrograman Transact SQL (SQL 2000 dan SQL 2005) Sekitar kuartal keempat tahun lalu (2007), saya sempat mengundang rekan-rekan untuk berkontribusi di dalam pembuatan buku pemrograman Transact SQL. Sedianya saya targetkan selesai...
Filed under:
SQL Server
0
Comments
Dengan Piece Meal Online Restore di SQL Server 2008, Saatnya Mission Critical Industry Migrasi ke SQL Server 2008
by
Kasim.Wirama
Dengan Piece Meal Online Restore di SQL Server 2008, Saatnya Mission Critical Industry Migrasi ke SQL Server 2008 by : Kasim Wirama, MCDBA Dalam rangka menaikkan tingkat penetrasi SQL Server ke mission critical application di dunia finance seperti core...
Filed under:
SQL Server
0
Comments
Spatial Data Type in SQL Server 2008 CTP
by
Kasim.Wirama
Spatial Data Type in SQL Server 2008 CTP By : Kasim Wirama, MCDBA One of bunch of enhancements made by SQL Server 2008 that is in CTP now is spatial data type. What can spatial data type do? It can save and display information about location of an object...
Filed under:
SQL Server
1
Comments
HierarchyId, New Data Type in SQL 2008 (CTP)
by
Kasim.Wirama
HierarchyId, New Data Type in SQL 2008 (CTP) By : Kasim Wirama, MCDBA One of enchancement made by SQL 2008 in CTP is hierarchy type data type. It is CLR based data type, so the method name is case sensitive. You can see some hierarchy examples such as...
Filed under:
SQL Server
3
Comments
Change Data Capture in SQL Server 2008 CTP
by
Kasim.Wirama
Change Data Capture in SQL Server 2008 CTP By : Kasim Wirama, MCDBA To record data changes in a table, we have to make another table and manually implement trigger on source table that capture data changes into change table. This is done in SQL Server...
Filed under:
SQL Server
More Posts
Next page »