Feeds:
Posts
Comments

Archive for May, 2011

SQL SERVER – Running SSIS Package From Command Line

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 21, 2011 | 4 Comments »

I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. This is really interesting question and very easy one as well. You can execute SSIS Package using command line utility. C:\>dtexec.exe /F “C:\ImportCSV\Package.dtsx” [...]

Read Full Post »

SQL SERVER – Management Studio and Browser in Same Application

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, SQL Utility, SQLServer, T SQL, Technology on May 20, 2011 | 9 Comments »

First of all – I must confess that I was not aware of this feature till I noticed it today. At home I have multiple monitors but when I am traveling I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for [...]

Read Full Post »

SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged on May 19, 2011 | 3 Comments »

Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had: DJ: Pinal, your SQL Server does not like me. Pinal: Possible, no one likes you! DJ: I am serious… Pinal: I am too… DJ: No really – be serious. Pinal: Well, you started it, [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 18, 2011 | 10 Comments »

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 : The request failed or [...]

Read Full Post »

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

Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 17, 2011 | 1 Comment »

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 active on twitter as well [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers