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.
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to [email protected]. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...
If you need more than a high-level review to make a decision about your OLAP tool, here are some details that might help. We developed a test database and standardized series of tests for the products. For space considerations, this sidebar recaps...
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...