All Articles - SQL Authority with Pinal Dave

SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP

April 2, 2009

Database, SQL Backup and Restore, SQL Data Storage, SQL Utility

It goes without saying that Database Backup is the most important task for any Database Administrator (DBA). Naturally, large organizations always have a team of DBAs who execute Database Backup tasks. No matter how big or small an organization is, the importance of database backup remains the same across the…

SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

April 1, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table

Some time ago I was helping one of my Junior Developers who presented me with an interesting situation. He had a table with Identity Column. Because of some reasons he was compelled to delete few rows from the table. On inserting new rows in the table he noticed that the…

SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense

March 31, 2009

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server, SQL Server Management Studio, SQL Utility, SSMS

While I was working with SQL Server 2008 IntelliSense, I realized that it was not functioning as I expected. Even after I had enabled IntelliSense it was still not opening any suggestions at all. After a while, I figured out some vital information regarding how to make sure IntelliSense smoothly works all the time without you giving any trouble. Let us learn how we can Enable IntelliSense.

SQLAuthority News – Top 10 Strategic Technologies for 2009

March 30, 2009

Pinal Dave

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

Best Practices, Software Development, SQL Download

Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt. The top…

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

March 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL TempDB

Recently, one of my regular blog readers emailed me with a question concerning the following error: Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. This reader has been encountering the above-mentioned error, and he is curious to know the reason…

SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download

March 28, 2009

Pinal Dave

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

Database, DBA, SQL Download

SQL Server 2008 new brochure is available for download. Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to: Run your most demanding mission-critical applications. Reduce time and cost of development and management of applications. Deliver actionable insight to your entire organization. Your Data,…

SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today

March 27, 2009

Pinal Dave

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

Database, DBA, MVP, Poll, SQL User Group

I have published a poll on website few days ago for favorite database of SQLAuthority.com readers. The best comment will win USB drive. The poll will close on April 1, 2009. Looking at the poll result, it seems that Oracle has gained a lot over SQL Server from last time…

SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009

March 27, 2009

Pinal Dave

Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP, MVP Summit 2009

Microsoft MVP Award Blog and Microsoft South Asian MVP Blog has published my video interview online. My interview was conducted by Abhishek Kant – Microsoft MVP Lead and Technology Blogger. I am thankful to Abhishek Kant for conducting my interview, Abhishek Baxi for publishing on South Asian Blog and Jas…

SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.

March 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Advanced Option, SQL Error Messages, SQL Scripts

I received another email describing error received due to my executing script from my previous article . Error : Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option ‘optimize for ad hoc workloads’ does not exist, or it may be an advanced option. Let us quickly…

SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master

March 26, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Activity Monitor, SQL Error Messages, , SQL Scripts

I have received comment from Radha Goswami on my previous blog article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users. Radha is facing following error when she is tring to grant permission to login. Error: Msg 4621, Level 16, State 10, Line…