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 MoreSQL SERVER – What is SQL Azure
A very common question which I often receive is What is SQL Azure?
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
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.