Developer hearted / Relational minded

  In some cases it it interesting to know whether a database was directly created on the current version of the running SQL Server instance or if the database was upgraded during an upgrade of the instance or by attaching a database from an older...

  In some cases you might face the problem that SQL Server Agent Service didn't come up or was stopped for reason. Jobs scheduled in the downtime will not run automatically when the Agent service comes up again, and that is a good thing. I often...

  A common question is how to move back to the older version of the database once upgraded. The answer is, you can´t . By attaching the database to the new SQL Server version an upgrade is done internally which can be seen if you run the attach commands...

Some time ago I did a blog entry for SQL Server Integration Services packages as a data source for SQL Server Reporting Services reports. You can find this article here. This feature relies on a data processing extension that is explained in detail here...

Some time ago I got an interesting questions why the following applies: -- drop table a create table a(m varchar ( max ), i int ) go declare @cnt int --Explicit transaction begin tran set @cnt=@@trancount insert into a select 'inside...

  (The project is attached to this blog post, if you have any questions, feel free to send me a mail. You find the bits for download here .) The most recent version can be found here For all of you who haven´t been able to read my blog entry on logging...