Configuring SQL Server 6.5
A properly configured SQL Server can mean the difference between a sluggish server and one that runs well. There are a few pitfalls that you can experience in doing this.
2001-05-08
3,437 reads
Articles
IIS Connection Pooling ? ADO Gotcha!
This article by Leon Platt speaks to how you can avoid pulling your hair out when configuring connection pooling for IIS.
2001-05-08
8,054 reads
Rants about the sa account!
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,794 reads
Character Datatype Decisions
The type of datatypes that you use in your schema could impact the performance and the accuracy of your database.
2001-05-07
6,599 reads
Running a DTS Package from Query Analyzer
Can you run a DTS package from Query Analyzer...you sure can! Read how to integrate DTS, Jobs and Stored Procedures to run a DTS Package from Query Analyzer.
2001-05-07
10,551 reads
StarSQL 3.0 Configuration
In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.
2001-05-07
3,448 reads
Sweeping Up The Slackers
Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.
2001-05-07
5,117 reads
Viewing Linked Servers' Meta Data
So, you've added a linked server and need information about it. There must be an easier way to fine information about your linked server and keep from walking to the server room.
2001-05-07
9,885 reads
The Data Mining Cluster Analysis Algorithm
Provides audience with information on cluster analysis algorithm.
2001-05-07
1,594 reads
Uncovering Linked Servers
A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.
2001-05-06
21,352 reads
Blogs
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Revolutionizing Entertainment with Mobile Game Development
Mobile game development has become a cornerstone of the entertainment industry, transforming creative ideas...
Exploring the Future of Mobile App Development
Mobile app development has become a cornerstone of modern business strategies, enabling companies to...
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers