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
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…
Read MoreSQL SERVER – Common Table Expression (CTE) and Few Observation
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…
Read MoreSQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007
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…
Read MoreSQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?
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…
Read MoreSQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
Quite often I get the request regarding how to copy all the objects – including schema and data from any database and re-create it on another instance. SQL Server 2008 and SQL Server 2008 R2 has script generator wizard which does it for us. I ask you to pay special…
Read MoreSQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
Yesterday I presented on the subject Check SQL Server Health using Best Practices Analyzer. There was great response to the session. Many asked me if the session is recorded so they can watch it later on. Absolutely, the session is recorded and you can watch it at your convince. Not…
Read MoreSQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
Today (May 5, 2011) I will be presenting on Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer at . I will be presenting on following subjects. The tools which I will be using in the demonstration are following: Engine – Backups outdated for databases Engine – Database files and…
Read MoreSQL SERVER – Cartoon Challenge – 140 Character Winner is Here
Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…
Read More
SQL SERVER – Interview on Wait Types and Wait Queues – SQL Doctor
Earlier this year I have written a whole month on the subject SQL Server Wait Types and Wait Queues SQL SERVER – Summary of Month – Wait Type – Day 28 of 28. The focus of this series was very simple – define a problem and solve it. I learned a lot while I wrote this series. While I am writing this blog, I am very much delighted that SQL Doctor team of Idera software is very kind to implement a few of the tricks from the blog post.