Skip navigation
Menu

John Paul Cook

John Paul Cook is a database and systems architect in Houston, Texas. His primary focus is helping large enterprise customers succeed with SQL Server, virtualization, and Visual Studio Team System. He has multiple Microsoft and Oracle certifications and is a Microsoft MVP.

[email protected]

John Paul’s Recent activity

Compression Basics
Feb 21, 2006
Compression routines look for repeating data patterns in files, then replace the patterns with shorter-bit patterns called tokens. Files that contain many repeating bits benefit the most from compression. For example...
Zip Your Data
Feb 21, 2006
Save space with these SQLCLR compression functions
Can I Have a Reference?
Jan 12, 2006
It's standard practice for developers to group and compile common functions into a single component (e.g., a DLL) that different applications can share and reuse. The Windows .NET Framework itself can be thought of as...
Easy Coding with SMO
Apr 18, 2005
Simplify your life with SQL Server 2005's fast, easy, powerful coding model
Manipulate Oracle with SQL*Plus
Apr 26, 2004
SQL*Plus is a utility that lets you query, modify, and manipulate Oracle database objects as well as carry out database maintenance activities. SQL*Plus is installed by default when you install the Oracle server. A...
Executing Stored Procedures Remotely
Oct 23, 2001
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Transactions
Oct 23, 2001
SQL Server's default behavior is to automatically commit implicit transactions. In Oracle, the default is that implicit transactions require an explicit commit. However, a linked Oracle query by default automatically...
System Procedures for Obtaining Linked-Server Metadata
Oct 23, 2001
If you aren't comfortable using Oracle tools to query the Oracle data dictionary, some SQL Server system stored procedures can help you obtain Oracle metadata from the linked Oracle server. The following procedures...
Load More