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

SQLAuthority News – Restart Remote Computer – Shutdown Remote Computer

May 14, 2011

I often work with multiple computer system. This machines are different machines. When I login using remote desktop to different machine, I often want to restart or shutdown the computer. Remote desktop does not let me shutdown computer when I have remote system as Windows 7. At this time, I…

SQL SERVER – Vote for My Session in SQL PASS

May 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Please Vote for My Session in SQL PASS SQL Server Waits and Queues – Your Gateway to Performance Troubleshooting Session Level: 300 Session Category: Regular Session (75 minutes) Session Track: Enterprise Database Administration and Deployment Just like a horoscope, SQL Server Waits and Queues can reveal your past, explain your…

SQL SERVER – expressor 3.2 Release Review

May 11, 2011

Pinal Dave

SQL

expressor, SQL Scripts, SQL Server, SQL Utility

I have been following expressor software for some time now and they have recently released a new version of their expressor Studio desktop ETL application. I am pleased to find out that the download and installation experience of this application has been greatly simplified. expressor Studio no longer requires users to install a license key after they download and install the product. They have also eliminated a Microsoft Visio dependency from their product. Removing the license requirement and Visio dependency has made download and installation much easier.

SQL SERVER – Resource Database ID – 32767

May 10, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

Earlier I blogged about SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?. After reading the post, I got question by one of the blog reader. “Hi Pinal, I see in your blog post you have Database ID which is 32767. Everytime I want to get the…

SQL SERVER – Common Table Expression (CTE) and Few Observation

May 10, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This blog post is written in response to the T-SQL Tuesday hosted by Bob Pusateri. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…

SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007

May 9, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…

SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?

May 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently I was talking with Vinod Kumar regarding NOLOCK. Suddenly he asked me do I know what kind of lock WITH(NOLOCK) hint takes on object. The immediate response of mine was that NOLOCK does not take any lock. He responded suggesting that I should think more and answer. I realized…