ssis script task
카테고리 없음 / 2015. 10. 2. 17:32
mysql recovery
카테고리 없음 / 2015. 10. 1. 16:36
c 에 용량이 얼마 없으니 아래와 같이 링크를 만든다
일반적인 작업은
use bacula 해서 그냥 쓰면 된다.
restore 할 때
source 명령어를 쓰는데 이건 workbench 에서는 동작하지 않는지 다른 모드가 있는 모양이다.
mysql -u root -p 로 들어가서
use bacula
mysql> source D:\어쩌고\저쩌고\mysqldump.dump
예전같이 그냥 mysql -u root -p < mysqldump.dump 이렇게 하려면 첫 줄에 use 대상데이터베이스 이렇게 넣어주어야 하는데 위와 같은 방법으로 하면 큰 파일 고치지 않고 가능하네~
Change password for user nixcraft, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='nixcraft';Finally, reload the privileges:
mysql> flush privileges; mysql> quit
select *, CAST(logtext AS CHAR(10000) CHARACTER SET utf8) from log order by logid desc limit 1000주옥같은 프로시저 겠쥐...나중에 봐야지...
카테고리 없음 / 2015. 9. 24. 11:43
Hello minsouk, Welcome back and I hope you had a great summer holiday! Today I would like to share with you some improvements we have made to SQLTest and sp_whopro; many of them were the result of user feedback: sp_whopro SQL Server Activity Monitoring and Logging Stored Procedure
Upcoming Workshops: The "Advanced SQL Server 2014, 2012 and 2008 Performance Monitoring & Tuning Hands-on Workshop"uses SQLTest tool to simulate real-world performance issues on every participant's computer and these problems are resolved together with the students using various techniques. This makes sure the participants receive first-hand practical performance tuning skills, with real-world problem solving and not just the common "best practice guidelines" discussion. Agenda Feedback
If there are three or more DBAs / developers / architects in your company who would like to attend, it might be more convenient to organize the training at your company's premises. Let us know if you have any SQL Server performance tuning questions! Best regards, Carmen and Ramesh |