It is often useful to see what database queries were made during a specific request in Orchard. Bertrand takes us through this in a brief informative post

Save tonnes of time by providing a consolidated script to you client to update the database

Great resources for learning all about Windows Azure.

Working as developer or DBA, we often required to take the backup of database. This is not a big deal if you have a handful of databases, but this task become very hectic if the there is number of databases (ex. 50+) on the same instance of SQL Server.

Administrating the Server resources such as memory, processes and storage and low level resources such as locks, latches and queues are crucial as these are consumed by transactions. This post outlines some tips on managing server level and database level resources and also explains monitoring user ...

Plan Guide is a very nice feature in SQL Server that allows you to apply hints to your queries without having to change the query type or text in the application. Plan Guides influence query optimization by using the query hints. This post shows you how to create a Plan Guide and apply to a query in...

This post outlines various options and tools for performing performance tuning on SQL Server. Performance tuning is ongoing, iterative process and it never stops. Typical performance tuning methodologies a

Solutions to sqlzoo.net More Join Operation Questions

I've been working with some simple spatial data lately. In one use-case, the user marks a polygon by using an iPad or iPhone in field and walks around storing points (coordinates), which after at least three points, forms an area (the first coordinates are also used as the last to close it). I’m usi...

Over time, the indexes applied to tables in a SQL Server database can become fragmented because of row insertions, updates and deletions. This fragmentation can severely impact the performance of the database so should be rectified periodically.

It is a common task to obtain the last inserted identity value for a SQL Server table for the current connection, with @@IDENTITY, or for the current scope, with SCOPE_IDENTITY. However, it is also possible to find the latest identity inserted by any session.

Ever losing a query because of system restart?

This is not a trial version, but the Entire EntitySpaces Studio and Profiler which we have made 100% Free. The Download.com link says 45 day Trial but that is wrong and will be corrected tomorrow, it's 100% free and under the BSD license.

Hers's some T-SQL for truncating all logs on a Microsoft SQL Server: