Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
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...
I have a flat-file system and a SQL Server database that need to reflect changes to each other's systems. Completing the initial data upload is easy, but replicating the changes in each data store is difficult, especially changes in the flat files...
If you need to recover a database because a drive failure made your database unusable, you'll probably want to restore as many transactions as possible that finished before the failure. SQL Server Books Online (BOL) says that if the log file is s...