Data Engineering – Learn from the experts
-
May 2010 UG Scheduled
We are ready for May month session. Please go-ahead and register for the same. Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai Landmark: Opposite to President hotel Timings: 10:00 AM to 01:00 PMDate: 29th May 2010
-
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…
-
Attach all user databases
I was doing an upgrade of one of our development servers to SQL Server 2008. To minimize the downtime I decided to attach all the user databases using script. Basically, I am attaching the db from the same location there were present earlier to being detached. Consider the following example, If I have a database…
-
April 2010 UG Presentation Material
We have conducted our UG this month on 17th Apr 2010 and it went fine. You can download the presentation materials and scripts used during the presentation to play with it. Incase if you need any clarification you are welcome to contact the presenter.
-
All about Bulk Logged
This document is relevant to bulk operations on SQL Server. The bulk-logged recovery model is a special-purpose model that works in a similar manner to the full recovery model. The only difference is in the way it handles bulk data modification operations. The bulk-logged model records these operations in the transaction log using a technical…
Got any recommendations?