Trapping DTS errors with Transact-SQL
Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.
2003-05-27
2,490 reads
Additional Articles
Test Your SQL Server Security Skills and Compete with your Friends!
Test to see how much you know about SQL Server security. If you're one of the members to pass the test (72% score or higher), you're entered into a contest to win a copy of AppDetective and one year's worth of support (over $1500 value)! You can only take the test question test once and it is not timed. After the test, you'll be given the answers and why one answer is more correct than another. Questions are randomly chosen from a pool.
2003-05-22
336 reads
COM+, SQL Server, Serializable isolation level and the issues!
This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.
2003-05-22
1,874 reads
SQL Stripes 0.50 Build 180 Released
SQL Stripes is an application that helps you - the SQL Server DBA, to have complete control over your servers. From the high-level of monitoring essential components to the low-level of analyzing your various databases. SQL Stripes is an intuitive and easy to use application and is intended for SQL Server DBA who want to have an easier life. SQL Stripes is completely free! (Announcement, not reviewed)
2003-05-20
461 reads
Web Application Maker released for SQL Server
New Web interface generator for multi-user SQL Server databases. Makes either complete DB interfaces with a single click, or web form fragments through model-based developer API. Sources available. Online showroom allows use and development; trial version available for download. (Announcement, not reviewed)
2003-05-20
1,154 reads
Webcast: 0 to Cluster in 60 Minutes-Clustering Windows and SQL Server
In this session we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment. We’ll then jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After this session, you should have just enough information to build you own SQL Server that is highly available.
2003-05-13
889 reads
SQLInserts 2.0 Released
LockwoodTech has released a new version of SQLInserts with an entirely redesigned interface that supports client-side WHERE clauses, column level scripting, table level row maximums and much more.
2003-05-13
535 reads
Economies of Speed Whitepaper
Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.
2003-05-08
1,600 reads
An Automated Solution for Migrating Database Structures
This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.
2003-05-06
2,750 reads
Sneak peak at Log Navigator II
As LockwoodTech Log Navigator Beta releases approaches we have released a bunch of new screen shots on product features. Log Navigator reads the MS SQL Server Transaction Log to allow you to passively audit data changes (inserts, updates and deletes) made to your database.
2003-05-05
619 reads
Blogs
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Forums
Problem installing SQL Server 2022
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
How to Attach and Detach Databases in SQL Server
Comments posted to this topic are about the item How to Attach and Detach...
What is Terraform?
Comments posted to this topic are about the item What is Terraform?
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers