SQL Event tracing (DeadLocks)

— SCRIPT TO LOG DEADLOCK GRAPHS USING SERVER SIDE TRACE— It is configured to run the rest of the day after it is started and is limited to max 2*10MB log files— Make sure the SQL user account have write access to the trace log output folder— The output .trc files can be viewed as… Read More »

SQL Query Multiple Databases (Microsoft SQL Server)

DECLARE @Database VARCHAR(255) DECLARE @stmt nvarchar(1000) DECLARE @params NVARCHAR(500) DECLARE @resTable TABLE (dbName VARCHAR(255), resCountFound INT) DECLARE @resFound INT DECLARE DatabaseCursor CURSOR FOR SELECT name FROM master.sys.databases WHERE state_desc=’ONLINE’ and name NOT IN (‘master’,’model’,’msdb’,’tempdb’,’distribution’,’ReportServerTempDB’,’ReportServer$SQL2008R2′,’ReportServer$SQL2008R2TempDB’) ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @Database WHILE @@FETCH_STATUS = 0 BEGIN SET @stmt=N’select @resFoundOUT=Count(*) from [‘+@Database+’].dbo.MyTable… Read More »

Basic Linux Commands Summary

This is just a simple list of some useful linux commands and tools, use the “man” command to get detailed manual for each command and its arguments. Currently i’m not working with linux every day and tends to forget these from time to time, so i started listing some commands here. User Management #add standard… Read More »

Writing a small custom PHP framework

There already exists several open source PHP frameworks, but they can often be a bit comprehensive to learn. Instead I have started writing a small framework in PHP myself. I is build on basic principles like OO (Object oriented) code for encapsulation, MVC (Model View Controller) for reusablity and structured code, ORM (Object-Relational Mapping) for… Read More »

A look inside an IPCAM

My mother had decided to buy an outdoor IPCAM and I had to help configure it. Unfortunately it seems to have som bugs. So lets have a look inside and see if they can be fixed. The cam itself does work, but is not very useful if you have to sit and monitor it yourself.… Read More »

Introduction to mobile networks

The mobile network (2G(GSM)/UMTS/3G/LTE/4G) is a technology we use every day and we don’t really have to know how it works. However as an IT-developer it would be interesting to get an understanding of the underlying network and protocols. The standards have been public for a long time so it should not be impossible to get a theoretical knowledge. However… Read More »

New webpage up and running!

Welcome to conner.dk Hopefully I’ll take my time to keep this site updated with some of the projects that I’m working on in my spare time.