SQL Server 7.0
|
100 results found, displaying items 1 - 20
|
Checking Backup Status on Multiple SQL Server Systems
Use this method to generate a simple backup status report that you can use to ensure all your SQL Server systems are backed up when they’re suppose to be.
SQL Server Magazine
—
Sivakumar Mahalingam
Want the Latest SQL Server Features? Then Upgrade!
Kalen discusses how you can use features from the latest versions of SQL Server in older versions of SQL Server, and explains the benefit of having to upgrade in order to use new features.
SQL Server Magazine
—
Kalen Delaney
LiteSpeed’s SmartDiff Technology Reduces Backup Sizes and Times
Quest Software's LiteSpeed for SQL Server now includes SmartDiff, which compresses database backups by as much as 40X.
SQL Server Magazine
—
Megan Keller
Diving Deeper into Wait Stats
In two previous articles, I've discussed SQL Server 2005 waits and showed you some of the more common ones. Now, let's dive down for a deeper view of what each connection or even thread in the SQL Server instance is waiting on.
SQL Server Magazine
—
Andrew J. Kelly
Set-Based vs. Cursor-Based Solutions for Running Aggregates
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.
SQL Server Magazine
—
Itzik Ben-Gan
SQL Server Magazine is 10 Years Old!
SQL Server Magazine launched in the SQL Server 7.0 timeframe. In 1998 SQL Server was a distant third in the enterprise database market and was regarded as a small-scale departmental database; easy to use but not enterprise-ready. How things have changed.
SQL Server Magazine
—
Michael Otey
Vulnerability Scanner Showdown: AppDetectivePro 5.4.6 vs. AuditPro Enterprise 4.0
Your SQL Server could be vulnerable to attack, but how would you know? AuditPro Enterprise and AppDetectivePro are database vulnerability scanners that can tell you, and this review will help you decide which one you want.
SQL Server Magazine
—
John Green
SonaSafe for SQL Server 5.0 Provides Advanced Data Protection and Disaster Recovery Features
SQL Server Magazine
—
Megan Keller
Windows SharePoint Services 3.0 for Business Intelligence
Windows IT Pro
—
Derek Comingore
Windows SharePoint Services 3.0 for Business Intelligence
A common question asked by Microsoft customers is "What can I do to extend my existing data warehousing/BI solution when I only have access to WSS 3.0?" Actually, WSS 3.0's basic BI capabilities are quite impressive! Let's look at them in detail.
SQL Server Magazine
—
Derek Comingore
In Search of Duplicate Indexes on Your Tables
Windows IT Pro
—
Andrew J. Kelly
In Search of Duplicate Indexes on Your Tables
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
SQL Server Magazine
—
Andrew J. Kelly
Panda Warns of Widespread SQL Injection Attacks
Panda Security is warning administrators of a widespread SQL injection attack against IIS servers. The company said that so far about 282,000 Web pages have already been infected.
Windows IT Pro
—
Mark Joseph Edwards
Managing Plan-Cache Size
Windows IT Pro
—
Kalen Delaney
Managing Plan-Cache Size
SQL Server 2005 doesn’t limit plan-cache size but still provides ways to control it. Learn how to keep an eye on cache size and tricks to trim down a bloated cache to improve performance.
SQL Server Magazine
—
Kalen Delaney
A Brief History of Plan Caching in SQL Server
Changes in plan caching over successive versions of SQL Server affect its memory usage.
SQL Server Magazine
—
Kalen Delaney
SQL Server Versions
Now that Microsoft has released several different service packs for SQL Server 2005, chances are you're running multiple versions. Here's an easy way to see what you're running.
SQL Server Magazine
—
Michael Otey
2007 PASS Community Summit: SQL Server, Orange Vests and the Blue Bear
The SQL Server Magazine editors attend the 2007 PASS Community Summit in Denver, Colorado. What do Quest Software, Idera Software and a gigantic blue bear have in common? Read on to find out....
SQL Server Magazine
—
Jeff James
SQL Server Magazine UPDATE, April 19, 2007--Keep Your Eye on DPM
Learn how improvements in Microsoft System Center Data Protection Manager 2007 Beta 1 make this product worth watching. Plus, read about the real value of BI technologies, check out the new Windows Live search macro for SQL Server, and more!
SQL Server Magazine
—
Various Authors
SQL Server Magazine UPDATE, April 12, 2007--Hotfixes vs. Service Packs: Blurring the Lines
Learn about the mysterious Incremental Service Model for automatic notification of SQL Server hotfix Cumulative Updates. Plus, check out the TechX Interoperability Web site and newsletter, join the discussions on our forums, and more!
SQL Server Magazine
—
Various Authors
|
|
Register
