Techie Talks
Monday, 16 June 2014
Finding missing sequence in mysql server
›
select t1.eventlogid + 1 as missing_id from ka_eventlognew1 t1 left join ka_eventlognew1 t2 on t2.eventlogid = t1.eventlogid + 1 where t...
Protect excel with password
›
Here is the VBA Code to protect an excel sheet with the password Please make sure that the libraries have interop dll . Microsoft.Office...
Thursday, 12 June 2014
Difference between SQL Server 2005/2008/2012
›
SQL Server 2005 to 2008 • Transparent Data Encryption. The ability to encrypt an entire database. • Backup Encryption. Executed at backup...
Wednesday, 4 June 2014
Copy data from one mysql server to another using SSIS
›
create a user in mysql CREATE USER 'admin'@'%' IDENTIFIED BY '@dm1n'; GRANT ALL TO 'admin'@'%' FL...
‹
›
Home
View web version