DataBaser.Net: Database Engine

[edit]

2 참고자료 #

Database Scoped Configuration(https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/05/02/database-scoped-configuration/)
SQL Server 2012 SP1 릴리스 정보(http://msdn.microsoft.com/ko-kr/library/jj200106(SQL.15).aspx)
The Accord.NET Framework(https://code.google.com/p/accord/) --> machine learning, artificial intelligence, pattern recognition and statistics in your applications ...
Tracking page splits using the transaction log(http://feedproxy.google.com/~r/PaulSRandal/~3/IGG0rATLZNg/)
How It Works: CMemThread and Debugging Them(http://blogs.msdn.com/b/psssql/archive/2012/12/20/how-it-works-cmemthread-and-debugging-them.aspx)
Memory Manager Configuration changes in SQL Server 2012(http://blogs.msdn.com/b/sqlosteam/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx)
Query Optimizer Deep Dive - Part 1(http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx)
Query Optimizer Deep Dive - Part 2(http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx)
Query Optimizer Deep Dive - Part 3(http://sqlblog.com/blogs/paul_white/archive/2012/04/29/query-optimizer-deep-dive-part-3.aspx)
Query Optimizer Deep Dive - Part 4(http://sqlblog.com/blogs/paul_white/archive/2012/05/01/query-optimizer-deep-dive-part-4.aspx)
SQL Server 2012: RML, XEvent Viewer and Distributed Replay(http://blogs.msdn.com/b/psssql/archive/2012/04/06/sql-server-2012-rml-xevent-viewer-and-distributed-replay.aspx)
SQL Server 2012 - True Black Box Recorder(http://blogs.msdn.com/b/psssql/archive/2012/03/08/sql-server-2012-true-black-box-recorder.aspx)
SQL Server 시스템 카탈로그 쿼리에 대한 질문과 대답(http://msdn.microsoft.com/ko-kr/library/ms345522.aspx)
SQL Server AlwaysOn Video(http://channel9.msdn.com/posts/SQL-Server-AlwaysOn)
동시성 제어(Concurrency Control)와 행버전(Row Versioning)(http://www.sqler.com/bColumn/431381)
SQL Server Denali Contained Database Feature(http://www.mssqltips.com/tip.asp?tip=2428)
Adventure Works for SQL Server Denali CTP3(http://msftdbprodsamples.codeplex.com/releases/view/55330)
SQL Server Code Name “Denali” CTP3 Product Guide is Here!(http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/10/sql-server-code-name-denali-ctp3-product-guide-is-here.aspx)
sql server 2011 sample database(http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=106391)
What is New in SQL Server Denali (SQL11)(http://beyondrelational.com/whatisnew/sqlserver/denali/)
TechNet SQL Server Code-Named 'Denali'(http://technet.microsoft.com/en-us/library/bb418432(SQL.10).aspx)
CTP3 T-SQL Enhancements : FORMAT() (http://sqlblog.com/blogs/aaron_bertrand/archive/2011/08/09/sql-server-v-next-denali-ctp3-t-sql-enhancements-format.aspx)
SQL Server Denali New Features(http://sqlserver-training.com/sql-server-denali-new-features/-)
T-SQL IntelliSense enhancements in SSMS –Denali(http://blogs.msdn.com/b/sqlrem/archive/2011/01/04/t-sql-intellisense-enhancements-in-ssms-denali.aspx)
SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials(http://sqlserver-training.com/sql-server-denali-integration-services-ssis-enhancement-video-tutorials/-)
SQL Server Code-Named “Denali” - T-SQL Debugger Enhancements(http://blogs.msdn.com/b/sqlrem/archive/2011/01/04/sql-server-code-named-denali-t-sql-debugger-enhancements-in-ctp1.aspx)
New Features in SQL Server 2011
New T-SQL Features in SQL Server 2011
Columnstore Indexes for Fast Data Warehouse Query Processing in SQL Server 11.0
SQL Code Name DENALI의 HADR 설치 및 구성 가이드
SQL Server 2011 - Books Online(http://msdn.microsoft.com/en-us/library/ms130214(v=sql.110).aspx)
Download SQL Server 2011 - Code Names Denali(http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9&displaylang=en)
Adventureworks Sample Database for SQL Server 2011(http://msftdbprodsamples.codeplex.com/releases/view/55330)
High Availability Options for SQL Server 2008(http://www.mssqltips.com/tip.asp?tip=2337&home)
Free ebook:Introducing Microsoft SQL Server 2008 R2(http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx)
Microsoft SQL Server White Papers(http://msdn.microsoft.com/en-us/library/bb418438(SQL.10).aspx)
SQL Server 2005 T-SQL
Spatial DataType(이재웅)
New SQL Server features in SQL Server 2008 R2 – Part 2(http://blogs.msdn.com/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-2.aspx)
New SQL Server features in SQL Server 2008 R2 – Part 1(http://blogs.msdn.com/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-1.aspx)
SQL Server 2008 R2 디지털 투어(http://www.microsoft.com/sqlserver/tour/ko/default.aspx)
SQL2008 vs Oracle11g (MS관점)
Free ebook: Introducing Microsoft SQL Server 2008 R2
Getting started with Master Data Services in SQL Server 2008 R2(http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1507514,00.html)
MERGE Your DML Statements in SQL Server 2008(http://www.databasejournal.com/features/mssql/article.php/3870061/article.htm)
SQL Server Geography Data Type(http://www.mssqltips.com/tip.asp?tip=1965)
An overview of Master Data Services - MDS in SQL Server 2008 R2(http://www.sql-server-performance.com/articles/dba/master_data_services_mds_overview_p1.aspx)
SQL Server 2008 R2
Upgrade SSIS 2005 Packages to SSIS 2008(http://www.sql-server-performance.com/articles/dba/upgarde_2005_packages_2008_i_p1.aspx)
Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization
SQL Server 2008 NUMA and Foreign Pages(http://blogs.msdn.com/psssql/archive/2010/02/23/how-it-works-sql-server-2008-numa-and-foreign-pages.aspx)
SQL Server 2008 R2 Update for Developers Training Kit(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d)
SQL Server 2008 Developer Training Kit(http://www.microsoft.com/downloads/details.aspx?FamilyID=E9C68E1B-1E0E-4299-B498-6AB3CA72A6D7&displayLang=en)
Performance improvement by orders of magnitude when merging partitions in SQL Server 2008 R2(http://blogs.msdn.com/sqlserverstorageengine/archive/2010/02/03/performance-improvement-by-orders-of-magnitude-when-merging-partitions-in-sql-server-2008r2.aspx)
Creating a linked Postgres Server on SQL Server 2008(http://dotnetslackers.com/articles/sql/Creating-a-linked-Postgres-Server-on-SQL-Server-2008.aspx)
Top 10 Features of SQL 2008 R2(http://www.databasejournal.com/features/mssql/article.php/3857466/Top-10-Features-of-SQL-2008-R2.htm)
Brads Sure Guide To SQL Server 2008
SQL Server 2008 Upgrade Technical Reference Guide(http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en) Upload new Attachment "SQL2008UpgradeTechnicalReferenceGuide.docx"
SQL Server 2008 Developer Training Kit(http://www.microsoft.com/downloads/details.aspx?FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7&DisplayLang=en)
Partitioned Table and Index Strategies Using SQL Server 2008
Cloud Computing with Microsoft Azure SDS(http://www.databasejournal.com/features/mssql/article.php/3828571/article.htm)
Using new location-aware data types in SQL Server 2008(http://www.developer.com/db/article.php/3839056/Using-new-location-aware-data-types-in-SQL-Server-2008.htm)
Tracking expensive queries with extended events in SQL 2008(http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=1e674d0f-560f-4d36-b0c4-07c7adc5e740)
Connection strings for SQL Server 2008(http://www.connectionstrings.com/sql-server-2008)
Pre Check List for 64 BIT SQL Server 2008 Cluster Installation(http://www.sqlservercentral.com/articles/Clustering/68967/)
SQL Server 2008 T-SQL
SQL Server 2005 T-SQL
SQL Server 2000 DB Sizer
64-bit Solutions on SQL Server 2005
pubs 데이터베이스
northwind 데이터베이스
spatial data types(http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/)
SQL Server 2008 T-SQL Enhancements Part - I (Intellisense)(http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/)
SQL Server 2008 T-SQL Enhancements Part - II (UDTs and TVPs)(http://www.sqlservercentral.com/articles/SQL+Server+2008/67550/)
SQL Server 2008 T-SQL Enhancements Part - III (HierarchyID and Large UDTs)(http://www.sqlservercentral.com/articles/SQL+Server+2008/67787/)
SQL Server 2008 T-SQL Enhancements Part - IV (Filestream)(http://www.sqlservercentral.com/articles/SQL+Server+2008/67945/)
SQL Server 2008 T-SQL Enhancements Part - V (Spatial)(http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/)

Contents

1 SQL Server T-SQL 분석과 데이터베이스 엔진 #

2 참고자료 #

3 Architecture #