SQL Tips and Tricks Archives - Page 288 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go

December 10, 2011

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

SQLSaturday 116 is now only 4 weeks away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. Schedule and Venue Event Date: January 7, 2012 Event Time: 10 AM to 6 PM Event Venue: Microsoft Singature Building, Domlur, Bangalore , Bangalore, India Important Links: Register for…

SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid

December 10, 2011

Pinal Dave

SQL Tips and Tricks

File format, SQL Error Messages, SQL Server

I recently had long email conversation with one of the blog reader who was struggling with installing SQL Server 2012 RC0 installation. I just thought I will publish what we have done and how we solved problem so if you are facing the same issue, you can avoid the same. In this blog post we will see how to fix setup error.

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

December 9, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Madhivanan is SQL Server MVP and very talented SQL expert. Here is one of the nugget he shared on Just Learned. He shared a tip where there were two interesting point to learn. Do not use keywords as an object name [read DHall’s excellent comment below] He has given excellent…

SQL SERVER – Error: Deleting Offline Database and Creating the Same Name

December 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Server Management Studio

Offline database is very interesting subject, and there are a couple of interesting details associated with it, which one must know. There are two common queries related to offline database: 1) My hard drive is getting full and I deleted my ‘offline’ databases. After deleting my offline databases, my hard…

SQL SERVER – Plenty of SQL Community Updates

December 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Every day we learn something new and we come across something which we like to read. I had decided to keep a log of things what I do during whole day. Here are few updates which I think you will find it interesting. This updates are in no specific order.…

SQLAuthority News – SQL Server Interview Questions and Answers Available on Kindle Format as eBook to Download

December 6, 2011

Pinal Dave

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

Reading the books on Kindle seems to be very popular. Since our new book released a month ago, we have received so many request from users regarding making it available on Kindle. Well, today we have acknowledge the request. Our new book is available to purchase on kindle. SQL Server…

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012

December 5, 2011

Pinal Dave

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

Database, SQL Saturday

This is the biggest news for SQL Enthusiast in India. SQL Saturday is here in India. PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. We…