Congratulations to Willem Grobbelaar, a SQL Server DBA for Comparex Africa in Cape Town, South Africa, and Simon Lidberg, in Stockholm, Sweden. Willem won first prize of $100 for the best solution to the September Reader Challenge, "Restoring...
Are you planning to evaluate a 64-bit version of SQL Server 2000 for an upcoming project? Several readers have asked, "Where can I get an evaluation copy? I can't find one on the Microsoft Web site." I did some checking and, sure enough, Microsoft...
By default, SQL Server denies access to user accounts that don't have explicit access to a database, a table, or a view. And by default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET...
Microsoft Knowledge Base Article 301689 contains the following summary:
Custom privacy preferences can be imported into Internet Explorer by clicking
Import on the Privacy tab of Internet Options and opening an Internet Explorer Priva...
Maintaining service pack levels and hotfixes on your systems is important, but it's not always simple. Many factors affect how and when you patch your systems. If you've tested your architecture and know that a given service pack or hotfix won't...
SQL Server Magazine UPDATE—brought to you by SQL Server Magazine and SQL Server Magazine Connections...
In the wake of the most recent wave of Internet viruses, Microsoft sent a reminder to SQL Server 7.0 users about an available security patch. In the article "MS03-031: Security Patch for SQL Server 7.0 Service Pack 4," Microsoft explains that this...