Category Archives: Cellular

Cellular hardware and software

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 »

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 »