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.
Microsoft is now accepting nominations for beta testers for the 64-bit version of SQL Server 2000 (code-named Liberty), SQL Server 2000 CE Edition 2.0, and SQL Server 2000 Service Pack 3 (SP3). The SQL Server development team will use the feedback...
Sybase's PowerDesigner 9.0, which I used to model Figure 1, makes it easy for you to define and use domains. In database terminology, domain refers to a description of an attribute's allowed values. That description is divided into two levels: th...
Microsoft stresses that writing queries directly against system tables is a bad idea. Microsoft reserves the right to change the underlying definition of system tables, so the correct and safest way to query system data is through a system functi...
To make sure you have the information necessary to successfully (and easily) restore from the file and filegroup backup strategy I discuss in the main article, you need to ensure the accessibility of msdb by backing it up often. However, by defa...