SQL Server Magazine August 2004
[Focus]
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
[Features]
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
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
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
[SQL Server Savvy]
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
Have you ever checked out the page life expectancy counter in Performance Monitor's Buffer Manager object?
By Brian Moran
Here's how to copy a query's results column headings and values from Query Analyzer to Microsoft Excel.
By Brian Moran
Learn how to store integers that have 20 digits, or more, as numeric values.
By Brian Moran
[Editorial]
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
[Inside SQL Server]
Follow the solution to a real-world SQL Server performance problem from identification through investigation to a happy conclusion.
By Kalen Delaney
[Solutions by Design]
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
[T-SQL Black Belt]
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]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
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
[Ask Microsoft]
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
Several example queries against syslogins and sysusers can give you the login and user information you need.
By Microsoft's SQL Server Development Team
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
|
