Steve found a gaping hole in his backup process. One that he plugged with this script to move log files around the network in the event of a server failure. If you can't afford to lose a day of work, read about his solution.
2002-09-30
6,277 reads
Ever needed a pause in a script? Maybe want to retry something after a minute? This article gives a quick snipped of code that will help you implement a pause in your script.
2002-09-26
6,956 reads
Having trouble with a target server (TSX)? Steve Jones did in his environment. Read about how he worked around the issue to restore administrative capabilities.
2002-09-16
7,247 reads
It's been a year since Steve Jones last wrote about the state of the DBA job market after the economy soured. Here's an update of the last year.
2002-09-09
4,500 reads
Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.
2002-09-03
4,759 reads
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
2002-08-29
13,007 reads
A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.
2002-08-20
18,048 reads
Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.
2002-08-12
4,269 reads
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
2002-08-07
3,922 reads
A look at a new security tool from Microsoft for analyzing your SQL (and other) servers.
2002-07-30
5,043 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Comments posted to this topic are about the item The day-to-day pressures of a...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers