Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database
I’m pleased to inform you all that I’ve recently launched my personal website. It’s been a long time since I’ve been writing on my blog https://blog.sqlauthority.com, but I’ve been keeping my personal notes at my homepage http://www.pinaldave.com. I’ve completely rehauled the website to give it the much-needed makeover, right from…
Read More

SQL SERVER – Introduction to JOINs – Basic of JOINs

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Joins, SQL Scripts, SQL User Group
The launch of Gandhinagar SQL Server User Group was a tremendous, astonishing success! It was overwhelming to see a large gathering of enthusiasts looking up to me (I was the Key Speaker) eager to enhance their knowledge and participate in some brainstorming discussions. Some members of User Group had requested…
Read More

SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Utility
A couple of days back I  had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software  I tried to install SQL Server 2005 .  However, it instantly displayed the following error message. The SQL Server System Configuration Checker cannot be executed due to…
Read More

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table, SQL Transactions
This post is about a riveting observation I made a few days back. While playing with transactions I came across two DMVs  that are associated with Transactions. 1) sys.dm_tran_active_transactions – Returns information about transactions for the instance of SQL Server. 2) sys.dm_tran_current_transaction – Returns a single row that displays the…
Read More

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages
This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from   people who are frequenting using forums or have blog related to storage and…
Read More