2013.09.06

    

SQL

   

• How to become a better, well-rounded SQL Server DBA

  http://www.sqlpassion.at/archive/2013/09/04/how-to-become-a-better-well-rounded-sql-server-dba

   

• Performance Surprises and Assumptions : DATEDIFF

  http://www.sqlperformance.com/2013/09/t-sql-queries/datediff-bug

     

• Nonclustered Index Seek Operator needs leftmost key in query

  http://www.sqlserver-dba.com/2013/09/nonclustered-index-seek-operator-needs-leftmost-key-in-query.html

     

• Introduction to Integrity: Corruption in Allocation Pages

  http://www.sqlsoldier.com/wp/sqlserver/introductiontointegritycorruptioninallocationpages

     

• A T-SQL query to get current job activit

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/05/a-t-sql-query-to-get-current-job-activity.aspx

   

• Getting Data between Excel and SQL Server using ODBC

  http://www.sqlservercentral.com/redirect/articles/101732/

     

• SQLCAT.com consolidated index of Whitepapers        

  http://blogs.msdn.com/b/sqlcat/archive/2013/09/05/sqlcat-com-consolidated-index-of-whitepapers.aspx        

     

• sp_executesql, Parameters and Parameter Sniffing

  http://www.scarydba.com/2013/09/05/sp_executesql-parameters-and-parameter-sniffing/

     

• Rebuild or Reorganize: Index Maintenance Can Save Your Job

  http://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/

     

• Integrating SQL Server 2014 constructs into the T-SQL canon

  http://www.sqlskills.com/blogs/bobb/integrating-sql-server-2014-constructs-into-the-t-sql-canon/

     

• New Enhanced Column Store Index in SQL Server 2014 ? Part 1

  http://www.databasejournal.com/features/mssql/new-enhanced-column-store-index-in-sql-server-2014-part-1.html

     

• Be honest: have you ever waited too long to back up your SQL Server data?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/05/be-honest-have-you-ever-waited-too-long-to-back-up-your-sql-server-data.aspx

     

• Five SQL Server Settings to Change

  http://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/

     

• Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

  http://www.sqlservercentral.com/articles/Stairway+Series/90381/

     

• SSIS ReportingPack v1.1.1.0 ? Execution Stats visualised in a Gannt chart via usp_ssiscatalog

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/09/05/ssis-reportingpack-v1-1-1-0-execution-stats-visualised-in-a-gannt-chart-via-usp-ssiscatalog.aspx

     

• SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions

  http://www.mssqltips.com/sqlservertip/3034/sql-server-analysis-services-ssas-2012-top-and-bottom-functions/

     

• Monitoring job history using Reporting Services

  http://www.sqlservercentral.com/articles/Job/101563/        

     

• Replicating A Volume Of Large Data via Transactional Replication

  http://www.sql-server-performance.com/2013/replicating-a-volume-of-large-data-over-the-via-transactional-replication/

     

• SSISReportingPack with usp_ssiscatalog v1.1 available ? first release with integrated installer

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/09/04/ssisreportingpack-with-usp-ssiscatalog-v1-1-available-first-release-with-integrated-installer.aspx

     

• Analysis Service connectivity error due to SQL Browser service

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/04/analysis-service-connectivity-error-due-to-sql-browser-service.aspx

     

• SQL Server Analysis Services Query Response Comparison by Storage Mode

  http://www.mssqltips.com/sqlservertip/3032/sql-server-analysis-services-query-response-comparison-by-storage-mode/

     

• SQL Server 2012 Sample database

  http://www.sqlpanda.com/2013/09/sql-server-2012-sample-database.html

  Sample Database 굿~

     

• SQL Server 2012 Express includes full SSMS function

  http://www.sqlpanda.com/2013/09/sql-server-2012-express-includes-full.html

     

• Free Tools For The DBA

  http://sqlserver365.blogspot.kr/2013/09/free-tools-for-dba.html

     

• Install SQL Server 2012 SP1 on Windows 2008R2

  http://www.sqlpanda.com/2013/09/install-sql-server-2012-sp1-on-windows.html

     

Other

   

• Here's my favorite secret MySQL 5.6 feature. What's yours?

  http://www.mysqlperformanceblog.com/2013/09/05/my-favorite-secret-mysql-5-6-feature/

     

• TokuDB vs InnoDB in timeseries INSERT benchmark

  http://www.mysqlperformanceblog.com/2013/09/05/tokudb-vs-innodb-timeseries-insert-benchmark/

     

• Amazon ElastiCache Adds Redis Support

  http://cloud.dzone.com/articles/amazon-elasticache-adds-redis

     

  Two presentations on Big Data Big Analytics with R

  http://blog.revolutionanalytics.com/2013/09/big-data-analytics-slidecast.html

     

  예외에 대한 생각들

  http://mimul.com/pebble/default/2013/09/04/1378268814153.html