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.
When SQL Server is first installed, it sets the default directory for data and transaction log files. Sometimes, when users use Enterprise Manager to create a database, they don't change the default transaction log path in the Database Properties...
Related: What perfmon Counters Can I Trust When Using SAN Disks?
I need to create a performance baseline for my company's SQL Server based on Performance Monitor counters. What counters should I measure, and which ones are most important?
We ...
In Jeffrey Yao's Reader to Reader tip "Refresh Database Objects," June 2002, InstantDoc ID 24600, the author describes the kinds of problems that can occur when objects in your database change over time. Yao suggests that a good way to solve thes...
Can I write a script that checks for the existence of an index on a particular table?
I recently answered a question like this one on the Microsoft SQL Server public newsgroup at msnews.microsoft.com, and I'd like to share my answer here for t...
Microsoft Group Vice President Jim Allchin verified the timeline for Longhorn, the next version of Windows, during his keynote address at Windows Server DevCon on September 6 in Seattle. Allchin said that Microsoft will deliver the far-reaching...
As part of a series of Developer Centers that provide a centralized source for tools, information, and resources, MSDN has rolled out the XML Web Services Developer Center. The Center, at http://msdn.microsoft.com/webservices , provides a place...
Microsoft's new Baseline Security Analyzer (MBSA) is now available at http://support.microsoft.com/default.aspx?scid=kb;\[LN\];Q320454 . The site provides information about and a link to download the security tool. This tool centrally scans...
Microsoft announced its first .NET certification, the Microsoft Certified Application Developer (MCAD) for Microsoft .NET credential. The MCAD certification recognizes professional developers who use Microsoft Visual Studio .NET and XML Web...