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.
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...
This month, I'm going to pitch a nice slow one right down the middle, and I expect everyone to hit it over the center field fence. Using the FoodMart 2000 Sales cube, write an MDX query that displays each product category and its average month-to...
One of the biggest benefits of using the file and filegroup backup strategy is the ability to recover quickly from isolated disk failures. If only one file or filegroup is damaged, you can easily recover by restoring only the damaged files or fil...
During the past year, I've run across many useful free tools. Here are my seven favorite free SQL Server utilities. Although vendors sometimes change the availability of free tools, when I wrote this column, all the utilities listed were freeware...