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
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×