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,266 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,944 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,232 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,485 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,743 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
12,694 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,037 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,254 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,823 reads
A look at a new security tool from Microsoft for analyzing your SQL (and other) servers.
2002-07-30
4,829 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers