SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.
SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON
I was recently watching a videos online of TechEd 2011 USA (link) and I learned that SET FMTONLY ON is going to be replaced with enhanced DMVs in future versions of SQL Server. I really liked the new direction of the product. However, SET FMTONLY ON is really have done…
Read MoreSQLAuthority News – Most Valuable Photographer – Vijay Raj
A good snapshot stops a moment from running away. ~Eudora Welty If I could tell the story in words, I wouldn’t need to lug around a camera. ~Lewis Hine Vijay Raj is a passionate Technology Evangelist and a Microsoft MVP. He recently took few snaps of my daughter. As soon…
Read More
SQL SERVER – Running SSIS Package in Scheduled Job
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 More
SQL SERVER – Management Studio and Browser in Same Application – SSMS Browser
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 information on the subject I am working on. Let us understand about SSMS Browser in this blog post.