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
Feb 5, 2016
blog

The Solution to Large Quantities of Data

High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
SQL Server 2016 Reporting Services
Jan 25, 2016
Article

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....More
Microsoft Power BI
Dec 8, 2015
Article

It is Time to Migrate Power BI for Office 365 1

Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....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) ×