2013.05.24

   

SQL

   

• Dedicated Administrator Connection (DAC)

  http://sqlserver365.blogspot.kr/2013/05/dedicated-administrator-connection-dac.html

   

• Automating SQL Traces        

  http://www.sqlservercentral.com/articles/SQL+Trace/99217/

     

• Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

  https://www.simple-talk.com/sql/backup-and-recovery/backup-and-restore-sql-server-with-the-sql-server-2012-powershell-cmdlets/

     

• Transaction Log Stairway Series available as a book

  http://www.sqlservercentral.com/articles/books/99431/

   

• SECURITY QUESTIONS: DIFFERENCES BETWEEN "GRANT" AND "WITH GRANT?"

  http://www.jasonstrate.com/2013/05/security-questions-differences-between-grant-and-with-grant

     

• Database Deployment: The Bits - Agent Jobs and other server objects

  https://www.simple-talk.com/sql/t-sql-programming/database-deployment-the-bits---agent-jobs-and-other-server-objects/

     

• Task Manager not showing correct SQL Server memory usage

  http://www.sqlserver-dba.com/2013/05/task-manager-not-showing-correct-sql-server-memory-usage.html

   

• Why won't my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?

  http://blogs.msdn.com/b/psssql/archive/2013/05/23/why-won-t-my-powerpivot-for-excel-2010-workbook-upgrade-to-excel-2013.aspx

   

• Getting Started with the SSAS Tabular Model

  https://www.simple-talk.com/sql/reporting-services/getting-started-with-the-ssas-tabular-model-/

     

• Moving Data From excel to SQL Server - 10 Steps to Follow

  https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/

     

Other        

   

• Experiences with the McAfee MySQL Audit Plugin

  http://www.mysqlperformanceblog.com/2013/05/23/experiences-with-the-mcafee-mysql-audit-plugin/

     

• MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency

  http://sql.dzone.com/articles/mysql-and-ssb-%E2%80%93-part-2-%E2%80%93?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29