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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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?
- 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.
- 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.
- 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.
- 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.