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. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.
SQL SERVER – Download PowerPivot Security Architecture Diagram
Security Architecture Diagram is very interesting and very important aspect of the database. I am currently attending the MVP Open Day event and one of the attendee asked if I can write about PowerPivot Security Architecture. This subject is very well explained earlier using diagram by Microsoft. Microsoft has published…
Read MoreSQL SERVER – Running SSIS Package From Command Line
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…
Read MoreSQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
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…
Read MoreSQLAuthority News – Facebook Page and Twitter – Connect Using Social Media
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…
Read More
SQL SERVER – SQL Server Compression Estimator
I recently come across an interesting tool called ‘SQL Server Compression Estimator’. I find this tool very interesting. This tool is a pretty decent tool and I used it on a couple of my personal server and it gave me a good estimate.
SQL SERVER – Attending MVP Open Day – May 2011
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 –…
Read More