SQL Archives - Page 406 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Microsoft Certification Exam – Discount Code

April 16, 2009

Database, Microsoft Certifications, MVP, SQL Server

Note: I am republishing this blog post as the offer of this code is extended to April 30, 2009. Please note down this important code or share with your colleagues who are keen to take Microsoft Certification Exam. This unique code is only available through Microsoft MVP’s and only published…

SQL SERVER – Poll Result – What is Your Favorite Database?

April 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Poll

I previously posted a Poll about What is Your Favorite Database? I got great response from users. In fact, I received some of the best poll-related comments on this blog and they are worth reading. Let us check the result first. Here are the votes I received on different database.…

SQL SERVER – Introduction to JOINs – Basic of JOINs

April 13, 2009

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…

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

April 12, 2009

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…

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

April 11, 2009

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…

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

April 10, 2009

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…

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

April 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download, SQL Utility

Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability…