Ken Spencer

Ken
Spencer

Ken Spencer is a longtime Microsoft Regional Director, and he consults as an architect on large application-development projects.

Articles
Debugging with Visual InterDev 14
Follow these steps to unleash the full power of the Visual InterDev debugging tool.
Running a COM Component in MTS
Follow these steps to create a COM component that runs in Microsoft Transaction Server (MTS).
Using COM Components with MTS
This article is the first in a series about using Visual Basic (VB) to develop distributed applications. I’ll explore COM components and how you can use them with Microsoft Transaction Server (MTS).
Introducing Queued Components
A new feature of COM+—queued components—offers benefits to developers of Web applications on the SQL Server platform.
MSMQ: Time Out for Your Database Applications - 15 May 2000
Many people overlook Microsoft Message Queue Server in their application development strategies, but this powerful messaging technology can give your applications a simple, robust way to interact with SQL Server.
Designing High-Performance User Applications
To increase a Web application’s performance, cut down on round-trips to the server.
Practical COM
COM can ease application development, speed application performance, and set you well on the path of modern application development.
Hardware's Golden Rule - 01 May 2000 1
If your hardware is golden, you've already eliminated many potential problems.
Solving Error-Handling Mysteries
When you’re troubleshooting Web applications, the answers you seek aren’t always in obvious places.
Putting COM Calls to the Test - 24 Apr 2000
The way you call COM objects can have a dramatic effect on application performance.
Returning an XML Document as a String - 17 Apr 2000
Here are three options for generating a complete XML document or stream from a stored procedure, then returning the XML document or stream as a string to the calling application.
Good Business Reasons for Using XML - 10 Apr 2000
XML provides practical solutions for many application needs, such as handling errors and storing session data.
Learning Through Prototyping - 03 Apr 2000
Prototyping is essential to building any application.
Includes Boost Productivity, Code Performance - 09 Mar 2000
Improve both your productivity and your Web applications’ performance by judiciously using server Includes.
Microsoft's New DNA XML Resource Kit - 02 Mar 2000
The DNA XML Resource Kit provides many tools and example code to help you send data across the Internet to other applications or browsers.

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
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....More
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×