Andy relates some info he got from Wes Grant about his freeware and open source project to build a web based admin tool for SQL that is currently in the design/initial coding phase. Get the scoop and maybe write some of the code too!
2002-10-22
4,832 reads
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.
2002-10-21
4,456 reads
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.
2002-10-17
7,130 reads
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,659 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
7,005 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
12,020 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,975 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,195 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,632 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
160 reads
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
hi we have to replace talend which generally was used to move files. talend's...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers