The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
2007-10-02 (first published: 2004-09-28)
40,377 reads
Your backups are critical for the success and stability of your business. However as backup sizes grow and servers proliferate, managing the backups and storing all this data becomes a challenge. Dale Elizabeth Corey brings us a look at Imceda's Litespeed for SQL Server, a fantastic utility for helping manage your backups.
2005-05-11
21,998 reads
SQL Server 2000 has a weak point in how it handles security. SA can see everything, a notion that disturbs many people, especially those that have data security requirements. Netlib has a great product that allows you to encrypt columns, tables, or databases in a way that is seemless to your application. Dale Corey takes a look at this product and how you might use it in your application.
2005-03-07
8,034 reads
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,764 reads
SQL Server 7 revamped Enterprise Manager to be an MMC snap in with many more capabilities and functions than it had in SQL Server 6.5. Dale Elizabeth Corey brings us a look at the top ten features in Enterprise Manager that you may not be aware of.
2004-11-16
11,319 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,833 reads
Ever have a transaction you need to roll back? Undo a fat finger? There are a number of log reading products available for SQL Server to help with you in this area. Dale Corey takes a look at LOG PI with an extensive review of the product, including a bunch of screenshots..
2004-08-23
8,266 reads
NGS Software is in the security business and have been very successful in finding vulnerabilities in many products, notable SQL Server. They have used their expertise to build products to help you better secure your systems. Dale Corey looks at one of those products, NGSSquirrel, which does vulnerability assessment.
2004-07-30
10,667 reads
Setting up SQL Server server-side traces is not the easiest task in the world. Quantum Software Research has built a product that is an MMC add-in to manage these traces. Author Dale Corey takes a look at this product and how well it works with SQL Server 2000.
2004-07-07
9,842 reads
Have you ever built a join graphically using Access or Visual Studio? Did you know that you can do this with the native SQL Server tools? And it's easy! Follow along as Dale Corey shows you how.
2004-04-26
14,024 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers