SQL DBA Blog

Author: Peter Whyte

  • “Content from the website listed below is being blocked” on Windows Server

    When managing a Windows Server, you may encounter the message:“Content from the website listed below is being blocked by the Internet Explorer Enhanced Security Configuration.” This occurs because Internet Explorer Enhanced Security Configuration (IE ESC) is enabled by default on Windows Server to protect against malicious websites and…

    Read More

  • Creating a Linked Server for a PostgreSQL Database

    This is a post on how to create a Linked Server to a PostgreSQL database. In my previous post, I created a Linked Server to another SQL Server instance. This time, it’s a link to a Postgres database. I recommend checking out my other post for pre-requisite information…

    Read More

  • Creating a Linked Server to SQL Server

    Linked Servers in SQL Server allow you to query external databases, such as remote SQL Server instances, Oracle, ODBC or MS Access databases. It provides easy query access to another database server for users, however it’s not the most efficient ways to do it. The following steps should…

    Read More

  • Database Growth Events in SQL Server

    When a database file reaches its maximum allocated size, a growth event is triggered to expand the file and allow for more data storage. The size of these growth events can be configured in the database options or by using the ALTER DATABASE statement, as demonstrated below. Properly…

    Read More

  • Setting Maximum Database File Sizes in SQL Server

    This post shares how to set maximum database file sizes in SQL Server, capping your database file size limits for proper disk space management. Configuring maximum database file sizes in SQL Server is often considered a safeguard or tactical measure rather than a primary strategy. Ideally, you want…

    Read More

  • Updating Help Documentation in PowerShell

    Keeping your PowerShell help documentation up to date ensures you always have the latest guidance and reference materials for installed modules. The Update-Help cmdlet allows you to download and install the most recent help files, but you may encounter an access denied error if PowerShell is not run…

    Read More

  • How to Move Temp DB Files in SQL Server

    It’s a solid best practice to store temp db files on a separate drive, away from your C: drive. This is because temp db can grow very large, very quickly, sometimes within minutes depending on workloads. This growth affects both the temp db data (.ndf) and log (.ldf)…

    Read More

  • The SSMS Import Flat File Feature

    The Import Flat File feature within SQL Server Management Studio (SSMS) was introduced in December 2017 (14.0.17213.0). This is a streamlined version of the Import Data feature and it minimises the user intervention during a file import. Unlike the Import data feature, you don’t have the option to…

    Read More

  • Attaching SQL Databases Without Log Files

    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

    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

Recent Posts

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags

Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (74) Database Backups & Recovery (13) Database Mirroring (2) Deleting Data (1) Error Messages (4) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (2) SQL Server Processes (5) SQL Server Replication (2) SQL Server Scripts (13) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (19)