The Ultimate SQL Server
From a DBA's point-of-view, the bigger the SQL Server box, the better. What would you consider to be the ultimate SQL Server box?
2001-08-10
1,628 reads
Additional Articles
Upsize Your Database: Convert Your Microsoft Acces
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
Monitoring blocking on a Server
This article will demonstrate how to monitor active spids, blocked by spids,cpu,I/O,cmds and app name being issued in a real time fashion by using the cmd shell calling a T-SQL script and a resource kit utility.
2001-08-07
49 reads
SQL Server 2000: New Features Provide Unmatched Ea
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
Microsoft SQL Server 2000 Security
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads
SQL Server 2000: .NET and the Death and Re-Birth o
In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.
2001-07-27
1,539 reads
SQL Server 2000 Operations Guide
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
2001-07-24
933 reads
SQLServerCentral.com Wrox Book Giveaway
Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!
2001-07-23
58 reads
Troubleshooting ASP and ADO Errors
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
Harnessing the Power of SQL's Analysis Services
WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.
2001-07-17
4,327 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Call Center Agoda
Nomor telepon call center Agoda: (0811) 222143 atau (0811) 222611. Hubungi Untuk Refund Dan...
Call Center Agoda Indonesia
Layanan Bantuan Planggan 24 Jam Call Center Agoda Indonesia Hubungi WhatsApp: 0811 222 143....
Kenapa cashback saya tidak masuk di Agoda
Untuk melakukan klaim cashback, Silahkan menghubungi Agoda melalui WhatsApp di nomor: 0811 222 143.
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers