Conflicting Instructions
Ever have problems following something from Books Online? There may be a reason. Microsoft has noticed as well and there are updates for this valuable DBA tool. Here's a sample of the changes and a link to get the update.
Designing a Flexible Task Management Database Part II
In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.
Restoring Using DMO - Getting File List and No Recovery
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!
Reaching the Outer Limits
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.
Querying XML files using SQL 2000
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!
Snapshot Replication
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.
Review: NGSSquirrel
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.
SQL Server 2000 Post SP2 Patch Released
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.
Freeware SQLExecMS Updated
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!
Using Check Constraints
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.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers