SQL
- The Read Committed Isolation Level - Paul White
http://sqlperformance.com/2014/04/t-sql-queries/the-read-committed-isolation-level
- Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types
http://www.sqlskills.com/blogs/paul/causes-io_completion-write_completion-sql-server-wait-types
- Delayed Durability in SQL Server 2014 - Aaron Bertrand
http://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014
- How Automatic Updates to Statistics Can Affect Query Performance
http://sqlperformance.com/2014/05/sql-performance/auto-stats-effects
- SQLskills community mentoring ? round 6
http://www.sqlskills.com/blogs/paul/sqlskills-community-mentoring-round-6/
- Optimizing Transaction Log Throughput
https://www.simple-talk.com/sql/database-administration/optimizing-transaction-log-throughput/
- Dream DBA
- Shrinking tempdb no longer prohibited
http://www.sqlskills.com/blogs/paul/shrinking-tempdb-longer-prohibited
- Introducing sp_BlitzCache™
http://www.brentozar.com/archive/2014/05/introducing-sp_blitzcache/
- Clustered Columnstore Indexes: Exploring Delta Store and Delete Bitmap
- The Cardinality Estimator in SQL Server 2014 ? Going Forward and Backward
- 4 Lightweight Ways to Tell if a Database is Used
http://www.brentozar.com/archive/2014/05/4-lightweight-ways-tell-database-used/
- SQL Server Debugging with WinDbg ? an Introduction
http://www.sqlpassion.at/archive/2014/05/05/sql-server-debugging-with-windbg-an-introduction/
- How to Restore a Certificate in SQL Server
http://sqlity.net/en/2384/restore-certificate/
- SQL intersection slides and samples
http://sqlperformance.com/2014/04/sql-performance/sql-intersection-slides-and-samples
- SELECT INTO ? Moving Data From A To B
http://kejser.org/databases/select-into-moving-data-from-a-to-b/
- Cannot Failover Nodes Using TempDB on Local Storage
- Further Testing with Automatic Updates to Statistics
http://www.sqlskills.com/blogs/erin/testing-automatic-updates-statistics
- DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
- Differential Changed Map (DCM): How SQL Server Tracks Changed Pages
http://sqlity.net/en/2387/dcm/
- SQL Server 2014 Clustered Columnstore Indexes and Partitioning
- Migrating SQL Server logins
- Using Kerberos With SQL Server ? Part 1 ? Double Hop
http://www.seangallardy.com/2014/05/using-kerberos-with-sql-server-part-1-double-hop
- Using Kerberos With SQL Server ? Part 2 ? Across Domains
http://www.seangallardy.com/2014/05/using-kerberos-with-sql-server-part-2-across-domains
- Configuring SQL Server 2012 Always On Lab- Part 1
- Why is there a sysobjects when we already have sys.objects?
- Does SQL Server do a CHECKDB during an instance restart?
- SQL SERVER ? What is SSAS Tabular Data model and Why to use it ? Part 2
LINKS
- Friday Followup For May 2, 2014
- Log Buffer #369, A Carnival of the Vanities for DBAs
http://www.pythian.com/blog/log-buffer-369-a-carnival-of-the-vanities-for-dbas/
- LAST WEEKS TOP "READING" LINKS #82
http://www.jasonstrate.com/2014/05/last-weeks-top-reading-links-82/
Other
- DynamoDB의 Write Capacity를 낮춰서 DynamoDB 비용 줄이기
http://readme.skplanet.com/?p=7570
- Use MySQL to store NoSQL and SQL data in the same database using memcached and InnoDB
- Parallel Query for MySQL with Shard-Query
http://java.dzone.com/articles/parallel-query-mysql-shard
- How to identify and cure MySQL replication slave lag
http://www.mysqlperformanceblog.com/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/
- Row-based replication, MySQL 5.6 upgrades and temporal data types
'SQLTAG Daily Links' 카테고리의 다른 글
2014.05.14 (0) | 2014.05.14 |
---|---|
2014.05.13 (0) | 2014.05.13 |
2014.04.30 (0) | 2014.04.30 |
2014.04.29 (0) | 2014.04.29 |
2014.04.28 (0) | 2014.04.29 |