Top 10 SQL Server tips of 2009

Before you say goodbye to 2009, take a look at the top-rated SQL Server tips of the year, with pointers on using functions like OPENROWSET and FILESTREAM, information on password cracking tools, and advice on a few DBA tasks that are wasting your time.

  1. Importing and exporting bulk data with SQL Server's bcp utility
    By Robert Sheldon, Published 02.18.2009
    The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
  2. Using the OPENROWSET function in SQL Server
    By Robert Sheldon, Published 04.16.2009
    OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.
  3. Password cracking tools for SQL Server
    By Kevin Beaver, Published 12.03.2009
    When performing SQL Server penetration tests and security audits, there is one probe you must not miss: password cracking. Check out which tools – some free – to use.
  4. Processing XML files with SQL Server functions
    By Denny Cherry , Published 02.16.2009
    Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.
  5. Determining the source of full transaction logs in SQL Server
    By Matthew Schroeder , Published 05.27.2009
    Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
  6. Top 5 DBA tasks that are a waste of time (and might be hurting your SQL Server)
    By Denny Cherry , Published 12.09.2009
    While some DBA tasks are less important than most, others can be completely pointless. Could you be wasting valuable time without even knowing it?
  7. Using dynamic management views to improve SQL Server index effectiveness
    By Baya Dewald, Published 02.02.2009
    Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.
  8. Examining data files when SQL Server tempdb is full
    By Matthew Schroeder , Published 03.16.2009
    If your SQL Server tempdb database is full, the data files could be the cause. Find out how to use the SQL Server process ID number and T-SQL queries to find the source.
  9. The short course on how SQL Server really works
    By Don Jones , Published 06.10.2009
    Have you been thrust into the DBA role simply because there's no one else to do it? No worries. Here you'll learn the basics of how data moves from disk to memory in SQL Server.
  10. Implementing SQL Server 2008 FILESTREAM functionality
    By Robert Sheldon, Published 05.25.2009
    Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.

There is plenty more where this came from! Check out all of our expert tips and articles from 2009.

This was first published in December 2009

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: