Is 0% Downtime Possible?
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
2002-02-25
5,990 reads
Articles
AdeptSQL Workshop released
Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.
2002-02-25
3,342 reads
Compare SQL Server Databases with sp_CompareDB
Use this free stored procedure to compare two different SQL Server databases in order to discover how they differ. Sp_CompareDB can compare both table structures and the data stored in them. Also learn how the stored procedure was written.
2002-02-22
1,214 reads
Exploring Deadlocks
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,402 reads
SQL Server Security Part 3
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
2002-02-18
9,894 reads
Mini ASP based SQL Server admin tool
myLittleAdmin For SQL Server is a web-based SQL Server Database administration tool. It is intended to handle the administration of SQL Server databases over the WWW using ASP. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.
2002-02-18
3,217 reads
2002-02-15
3,570 reads
SQL Server 2000 Performance Tuning
A series of web presenatations from Microsoft about tuning SQL Server 2000.
2002-02-15
1,362 reads
Adding a Column using SQL_DMO
One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!
2002-02-14
4,764 reads
Speed of Partitioned Views
There has been some talk about the use of partitioned views in SQL Server 2000 to gain performance improvements for scale-out of applications. In this article by Neil Jacobson, he discusses his findings in respect of the speed of partitioned views.
2002-02-13
7,502 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers