FAQ : Why can't I see my text field's data when using ADO?
In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.
2001-07-06
23 reads
Articles
Taming the Stateless Beast: Managing Session State
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
XP_ENUM Stored Procedures
Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.
2001-07-05
3,486 reads
SQL Server CE: New Version Lets You Store and Upda
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.
2001-07-05
802 reads
Tame Those Strings - Part 6
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2001-07-04
8,827 reads
The Guru's Guide to T-SQL
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
2001-07-04
5,401 reads
PASS 2001 North America - Register and Save $500
Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!
2001-07-04
3,665 reads
Clonation and the Case of Table Dolly, Part 2
In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.
2001-07-03
950 reads
2001-07-02
4,052 reads
SQL Server 7.0 Log Shipping Frequently Asked Questions
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
2001-07-02
1,764 reads
Blogs
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers