corpus.blog
41554 blogs · [ { "id": "01a08794-be26-70a0-b282-042d6a6e8c77", "title": "Dear SQL DBA: Why I Rarely Mention Service Broker", "url": "https://kendralittle.com/2018/07/19/dear-sql-dba-why-dont-you-teach-service-broker/", "published_at": "2018-07-19T00:00:00+00:00" }, { "id": "01a08794-be26-70a0-b282-042d6a9cd9d7", "title": "The BREAK Keyword in Transact SQL", "url": "https://kendralittle.com/2018/07/16/break-in-transact-sql/", "published_at": "2018-07-16T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12197e6652", "title": "What the Microsoft MVP Award Means to Me in 2018", "url": "https://kendralittle.com/2018/07/11/what-the-microsoft-mvp-program-means-to-me-in-2018/", "published_at": "2018-07-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121a1d3340", "title": "Using RETURN in Transact SQL: Quiz Results", "url": "https://kendralittle.com/2018/07/09/using-return-in-transact-sql-quiz-results/", "published_at": "2018-07-09T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121a528799", "title": "The Right to Be Erased is Coming to California, Along with Other Privacy Rights", "url": "https://kendralittle.com/2018/07/05/the-right-to-be-erased-is-coming-to-california-along-with-other-privacy-rights/", "published_at": "2018-07-05T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121add23c8", "title": "Find the Scalar Function Call: What It Means When It Hides in Probe Residual", "url": "https://kendralittle.com/2018/07/02/find-the-scalar-function-call-what-it-means-if-its-hiding-in-probe-residual/", "published_at": "2018-07-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121b822fe1", "title": "ORDER BY, OFFSET, and Fetch in TSQL", "url": "https://kendralittle.com/2018/06/29/order-by-offset-and-fetch-in-tsql/", "published_at": "2018-06-29T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121c7f77b6", "title": "New Courses: Extended Events, Parallelism, Indexes, and More", "url": "https://kendralittle.com/2018/06/22/new-courses-extended-events-parallelism-indexes-and-more/", "published_at": "2018-06-22T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121d57b403", "title": "AVG() in TSQL: Watch Your Data Types", "url": "https://kendralittle.com/2018/06/21/avg-in-tsql-watch-your-datatypes/", "published_at": "2018-06-21T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121e13c7c3", "title": "Dear SQL DBA: Training Resources for SQL Newbies", "url": "https://kendralittle.com/2018/06/14/dear-sql-dba-training-resources-for-sql-newbies/", "published_at": "2018-06-14T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121ea2a0e4", "title": "Perks for My SQLPASS Summit Precon: Prevent Fake News in Your Data! Isolation Levels Demystified", "url": "https://kendralittle.com/2018/06/12/perks-for-my-sqlpass-summit-precon-prevent-fake-news-in-your-data-isolation-levels-demystified/", "published_at": "2018-06-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da121f889082", "title": "Two Free Sessions Next Week: Fighting Bad Data and Deadlocks", "url": "https://kendralittle.com/2018/06/07/two-free-sessions-next-week-fighting-bad-data-and-deadlocks/", "published_at": "2018-06-07T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122007fff5", "title": "Row Width Impact on Version Store Usage under Snapshot Isolation", "url": "https://kendralittle.com/2018/05/28/row-width-impact-on-version-store-usage-under-snapshot-isolation/", "published_at": "2018-05-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1220a3968e", "title": "Code: Fixing a Filtered Index Which is Causing Data Modifications to Fail", "url": "https://kendralittle.com/2018/05/23/code-fixing-a-filtered-index-which-is-causing-data-modifications-to-fail/", "published_at": "2018-05-23T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122175f190", "title": "Free Session! DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario", "url": "https://kendralittle.com/2018/05/22/free-session-dba-vs-deadlock-how-to-out-index-a-deadly-blocking-scenario/", "published_at": "2018-05-22T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1221d02597", "title": "What is Deferred Name Resolution, and How Can It Go Wrong?", "url": "https://kendralittle.com/2018/05/21/what-is-deferred-name-resolution-and-how-can-it-go-wrong/", "published_at": "2018-05-21T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1222ae5a8c", "title": "Dear SQL DBA: Dealing With a Lack of Control", "url": "https://kendralittle.com/2018/05/18/dear-sql-dba-dealing-with-a-lack-of-control/", "published_at": "2018-05-18T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122307880d", "title": "Fake News about Auto Parameterization/Simple Parameterization", "url": "https://kendralittle.com/2018/05/04/fake-news-about-auto-parameterization-simple-parameterization/", "published_at": "2018-05-04T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1223703e77", "title": "Dear SQL DBA: Do DBAs Need a College Degree?", "url": "https://kendralittle.com/2018/05/03/dear-sql-dba-do-dbas-need-a-college-degree/", "published_at": "2018-05-03T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1223ebfe66", "title": "Dear SQL DBA: How Do I Prepare for Certification Exams? (video)", "url": "https://kendralittle.com/2018/04/23/dear-sql-dba-how-do-i-prepare-for-certification-exams-video-with-captions-and-transcript/", "published_at": "2018-04-23T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12247c9cb3", "title": "Query Store Cleanup Can be Part of a Blocking Chain", "url": "https://kendralittle.com/2018/04/18/query-store-cleanup-can-be-part-of-a-blocking-chain/", "published_at": "2018-04-18T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1224a12fc0", "title": "Dear SQL DBA Q&A: A Poorly Indexed ISV Database", "url": "https://kendralittle.com/2018/04/16/dear-sql-dba-qa-a-poorly-indexed-isv-database/", "published_at": "2018-04-16T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122511128f", "title": "A Case of Inconsistent Wait Stats and Query Duration", "url": "https://kendralittle.com/2018/04/11/a-case-of-inconsistent-wait-stats-and-query-duration/", "published_at": "2018-04-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1225fb68f7", "title": "Free Webcast: DBA vs Memory Settings", "url": "https://kendralittle.com/2018/04/11/upcoming-free-webcast-dba-vs-memory-settings/", "published_at": "2018-04-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1226eb92f9", "title": "Register for My Free Session on Execution Plan Forcing", "url": "https://kendralittle.com/2018/04/09/register-for-my-free-session-on-execution-plan-forcing/", "published_at": "2018-04-09T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1227881108", "title": "Dear SQL DBA: I Want to Work for Myself (video with captions and transcript)", "url": "https://kendralittle.com/2018/04/06/dear-sql-dba-i-want-to-work-for-myself-video-with-captions/", "published_at": "2018-04-06T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1227eb42b5", "title": "Adaptive Queries in Standard Edition: Interleaved Exec for Multi-Statement TVFs", "url": "https://kendralittle.com/2018/04/04/adaptive-queries-in-standard-edition-interleaved-exec-for-multi-statement-tvfs/", "published_at": "2018-04-04T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1227ecb857", "title": "Remembering Robert Davis, aka @SQLSoldier", "url": "https://kendralittle.com/2018/04/03/remembering-robert-davis-aka-sqlsoldier/", "published_at": "2018-04-03T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122887112f", "title": "Sys.dm_db_tuning_recommendations Makes Suggestions if Automatic Tuning is Not Enabled", "url": "https://kendralittle.com/2018/04/02/sys-dm_db_tuning_recommendations-makes-suggestions-if-automatic-tuning-isnt-enabled/", "published_at": "2018-04-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1228e8746a", "title": "Auto-Tuning: Automatic Plan Correction is Cleared on Restart", "url": "https://kendralittle.com/2018/03/28/auto-tuning-automatic-plan-correction-is-cleared-on-restart/", "published_at": "2018-03-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12299b1285", "title": "Partitioned Tables: Rolling/Rotating/Round-Robining Partitions", "url": "https://kendralittle.com/2018/03/26/partitioned-tables-rolling-rotating-round-robining-partitions/", "published_at": "2018-03-26T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122a444eef", "title": "Why Is My Function Missing From sys.dm_exec_query_stats and Query Store?", "url": "https://kendralittle.com/2018/03/21/why-isnt-my-function-in-the-sys-dm_exec_query_stats-dynamic-management-view-and-in-query-store/", "published_at": "2018-03-21T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122a8d9c63", "title": "Adding a Downloadable Calendar Event File to Wordpress without a Plugin", "url": "https://kendralittle.com/2018/03/19/adding-a-downloadable-calendar-event-file-to-wordpress-without-a-plugin/", "published_at": "2018-03-19T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122b384e25", "title": "New Course: Why Table Partitioning Does Not Speed Up Query Performance – With One Exception", "url": "https://kendralittle.com/2018/03/15/new-course-why-table-partitioning-does-not-speed-up-query-performance-with-one-exception/", "published_at": "2018-03-15T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122b55eb4c", "title": "The Case of MAX() Requiring an Index Scan, While TOP(1)/ORDER BY DESC Does Not", "url": "https://kendralittle.com/2018/03/14/the-case-of-max-requiring-an-index-scan-while-top1-order-by-desc-does-not/", "published_at": "2018-03-14T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122c5422ae", "title": "SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)", "url": "https://kendralittle.com/2018/03/13/sql-server-2026-bagi-edition-tsql2sday-100/", "published_at": "2018-03-13T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122d2f4290", "title": "New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels", "url": "https://kendralittle.com/2018/03/12/new-free-webinars-index-tuning-free-qa-and-isolation-levels/", "published_at": "2018-03-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122de74975", "title": "What is a Morally Equivalent Execution Plan, and Why Is It Useful?", "url": "https://kendralittle.com/2018/03/12/what-is-a-morally-equivalent-execution-plan-and-why-is-it-good/", "published_at": "2018-03-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122eb8f916", "title": "New Free Posters & Desktop Backgrounds for Download", "url": "https://kendralittle.com/2018/03/08/new-free-posters-desktop-backgrounds-for-download/", "published_at": "2018-03-08T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122ec2bc47", "title": "EstimateRowsWithoutRowGoal helps you see: is it a statistics problem?", "url": "https://kendralittle.com/2018/03/07/estimaterowswithoutrowgoal-helps-you-see-is-it-a-statistics-problem/", "published_at": "2018-03-07T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da122fa647a1", "title": "Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”", "url": "https://kendralittle.com/2018/03/07/overheard-i-just-think-theres-not-that-many-women-who-enjoy-coding-and-i-say-that-based-on-my-daughter-too/", "published_at": "2018-03-07T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1230909b3b", "title": "Forced Plan Confusion: Is_Forced vs Use Plan = True", "url": "https://kendralittle.com/2018/03/05/forced-plan-confusion-is_forced-vs-use-plan-true/", "published_at": "2018-03-05T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1231089f1c", "title": "Why I Love the Automatic Plan Correction Auto-Tuning Feature", "url": "https://kendralittle.com/2018/03/01/why-i-love-the-automatic-plan-correction-auto-tuning-feature/", "published_at": "2018-03-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1231fda70b", "title": "Can I Force Multiple Plans for a Query in Query Store?", "url": "https://kendralittle.com/2018/02/28/can-i-force-multiple-plans-for-a-query-in-query-store/", "published_at": "2018-02-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1232a9d48b", "title": "Infographic: Conference Prep for Anxious Folk", "url": "https://kendralittle.com/2018/02/26/infographic-conference-prep-for-anxious-folk/", "published_at": "2018-02-26T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1232be80e0", "title": "Using YouTube Captions & Transcript to Find Content in a Long Video", "url": "https://kendralittle.com/2018/02/23/using-youtube-captions-transcript-to-find-content-in-a-long-video/", "published_at": "2018-02-23T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123376bd62", "title": "When Should I Use Explicit Transactions for Single Statements?", "url": "https://kendralittle.com/2018/02/22/when-should-i-use-explicit-transactions-for-single-statements/", "published_at": "2018-02-22T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12340b1daf", "title": "New SQLChallenge: Defuse the Deadlock", "url": "https://kendralittle.com/2018/02/20/new-sqlchallenge-defuse-the-deadlock/", "published_at": "2018-02-20T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1234d67d5a", "title": "When Were Statistics Last Updated for a Heap?", "url": "https://kendralittle.com/2018/02/16/when-were-statistics-last-updated-for-a-heap/", "published_at": "2018-02-16T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1234fd5fd0", "title": "How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)", "url": "https://kendralittle.com/2018/02/13/how-i-accidentally-found-a-passion-for-plants-tsql2sday/", "published_at": "2018-02-13T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12359a1b74", "title": "Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions", "url": "https://kendralittle.com/2018/02/08/formatting-a-vtt-caption-file-into-a-transcript-with-sublime-text-and-multiple-regular-expressions/", "published_at": "2018-02-08T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1235f2c17d", "title": "Does a Clustered Index Give a Default Ordering?", "url": "https://kendralittle.com/2018/02/02/does-a-clustered-index-give-a-default-ordering/", "published_at": "2018-02-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1235f8ac0b", "title": "Watch my live session: When Partitioning Indexes Hurts Performance (and How to Fix It)", "url": "https://kendralittle.com/2018/01/25/watch-my-live-session-when-partitioning-indexes-hurts-performance-and-how-to-fix-it/", "published_at": "2018-01-25T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12366cf3a0", "title": "Watch the first lesson in my new Repeatable Read and Serializable Isolation Levels course! (Video with transcript and captions)", "url": "https://kendralittle.com/2017/12/18/watch-the-first-lesson-in-my-new-repeatable-read-and-serializable-isolation-levels-course-video-with-transcript-and-captions/", "published_at": "2017-12-18T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12371cfe9f", "title": "New Course: Indexing for Windowing Functions (with preview lesson)", "url": "https://kendralittle.com/2017/12/11/new-course-indexing-for-windowing-functions-with-preview-lessonhttps-sqlworkbooks-com-shop-online-sql-server-video-training-indexing-for-window-functions/", "published_at": "2017-12-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123727661b", "title": "New free webcasts! How keys & includes work, dirty secrets of NOLOCK, and more", "url": "https://kendralittle.com/2017/12/06/new-free-webcasts-how-keys-includes-work-dirty-secrets-of-nolock-and-more/", "published_at": "2017-12-06T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12372bce04", "title": "Auto-Tuning and the #1 Mindset Problem I Had as a DBA", "url": "https://kendralittle.com/2017/12/04/auto-tuning-and-the-1-mindset-problem-i-had-as-a-dba/", "published_at": "2017-12-04T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12373c122d", "title": "In-Memory OLTP and Isolation Levels in SQL Server (Webcast Video with Transcript)", "url": "https://kendralittle.com/2017/12/01/in-memory-oltp-and-isolation-levels-in-sql-server-webcast-video/", "published_at": "2017-12-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1237eec0be", "title": "Where are key columns stored in a nonclustered index in SQL Server?", "url": "https://kendralittle.com/2017/11/29/where-are-key-columns-stored-in-a-nonclustered-index-in-sql-server/", "published_at": "2017-11-29T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1238a644b5", "title": "Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers", "url": "https://kendralittle.com/2017/11/20/slowing-down-your-motor-mouth-presentation-tips-for-fast-talkers/", "published_at": "2017-11-20T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1238eea87f", "title": "Attempting to Force a Narrow Plan on an Update with Query Store", "url": "https://kendralittle.com/2017/11/15/attempting-to-force-a-narrow-plan-on-an-update-with-query-store/", "published_at": "2017-11-15T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1239e13f2b", "title": "Kalen Delaney and Inspiration for Adventure", "url": "https://kendralittle.com/2017/11/14/tsql2sday-96-kalen-delaneys-inspiration-for-adventure/", "published_at": "2017-11-14T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123a2eb765", "title": "The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Wait", "url": "https://kendralittle.com/2017/11/09/the-case-of-the-weirdly-long-columnstore_build_throttle-wait/", "published_at": "2017-11-09T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123a9e8c5f", "title": "Things I Learned from Speaker Idol 2017 at the SQL PASS Summit", "url": "https://kendralittle.com/2017/11/09/things-i-learned-from-speaker-idol-2017-at-the-sql-pass-summit/", "published_at": "2017-11-09T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123b3dd370", "title": "I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)", "url": "https://kendralittle.com/2017/11/08/dear-sql-dba-i-thought-i-was-an-introvert-turns-out-i-was-anxious-as/", "published_at": "2017-11-08T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123bf6d15c", "title": "SQL PASS Summit 2017 Day 2 - Keynote Notes and Ideas", "url": "https://kendralittle.com/2017/11/02/sql-pass-summit-2017-day-2-keynote-and-ideas/", "published_at": "2017-11-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123c6a40c6", "title": "SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories", "url": "https://kendralittle.com/2017/11/01/sql-pass-summit-2017-day-1-keynote-thoughts-and-memories/", "published_at": "2017-11-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123c996048", "title": "Locked Pages, Working Set, and Private Bytes", "url": "https://kendralittle.com/2017/10/19/locked-pages-working-set-and-private-bytes/", "published_at": "2017-10-19T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123cb592b6", "title": "My Two Sessions at the SQL PASS Summit 2017", "url": "https://kendralittle.com/2017/10/12/im-giving-two-sessions-at-the-sql-pass-summit/", "published_at": "2017-10-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123cfc96fb", "title": "The Death of SQL Server Service Packs", "url": "https://kendralittle.com/2017/10/06/the-death-of-sql-server-service-packs/", "published_at": "2017-10-06T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123dbea0ee", "title": "IO Patterns for Index Seeks: There May be a Lot of Read Ahead Reads", "url": "https://kendralittle.com/2017/10/04/io-patterns-for-index-seeks-there-may-be-a-lot-of-read-ahead-reads/", "published_at": "2017-10-04T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123e8749da", "title": "Love and Hate for SSMS", "url": "https://kendralittle.com/2017/09/29/love-and-hate-for-ssms/", "published_at": "2017-09-29T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123f283dc1", "title": "New Free Webcasts for November and December 2017", "url": "https://kendralittle.com/2017/09/28/new-free-webcasts-for-november-and-december-2017/", "published_at": "2017-09-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123f446d90", "title": "How Do I Analyze a SQL Server Execution Plan?", "url": "https://kendralittle.com/2017/09/22/how-do-i-analyze-a-sql-server-execution-plan/", "published_at": "2017-09-22T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da123fc263f4", "title": "The Case of the Rowgroup Deadlock in a Columnstore Index", "url": "https://kendralittle.com/2017/09/21/the-case-of-the-rowgroup-deadlock-in-a-columnstore-index/", "published_at": "2017-09-21T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12402c3ad3", "title": "Do I Need to Master PowerShell?", "url": "https://kendralittle.com/2017/09/12/do-i-need-to-master-powershell/", "published_at": "2017-09-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124042781d", "title": "SSMS Shortcuts & Secrets - Live Webcast Edition (video)", "url": "https://kendralittle.com/2017/09/11/ssms-shortcuts-secrets-live-webcast-edition-video/", "published_at": "2017-09-11T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1241210382", "title": "SQL PASS Summit 2017: Tips on Attending", "url": "https://kendralittle.com/2017/09/07/sql-pass-summit-2017-why-im-excited-and-tips-on-attending/", "published_at": "2017-09-07T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124219eb41", "title": "Shortcut Update: Toggling Intellisense in SSMS", "url": "https://kendralittle.com/2017/09/06/shortcut-update-toggling-intellisense-in-ssms/", "published_at": "2017-09-06T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12430812c3", "title": "How Do You Stay Motivated? (Dear SQL DBA Episode 47)", "url": "https://kendralittle.com/2017/09/01/how-do-you-stay-motivated-dear-sql-dba-episode-47/", "published_at": "2017-09-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124364c963", "title": "Why Did My Clever Index Change Backfire? (free video)", "url": "https://kendralittle.com/2017/08/30/why-did-my-clever-index-change-backfire-free-video/", "published_at": "2017-08-30T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1244033d1f", "title": "You faked your resume... now what? (video with transcript)", "url": "https://kendralittle.com/2017/08/25/i-faked-my-resume-now-what/", "published_at": "2017-08-25T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1244208ba4", "title": "sp_query_store_flush_db, Query Store, and Backups", "url": "https://kendralittle.com/2017/08/23/sp_query_store_flush_db-query-store-and-backups/", "published_at": "2017-08-23T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1244b56ea4", "title": "How to Get Email Notifications for TSQLTuesday", "url": "https://kendralittle.com/2017/08/21/how-to-get-email-notifications-for-tsqltuesday/", "published_at": "2017-08-21T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12452d2bd6", "title": "Recruiters, Nerves, and Saying No in Interviews (video with transcript)", "url": "https://kendralittle.com/2017/08/17/interview-advice-from-the-sql-server-community-video-or-transcript/", "published_at": "2017-08-17T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1245c51ef5", "title": "Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community", "url": "https://kendralittle.com/2017/08/14/interviewing-patterns-anti-patterns-advice-from-the-sql-server-community/", "published_at": "2017-08-14T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1246406b5d", "title": "Do Index Changes Remove Execution Plans from Cache?", "url": "https://kendralittle.com/2017/08/09/do-index-changes-remove-execution-plans-from-cache/", "published_at": "2017-08-09T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1246409b20", "title": "The Story of an Interview Flop", "url": "https://kendralittle.com/2017/08/08/interview-patterns-anti-patterns-tsql-tuesday-93/", "published_at": "2017-08-08T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1247210786", "title": "Running SQL Server in a Docker Container on a Mac", "url": "https://kendralittle.com/2017/08/02/running-sql-server-in-a-docker-container-on-a-mac/", "published_at": "2017-08-02T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1247848455", "title": "TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns", "url": "https://kendralittle.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/", "published_at": "2017-08-01T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da1247e212fe", "title": "The COMPRESS() TSQL Function in SQL Server 2016+", "url": "https://kendralittle.com/2017/07/31/the-compress-tsql-function-in-sql-server-2016/", "published_at": "2017-07-31T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124854c855", "title": "Desktop Wallpapers and Webcasts on Isolation Levels and Memory", "url": "https://kendralittle.com/2017/07/28/desktop-wallpapers-and-webcasts-on-isolation-levels-and-memory/", "published_at": "2017-07-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12494c96e8", "title": "Downloadable SQL Server Desktop Wallpapers", "url": "https://kendralittle.com/2017/07/26/downloadable-sql-server-desktop-wallpapers/", "published_at": "2017-07-26T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da12496172a1", "title": "Did that Query Eliminate Partitions? (videos)", "url": "https://kendralittle.com/2017/07/19/did-that-query-eliminate-partitions-videos/", "published_at": "2017-07-19T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124a24f800", "title": "IF Statement Branching and Parameter Sniffing", "url": "https://kendralittle.com/2017/07/12/if-statement-branching-and-parameter-sniffing/", "published_at": "2017-07-12T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124ae3f351", "title": "Index Rebuild, Reorganize, and Statistics in Maintenance Plans in SQL Server 2016", "url": "https://kendralittle.com/2017/07/05/index-rebuild-reorganize-and-statistics-in-maintenance-plans-in-sql-server-2016/", "published_at": "2017-07-05T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124b68cd75", "title": "New Free Webcasts on Interviewing and Indexing", "url": "https://kendralittle.com/2017/06/29/new-free-webcasts-on-interviewing-and-indexing/", "published_at": "2017-06-29T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124bb6aaa0", "title": "Using sp_WhoIsActive with Temp Tables to Limit Data Collected", "url": "https://kendralittle.com/2017/06/28/using-sp_whoisactive-with-temp-tables-to-limit-data-collected/", "published_at": "2017-06-28T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124c2b6e78", "title": "Join me for Why Did My Clever Index Change Backfire? at the 24 Hours of PASS", "url": "https://kendralittle.com/2017/06/23/join-me-for-why-did-my-clever-index-change-backfire-at-the-24-hours-of-pass/", "published_at": "2017-06-23T00:00:00+00:00" }, { "id": "01a08794-be27-7131-a235-da124c6d49e1", "title": "How to Enable the Debug Channel in Extended Events for the Query Thread Profile XEvent in SQL Sever 2014+", "url": "https://kendralittle.com/2017/06/19/how-to-enabletrace-the-query-thread-profile-extended-event-in-sql-sever-2014/", "published_at": "2017-06-19T00:00:00+00:00" } ] posts Claim your blog
Back to kendralittle.com
Blog · corpus.blog/blogs/kendralittle.com/posts

kendralittle.com

kendralittle.com

2018

Dear SQL DBA: Why I Rarely Mention Service Brokeroriginal ↗
19 Jul 2018
The BREAK Keyword in Transact SQLoriginal ↗
16 Jul 2018
What the Microsoft MVP Award Means to Me in 2018original ↗
11 Jul 2018
Using RETURN in Transact SQL: Quiz Resultsoriginal ↗
9 Jul 2018
The Right to Be Erased is Coming to California, Along with Other Privacy Rightsoriginal ↗
5 Jul 2018
Find the Scalar Function Call: What It Means When It Hides in Probe Residualoriginal ↗
2 Jul 2018
ORDER BY, OFFSET, and Fetch in TSQLoriginal ↗
29 Jun 2018
New Courses: Extended Events, Parallelism, Indexes, and Moreoriginal ↗
22 Jun 2018
AVG() in TSQL: Watch Your Data Typesoriginal ↗
21 Jun 2018
Dear SQL DBA: Training Resources for SQL Newbiesoriginal ↗
14 Jun 2018
Perks for My SQLPASS Summit Precon: Prevent Fake News in Your Data! Isolation Levels Demystifiedoriginal ↗
12 Jun 2018
Two Free Sessions Next Week: Fighting Bad Data and Deadlocksoriginal ↗
7 Jun 2018
Row Width Impact on Version Store Usage under Snapshot Isolationoriginal ↗
28 May 2018
Code: Fixing a Filtered Index Which is Causing Data Modifications to Failoriginal ↗
23 May 2018
Free Session! DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenariooriginal ↗
22 May 2018
What is Deferred Name Resolution, and How Can It Go Wrong?original ↗
21 May 2018
Dear SQL DBA: Dealing With a Lack of Controloriginal ↗
18 May 2018
Fake News about Auto Parameterization/Simple Parameterizationoriginal ↗
4 May 2018
Dear SQL DBA: Do DBAs Need a College Degree?original ↗
3 May 2018
Dear SQL DBA: How Do I Prepare for Certification Exams? (video)original ↗
23 Apr 2018
Query Store Cleanup Can be Part of a Blocking Chainoriginal ↗
18 Apr 2018
Dear SQL DBA Q&A: A Poorly Indexed ISV Databaseoriginal ↗
16 Apr 2018
A Case of Inconsistent Wait Stats and Query Durationoriginal ↗
11 Apr 2018
Free Webcast: DBA vs Memory Settingsoriginal ↗
11 Apr 2018
Register for My Free Session on Execution Plan Forcingoriginal ↗
9 Apr 2018
Dear SQL DBA: I Want to Work for Myself (video with captions and transcript)original ↗
6 Apr 2018
Adaptive Queries in Standard Edition: Interleaved Exec for Multi-Statement TVFsoriginal ↗
4 Apr 2018
Remembering Robert Davis, aka @SQLSoldieroriginal ↗
3 Apr 2018
Sys.dm_db_tuning_recommendations Makes Suggestions if Automatic Tuning is Not Enabledoriginal ↗
2 Apr 2018
Auto-Tuning: Automatic Plan Correction is Cleared on Restartoriginal ↗
28 Mar 2018
Partitioned Tables: Rolling/Rotating/Round-Robining Partitionsoriginal ↗
26 Mar 2018
Why Is My Function Missing From sys.dm_exec_query_stats and Query Store?original ↗
21 Mar 2018
Adding a Downloadable Calendar Event File to Wordpress without a Pluginoriginal ↗
19 Mar 2018
New Course: Why Table Partitioning Does Not Speed Up Query Performance – With One Exceptionoriginal ↗
15 Mar 2018
The Case of MAX() Requiring an Index Scan, While TOP(1)/ORDER BY DESC Does Notoriginal ↗
14 Mar 2018
SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)original ↗
13 Mar 2018
New Free Webinars! Index Tuning, Free Q&A, and Isolation Levelsoriginal ↗
12 Mar 2018
What is a Morally Equivalent Execution Plan, and Why Is It Useful?original ↗
12 Mar 2018
New Free Posters & Desktop Backgrounds for Downloadoriginal ↗
8 Mar 2018
EstimateRowsWithoutRowGoal helps you see: is it a statistics problem?original ↗
7 Mar 2018
Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”original ↗
7 Mar 2018
Forced Plan Confusion: Is_Forced vs Use Plan = Trueoriginal ↗
5 Mar 2018
Why I Love the Automatic Plan Correction Auto-Tuning Featureoriginal ↗
1 Mar 2018
Can I Force Multiple Plans for a Query in Query Store?original ↗
28 Feb 2018
Infographic: Conference Prep for Anxious Folkoriginal ↗
26 Feb 2018
Using YouTube Captions & Transcript to Find Content in a Long Videooriginal ↗
23 Feb 2018
When Should I Use Explicit Transactions for Single Statements?original ↗
22 Feb 2018
New SQLChallenge: Defuse the Deadlockoriginal ↗
20 Feb 2018
When Were Statistics Last Updated for a Heap?original ↗
16 Feb 2018
How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)original ↗
13 Feb 2018
Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressionsoriginal ↗
8 Feb 2018
Does a Clustered Index Give a Default Ordering?original ↗
2 Feb 2018
Watch my live session: When Partitioning Indexes Hurts Performance (and How to Fix It)original ↗
25 Jan 2018

2017

Watch the first lesson in my new Repeatable Read and Serializable Isolation Levels course! (Video with transcript and captions)original ↗
18 Dec 2017
New Course: Indexing for Windowing Functions (with preview lesson)original ↗
11 Dec 2017
New free webcasts! How keys & includes work, dirty secrets of NOLOCK, and moreoriginal ↗
6 Dec 2017
Auto-Tuning and the #1 Mindset Problem I Had as a DBAoriginal ↗
4 Dec 2017
In-Memory OLTP and Isolation Levels in SQL Server (Webcast Video with Transcript)original ↗
1 Dec 2017
Where are key columns stored in a nonclustered index in SQL Server?original ↗
29 Nov 2017
Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkersoriginal ↗
20 Nov 2017
Attempting to Force a Narrow Plan on an Update with Query Storeoriginal ↗
15 Nov 2017
Kalen Delaney and Inspiration for Adventureoriginal ↗
14 Nov 2017
The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Waitoriginal ↗
9 Nov 2017
Things I Learned from Speaker Idol 2017 at the SQL PASS Summitoriginal ↗
9 Nov 2017
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)original ↗
8 Nov 2017
SQL PASS Summit 2017 Day 2 - Keynote Notes and Ideasoriginal ↗
2 Nov 2017
SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memoriesoriginal ↗
1 Nov 2017
Locked Pages, Working Set, and Private Bytesoriginal ↗
19 Oct 2017
My Two Sessions at the SQL PASS Summit 2017original ↗
12 Oct 2017
The Death of SQL Server Service Packsoriginal ↗
6 Oct 2017
IO Patterns for Index Seeks: There May be a Lot of Read Ahead Readsoriginal ↗
4 Oct 2017
Love and Hate for SSMSoriginal ↗
29 Sept 2017
New Free Webcasts for November and December 2017original ↗
28 Sept 2017
How Do I Analyze a SQL Server Execution Plan?original ↗
22 Sept 2017
The Case of the Rowgroup Deadlock in a Columnstore Indexoriginal ↗
21 Sept 2017
Do I Need to Master PowerShell?original ↗
12 Sept 2017
SSMS Shortcuts & Secrets - Live Webcast Edition (video)original ↗
11 Sept 2017
SQL PASS Summit 2017: Tips on Attendingoriginal ↗
7 Sept 2017
Shortcut Update: Toggling Intellisense in SSMSoriginal ↗
6 Sept 2017
How Do You Stay Motivated? (Dear SQL DBA Episode 47)original ↗
1 Sept 2017
Why Did My Clever Index Change Backfire? (free video)original ↗
30 Aug 2017
You faked your resume... now what? (video with transcript)original ↗
25 Aug 2017
sp_query_store_flush_db, Query Store, and Backupsoriginal ↗
23 Aug 2017
How to Get Email Notifications for TSQLTuesdayoriginal ↗
21 Aug 2017
Recruiters, Nerves, and Saying No in Interviews (video with transcript)original ↗
17 Aug 2017
Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Communityoriginal ↗
14 Aug 2017
Do Index Changes Remove Execution Plans from Cache?original ↗
9 Aug 2017
The Story of an Interview Floporiginal ↗
8 Aug 2017
Running SQL Server in a Docker Container on a Macoriginal ↗
2 Aug 2017
TSQL Tuesday #93: Interviewing Patterns & Anti-Patternsoriginal ↗
1 Aug 2017
The COMPRESS() TSQL Function in SQL Server 2016+original ↗
31 Jul 2017
Desktop Wallpapers and Webcasts on Isolation Levels and Memoryoriginal ↗
28 Jul 2017
Downloadable SQL Server Desktop Wallpapersoriginal ↗
26 Jul 2017
Did that Query Eliminate Partitions? (videos)original ↗
19 Jul 2017
IF Statement Branching and Parameter Sniffingoriginal ↗
12 Jul 2017
Index Rebuild, Reorganize, and Statistics in Maintenance Plans in SQL Server 2016original ↗
5 Jul 2017
New Free Webcasts on Interviewing and Indexingoriginal ↗
29 Jun 2017
Using sp_WhoIsActive with Temp Tables to Limit Data Collectedoriginal ↗
28 Jun 2017
Join me for Why Did My Clever Index Change Backfire? at the 24 Hours of PASSoriginal ↗
23 Jun 2017
How to Enable the Debug Channel in Extended Events for the Query Thread Profile XEvent in SQL Sever 2014+original ↗
19 Jun 2017
Previous Next