Extended stored procedures enable significant functionality that does not exist natively inside SQL Server. Extended stored procedures is a misnomer that started several versions ago when they were first introduced. These are not stored procedures at all. An extended stored procedure is actually a f

By Angie Brew Clarity Systems and Maximal Innovative Intelligence formed a partnership to offer Maximal’s Max data analysis tool as part of its business intelligence (BI) solutions. The partnership combines Clarity’s expertise in implementing OLAP-centered BI solutions with Maximal’s Max, which

Chosing datatypes for your tables is one of the most basic decisions you will make in database design. Many people discount this part of database planning and take a "close enough" approach. The decisions you make at this stage have far reaching effects that you might not have intended. The

by Angie Brew LEXIS-NEXIS which provides decision-support information and services in the legal, business, and government markets, recently built a search solution on SQL Server 2000 to let its customers search its public records faster and more efficiently and to reduce its cost per transaction

Learn everything you ever wanted to about Microsoft SQL Server 2000 Profiler and SQL Trace Architecture. This Support WebCast will talk about using stored procedures to trace, Replay facility, Index Tuning Wizard, scenarios, known issues, and will provide handy tips and tricks. Tuesday, November 14,

Wysdom – As seen at Internet World Fall 2000. Mobyle Blueprints is a revolutionary development environment offering developers unprecedented freedom to build applications – lightning fast – regardless of the complexities of devices and protocols. Mobyle Blueprints can extract information from

by Angie Brew Want to give mobile users powerful database functionality? Check out SQL Server 2000 Windows CE Edition (SQL Server CE). Microsoft built SQL Server CE specifically for managing small databases on portable devices. You can easily integrate SQL Server CE with existing systems because

One of the projects I began years ago was to design a course that would teach TSQL, SQL, database design, data warehousing, replication, and OLAP. This section is the fruits of that labor. One of the greatest benefits you get from instructor led training is the instructor. Since I obviously can&#

By default, SQL Server Enterprise Manager displays all of the system databases, tables, and other database objects in its console tree and details pane. If you don't want to see these system objects, you can turn off their display by editing your server's registration properties.

One of the things that I see very rarely is script headers and comments. This is baffling. Almost every development project I have ever worked on has had very elaborate version control systems, coding standards, commenting guidelines, and even templates. For some reason, this was never carried th