Once you disconnect a database, you must restore it from its .MDF file in a process called "attachment." SQL Server offers two ways to attach the .MDF file: via the Management Studio program's ...

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

Small Business | Accounting & Bookkeeping | Excel. How to Use SQL Statements in MS Excel. ... a SQL Server database or even a large text file, you can also retrieve data from it using Excel.