By John Foley – Microsoft’s SQL Server has been playing catch-up for years. As the database software turns 10 and prepares for a 64-bit power boost, is it what big business needs?
Tag: sql server
A decade of data — Seattle summit to celebrate SQL Server, preview Yukon
By Margie Semilof – It may be the 10th anniversary of Microsoft’s SQL Server, but database administrators at the annual SQL Server user group meeting next week in Seattle are more likely to be buzzing about the first Yukon beta scheduled for early in the new year.
SQL Server’s Future: Better, Faster, Easier
Brian Moran has gained a new appreciation for the value of stored procedures exposed as Web services. Will this functionality, which Microsoft will enhance in Yukon, make his current theory of extreme performance irrelevant?
Microsoft scraps server OS plans
Microsoft has scratched plans for a major overhaul to an upcoming version of its Windows operating system for servers, the company confirmed Tuesday.The Redmond, Wash.-based software maker has been working on delivering the next major desktop and server versions of Windows–code-named Longho
Security Models and Scenarios for SQL Server 2000 Windows CE Edition 2.0
Easily convert your eMbedded Visual Basic applications to SQL Server CE 2.0.
Upgrading from SQL Server 7.0 to 2000
By Rhys Kerrigan – I recently came across the following error while upgrading to SQL Server 2000. “The Ordinal 105 could not be located in the dll Opens60.dll”The following options are available to recover from this problem.
Collecting SQL Server Statistics
need to collect statistics such as transactions per second (tps) on my SQL Server machines for periodic reporting. I’ve used the Performance Monitor extensively, but I’m unable to produce a set of SQL Server performance numbers that are meaningful to DBAs [database administrators]. Are any utilities
IMP Index Manager Speeds SQL Server Database Searches
by Brad M. McGehee – Intranet and Internet websites are so common now that if your company doesn’t have both, your CEO must still be living in the dark ages (don’t tell him or her I said that). One of the biggest issues that web developers, or DBAs, or both, have with websites is how to allow users
Connection Pooling with SQL Server 2000 Analysis Services
Connection pooling with SQL Server 2000 Analysis Services gives improved control over resource management.
SQL Server DTS Optimization Tips
In his latest article, Alexander Chigrik offers fourteen helpful tips to ensure you are using SQL Server Data Transformation Services (DTS) in the most efficient manner possible.
