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
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....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) ×