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)
39,406 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,864 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
7,809 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,736 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,136 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,791 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,239 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,397 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,824 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
13,853 reads
By Steve Jones
Today’s coping tip is to discover your artistic side. Design a friendly greeting card....
So, we made it through our first 90 days, things start getting tougher now...
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...
Hi, In Power BI Report Builder I need to use SSRS code for my...
Hi We have a SSIS package that uploads data to Blob storage. The package...
I need only one backup full at mid night, and one backup log each...
Ask SSC