Starting with SQL Server 2005, Microsoft SQL Server has a default trace. I think many of you have already heard about it, but I wonder if all of you are aware of the potential of the default trace. In case you are not aware of it, I found a great article by Feodor Georgiev, that explains what is the default trace, Feodor explains which events are logged in the default trace and gives examples on how to retrieve information from the default trace. At the end of the article Feodor provides a link to the documentation of his default trace reports, from that link you will be able to download a MSI file that you can install on you workstation. I downloaded the MSI an tried the reports on SQL Server 2012. In the documentation you will find instructions on how to access the reports. You can find the article here.
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways. I hope you enjoy my blog and if you want to send a question, just drop me a mail at email@example.com or firstname.lastname@example.org View all posts by isalom