SQL
SQL2014 CTP1
- SQL Server In-Memory OLTP Internals Overview for CTP1
- My Thoughts about SQL Server 2014
http://www.dbnewsfeed.com/2013/06/25/my-thoughts-about-sql-server-2014/
- New DMVs in SQL Server 2014 CTP1
http://www.brentozar.com/archive/2013/06/new-dmvs-in-sql-server-2014-ctp1/
- On Line link with ALL the new
http://msdn.microsoft.com/en-us/library/bb510411(v=sql.120).aspx
dmv중에 sys.dm_exec_query_profiles도 보이고,, 오호~~ 보안도 강화되고~~
- SQL SERVER 2014 CTP 1 Installation
http://dbaishtiaq.wordpress.com/2013/06/25/sql-server-2014-ctp-1-installation/
install 방법도 나왔네요..
- Prepare a new VM for SQL Server 2014 CTP1
http://www.sqlperformance.com/2013/06/system-configuration/sql2014-ctp1-1
- SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sql-server-2014-ctp1-native
- Supported and unsupported datatypes with Hekaton tables
- New Dynamic Management Views in SQL Server 2014 CTP1
- SQL Server 2014 – Public CTP Now Available
- The Accidental DBA (Day 25 of 30): Wait Statistics Analysis - Erin Stellato
- Index Internals and How Filtered Indexes Look Like (Part 1)
http://www.pythian.com/blog/index-internals-and-how-filtered-indexes-look-like-part-1/
filtered index에 대한 내부 정보를 보여주네요^^
- Did You Know? What settings to always change - Kalen Delaney
http://sqlblog.com/blogs/kalen_delaney/archive/2013/06/25/settings-to-always-change.aspx
- Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell
- When was sys.dm_os_wait_stats last cleared?
http://blogs.msdn.com/b/sqlosteam/archive/2011/11/12/when-was-sys-dm-os-wait-stats-last-cleared.aspx
- Using The System Monitor Tool For Measuring SQL Server Performance
http://www.sql-server-performance.com/2013/system-monitor-tool-measure-performance
- Amazing SQL server tools every DBA must have!!! – Part 1
http://sql-blogs.com/2013/06/25/amazing-sql-server-tools-every-dba-must-have-part-1/
- Amazing SQL server tools every DBA must have!!! – Part 2
http://sql-blogs.com/2013/06/25/amazing-sql-server-tools-every-dba-must-have-part-2/
Other
- Real-time Profiling a MongoDB Sharded Cluster
http://emptysqua.re/blog/real-time-profiling-a-mongodb-cluster/
- 3 Ways to Optimize for Paging in MySQL
http://sql.dzone.com/articles/3-ways-optimize-paging-mysql?
오호^^ MySQL에서 페이징 처리 방법~ ㅎㅎ
'SQLTAG Daily Links' 카테고리의 다른 글
2013.06.28 (0) | 2013.06.28 |
---|---|
2013.06.27 (0) | 2013.06.27 |
Table-Valued Parameter 사용 방법^^(c#) (2) | 2013.06.25 |
2013.06.25 (0) | 2013.06.25 |
2013.06.24 (0) | 2013.06.24 |