Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!
2002-10-15
8,622 reads
What's this error:Arithmetic overflow error converting IDENTITY to data type int? It was a new one to me, but read on to find out what it means.
2002-10-14
6,955 reads
One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!
2002-10-11
11,995 reads
Now that Andy has converted Steve Jones to a DMO believer we asked him to spend some time discussing replication. In this kick off article he discussion snapshot replication at a very high level - and looking for reasons to use it. This article isn't about how to do snapshot replication, it's about whether you should.
2002-10-10
11,927 reads
How secure are your SQL Servers? Are they patched? Are you aware of all the patches and vulnerabilities out there? This new tool from NGSSoftware can help you answer these questions and keep your environment secure.
2002-10-08
5,164 reads
If you're still on SQL Server 2000 SP2, beware! Microsoft has released a number of fixes that have now been rolled up into this cumulative patch to fix major security flaws in SQL Server.
2002-10-07
4,622 reads
Laplas Soft has updated its ever popular freeware SQLExecMS. SQLExecMS makes a DBAs and developers life so much easier by building in a number of common untilites. You can download it free if you're a SQLServerCentral.com member!
2002-10-04
146 reads
Check constraints can be added to a table to enforce specific rules on one or more columns. This article shows you how to use them to enforce simple and more complex rules.
2002-10-03
16,079 reads
Are you migrating your database and applications from Oracle to SQL Server and having trouble converting your code from PL/SQL to T-SQL? Then this article might help, though it doesn't cover all aspects. It provides you with answers to most commonly asked migration relasted questions. You will also find links to additional resources and books.
2002-10-02
419 reads
If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!
2002-10-01
7,453 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers