2013.05.31

   

SQL

   

• Stored procedure debugging in SSDT and LocalDB

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/05/30/stored-procedure-debugging-in-ssdt-and-localdb.aspx

     

• SECURITY QUESTIONS: TRUNCATE TABLE PERMISSIONS

  http://www.jasonstrate.com/2013/05/security-questions-truncate-table-permissions/

   

• End of DBCC Command Month

  http://stevestedman.com/2013/05/end-of-dbcc-command-month/        

     

• SQL Database Corruption - What steps should I follow to prepare for database corruption?

  http://www.sqlserver-dba.com/2013/05/sql-database-corruption.html

     

• Bad DBA Job Detector Test [Video]

  http://www.brentozar.com/archive/2013/05/bad-dba-job-detector-test-video/

  DBA 여러 직무 잡에 대한 좋은 이슈들을 알려주네요^^ 영어라 압박이 ㅠㅠ        

     

• Super Fast Transactional Replication Repair        

  http://www.sqlservercentral.com/articles/Replication/98897/

   

• Show off your Solutions

  http://www.sqlservercentral.com/articles/SQLServerCentral/99555/

     

• Extending SQL Server DDL Triggers for more functionality: Part 1

  http://www.mssqltips.com/sqlservertip/2951/extending-sql-server-ddl-triggers-for-more-functionality-part-1/

   

• Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

  http://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

     

• SQL SERVER – Add Identity Column to Table Based on Order of Another Column

  http://blog.sqlauthority.com/2013/05/30/sql-server-add-identity-column-to-table-based-on-order-of-another-column/

   

• SQL Server Service won't start after changing service account - service-specific error %%-2146885628        

  http://sqlblog.com/blogs/greg_low/archive/2013/05/30/sql-server-service-won-t-start-after-changing-service-account-service-specific-error-2146885628.aspx

     

     

Other

   

• Migrate VMWare VMs to Windows Azure

  http://cloud.dzone.com/articles/migrate-vmware-vms-windows

     

• Replication in MySQL 5.6: GTIDs benefits and limitations – Part 2

  http://www.mysqlperformanceblog.com/2013/05/30/replication-in-mysql-5-6-gtids-benefits-and-limitations-part-2/

     

• [명령어] grep

  http://naleejang.tistory.com/70