The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,951 reads
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,837 reads
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,179 reads
Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.
2003-02-17
4,628 reads
In SQL Server 2000, there is a database option to close the database when it is not in use. Every wonder what this is? Or when it should be used? Steve Jones takes a look at this seldom used option.
2003-02-10
12,062 reads
I've had to call Microsoft quite a few times for support this year. Was it worth it? Read on to see when you should decide to call.
2003-02-06
6,193 reads
Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware.
2003-01-30
6,084 reads
Continuing with our worst practices series, Steve Jones looks at another administrative no-no. Making a change to your live system on the fly.
2003-01-20
7,796 reads
Continuing on looking at demo servers, this article presents an interesting solution to ensuring consistent demos that was deployed out in the field for a client company.
2003-01-13
3,648 reads
Steve discusses a potential new project we have in the works. We'd appreciate as many comments and votes on this one as possible.
2003-01-06
7,967 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...
Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...
Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers