Installing SQL Server 2008 R2

In this article we are going to discuss about installing SQL Server 2008 R2, I know Im little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check this KB article for the same.

Recent Objects – Without Triggers

I was thinking about writing a script to capture the objects that were either CREATED/DELETED or MODIFIED in the last 24hrs. Instead of directly querying the sys.objects I from where I can only get minimal information I decided to get a whole bunch of useful information using the SQL Server default trace. By default the… Continue reading Recent Objects – Without Triggers