— 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 »
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 »
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 »
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 »