By Brian Moran – Publicly, Microsoft loves and supports Java. But let’s face it, Java is a four-letter word to most people in Redmond. Microsoft architects (especially the .NET folks) probably wouldn’t mind if Java and its related platforms simply faded away so that Microsoft could get on with the b
Tag: sql server
New PASS North America Dates Announced
Thank you for being patient while we deliberated on a new PASS user conference venue. PASS is pleased to announce that PASS North America has been rescheduled to January 28-31, 2002 at the Adam’s Mark Hotel in Denver, Colorado, USA.
ASP Neat Released
ASP Neat is a powerful, yet easy to use, code generator for Active Server Page code. Database programming for the web just got easier, and much faster!Designed for use with Microsoft SQL Server and MS Access databases, ASP Neat helps you to quickly create Active Server ‘Page Sets’ for basic
Microsoft Accepting Applications for SQL Server SP2 Beta Program
By Kathy Blomstrom – The Microsoft SQL Server product team is accepting applications for the SQL Server 2000 Service Pack 2 (SP2) beta program. Only registered members of this private program will receive the beta version of SP2 for testing and evaluation purposes. SP2 beta program participants will
Auxiliary Tables, Bit by Bit
By Itzik Ben-Gan – Auxiliary tables are extra, “helper” tables you create in your database specifically to help you provide T-SQL solutions. With auxiliary tables, you can write shorter, simpler, and more elegant code. I can best explain the concept of using auxiliary tables through an example. In t
Undocumented SQL Server 7.0 System Tables
by Alexander Chigrik – In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database).
Keyword search using a tally or sequence table
From SQLTeam – Ryan writes “I am looking for a way of creating a stored procedure that will carry out a keyword search without building up the SQL dynamically in the stored procedure. What I’m after is a method of doing this that doesn’t require me to build up a huge string.”
OLAP Survey Respondents Give Analysis Services High Marks
By Kathy Blomstrom – SQL Server 2000’s integrated Analysis Services functionality came out on top in several categories in the recent 2001 OLAP Survey, conducted by Survey.com and published by The OLAP Report. The survey asked more than 644 OLAP users from 46 countries to rate 11 vendors on implemen
AGS SQL Scribe
SQL Scribe is a documentation tool created with the developer in mind. SQL Scribe will interrogate a SQL 7.0 or 2000 database and extract the database schema. This schema information is stored in an MS Access 2000 database. Using any readily available browser the developers can navigate though the
Advanced SQL Techniques – Part 1: Analyzing Duplicate Records
By David Penton – The following is an analysis of records in a table, some of which may be duplicated. Many different things can be accomplished with this method, including looking for duplicates, looking for records that are duplicated n times, deleting duplicates, etc.