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.
In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid. I understand why I should avoid options such as offline, DBO-use only, statistics off, truncate log on checkpoint...
In his keynote address at Comdex earlier this week, Bill Gates announced that a Unisys 32-way ES7000 server running Windows Datacenter Server Limited Edition and SQL Server 2000 Enterprise Edition set a new record for Windows performance on the...
A few months ago, I discussed the pending release of a new Microsoft business intelligence (BI) tool called Data Analyzer, which the company officially launched on November 1. I'd like to revisit Data Analyzer and focus on its features and—more...
From time to time, I've discussed the problem of drowning in a sea of information. Reading and digesting all the technical content that interests you and is readily available on the Web or in print is impossible. So, where do you start? Sometimes...
Microsoft has posted a new article that details a SQL Server 2000 Service Pack 1 (SP1) bug. The article explains that executing a SELECT statement that has a nested query on a table that contains a computed column might generate the following...
Congratulations to Tony Bain, senior DBA at Wellington, New Zealand-based SQL Services and Zivan Karaman, manager of the statistical department at Limagrain Genetics in Chappes, France. Tony won first prize of $100 for the best solution to the...