Destroyed your database? Corrupted files? What about corrupted records? What do you do in SQL Server? MSSQLRecovery is a product that can help you with this and more. Read this review by Dale Elizabeth Corey and see if this product might be something you can use.
2004-12-14
6,762 reads
Deploying a SQL Server database with your software can be tricky. It's easy to forget something that you added to development when trying to script out or detach and copy a database. And there's the whole problem of integrating the installation or upgrade into your main installation routine. New author Mark Vermeulen takes a look at Red Gate's SQLPackager, designed to make the job of deploying a database much easier.
2004-12-13
5,505 reads
SQL Server has a rock solid backup and restore routine. However, it is not the most efficient way of handling the backups and restores. Neither in terms of time or space required. A number of software vendors have developed their own additions to SQL Server that accelerate or compress the backups (or both). Wesley Brown has taken four of these products into his environment and run some comparisons. Read about large databases in part 2 of this series.
2004-12-09
7,290 reads
SQL Server has a rock solid backup and restore routine. However, it is not the most efficient way of handling the backups and restores. Neither in terms of time or space required. A number of software vendors have developed their own additions to SQL Server that accelerate or compress the backups (or both). New Author Wesley Brown has taken four of these products into his environment and run some comparisons. Read part one of his review.
2004-12-07
10,773 reads
SQL Server includes Query Analyzer as a client editing tool for T-SQL code. It's a great tool, but it does have a number of shortcomings. Apex SQL has released an editor that includes a number of features missing in Query Analyzer. Read this review by Brian Kelley.
2004-11-08
7,796 reads
Teratrax, maker of SQL Server products, is offering the SQLServerCentral.com community a 15% discount on their products.
2004-11-04
2,472 reads
Version control in SQL Server is fairly immature, to put it nicely. Fortunately it's also an area that a number of vendors are working to make smoother. Dinesh Asanka looks at dbMaestro, a tool from Extreme Technologies to help you track changes in multiple databases.
2004-10-20
7,615 reads
Every shop with any sort of IT organization should be scanning for vulnerabilities and issues with their systems and SQL Server is no exception. Security software vendor has a tool that can scan and report on all your SQL Servers is an easy to use product called Typhon III. Our security expert Brian Kelley takes a look at this product.
2004-10-07
13,911 reads
Security in SQL Server is every DBA's concern. Your data is critical and ensuring that it is secure and intact is your responsibility. Application Security's AppRadar is reviewed by Dale Elizabeth Corey and provides monitoring of your critical databases for malicious activity and more.
2004-09-23
5,830 reads
How solid is your SQL Server database design? Will it perform well in practice? SSW has a product, SQL Auditor, that compares your design against a number of well known design rules and gives you reports based on how well your design does. Read Mike Pearson's review of this product.
2004-09-06
5,806 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers