2013.04.10

   

SQL

   

• A SQL Server Hardware Tidbit a Day – Day 9

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-9

  그렌아쩌쒸 대단하시네요. ^^

   

• Partitioning in SQL Server: Managing Sliding Window Scenario

  http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-managing-sliding-window-scenario.html

     

• Managing SQL Server Statistics

  https://www.simple-talk.com/sql/performance/managing-sql-server-statistics/

     

• TSQL Coding Style

  http://www.databasejournal.com/features/mssql/tsql-coding-style.html

     

• Batching Techniques for SQL Database Applications in Windows Azure

  http://sqlcat.com/sqlcat/b/msdnmirror/archive/2013/04/09/batching-techniques-for-sql-database-applications-in-windows-azure.aspx

     

• SQL Server – Add Date/Time to output file of BCP / SQLCMD

  http://sqlandme.com/2013/04/09/sql-server-add-datetime-to-output-file-of-bcp-sqlcmd/

     

• SSIS gotcha – Regional Settings can affect your expressions

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/04/09/ssis-gotcha-regional-settings-can-affect-your-expressions.aspx

     

• Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor

  http://www.sqlservercentral.com/articles/Database+Engine+Tuning+Advisor/97860/

     

• Consolidating Error Logs from multiple SQL Servers using SSIS

  http://www.mssqltips.com/sqlservertip/2925/consolidating-error-logs-from-multiple-sql-servers-using-ssis/

     

• New Features added to Azure today - AD, Backup & Website Monitoring

  http://sqlblog.com/blogs/greg_low/archive/2013/04/09/new-features-added-to-azure-today-ad-backup-website-monitoring.aspx

     

OTHER

   

MySQL: Repairing broken tables/indices

http://sql.dzone.com/articles/mysql-repairing-broken