Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
Query Analyzer is one of the most frequently used utilities in SQL Server's tool set. As every DBA knows, Query Analyzer is essentially SQL Server's command console. Query Analyzer's GUI makes it easy to use. In fact, you can easily overlook the ...
SQL Server stores most of its metadata in system tables in the installed databases. However, SQL Server stores some configuration settings—such as login authentication mode, shortcuts to SQL Server utilities, and so on—in the registry. If SQL Ser...
I used Sybase's PowerDesigner 9.0 to create the data model that Figure 2 (in the main article) shows. The design is a conceptual data model; therefore, the foreign keys aren't displayed as attributes. Instead, the relationships imply the foreign ...
I've noticed that the SQL Server 7.0 code page for a default installation is SQL_Latin1_General_CP1_CI_AS, but SQL Server 2000's default code page is Latin1_General_CI_AS. This change makes a significant difference when I need to restore SQL...
You might wonder why I didn't consider transactional replication for distributing just the changes within a large snapshot to target servers. Let's look at a real-world example that illustrates the reason for my choice. Although using transaction...