SQL Server Archives - Page 220 of 393 - SQL Authority with Pinal Dave

SQLAuthority News – Database Performance for SharePoint Sites – Session Tomorrow in Singapore

October 26, 2010

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

I am all excited to present my very first session on Database Performance for SharePoint Sites. Here is the details for my session which is planned for tomorrow. Grand Copthorne Waterfront Hotel Singapore 392 Havelock Road Singapore 169663 My Sessions details: Maintaining SQL Server at Optimal Performance for Blazing Fast…

SQL SERVER – A Brief Introduction to DW 2.0

October 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Warehousing, Database

The traditional form of storing digital data has been disk storage. However, the huge advances in technology means that there has been a huge need for data storage to evolve to keep up with the fast-changing times. Microsoft SQL Server has gone through a huge overhaul in order to keep…

SQL SERVER – Corrupted Backup File and Unsuccessful Restore

October 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…