SQL DBA Blog

Month: January 2019

SSMS Import Flat File Feature

January 24, 2019

The Import Flat File feature in SSMS (SQL Server Management Studio) was introduced in December 2017 (14.0.17213.0). This is a streamlined version of the Import Data feature and it minimizes the user intervention during a file import. Unlike the Import and Export Data Feature, you don’t have the…
Read More
Attaching SQL Databases Without Log Files

January 22, 2019

In a perfect world, you’d never lose a database log file. But when the unexpected happens and you urgently need the data from a database, knowing how to attach a SQL Server database without its log (.ldf) file can be a lifesaver. This guide walks you through the…
Read More
SQL Server Backup & Restore WITH FILE Option

January 20, 2019

When you back up a SQL Server database, multiple backups can be stored in a single file. The WITH FILE = X option allows you to choose a specific backup version from a single backup file. Here’s what happens: – WITH FILE = 1: Restores the first backup…
Read More
Applying Data Retention to a SQL Table

January 13, 2019

In SQL Server, there’s often a need to delete old data from a database table. This could be for reasons like adhering to GDPR policies, managing oversized tables that are slowing down operations, staying within SQL Server Express’s 10GB limit, or simply cleaning up application logs and errors.…
Read More

Categories

Tags