Naim KÖLEOĞLU
20 Ekim 2015 Salı
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
31 Mart 2015 Salı
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;
}
30 Ağustos 2013 Cuma
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
26 Ağustos 2013 Pazartesi
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.
16 Ağustos 2013 Cuma
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
14 Ağustos 2013 Çarşamba
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
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
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
Kaydol:
Kayıtlar (Atom)