SQL Server Magazine

		Options
Need for Speed Track down roadblocks with these 9 steps to an automated Profiler trace, dissect a real-world performance solution, learn how to prevent SQL injection attacks, put Reporting Services parameters to work, and more!		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

9 Steps to an Automated Trace

SQL Server Profiler traces can give you great information to help you improve performance, but you probably don't have the time to run them often enough. The answer? Automate your traces with SQL Server jobs!
By Steven Berringer 

Embedded Scripting in Stored Procedures

If you need to import data from a Microsoft Excel spreadsheet or .csv file into SQL Server, you might be frustrated because T-SQL doesn’t support the ability to access external objects--or does it? Learn how to work around this common problem.
By William Barton 

Preventing SQL Injection Attack

You can best protect your data from SQL injection attacks if you first understand how they work. Learn to create your own SQL injection attack--then use your knowledge to set up effective data-protection layers.
By William Sheldon 

Pushing the Parameters

SQL Server 2000 Reporting Services lets you use parameters and expressions minimal programming to customize reports and give users the functionality they need.
By Rodney Landrum 

Fighting OS-Level Fragmentation

Fragmentation exists at both the SQL Server level and the file level within the OS. Here's how and when OS-level defragmentation can speed up your SQL Server.
By Brian Moran 

Page Life Expectancy a Reliable Indicator of SQL Server Memory Pressure

Have you ever checked out the page life expectancy counter in Performance Monitor's Buffer Manager object?
By Brian Moran 

Sending Query Analyzer Results to Excel

Here's how to copy a query's results column headings and values from Query Analyzer to Microsoft Excel.
By Brian Moran 

Store Integers as Decimal Data Type

Learn how to store integers that have 20 digits, or more, as numeric values.
By Brian Moran 

Is VB Dead?

The biggest base of Microsoft developers isn't made up of Web developers; it consists of the 8 million Visual Basic (VB) 6.0 developers who haven't migrated to Visual Studio .NET in the numbers Microsoft hoped for.
By Michael Otey 

Anatomy of a Performance Solution

Follow the solution to a real-world SQL Server performance problem from identification through investigation to a happy conclusion.
By Kalen Delaney 

Modernizing Memberships

Managing a nonprofit organization's rapidly changing membership database was a challenge for one DBA. Learn how she simplified her job by aligning her database design with members' real needs.
By Michelle A. Poolet 

Back Doors with a View

Itzik Ben-Gan concludes his series on T-SQL back doors by looking at hidden ways to work with views.
By Itzik Ben-Gan 

New Products, August 2004

Check out the latest SQL Server-related new and improved products.
By Dawn Cyr 

Bulk-Insert Options for ADO.NET

Looking for a fast way to bulk insert data to SQL Server from ADO.NET applications? Here are four high-performance methods you can use.
By Michael Otey 

Analyzing Object I/O Utilization

Your best best for gathering I/O information for analysis is to create a SQL Server Profiler trace.
By Microsoft's SQL Server Development Team 

Finding Login Counts and Creation Dates

Several example queries against syslogins and sysusers can give you the login and user information you need.
By Microsoft's SQL Server Development Team 

Specifying Appended Backups

By default, the restore process uses the first file in the backup set. If you want appended backups, you must explicitly specify them, as this example shows.
By Microsoft's SQL Server Development Team