October 2010 - Page 2 of 5 - SQL Authority with Pinal Dave

SQL SERVER – Corrupted Backup File and Unsuccessful Restore

October 24, 2010

SQL Backup and Restore, SQL Error Messages

If you are an SQL Server Consultant, there is never a single dull moment in your life. Quite often you are called in for fixing something, but then you always end up fixing something else! I was recently working on an offshore project where I was called in to tune…

SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup

October 23, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

I recently had a very interesting experience. In one of my recent consultancy works, I was told by our client that they are going to take the backup of the database and will also a copy of it at the same time. I expressed that it was surely possible if…

SQLAuthority News – SQLAuthority News – Presenting at South East Asia SharePoint Conference – Demo Details

October 22, 2010

Pinal Dave

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

SQLAuthority Author Visit

I will be Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site. I am very excited beuse this is going to be my very first series of presentations at SharePoint Conference. Since I posted details about the event, I have…

SQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners

October 21, 2010

Pinal Dave

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

SQLAuthority Book Review

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners Rick A Morelan, Doug Fritz Link to Amazon Short Review: This is one book that provides a solid fundamental to the reader along with hands-on experience and in-depth learning. Right now, an error-free book that is closer to real…

SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it

October 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I was recently getting following error in my StreamInsight Application. Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it. The solution was very simple, I had to enable exception of the my port in my windows firewall. The way…

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

October 19, 2010

Pinal Dave

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

MVP, SQL Training, SQLAuthority Author Visit

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we…

SQL SERVER – Change Column DataTypes

October 18, 2010

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Scripts, SQL Server

There are times when I feel like writing that I am a day older in SQL Server. In fact, there are many who are looking for a solution that is simple enough. Have you ever searched online for something very simple. I often do and enjoy doing things which are straight forward and easy for change.
In this blog post, we will see to Change Column DataTypes