SQL SUSPECT RECOVERY

EXEC SP_RESETSTATUS 'DBNAME'; ALTER DATABASE DBNAME SET EMERGENCY DBCC CHECKDB('DBNAME') ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CHECKDB ('DBNAME', REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE DBNAME SET MULTI_USER

rebuild all index sql

DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 DECLARE DatabaseCursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','msdb','tempdb','model','distribution') ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @Database WHILE @@FETCH_STATUS = 0 BEGIN SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + table_name + '']'' as tableName FROM [' + @Database + '].INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE''' -- create table cursor EXEC (@cmd) OPEN TableCursor FETCH NEXT FROM TableCursor INTO @Table WHILE @@FETCH_STATUS = 0 BEGIN IF (@@MICROSOFTVERSION / POWER(2, 24) >= 9) BEGIN -- SQL 2005 or higher command SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' EXEC (@cmd) END ELSE BEGIN -- SQL 2000 command DBCC DBREINDEX(@Table,' ',@fillfactor) END FETCH NEXT FROM TableCursor INTO @Table END CLOSE TableCursor DEALLOCATE TableCursor FETCH NEXT FROM DatabaseCursor INTO @Database END CLOSE DatabaseCursor DEALLOCATE DatabaseCursor

C#.NET Isnumeric Fonksiyonu

public static bool IsNumeric(object Expression) { bool isNum; double retNum; isNum = Double.TryParse(Convert.ToString(Expression), System.Globalization.NumberStyles.Any, System.Globalization.NumberFormatInfo.InvariantInfo, out retNum); return isNum; }

SQL LOG DOSYASI TRUNCATE ETME

ALTER DATABASE MikroDB_V14_MERKEZ SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(MikroDB_V14_MERKEZ_log, 1) ALTER DATABASE MikroDB_V14_MERKEZ SET RECOVERY FULL WITH NO_WAIT GO

terminal server 2008 güvenlik ayarı

1. Remote Desktop Lisans Yöneticisine gelin 2. Lisans sunucu adına sağ tıklayıp Özellikler'e gelin. 3. Bağlantı methodunu 'Web Browser' olarak değiştirin. 4. Lisans sunucusuna geri dönüp sunucuya sağ tıklayarak Gelişmiş -> Yeniden etkinleştir (Reactivate) seçin. 5. Server'ı web browser üzerinden yeniden etkinleştirin. 6. Aşağıdaki anahtarları Remote Desktop sunucu üzerinde Regeditten yedek alarak silin. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\RCM değerini altında aşağıdaki anahtarlar: Certificate X509 Certificate X509 Certificate ID X509 Certificate2 7. Sunucuyu yeniden başlatın.

LOGO ÇEK VİEW

SELECT TOP (100) PERCENT LG_003_CLCARD_2.CODE AS KİMDEN, C.DOC AS [çek 1 senet 2], C.BANKNAME AS BANKA, SUBSTRING(C.BNBRANCHNO, 6, 12) AS ŞUBE, C.NEWSERINO AS [Seri No], SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),7,4)+SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),4,2)+SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),1,2) AS vadesi, C.AMOUNT AS Tutar, CASE CURRSTAT WHEN 1 THEN 'Portföyde' WHEN 2 THEN 'Ciro Edildi' WHEN 3 THEN 'Teminata Verildi' WHEN 4 THEN 'Tahsile Verildi' WHEN 5 THEN 'Protestolu Tahsile Verildi' WHEN 6 THEN 'İade Edildi' WHEN 7 THEN 'Protesto Edildi' WHEN 8 THEN 'Tahsil Edildi' WHEN 9 THEN 'Kendi Çekimiz' WHEN 10 THEN 'Borç Senedimiz' WHEN 11 THEN 'Karşılığı Yok' WHEN 12 THEN 'Tahsil Edilemiyor' ELSE 'Ne Oldugu Belirsiz' END AS DURUMU, C.OWING AS [CİRO EDEN], C.DUEDATE AS Vade, LG_003_01_CSROLL.ROLLNO, (SELECT DEFINITION_ FROM LG_003_CLCARD AS LG_003_CLCARD_1 WHERE (LOGICALREF IN (SELECT CARDREF FROM LG_003_01_CSTRANS AS LG_003_01_CSTRANS_1 WHERE (CSREF = C.LOGICALREF) AND (TRCODE = 3)))) AS [CİRO EDİLEN], LG_003_01_CSTRANS_2.CARDREF, LG_003_BANKACC.CODE BANKA FROM LG_003_01_CSCARD AS C INNER JOIN dbo.LG_003_CLCARD AS LG_003_CLCARD_2 INNER JOIN dbo.LG_003_01_CSROLL ON LG_003_CLCARD_2.LOGICALREF = dbo.LG_003_01_CSROLL.CARDREF INNER JOIN dbo.LG_003_01_CSTRANS AS LG_003_01_CSTRANS_2 ON dbo.LG_003_01_CSROLL.LOGICALREF = LG_003_01_CSTRANS_2.ROLLREF ON C.LOGICALREF = LG_003_01_CSTRANS_2.CSREF INNER JOIN LG_003_BANKACC ON LG_003_BANKACC.LOGICALREF = LG_003_01_CSTRANS_2.CARDREF WHERE (dbo.LG_003_01_CSROLL.TRCODE IN (05,06,07,08)) AND CURRSTAT=4 UNION ALL SELECT TOP (100) PERCENT LG_003_CLCARD_2.CODE AS KİMDEN, C.DOC AS [çek 1 senet 2], C.BANKNAME AS BANKA, SUBSTRING(C.BNBRANCHNO, 6, 12) AS ŞUBE, C.NEWSERINO AS [Seri No], SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),7,4)+SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),4,2)+SUBSTRING(CONVERT(varchar(10),C.DUEDATE, 103),1,2) AS vadesi, C.AMOUNT AS Tutar, CASE CURRSTAT WHEN 1 THEN 'Portföyde' WHEN 2 THEN 'Ciro Edildi' WHEN 3 THEN 'Teminata Verildi' WHEN 4 THEN 'Tahsile Verildi' WHEN 5 THEN 'Protestolu Tahsile Verildi' WHEN 6 THEN 'İade Edildi' WHEN 7 THEN 'Protesto Edildi' WHEN 8 THEN 'Tahsil Edildi' WHEN 9 THEN 'Kendi Çekimiz' WHEN 10 THEN 'Borç Senedimiz' WHEN 11 THEN 'Karşılığı Yok' WHEN 12 THEN 'Tahsil Edilemiyor' ELSE 'Ne Oldugu Belirsiz' END AS DURUMU, C.OWING AS [CİRO EDEN], C.DUEDATE AS Vade, LG_003_01_CSROLL.ROLLNO, (SELECT DEFINITION_ FROM LG_003_CLCARD AS LG_003_CLCARD_1 WHERE (LOGICALREF IN (SELECT CARDREF FROM LG_003_01_CSTRANS AS LG_003_01_CSTRANS_1 WHERE (CSREF = C.LOGICALREF) AND (TRCODE = 3)))) AS [CİRO EDİLEN], '','' FROM LG_003_01_CSCARD AS C INNER JOIN dbo.LG_003_CLCARD AS LG_003_CLCARD_2 INNER JOIN dbo.LG_003_01_CSROLL ON LG_003_CLCARD_2.LOGICALREF = dbo.LG_003_01_CSROLL.CARDREF INNER JOIN dbo.LG_003_01_CSTRANS AS LG_003_01_CSTRANS_2 ON dbo.LG_003_01_CSROLL.LOGICALREF = LG_003_01_CSTRANS_2.ROLLREF ON C.LOGICALREF = LG_003_01_CSTRANS_2.CSREF where currstat=1

fortigate ip mac binding

config system interface
edit port9
set ipmac enable
end
config firewall ipmacbinding setting
set bindthroughfw enable
set bindtofw enable
set undefinedhost block
end
config firewall ipmacbinding table

Buraya kadar ip-mac binding enable komutları. 

edit 1
set ip 192.168.0.2
set mac 00:16:E6:40:3B:21
set status enable
set name "naim_pc1"
next
edit 2
set ip 192.168.0.3
set mac 10:16:E6:40:3B:21
set status enable
set name "naim_pc2"
next

end