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.
We database professionals constantly strive to get every last ounce of performance improvement out of our systems. We bend over backwards to make our systems run faster and better. But while we're worrying about tweaks, we sometimes forget about...
According to a new report from research firm Gartner, the database market experienced a decline in sales in 2002, but Microsoft SQL Server experienced a substantial increase in sales and market share. In 2002, economic troubles hit the database...
Microsoft released several new articles that provide product fixes and information for SQL Server customers. Two of the fixes specifically address problems that DBAs might encounter when they install SQL Server 2000 Service Pack 3 (SP3)...
The race for supremacy in the Transaction Processing Performance Council's (TPC's) TPC-C benchmark continued as Microsoft and Hewlett-Packard (HP) posted new results yesterday in the nonclustered TPC-C category. The race has heated up in recent...
How can I track how frequently my applications use indexes on a particular table and find out which applications are using the indexes?
Tracking index usage helps you determine which indexes you need to keep, but you can't get this information...
Query Analyzer is packed with features that many people haven't experimented with. Here's an obscure capability that I didn't know existed until recently. Query Analyzer lets you set a wide variety of configuration options. However, I didn't know...
Using the FoodMart 2000 Sales cube, write an MDX query that displays only the product categories on rows that contain products that are in the top five based on store sales. On the columns, display only Store Sales. Here's a hint: This puzzle will...