Blog Home Page - Page 497 of 829 - SQL Authority with Pinal Dave

Nov30

SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error: Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: …

Nov29

SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back

Pinal Dave

SQL Puzzle

Embarcadero, SQL Cartoon, SQL Humor, SQL Server

There are two excellent contests and we have lots of winning to do this year end. In this blog post we are going to have a cartoon contest again.

Nov28

SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video

Pinal Dave

SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio

Every developer once in a while facing an unfortunate situation where they have not yet saved the work and their SQL Server Management Studio crashes. Well, you can minimize the loss by optimizing auto recovery settings. In this video we can see how to set the auto recovery settings.

Nov27

SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

There is no doubt that SQL databases play an important role in modern applications. In an ideal world, a single database can handle hundreds of incoming connections from multiple clients and scale to accommodate the related transactions. However the world is not ideal and databases are often a cause of…

Nov26

SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Utility

Let me tell you about one of the most useful SQL tools that every DBA should use – it is SQLBackupAndFTP. I have been using this tool since 2009 – and it is the first program I install on a SQL server. Download a free version, 1 minute configuration and…

Nov25

SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server 2012

Yesterday we had very first SQL Bangalore User Group meeting and I was asked following question right after the session. This question is about to Find Weekend and Weekdays from Datetime in SQL Server 2012.

Nov24

SQL SERVER – Cursor, Log File and More – Memory Lane #004

Pinal Dave

SQL

Memory Lane, SQL Server

This is the 4th episode of memory lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite article this week is an article discussing cursor and log file. Let me know which one of the following is your favorite article from memory lane.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back

SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video

SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database

SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3

SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012

SQL SERVER – Cursor, Log File and More – Memory Lane #004

SQL SERVER – XEvents to Find Cardinality Estimation Issues

SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105

SQL SERVER – 2016 – Opening JSON with OPENJSON()

SQL SERVER – Resource Governor and Database Mapping

Interview Question of the Week #048 – How to Move TempDB to Another Drive?

SQL SERVER – Easy Way to Import and Export SQL Server Data

SQL SERVER – Free Database Search and Dependency Analysis