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

SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)

May 18, 2011

Just another day I received following error while starting my agent. As soon as I received following error I felt like Deja Vu. I had similar feeling few days ago. I quickly looked at my blog post history and I found out following article SQL SERVER – Fix : Error…

SQLAuthority News – Facebook Page and Twitter – Connect Using Social Media

May 17, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I often get question if I am active on social media. I am very much active on social media. I have noticed that we have all are active on Facebook, I have created Facebook page where you can do discussion and follow on my updates. SQLAuthority.com Page I am very…

SQL SERVER – Attending MVP Open Day – May 2011

May 15, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP

The MVP Open Day is an exclusive event for Asia Pacific & Greater China MVPs. MVPs from the region gather and have great time together. It is mix of education, fun and networking. I have previously written my experience over here. SQLAuthority News – MVP Open Day South Asia –…

SQLAuthority News – Restart Remote Computer – Shutdown Remote Computer

May 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

I often work with multiple computer system. This machines are different machines. When I login using remote desktop to different machine, I often want to restart or shutdown the computer. Remote desktop does not let me shutdown computer when I have remote system as Windows 7. At this time, I…

SQL SERVER – Vote for My Session in SQL PASS

May 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Please Vote for My Session in SQL PASS SQL Server Waits and Queues – Your Gateway to Performance Troubleshooting Session Level: 300 Session Category: Regular Session (75 minutes) Session Track: Enterprise Database Administration and Deployment Just like a horoscope, SQL Server Waits and Queues can reveal your past, explain your…

SQL SERVER – Import CSV File into Database Table Using SSIS

May 12, 2011

Pinal Dave

SQL Tips and Tricks

CSV, SQL Scripts, SQL Server, SSIS

It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server.

SQL SERVER – Resource Database ID – 32767

May 10, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

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…