SQL
SQL2014
- SQL Server 2014 In-Memory Technologies: Blog Series Introduction
- Hekaton data and code – where does that stuff actually live? - Bob Beauchemin
http://www.sqlskills.com/blogs/bobb/hekaton-data-and-code-where-does-that-stuff-actually-live/
- Getting Started with SQL Server 2014 In-Memory OLTP
In-Memory 테스트한 자료네요~... 아직 설치도 못했는데...
- This Can Be the Best Thing in SQL Server 2014
http://www.dbnewsfeed.com/2013/06/26/this-can-be-the-best-thing-in-sql-server-2014
SQL2014에서 sys.dm_exec_query_profiles이 DMV가 눈에 가더군요... showplan xml을 직렬화해서 플랜을 수집한다.. 등등등.. 머 하는 놈이고~~
근데,,아직 이 dmv는 ctp 버젼에 안 올라왔나봐요.. 설치하고 확인해봐야징..
- The Accidental DBA (Day 26 of 30): Monitoring Disk I/O - Erin Stellato
http://www.sqlskills.com/blogs/erin/the-accidental-dba-monitoring-disk-io
- Encrypting sa passwords during SQL Server Installation
http://www.sqlserver-dba.com/2013/06/encrypting-sa-passwords-during-sql-server-installation.html
- Expand your Powershell mind – Three key cmdlets
http://www.sqlserver-dba.com/2013/06/expand-your-powershell-mind-three-key-cmdlets-1.html
- The Elephant and the Mouse, or, Parameter Sniffing in SQL Server
- Alert visualization recipe: Get out your blender, drop in some sp_send_dbmail, Google Charts API, add your favorite colors and sprinkle with html. Blend till it's smooth and looks pretty enough to taste.
- We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.
- Shakespeare and storing Unicode characters
- A Computed Column Defined with a User-Defined Function Might Impact Query Performance
- Big Data for SQL folks: The Technologies (Part I)
http://www.sqlservercentral.com/articles/Big+Data/95647/
- SQL Server Integration Services package to delete files from a Network or Local path based on date
- SQL Server 2012 Analysis Services XMLA
http://www.mssqltips.com/sqlservertip/2982/sql-server-2012-analysis-services-xmla/
Other
- Scaling lessons learned at Dropbox, part 1
http://eranki.tumblr.com/post/27076431887/scaling-lessons-learned-at-dropbox-part-1
dropbox scaling 어떤 방법인지 궁굼하네요.
- pt-online-schema-change and binlog_format
'SQLTAG Daily Links' 카테고리의 다른 글
2013.07.01 (0) | 2013.07.01 |
---|---|
2013.06.28 (0) | 2013.06.28 |
2013.06.26 (0) | 2013.06.26 |
Table-Valued Parameter 사용 방법^^(c#) (2) | 2013.06.25 |
2013.06.25 (0) | 2013.06.25 |