Recover Those Packages!
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,857 reads
Articles
An interview with Robin Dewson
Want to learn more about some of your favorite authors. Check out this interview with Robin Dewson.
2001-08-15
3,424 reads
Review: Loading Sample Data with DataTect 1.6
So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.
2001-08-15
3,890 reads
Pseudo web service using xmlHTTP
This article delves into the mysterious xmlHTTP object and the supporting ASP code. I've got to tell you that I really love using this object. Basically what I like about it is that through xmlHTTP you can expose some or all methods of any ActiveX class to the client-side user. What this means is you are giving the user the capability of calling your back-end Active X controls. And the best part of it all is that the entire communication process takes place behind the scenes!
2001-08-14
7,560 reads
2001-08-13
4,066 reads
ASP and ADO Gotcha - Duplicate Field Names in a Query
Recently while working on the SQLServerCentral.com site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.
2001-08-10
3,453 reads
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
Save Your Packages Locally
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,944 reads
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
Book Review:Admin 911: SQL Server 2000
This is a great administrative reference for anyone using SQL Server 2000.
2001-08-08
3,275 reads
Blogs
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Forums
Joining against min date only
This is one of those things very hard (for me)to explain in words. See...
Feeling your age? How would you know?
Comments posted to this topic are about the item Feeling your age? How would...
Sever Migration
Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...
Question of the Day
Rolling Back CUs
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers