위키
포럼
도구
바뀐글
랜덤

"Dear SQL DBA"의 두 판 사이의 차이

8번째 줄: 8번째 줄:
== 에피소드 ==
== 에피소드 ==
{| class='wikitable'
{| class='wikitable'
! # !! 제목
! # !! 제목 !! 주제
|-
|-
| 24 ||  Is Your SQL Server Running with Scissors?
| 24 ||  Is Your SQL Server Running with Scissors? || 무능한 SQL 서버 운영팀의 표지
|-
|-
| 23 ||  Why is My Query Faster the Second Time It Runs?
| 23 ||  Why is My Query Faster the Second Time It Runs? ||
|-
|-
| 22 ||  Should I Upgrade to SQL Server 2016?
| 22 ||  Should I Upgrade to SQL Server 2016? ||
|-
|-
| 21 || What is Adaptive Query Processing?
| 21 || What is Adaptive Query Processing? ||
|-
|-
| 20 || Where Do You Get Your Creativity?
| 20 || Where Do You Get Your Creativity? ||
|-
|-
| 19 || Should I Rebuild or Reorganize Large Indexes?
| 19 || Should I Rebuild or Reorganize Large Indexes? ||
|-
|-
| 18 || Can I use Statistics to Design Indexes?
| 18 || Can I use Statistics to Design Indexes? ||
|-
|-
| 17 || Setting up Free Blocking Alerts and Deadlock Monitoring
| 17 || Setting up Free Blocking Alerts and Deadlock Monitoring ||
|-
|-
| 16 || Which is Worse: An Unused Index, or an Un-Indexed Foreign Key?
| 16 || Which is Worse: An Unused Index, or an Un-Indexed Foreign Key? ||
|-
|-
| 15 || Finding Your Voice as a Speaker
| 15 || Finding Your Voice as a Speaker ||
|-
|-
| 14 || Collect and Baseline Wait Statistics
| 14 || Collect and Baseline Wait Statistics ||
|-
|-
| 13 || Developer Seeks DBA Career
| 13 || Developer Seeks DBA Career ||
|-
|-
| 12 || Teach Yourself SQL Server Performance Tuning
| 12 || Teach Yourself SQL Server Performance Tuning || 성능 튜닝 자습을 위한 데이터, 참고자료
|-
|-
| 11 || Altering an INT Column to a BIGINT
| 11 || Altering an INT Column to a BIGINT ||
|-
|-
| 10 || Should I Automate My Windows Updates?
| 10 || Should I Automate My Windows Updates? ||
|-
|-
| 9 || Why an Upgrade can Cause Performance Regressions 
| 9 || Why an Upgrade can Cause Performance Regressions ||
|-
|-
| 8 || MAXDOP of Confusion – Setting Max Degree of Parallelism, Cost Threshold for Parallelism, and a Brief Intro to Soft NUMA
| 8 || MAXDOP of Confusion – Setting Max Degree of Parallelism, Cost Threshold for Parallelism, and a Brief Intro to Soft NUMA ||
|-
|-
| 7 || How to Level Up Your DBA Career
| 7 || How to Level Up Your DBA Career ||
|-
|-
| 6 || Index Usage Stats Insanity – sys.dm_db_index_usage_stats
| 6 || Index Usage Stats Insanity – sys.dm_db_index_usage_stats ||
|-
|-
| 5 || Fail Over Again, Fail Better – Preparing for Disaster Recovery
| 5 || Fail Over Again, Fail Better – Preparing for Disaster Recovery ||
|-
|-
| 4 || Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server
| 4 || Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server ||
|-
|-
| 3 || Next Door to Derpton – When Your Fellow DBA is a Danger to Databases
| 3 || Next Door to Derpton – When Your Fellow DBA is a Danger to Databases || 믿을 수 없는 동료 DBA
|-
|-
| 2 || Lost in Performance Troubleshooting – Kendra’s Perf Triage for SQL Server
| 2 || Lost in Performance Troubleshooting – Kendra’s Perf Triage for SQL Server || 성능문제 트러블슈팅시의 주요 확인리스트, 트러블슈팅 툴
|-
|-
| 1 || Bleeding In Edgeville – When Upgrades Come Too Fast
| 1 || Bleeding In Edgeville – When Upgrades Come Too Fast || 최신버전 MS-SQL 현업 적용 해야할까
|}
|}


2016년 12월 3일 (토) 13:07 판

1 개요

Dear SQL DBA
  • SQL Server 즉 MS-SQL 과 관련된 고급주제를 다루는 영어 팟캐스트. 매회 DBA들로부터의 질문 또는 DBA와 관련된 질문을 주제로 20~30분 정도 진행됨.
  • 진행 : 켄드라 리틀 ( Kendra Little , MS MVP )
  • ipod 팟캐스트로 음성/화상 파일이 배포되며, youtube 채널을 통해서도 시청이 가능하다. 방송 내용에서 언급된 내용은 켄드라 리틀의 개인블로그에 정리되므로 참고할 수 있다.
  • 1화 방송업로드는 (유튜브 기준) 2016년 5월 26일. 관련 블로그포스팅도 같은날 포스팅되었음. 2016년 12월 현재 계속 업데이트되고 있다.

2 에피소드

# 제목 주제
24  Is Your SQL Server Running with Scissors? 무능한 SQL 서버 운영팀의 표지
23  Why is My Query Faster the Second Time It Runs?
22  Should I Upgrade to SQL Server 2016?
21 What is Adaptive Query Processing?
20 Where Do You Get Your Creativity?
19 Should I Rebuild or Reorganize Large Indexes?
18 Can I use Statistics to Design Indexes?
17 Setting up Free Blocking Alerts and Deadlock Monitoring
16 Which is Worse: An Unused Index, or an Un-Indexed Foreign Key?
15 Finding Your Voice as a Speaker
14 Collect and Baseline Wait Statistics
13 Developer Seeks DBA Career
12 Teach Yourself SQL Server Performance Tuning 성능 튜닝 자습을 위한 데이터, 참고자료
11 Altering an INT Column to a BIGINT
10 Should I Automate My Windows Updates?
9 Why an Upgrade can Cause Performance Regressions 
8 MAXDOP of Confusion – Setting Max Degree of Parallelism, Cost Threshold for Parallelism, and a Brief Intro to Soft NUMA
7 How to Level Up Your DBA Career
6 Index Usage Stats Insanity – sys.dm_db_index_usage_stats
5 Fail Over Again, Fail Better – Preparing for Disaster Recovery
4 Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server
3 Next Door to Derpton – When Your Fellow DBA is a Danger to Databases 믿을 수 없는 동료 DBA
2 Lost in Performance Troubleshooting – Kendra’s Perf Triage for SQL Server 성능문제 트러블슈팅시의 주요 확인리스트, 트러블슈팅 툴
1 Bleeding In Edgeville – When Upgrades Come Too Fast 최신버전 MS-SQL 현업 적용 해야할까

3 같이 보기

4 참고 자료

원본 주소 "https://zetawiki.com/w/index.php?title=Dear_SQL_DBA&oldid=223415"
문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}