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.
Upcoming Conferences

Register now to get the best rate available!

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
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×