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.
Three weeks ago, I described a SQL Server system-design philosophy that I call "designing for extreme performance." Many of you asked me to clarify my thoughts in a few key areas, and I'm going to start that process this week. I'll continue to...
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...