Creating Folders Using VB and Recursion
Read this article to learn how to use recursion to simply the task of creating multiple levels of folders on disk. Perfect for creating a folder hierarchy for holding backup files!
2001-08-03
12,796 reads
Andy Warren
SqlServerCentral Announces New Guest Columnist
We've got a new guest columnist! Click here to find out a little bit about Mindy Curnutt, then read her first article for SqlServerCentral.com.
2001-08-01
2,260 reads
Review: SQL Server 2000 Database Design
Is this a book you should read? Spend a few minutes reading the review to find out!
2001-07-23
4,545 reads
Missing Temp Tables - Follow Up
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
2001-06-27
4,849 reads
Executing Multiple Scripts in a Folder using the ScriptRunner Utility
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
2001-06-14
9,939 reads
Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
2001-06-01
4,191 reads
Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,279 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,691 reads
Non_Continuous Replication
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
2001-05-15
4,710 reads
Minimizing the Number of Log Backups
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,360 reads
Blogs
RMOUG Training Days in Denver
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Forums
What are the alternatives of S3 Object Lambda?
Hi all! AWS has a good example of how to manipulate the requested objects...
SQL Script plug-in
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Modify RDS page missing the Storage Autoscaling option
Hi folks, I have a single Postgres instance on RDS that in the past...
Ask SSC