corpus.blog
41554 blogs · [ { "id": "01a08794-be28-722f-816e-19c8be43dc22", "title": "Finding Your Voice as a Speaker (Dear SQL DBA Episode 15)", "url": "https://kendralittle.com/2016/09/01/finding-your-voice-as-a-speaker-dear-sql-dba-episode-15/", "published_at": "2016-09-01T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8beb638b3", "title": "Do Clustered Index Columns Count Against Max Nonclustered Key Size?", "url": "https://kendralittle.com/2016/08/30/do-clustered-index-columns-count-against-max-nonclustered-key-size/", "published_at": "2016-08-30T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bfa9a061", "title": "Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)", "url": "https://kendralittle.com/2016/08/25/collect-and-baseline-wait-statistics-dear-sql-dba-episode-14/", "published_at": "2016-08-25T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8bfc316c4", "title": "Free Poster: tempdb data files in SQL Server", "url": "https://kendralittle.com/2016/08/23/free-poster-tempdb-data-files-in-sql-server/", "published_at": "2016-08-23T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c00c5602", "title": "Developer Seeks DBA Career (Dear SQL DBA, Episode 13)", "url": "https://kendralittle.com/2016/08/18/developer-seeks-dba-career-dear-sql-dba-episode-13/", "published_at": "2016-08-18T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c0eeec76", "title": "Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?", "url": "https://kendralittle.com/2016/08/16/does-adding-noindex-change-dbcc-checkdb-with-physical_only/", "published_at": "2016-08-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c105b854", "title": "Teach Yourself SQL Server Performance Tuning (Dear SQL DBA Episode 12)", "url": "https://kendralittle.com/2016/08/11/teach-yourself-sql-server-performance-tuning-dear-sql-dba-episode-12/", "published_at": "2016-08-11T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c110bbfc", "title": "SSMS Tips: Templates and Control+Shift+M", "url": "https://kendralittle.com/2016/08/09/ssms-tips-templates-and-controlshiftm/", "published_at": "2016-08-09T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c1cf08b0", "title": "Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)", "url": "https://kendralittle.com/2016/08/04/altering-an-int-column-to-a-bigint-dear-sql-dba-episode-11/", "published_at": "2016-08-04T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c2a5dc04", "title": "Should I Automate my Windows Updates for SQL Server? (Dear SQL DBA Episode 10)", "url": "https://kendralittle.com/2016/07/28/should-i-automate-my-windows-updates-for-sql-server-dear-sql-dba-episode-10/", "published_at": "2016-07-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c3813f85", "title": "Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)", "url": "https://kendralittle.com/2016/07/21/why-can-an-upgrade-cause-performance-regression-dear-sql-dba-episode-9/", "published_at": "2016-07-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c3e39fb9", "title": "Free Poster: Cat DBA Says Not Right Meow", "url": "https://kendralittle.com/2016/07/19/free-sql-server-poster-cat-dba-says-not-right-meow/", "published_at": "2016-07-19T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c49638a0", "title": "Coming to SQL Saturday Portland? Plan a Vacation, too!", "url": "https://kendralittle.com/2016/07/15/coming-to-sql-saturday-portland-plan-a-vacation/", "published_at": "2016-07-15T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c4cf0177", "title": "MAXDOP of Confusion (Dear SQL DBA Episode 8)", "url": "https://kendralittle.com/2016/07/14/max-degree-of-parallelism-cost-threshold-for-parallelism/", "published_at": "2016-07-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c5bbda76", "title": "Is User Acceptance Testing Covered Under Developer Edition?", "url": "https://kendralittle.com/2016/07/12/is-user-acceptance-testing-covered-under-developer-edition/", "published_at": "2016-07-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c61406b9", "title": "How to Level Up Your DBA Career (Dear SQL DBA)", "url": "https://kendralittle.com/2016/07/07/how-to-level-up-your-dba-career-dear-sql-dba/", "published_at": "2016-07-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c6b1e4be", "title": "Which Indexes are Disk Based in SQL Server?", "url": "https://kendralittle.com/2016/07/05/which-indexes-are-disk-based-in-sql-server/", "published_at": "2016-07-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c70d5cc3", "title": "Index Usage Stats Insanity - the oddities of sys.dm db index usage stats (Dear SQL DBA)", "url": "https://kendralittle.com/2016/06/30/index-usage-stats-insanity-sys-dm_db_index_usage_stats-dear-sql-dba/", "published_at": "2016-06-30T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c744a200", "title": "SPLIT in a LEFT Partition Function: Where Does the Above-Boundary Data Go?", "url": "https://kendralittle.com/2016/06/28/split-in-a-left-partition-function-where-does-the-above-boundary-data-go/", "published_at": "2016-06-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c7dc473b", "title": "Learn Index Tuning at the PASS Summit in 2016!", "url": "https://kendralittle.com/2016/06/24/learn-index-tuning-at-the-pass-summit-in-2016/", "published_at": "2016-06-24T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c81dac0f", "title": "Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)", "url": "https://kendralittle.com/2016/06/23/fail-over-fail-again-fail-better-preparing-for-disaster-recovery-dear-sql-dba/", "published_at": "2016-06-23T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c8b52ea0", "title": "Will Query Store Work in a Read Only Database?", "url": "https://kendralittle.com/2016/06/21/will-query-store-work-in-a-read-only-database/", "published_at": "2016-06-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8c967e36b", "title": "Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)", "url": "https://kendralittle.com/2016/06/16/outside-the-big-san-box-analyzing-storage-and-san-latency-in-sql-server-dear-sql-dba/", "published_at": "2016-06-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ca0830f8", "title": "Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016", "url": "https://kendralittle.com/2016/06/14/target-recovery-interval-and-indirect-checkpoint-new-default-of-60-seconds-in-sql-server-2016/", "published_at": "2016-06-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ca22cc59", "title": "Next Door to Derpton - When Your Fellow DBA is a Danger to Databases (Dear SQL DBA)", "url": "https://kendralittle.com/2016/06/09/dear-sql-dba-next-door-to-derpton/", "published_at": "2016-06-09T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ca71d5f0", "title": "Merging Boundary Points: Does a Changing Partition_Number Indicate Data Movement?", "url": "https://kendralittle.com/2016/06/07/merging-boundary-points-does-partition_number-changing-indicate-data-movement/", "published_at": "2016-06-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cad9105a", "title": "Lost in Performance Troubleshooting - Perf Triage for SQL Server", "url": "https://kendralittle.com/2016/06/02/dear-sql-dba-lost-in-performance-troubleshooting/", "published_at": "2016-06-02T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cb271a44", "title": "Testing an Insert for Race Conditions with Ostress.exe", "url": "https://kendralittle.com/2016/05/31/testing-an-insert-for-race-conditions-with-ostress-exe/", "published_at": "2016-05-31T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cc013715", "title": "Bleeding In Edgeville - When Upgrades Come Too Fast (Dear SQL DBA)", "url": "https://kendralittle.com/2016/05/26/dear-sql-dba-bleeding-in-edgeville/", "published_at": "2016-05-26T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cc63a610", "title": "The Case of the Blocking Merge Statement (LCK_M_RS_U locks)", "url": "https://kendralittle.com/2016/05/24/the-case-of-the-blocking-merge-statement-lck_m_rs_u-locks/", "published_at": "2016-05-24T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cd07f254", "title": "Blogger Tip: Easy Free-Use Images with Pablo by Buffer", "url": "https://kendralittle.com/2016/05/19/blogger-tip-easy-free-use-images-with-pablo-by-buffer/", "published_at": "2016-05-19T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cdf26c60", "title": "Index Usage Stats Bug Fixed in SQL Server 2012 SP2 CU12 / SP3 CU3", "url": "https://kendralittle.com/2016/05/18/index-usage-stats-bug-fixed-in-sql-server-2012-sp2-cu12-sp3-cu3/", "published_at": "2016-05-18T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ce212d54", "title": "Sabbatical Update: 4 Months of Fun and Reflection", "url": "https://kendralittle.com/2016/05/17/sabbatical-update-4-months-of-fun-and-reflection/", "published_at": "2016-05-17T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8ce6c0d12", "title": "Submit a Dear DBA Question", "url": "https://kendralittle.com/2016/05/12/submit-a-dear-dba-question/", "published_at": "2016-05-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cf62b248", "title": "Indexes: Do Included Columns Always Go on a Non-Root Page? (video)", "url": "https://kendralittle.com/2016/05/10/indexes-do-included-columns-always-go-on-a-non-root-page-video/", "published_at": "2016-05-10T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cf65057f", "title": "How to Script Out Indexes from SQL Server", "url": "https://kendralittle.com/2016/05/05/how-to-script-out-indexes-from-sql-server/", "published_at": "2016-05-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8cfd05fb1", "title": "Why Table Partitioning Does Not Speed Up Query Performance (video)", "url": "https://kendralittle.com/2016/05/03/why-table-partitioning-doesnt-speed-up-query-performance-video/", "published_at": "2016-05-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d0bca5b6", "title": "Required Testing for Installing SQL Server Cumulative Updates and Service Packs", "url": "https://kendralittle.com/2016/04/28/required-testing-for-installing-sql-server-cumulative-updates-and-service-packs/", "published_at": "2016-04-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d12308d1", "title": "What is the Difference between a Junior and Senior DBA?", "url": "https://kendralittle.com/2016/04/26/whats-the-difference-between-a-junior-and-senior-dba/", "published_at": "2016-04-26T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d1366696", "title": "Managing Statistics in SQL Server for DBAs (videos)", "url": "https://kendralittle.com/2016/04/21/managing-statistics-in-sql-server-for-dbas-videos/", "published_at": "2016-04-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d1c7864b", "title": "Updating Statistics in SQL Server: Maintenance Questions & Answers", "url": "https://kendralittle.com/2016/04/18/updating-statistics-in-sql-server-maintenance-answers/", "published_at": "2016-04-18T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d2141644", "title": "Free Webcast! Updating Statistics in SQL Server: Questions and Answers", "url": "https://kendralittle.com/2016/04/14/free-webcast-updating-statistics-in-sql-server-questions-and-answers/", "published_at": "2016-04-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d2477ddf", "title": "Change Management Template for SQL Server DBAs and Developers", "url": "https://kendralittle.com/2016/04/12/change-management-template-for-sql-server-dbas-and-deveopers/", "published_at": "2016-04-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d29867ad", "title": "New SSMS Features: Click + Drag and Click + Mouse Scroll", "url": "https://kendralittle.com/2016/04/07/new-ssms-features-click-drag-and-click-mouse-scroll/", "published_at": "2016-04-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d29a1bad", "title": "Links and Notes from SQL Server Index Formulas, Huntington Beach", "url": "https://kendralittle.com/2016/04/05/links-and-notes-from-sql-server-index-formulas-huntington-beach/", "published_at": "2016-04-05T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d3751195", "title": "Can I Force A Hinted Plan with Query Store in SQL Server 2016?", "url": "https://kendralittle.com/2016/03/31/can-i-force-a-hinted-plan-with-query-store-in-sql-server-2016/", "published_at": "2016-03-31T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d46853c7", "title": "Training Plan for Junior DBAs Learning SQL Server", "url": "https://kendralittle.com/2016/03/29/training-plan-for-junior-dbas-learning-sql-server/", "published_at": "2016-03-29T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d4a28456", "title": "NO_PLAN and NO_INDEX: Breaking a Forced Query Store Plan", "url": "https://kendralittle.com/2016/03/25/no_plan-and-no_index-breaking-a-forced-query-store-plan/", "published_at": "2016-03-25T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d502d046", "title": "3 Tricks with STATISTICS IO and STATISTICS TIME in SQL Server", "url": "https://kendralittle.com/2016/03/24/3-tricks-with-statistics-io-and-statistics-time-in-sql-server/", "published_at": "2016-03-24T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d5d34ecb", "title": "Truncate Table with Partitions Fails if You Have Non-Aligned Indexes", "url": "https://kendralittle.com/2016/03/22/truncate-table-with-partitions-fails-if-you-have-non-aligned-indexes/", "published_at": "2016-03-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d5e293d1", "title": "Learn Indexing from Kendra in Huntington Beach on April 1 for $99!", "url": "https://kendralittle.com/2016/03/18/learn-indexing-from-kendra-in-huntington-beach-on-april-1-for-99/", "published_at": "2016-03-18T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d632485e", "title": "Live Query Statistics Do Not Replace Actual Execution Plans", "url": "https://kendralittle.com/2016/03/17/live-query-statistics-dont-replace-actual-execution-plans/", "published_at": "2016-03-17T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d6bbb427", "title": "Find the Partitioning Key on an Existing Table with Partition_Ordinal", "url": "https://kendralittle.com/2016/03/15/find-the-partitioning-key-on-an-existing-table-with-partition_ordinal/", "published_at": "2016-03-15T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d6e93bb8", "title": "The Case of DATETIME2 and Partition Elimination", "url": "https://kendralittle.com/2016/03/10/the-case-of-datetime2-and-partition-elimination/", "published_at": "2016-03-10T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d7e830ec", "title": "What Resets sys.dm_db_index_usage_stats and Missing Index DMVs?", "url": "https://kendralittle.com/2016/03/07/sql-server-2016-rc0-fixes-index-usage-stats-bug-missing-indexes-still-broken/", "published_at": "2016-03-07T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d87a54b6", "title": "SQL Code Basics: Reusable Event Logging Utility", "url": "https://kendralittle.com/2016/03/03/sql-code-basics-reusable-event-logging-utility/", "published_at": "2016-03-03T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d87dd818", "title": "SQL Server YEAR() Function and Index Performance", "url": "https://kendralittle.com/2016/03/01/sql-servers-year-function-and-index-performance/", "published_at": "2016-03-01T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d87e38d4", "title": "Faking Read and Writes in SQL Server Index DMVs (Trainer Resource)", "url": "https://kendralittle.com/2016/02/25/faking-read-and-writes-in-sql-servers-index-dmvs-trainer-resource/", "published_at": "2016-02-25T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d8b56a63", "title": "Incorrect Results: Why You Should Not Ignore Patches for SQL Server", "url": "https://kendralittle.com/2016/02/22/incorrect-results-why-you-really-cant-ignore-patches-for-sql-server/", "published_at": "2016-02-22T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d998b204", "title": "How to Choose Between RCSI and Snapshot Isolation Levels", "url": "https://kendralittle.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/", "published_at": "2016-02-18T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8d9ea0bbb", "title": "Three Inspiring Articles to Read This Week", "url": "https://kendralittle.com/2016/02/16/three-inspiring-articles-to-read-this-week/", "published_at": "2016-02-16T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dad3a025", "title": "The #1 Thing to Never Do to Fix a Performance Problem", "url": "https://kendralittle.com/2016/02/11/one-thing-never-fix-performance-problem/", "published_at": "2016-02-11T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8db15455f", "title": "Warning Signs That You Have a SQL Server Backup Problem", "url": "https://kendralittle.com/2016/02/09/warning-signs-that-you-have-a-sql-server-backup-problem/", "published_at": "2016-02-09T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dbd82703", "title": "Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Server", "url": "https://kendralittle.com/2016/02/04/why-rowlock-hints-can-make-queries-slower-and-blocking-worse-in-sql-server/", "published_at": "2016-02-04T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dc1b5a9a", "title": "Sliding Window Table Partitioning: What to Decide Before You Automate", "url": "https://kendralittle.com/2016/02/02/sliding-window-table-partitioning-what-to-decide-before-you-automate/", "published_at": "2016-02-02T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dc844777", "title": "How to Check if an Index Exists on a Table in SQL Server", "url": "https://kendralittle.com/2016/01/28/how-to-check-if-an-index-exists-on-a-table-in-sql-server/", "published_at": "2016-01-28T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dd1bb105", "title": "How to Fix Lopsided Partitioned Tables", "url": "https://kendralittle.com/2016/01/26/partitioned-tables-missing-boundary-points/", "published_at": "2016-01-26T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8dd97fed0", "title": "Does Query Store Regressed Queries View Catch Nasty Parameter Sniffing?", "url": "https://kendralittle.com/2016/01/21/query-store-regression-parameter-sniffing/", "published_at": "2016-01-21T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8de7b948d", "title": "How to Find Missing Index Requests in Query Store", "url": "https://kendralittle.com/2016/01/19/find-missing-index-requests-query-store-sql-2016/", "published_at": "2016-01-19T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8df571e13", "title": "3 Things I Wish I Learned Earlier as a SQL Server DBA", "url": "https://kendralittle.com/2016/01/14/3-things-i-wish-id-learned-earlier-as-a-sql-server-dba/", "published_at": "2016-01-14T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8e04dfbe2", "title": "Useful Whitepapers for Planning SQL Server Migrations", "url": "https://kendralittle.com/2016/01/12/whitepapers-for-planning-sql-server-migrations/", "published_at": "2016-01-12T00:00:00+00:00" }, { "id": "01a08794-be28-722f-816e-19c8e0762a57", "title": "New Class! SQL Server Index Formulas: Problems and Solutions for $99 in Huntington Beach, California", "url": "https://kendralittle.com/2016/01/07/sql-server-index-formulas-problems-and-solutions-for-just-99/", "published_at": "2016-01-07T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b722bf083", "title": "Join me at SQLBits for a Day of Index Design and Tuning", "url": "https://kendralittle.com/2015/12/30/join-me-at-sqlbits-day-index-design-tuning/", "published_at": "2015-12-30T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b729bfd70", "title": "Why Teaching Makes You a Better DBA and Performance Tuner", "url": "https://kendralittle.com/2015/12/29/why-teaching-makes-you-a-better-dba-and-performance-tuner/", "published_at": "2015-12-29T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b738414ba", "title": "3 Things Every Junior SQL Server DBA Must Know", "url": "https://kendralittle.com/2015/12/23/3-things-every-junior-sql-server-dba-should-know/", "published_at": "2015-12-23T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b74239cbe", "title": "How to Write a Presentation Abstract for a Tech Conference", "url": "https://kendralittle.com/2015/12/22/how-to-write-a-presentation-abstract-for-a-tech-conference/", "published_at": "2015-12-22T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b75024a4b", "title": "3 Ways Availability Groups Beat Database Mirroring", "url": "https://kendralittle.com/2015/12/17/3-ways-availability-groups-beat-database-mirroring/", "published_at": "2015-12-17T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b75e85c6a", "title": "Free, Open License Datasets at Data.gov", "url": "https://kendralittle.com/2015/12/15/free-open-license-datasets-at-data-gov/", "published_at": "2015-12-15T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7618889c", "title": "My Wordpress Setup: Canvas, MailChimp, GravityForms and Other Tools", "url": "https://kendralittle.com/2015/12/10/wordpress-setup-canvas-woo-mailchimp/", "published_at": "2015-12-10T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b76bcf72d", "title": "Joins, Predicates, and Statistics in SQL Server", "url": "https://kendralittle.com/2015/12/08/joins-predicates-and-statistics-in-sql-server/", "published_at": "2015-12-08T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b77864f8c", "title": "Actual Number of Rows Read in SQL Server Execution Plans", "url": "https://kendralittle.com/2015/12/03/actual-number-of-rows-read-in-sql-server-execution-plans/", "published_at": "2015-12-03T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b77ff2c2a", "title": "My Six Month Plan, Post Brent Ozar Unlimited", "url": "https://kendralittle.com/2015/12/01/my-six-month-plan-post-brent-ozar-unlimited/", "published_at": "2015-12-01T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b78b3e798", "title": "Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?", "url": "https://kendralittle.com/2015/11/25/option-recompile-query-store-execution-plan/", "published_at": "2015-11-25T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7907ca38", "title": "My SQLPASS 2015 Session Evaluations", "url": "https://kendralittle.com/2015/11/24/my-sqlpass-2015-session-evaluations/", "published_at": "2015-11-24T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b79d2d3d2", "title": "Telemetry_xevents, NT SERVICE\\SQLTELEMETRY, and XE_LIVE_TARGET_TVF in SQL Server 2016", "url": "https://kendralittle.com/2015/11/19/telemetry_xevents-session-sql-server-2016/", "published_at": "2015-11-19T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7a591e9a", "title": "Did My Query Eliminate Table Partitions in SQL Server?", "url": "https://kendralittle.com/2015/11/17/did-my-query-eliminate-table-partitions-sql-server/", "published_at": "2015-11-17T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7aabdd98", "title": "Resources for Learning Python", "url": "https://kendralittle.com/2015/11/10/resources-learning-python/", "published_at": "2015-11-10T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7af404fd", "title": "Are You a Woman in Tech Working with SQL Server? Join the SQLWIT Slack Channel!", "url": "https://kendralittle.com/2015/11/05/sqlwit-slack-channel-women-who-work-with-sql/", "published_at": "2015-11-05T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7b4eaead", "title": "Taking the time to write about something makes you learn more", "url": "https://kendralittle.com/2015/08/24/frequency-illusion-and-learning/", "published_at": "2015-08-24T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7c3368f7", "title": "How I learned to write TSQL", "url": "https://kendralittle.com/2015/08/17/how-i-learned-to-write-tsql/", "published_at": "2015-08-17T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7c3e59fe", "title": "SQL Server Filtered Indexes: The Third Index Dimension", "url": "https://kendralittle.com/2015/08/11/sql-server-filtered-index-inequality-predicates/", "published_at": "2015-08-11T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7c5e2e33", "title": "The new ApprenticeshipInEducation.com, and How You Can Learn about Life in Haiti", "url": "https://kendralittle.com/2014/05/27/the-new-apprenticeshipineducation-com-and-how-you-can-learn-about-life-in-haiti/", "published_at": "2014-05-27T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7c8dd66d", "title": "Public Speaking Is Not Only Helpful for Your Audience", "url": "https://kendralittle.com/2013/11/18/public-speaking-isnt-just-for-your-audience/", "published_at": "2013-11-18T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7cac1278", "title": "DBCC USEROPTIONS: See Your Session Settings in SQL Server", "url": "https://kendralittle.com/2013/11/07/dbcc-useroptions-session-settings-sql-server/", "published_at": "2013-11-07T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7cfc3e17", "title": "My Biggest Regret as a Database Administrator", "url": "https://kendralittle.com/2012/10/30/my-biggest-regret-as-a-database-administrator/", "published_at": "2012-10-30T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7df2364f", "title": "The #1 Thing You Forget to Do Before Presenting", "url": "https://kendralittle.com/2012/10/16/the-1-forgotten-presentation-preparation-task/", "published_at": "2012-10-16T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7e0e6409", "title": "DBA Confession: Sometimes Everyone's the Slow Kid", "url": "https://kendralittle.com/2012/10/09/dba-confession-sometimes-everyones-the-slow-kid/", "published_at": "2012-10-09T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7e92118b", "title": "Conference Prep List: Pick Your Workout", "url": "https://kendralittle.com/2012/10/03/conference-preparation-list-pick-your-workout/", "published_at": "2012-10-03T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b7f4239e5", "title": "Forms of Database Torture (Illustrated)", "url": "https://kendralittle.com/2012/03/19/forms-of-database-torture-illustrated/", "published_at": "2012-03-19T00:00:00+00:00" }, { "id": "01a08794-be29-73c6-89f8-fb2b80329fc5", "title": "Are You Following Your Dream?", "url": "https://kendralittle.com/2012/03/12/are-you-following-your-dream/", "published_at": "2012-03-12T00:00:00+00:00" } ] posts Claim your blog
Back to kendralittle.com
Blog · corpus.blog/blogs/kendralittle.com/posts

kendralittle.com

kendralittle.com

2016

Finding Your Voice as a Speaker (Dear SQL DBA Episode 15)original ↗
1 Sept 2016
Do Clustered Index Columns Count Against Max Nonclustered Key Size?original ↗
30 Aug 2016
Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)original ↗
25 Aug 2016
Free Poster: tempdb data files in SQL Serveroriginal ↗
23 Aug 2016
Developer Seeks DBA Career (Dear SQL DBA, Episode 13)original ↗
18 Aug 2016
Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?original ↗
16 Aug 2016
Teach Yourself SQL Server Performance Tuning (Dear SQL DBA Episode 12)original ↗
11 Aug 2016
SSMS Tips: Templates and Control+Shift+Moriginal ↗
9 Aug 2016
Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)original ↗
4 Aug 2016
Should I Automate my Windows Updates for SQL Server? (Dear SQL DBA Episode 10)original ↗
28 Jul 2016
Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)original ↗
21 Jul 2016
Free Poster: Cat DBA Says Not Right Meoworiginal ↗
19 Jul 2016
Coming to SQL Saturday Portland? Plan a Vacation, too!original ↗
15 Jul 2016
MAXDOP of Confusion (Dear SQL DBA Episode 8)original ↗
14 Jul 2016
Is User Acceptance Testing Covered Under Developer Edition?original ↗
12 Jul 2016
How to Level Up Your DBA Career (Dear SQL DBA)original ↗
7 Jul 2016
Which Indexes are Disk Based in SQL Server?original ↗
5 Jul 2016
Index Usage Stats Insanity - the oddities of sys.dm db index usage stats (Dear SQL DBA)original ↗
30 Jun 2016
SPLIT in a LEFT Partition Function: Where Does the Above-Boundary Data Go?original ↗
28 Jun 2016
Learn Index Tuning at the PASS Summit in 2016!original ↗
24 Jun 2016
Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)original ↗
23 Jun 2016
Will Query Store Work in a Read Only Database?original ↗
21 Jun 2016
Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)original ↗
16 Jun 2016
Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016original ↗
14 Jun 2016
Next Door to Derpton - When Your Fellow DBA is a Danger to Databases (Dear SQL DBA)original ↗
9 Jun 2016
Merging Boundary Points: Does a Changing Partition_Number Indicate Data Movement?original ↗
7 Jun 2016
Lost in Performance Troubleshooting - Perf Triage for SQL Serveroriginal ↗
2 Jun 2016
Testing an Insert for Race Conditions with Ostress.exeoriginal ↗
31 May 2016
Bleeding In Edgeville - When Upgrades Come Too Fast (Dear SQL DBA)original ↗
26 May 2016
The Case of the Blocking Merge Statement (LCK_M_RS_U locks)original ↗
24 May 2016
Blogger Tip: Easy Free-Use Images with Pablo by Bufferoriginal ↗
19 May 2016
Index Usage Stats Bug Fixed in SQL Server 2012 SP2 CU12 / SP3 CU3original ↗
18 May 2016
Sabbatical Update: 4 Months of Fun and Reflectionoriginal ↗
17 May 2016
Submit a Dear DBA Questionoriginal ↗
12 May 2016
Indexes: Do Included Columns Always Go on a Non-Root Page? (video)original ↗
10 May 2016
How to Script Out Indexes from SQL Serveroriginal ↗
5 May 2016
Why Table Partitioning Does Not Speed Up Query Performance (video)original ↗
3 May 2016
Required Testing for Installing SQL Server Cumulative Updates and Service Packsoriginal ↗
28 Apr 2016
What is the Difference between a Junior and Senior DBA?original ↗
26 Apr 2016
Managing Statistics in SQL Server for DBAs (videos)original ↗
21 Apr 2016
Updating Statistics in SQL Server: Maintenance Questions & Answersoriginal ↗
18 Apr 2016
Free Webcast! Updating Statistics in SQL Server: Questions and Answersoriginal ↗
14 Apr 2016
Change Management Template for SQL Server DBAs and Developersoriginal ↗
12 Apr 2016
New SSMS Features: Click + Drag and Click + Mouse Scrolloriginal ↗
7 Apr 2016
Links and Notes from SQL Server Index Formulas, Huntington Beachoriginal ↗
5 Apr 2016
Can I Force A Hinted Plan with Query Store in SQL Server 2016?original ↗
31 Mar 2016
Training Plan for Junior DBAs Learning SQL Serveroriginal ↗
29 Mar 2016
NO_PLAN and NO_INDEX: Breaking a Forced Query Store Planoriginal ↗
25 Mar 2016
3 Tricks with STATISTICS IO and STATISTICS TIME in SQL Serveroriginal ↗
24 Mar 2016
Truncate Table with Partitions Fails if You Have Non-Aligned Indexesoriginal ↗
22 Mar 2016
Learn Indexing from Kendra in Huntington Beach on April 1 for $99!original ↗
18 Mar 2016
Live Query Statistics Do Not Replace Actual Execution Plansoriginal ↗
17 Mar 2016
Find the Partitioning Key on an Existing Table with Partition_Ordinaloriginal ↗
15 Mar 2016
The Case of DATETIME2 and Partition Eliminationoriginal ↗
10 Mar 2016
What Resets sys.dm_db_index_usage_stats and Missing Index DMVs?original ↗
7 Mar 2016
SQL Code Basics: Reusable Event Logging Utilityoriginal ↗
3 Mar 2016
SQL Server YEAR() Function and Index Performanceoriginal ↗
1 Mar 2016
Faking Read and Writes in SQL Server Index DMVs (Trainer Resource)original ↗
25 Feb 2016
Incorrect Results: Why You Should Not Ignore Patches for SQL Serveroriginal ↗
22 Feb 2016
How to Choose Between RCSI and Snapshot Isolation Levelsoriginal ↗
18 Feb 2016
Three Inspiring Articles to Read This Weekoriginal ↗
16 Feb 2016
The #1 Thing to Never Do to Fix a Performance Problemoriginal ↗
11 Feb 2016
Warning Signs That You Have a SQL Server Backup Problemoriginal ↗
9 Feb 2016
Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Serveroriginal ↗
4 Feb 2016
Sliding Window Table Partitioning: What to Decide Before You Automateoriginal ↗
2 Feb 2016
How to Check if an Index Exists on a Table in SQL Serveroriginal ↗
28 Jan 2016
How to Fix Lopsided Partitioned Tablesoriginal ↗
26 Jan 2016
Does Query Store Regressed Queries View Catch Nasty Parameter Sniffing?original ↗
21 Jan 2016
How to Find Missing Index Requests in Query Storeoriginal ↗
19 Jan 2016
3 Things I Wish I Learned Earlier as a SQL Server DBAoriginal ↗
14 Jan 2016
Useful Whitepapers for Planning SQL Server Migrationsoriginal ↗
12 Jan 2016
New Class! SQL Server Index Formulas: Problems and Solutions for $99 in Huntington Beach, Californiaoriginal ↗
7 Jan 2016

2015

Join me at SQLBits for a Day of Index Design and Tuningoriginal ↗
30 Dec 2015
Why Teaching Makes You a Better DBA and Performance Tuneroriginal ↗
29 Dec 2015
3 Things Every Junior SQL Server DBA Must Knoworiginal ↗
23 Dec 2015
How to Write a Presentation Abstract for a Tech Conferenceoriginal ↗
22 Dec 2015
3 Ways Availability Groups Beat Database Mirroringoriginal ↗
17 Dec 2015
Free, Open License Datasets at Data.govoriginal ↗
15 Dec 2015
My Wordpress Setup: Canvas, MailChimp, GravityForms and Other Toolsoriginal ↗
10 Dec 2015
Joins, Predicates, and Statistics in SQL Serveroriginal ↗
8 Dec 2015
Actual Number of Rows Read in SQL Server Execution Plansoriginal ↗
3 Dec 2015
My Six Month Plan, Post Brent Ozar Unlimitedoriginal ↗
1 Dec 2015
Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan?original ↗
25 Nov 2015
My SQLPASS 2015 Session Evaluationsoriginal ↗
24 Nov 2015
Telemetry_xevents, NT SERVICE\SQLTELEMETRY, and XE_LIVE_TARGET_TVF in SQL Server 2016original ↗
19 Nov 2015
Did My Query Eliminate Table Partitions in SQL Server?original ↗
17 Nov 2015
Resources for Learning Pythonoriginal ↗
10 Nov 2015
Are You a Woman in Tech Working with SQL Server? Join the SQLWIT Slack Channel!original ↗
5 Nov 2015
Taking the time to write about something makes you learn moreoriginal ↗
24 Aug 2015
How I learned to write TSQLoriginal ↗
17 Aug 2015
SQL Server Filtered Indexes: The Third Index Dimensionoriginal ↗
11 Aug 2015

2014

The new ApprenticeshipInEducation.com, and How You Can Learn about Life in Haitioriginal ↗
27 May 2014

2013

Public Speaking Is Not Only Helpful for Your Audienceoriginal ↗
18 Nov 2013
DBCC USEROPTIONS: See Your Session Settings in SQL Serveroriginal ↗
7 Nov 2013

2012

My Biggest Regret as a Database Administratororiginal ↗
30 Oct 2012
The #1 Thing You Forget to Do Before Presentingoriginal ↗
16 Oct 2012
DBA Confession: Sometimes Everyone's the Slow Kidoriginal ↗
9 Oct 2012
Conference Prep List: Pick Your Workoutoriginal ↗
3 Oct 2012
Forms of Database Torture (Illustrated)original ↗
19 Mar 2012
Are You Following Your Dream?original ↗
12 Mar 2012
Previous Next