John Paul Cook

John Paul

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.

Zip Your Data
Add compression capabilities to SQL Server 2005 by leveraging the Common Language Runtime (CLR) and taking advantage of the new varbinary(max) data type.
Compression Basics 1
If you're embarking on a solution for compressing data, you'll find this compression overview helpful.
Can I Have a Reference?
SQL Server Projects restrict the custom .NET assemblies you can reference.
SQL Server 2005 Express and Workgroup: Scaled Back, Yet Feature-Rich 1
SQL Server 2005 Express Edition and SQL Server 2005 Workgroup Edition provide many SQL Server 2005 features and are geared toward the needs of developers and smaller organizations.
Easy Coding with SMO
SMO, the new programming access layer in SQL Server 2005, lets you quickly and easily develop applications while reducing coding errors and increasing the likelihood that your solution will work the first time.
Executing Stored Procedures Remotely
You can't use a linked server to execute an Oracle stored procedure from SQL Server, but you can update an Oracle table from a linked-server query.
Learn how to deal with differences in how SQL Server and Oracle treat transaction commitment.
System Procedures for Obtaining Linked-Server Metadata
Some SQL Server system stored procedures can help you obtain Oracle metadata from a linked Oracle server.
Analyzing Linked-Server Queries 2
To fully analyze an Oracle linked-server query, you need to use Oracle's SQL Trace facility.
SQL Server and Oracle: Making the Connection 19
Linking servers is fairly straightforward when they're all SQL Servers--but what happens when your company has data in both SQL Server and Oracle? Here's a guide to what Microsoft and Oracle don't tell you.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2016

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×