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

About Me

poonam
View my complete profile
Powered by Blogger.