41554 blogs · [ { "id": "01a0d1d3-fa8b-7082-bb3b-5eb7b8790d45", "title": "New features in T-SQL for SQL Server 2022", "url": "https://sqlblog.org/2022/05/25/new-t-sql-server-2022", "published_at": "2022-05-25T04:01:20+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4869305da", "title": "Obscure changes in SQL Server 2022: Metadata", "url": "https://sqlblog.org/2022/05/24/2022-metadata-1", "published_at": "2022-05-24T21:00:24+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e486ec6ee1", "title": "Leadership award from MSSQLTips.com", "url": "https://sqlblog.org/2022/05/11/leadership-award-from-mssqltips-com", "published_at": "2022-05-11T17:14:54+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4870bf1e4", "title": "T-SQL Tuesday #150: My first technical job", "url": "https://sqlblog.org/2022/05/10/t-sql-tuesday-150-my-first-technical-job", "published_at": "2022-05-10T13:20:25+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4871d5d71", "title": "Find a string in some or all databases", "url": "https://sqlblog.org/2022/05/09/find-string", "published_at": "2022-05-09T15:15:09+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e487526f44", "title": "A minor CPU upgrade", "url": "https://sqlblog.org/2022/04/19/a-minor-cpu-upgrade", "published_at": "2022-04-19T17:29:12+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e487fa908a", "title": "Building DBML syntax from metadata", "url": "https://sqlblog.org/2022/04/13/building-dbml-from-metadata", "published_at": "2022-04-13T09:00:29+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48813ed0d", "title": "Populate dimension tables dynamically – Parts 1 & 2", "url": "https://sqlblog.org/2022/04/08/populate-dimensions-dynamically", "published_at": "2022-04-08T15:05:12+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4884e08e7", "title": "Why I always start CTEs with a statement terminator", "url": "https://sqlblog.org/2022/04/06/why-ctes-start-with-terminator", "published_at": "2022-04-06T10:00:47+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4893758ce", "title": "All you NOLOCK lovers better read this!", "url": "https://sqlblog.org/2022/04/01/all-you-nolock-lovers-better-read-this", "published_at": "2022-04-01T00:00:52+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e489cc3b33", "title": "Interview with Kevin Kline for Orange Matter", "url": "https://sqlblog.org/2022/03/09/interview-kevin-kline", "published_at": "2022-03-09T09:00:47+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48a6d60c3", "title": "Advanced report examples using PIVOT and GROUPING SETS", "url": "https://sqlblog.org/2022/03/07/adv-report-pivot-grouping-sets", "published_at": "2022-03-07T14:26:16+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48ade9895", "title": "FORMAT is convenient but expensive – part 2", "url": "https://sqlblog.org/2022/03/01/format-expensive-2", "published_at": "2022-03-01T15:56:15+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48b9da452", "title": "String aggregation over the years", "url": "https://sqlblog.org/2022/02/17/string-aggregation-over-the-years-in-sql-server", "published_at": "2022-02-17T09:05:56+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48c4177ce", "title": "FORMAT is convenient but expensive – part 1", "url": "https://sqlblog.org/2022/02/16/format-expensive-1", "published_at": "2022-02-16T14:55:10+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48c5537d6", "title": "Mixed Extents Podcast: 2022.02.14", "url": "https://sqlblog.org/2022/02/14/mixed-extents-podcast-2022-02-14", "published_at": "2022-02-14T09:00:26+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48cec01b3", "title": "Performance of Docker + Mac: Intel vs. Apple silicon", "url": "https://sqlblog.org/2022/02/02/testing-docker-macbooks", "published_at": "2022-02-02T14:53:44+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48d9d3cd8", "title": "Just enable indirect checkpoints everywhere, please!", "url": "https://sqlblog.org/2022/01/18/just-enable-indirect-checkpoints", "published_at": "2022-01-18T14:29:09+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48e1b64b6", "title": "T-SQL Tuesday #146: Preconceived notions", "url": "https://sqlblog.org/2022/01/11/t-sql-tuesday-146-preconceived-notions", "published_at": "2022-01-11T07:00:53+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48e70e190", "title": "Azure SQL Edge and Docker on Apple silicon", "url": "https://sqlblog.org/2022/01/07/azure-sql-edge-docker-m1-macbooks", "published_at": "2022-01-07T15:24:55+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48ed4ee81", "title": "Serializing clustered columnstore deletes", "url": "https://sqlblog.org/2022/01/05/serializing-clustered-columnstore-deletes", "published_at": "2022-01-05T09:05:21+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e48fb5ad3f", "title": "Ladybug, Connect, and UserVoice: RIP", "url": "https://sqlblog.org/2021/12/31/ladybug-connect-uservoice-rip", "published_at": "2021-12-31T11:37:00+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4904befb4", "title": "2021 : Community Influencer of the Year", "url": "https://sqlblog.org/2021/12/29/2021-community-influencer-of-the-year", "published_at": "2021-12-29T09:00:02+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e490e501da", "title": "Using GREATEST and LEAST in Azure SQL Database", "url": "https://sqlblog.org/2021/12/08/greatest-least-azure-sql-database", "published_at": "2021-12-08T15:01:44+00:00" }, { "id": "01a0d1d3-fa8c-7186-a1fa-d3e4914f5f2f", "title": "Unboxing the MacBook Pro M1 Max", "url": "https://sqlblog.org/2021/12/02/unboxing-mbp-m1-max", "published_at": "2021-12-02T03:22:49+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1ccecf8d", "title": "Funemployment: Making a tidy workspace", "url": "https://sqlblog.org/2021/11/24/funemployment-tidy-workspace", "published_at": "2021-11-24T21:51:13+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1ce41837", "title": "Trusting STRING_SPLIT order in Azure SQL Database", "url": "https://sqlblog.org/2021/11/11/trusting-string_split-order-in-azure-sql-database", "published_at": "2021-11-11T13:58:05+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1db07f1c", "title": "Ordered string splitting in SQL Server with OPENJSON", "url": "https://sqlblog.org/2021/11/08/ordered-string-splitting-openjson", "published_at": "2021-11-08T15:56:12+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1ead3565", "title": "\"I want to do X to all the Ys in database Z\" – Part 1", "url": "https://sqlblog.org/2021/11/08/x-to-y-database-z-1", "published_at": "2021-11-08T13:37:32+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1ee6cf5f", "title": "2021 : The Year of the Exodus", "url": "https://sqlblog.org/2021/11/05/2021-the-year-of-the-exodus", "published_at": "2021-11-05T12:45:39+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c1fe10ce4", "title": "Find queries with index hints – not just in the plan cache", "url": "https://sqlblog.org/2021/11/03/index-hints-not-just-plan-cache", "published_at": "2021-11-03T12:48:05+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c2003c7c5", "title": "Handle an unknown number of parameters with OPENJSON()", "url": "https://sqlblog.org/2021/10/22/unknown-number-parameters", "published_at": "2021-10-22T16:51:59+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c202fea12", "title": "Bad Habits to Kick: Avoiding NULL", "url": "https://sqlblog.org/2021/10/21/bad-habits-avoiding-null", "published_at": "2021-10-21T09:05:00+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c208a68c1", "title": "A handy search procedure", "url": "https://sqlblog.org/2021/10/20/a-handy-search-procedure", "published_at": "2021-10-20T09:00:00+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c214387d5", "title": "Bad Habits to Kick: Abusing bit columns", "url": "https://sqlblog.org/2021/10/14/bad-habits-abusing-bit-columns", "published_at": "2021-10-14T16:02:23+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c22177d8e", "title": "T-SQL Tuesday #143: Preparing for the worst… metadata", "url": "https://sqlblog.org/2021/10/12/t-sql-tuesday-143-worst-metadata", "published_at": "2021-10-12T09:00:22+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c22b1c22a", "title": "Yes, data type names can still be case sensitive", "url": "https://sqlblog.org/2021/10/04/data-type-case-sensitive", "published_at": "2021-10-04T13:38:28+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c22c7d6c7", "title": "Refreshing tables with less disruption", "url": "https://sqlblog.org/2021/09/29/refreshing-tables-with-less-interruption", "published_at": "2021-09-29T09:05:40+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c234ec9b5", "title": "Consolidating links and resources", "url": "https://sqlblog.org/2021/09/23/consolidating-links-and-resources", "published_at": "2021-09-23T23:13:10+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c23e7a669", "title": "Why I don't like the WHILE (1=1) pattern", "url": "https://sqlblog.org/2021/09/08/while-pattern", "published_at": "2021-09-08T13:06:02+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c2407448d", "title": "Finding problematic NOLOCK patterns – Part 4", "url": "https://sqlblog.org/2021/09/01/problematic-nolock-4", "published_at": "2021-09-01T13:52:06+00:00" }, { "id": "01a0d1d4-4ee5-73e6-9025-8f9c247d3e48", "title": "Finding problematic NOLOCK patterns – Part 3", "url": "https://sqlblog.org/2021/08/18/problematic-nolock-3", "published_at": "2021-08-18T11:53:52+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba62d43193", "title": "T-SQL Tuesday #141: Work/life balance", "url": "https://sqlblog.org/2021/08/10/t-sql-tuesday-141-work-life-balance", "published_at": "2021-08-10T13:29:47+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba63d23d92", "title": "Finding problematic NOLOCK patterns – Part 2", "url": "https://sqlblog.org/2021/08/03/problematic-nolock-2", "published_at": "2021-08-03T13:38:50+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba641d6ad4", "title": "Finding problematic NOLOCK patterns – Part 1", "url": "https://sqlblog.org/2021/07/28/problematic-nolock-1", "published_at": "2021-07-28T13:20:09+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba6445e817", "title": "Minimizing PAGELATCH_EX waits in SQL Server 2019", "url": "https://sqlblog.org/2021/07/23/pagelatch-ex-sql-server-2019", "published_at": "2021-07-23T14:09:32+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba6497c3de", "title": "T-SQL Tuesday #140: What have you been up to with containers?", "url": "https://sqlblog.org/2021/07/13/t-sql-tuesday-140-containers", "published_at": "2021-07-13T09:00:20+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba65603aba", "title": "Deprecated features to take out of your toolbox – Part 3", "url": "https://sqlblog.org/2021/07/01/deprecated-features-to-take-out-of-your-toolbox-part-3", "published_at": "2021-07-01T09:05:04+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba65c8a380", "title": "SQL Server 2019 adventures on CentOS 7.5", "url": "https://sqlblog.org/2021/06/24/sql-server-2019-centos-7-5", "published_at": "2021-06-24T12:08:39+00:00" }, { "id": "01a0d1d4-4ee6-7343-8c14-fcba65f529f7", "title": "How to USE a calendar table – Part 3", "url": "https://sqlblog.org/2021/06/16/how-to-use-a-calendar-table-part-3", "published_at": "2021-06-16T12:40:55+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492aa9feef", "title": "How to USE a calendar table – Part 2", "url": "https://sqlblog.org/2021/04/28/how-to-use-a-calendar-table-part-2", "published_at": "2021-04-28T13:13:03+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492b775c7a", "title": "How to USE a calendar table – Part 1", "url": "https://sqlblog.org/2021/04/22/how-to-use-a-calendar-table-part-1", "published_at": "2021-04-22T13:42:26+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492bea1717", "title": "Maintaining LastModified without triggers", "url": "https://sqlblog.org/2021/04/01/lastmodified-without-triggers", "published_at": "2021-04-01T09:00:40+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492c3acc3e", "title": "Deprecated features to take out of your toolbox – Part 2", "url": "https://sqlblog.org/2021/03/15/deprecated-features-to-take-out-of-your-toolbox-part-2", "published_at": "2021-03-15T09:15:35+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492ca9489d", "title": "My two least favorite data types", "url": "https://sqlblog.org/2021/03/09/my-two-least-favorite-data-types", "published_at": "2021-03-09T09:00:30+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492d7be37c", "title": "When does SQL Server think YYYY-DD-MM is a valid date?", "url": "https://sqlblog.org/2021/03/04/yyyy-dd-mm", "published_at": "2021-03-04T16:10:26+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492e7b8359", "title": "Deprecated features to take out of your toolbox – Part 1", "url": "https://sqlblog.org/2021/02/22/deprecated-features-to-take-out-of-your-toolbox-part-1", "published_at": "2021-02-22T12:38:44+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492f7083a5", "title": "Unique constraints where order doesn't matter", "url": "https://sqlblog.org/2021/02/19/enforcing-constraints-where-order-doesnt-matter", "published_at": "2021-02-19T15:30:16+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45492fb8c0ec", "title": "Performance of sys.partitions", "url": "https://sqlblog.org/2021/01/19/performance-sys-partitions", "published_at": "2021-01-19T01:44:01+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45493015eb5a", "title": "Maybe you do want to collect database name in Extended Events", "url": "https://sqlblog.org/2021/01/14/maybe-you-do-want-to-collect-database-name-in-extended-events", "published_at": "2021-01-14T15:46:56+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454930240cdb", "title": "T-SQL Tuesday #134: Give me a break!", "url": "https://sqlblog.org/2021/01/12/t-sql-tuesday-134-give-me-a-break", "published_at": "2021-01-12T09:00:45+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454930c8ed2a", "title": "A use case for sp_prepare / sp_prepexec", "url": "https://sqlblog.org/2021/01/11/use-case-sp-prepare-sp-prepexec", "published_at": "2021-01-11T14:01:21+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454930f5f86a", "title": "An Extended Events conundrum: collect_database_name", "url": "https://sqlblog.org/2020/12/23/extended-events-collect-database-name", "published_at": "2020-12-23T16:08:50+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549317814bc", "title": "2020 : Community Influencer of the Year", "url": "https://sqlblog.org/2020/12/22/2020-community-influencer", "published_at": "2020-12-22T14:39:58+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-45493200a14d", "title": "T-SQL Tuesday #133: What (else) have you learned from presenting?", "url": "https://sqlblog.org/2020/12/08/t-sql-tuesday-133-what-else-have-you-learned-from-presenting", "published_at": "2020-12-08T09:00:49+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549327b4e07", "title": "T-SQL Tuesday #132: The pandemic", "url": "https://sqlblog.org/2020/11/10/t-sql-tuesday-132-a-global-pandemic", "published_at": "2020-11-10T09:00:05+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549334fea33", "title": "DBCC CHECKDB for \"very large databases\"", "url": "https://sqlblog.org/2020/11/05/navigating-dbcc-checkdb-for-vldb", "published_at": "2020-11-05T16:27:41+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549340d9d4f", "title": "Parse parameter default values using PowerShell – Part 3", "url": "https://sqlblog.org/2020/10/16/paramparser-3", "published_at": "2020-10-16T20:48:33+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454934fc8588", "title": "T-SQL Tuesday #131: My favorite SQL Server analogy", "url": "https://sqlblog.org/2020/10/13/t-sql-tuesday-131-analogy", "published_at": "2020-10-13T09:00:08+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549350f2a99", "title": "Parse parameter default values using PowerShell – Part 2", "url": "https://sqlblog.org/2020/10/01/paramparser-2", "published_at": "2020-10-01T10:01:18+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454935e5ae76", "title": "Parse parameter default values using PowerShell – Part 1", "url": "https://sqlblog.org/2020/09/25/paramparser-1", "published_at": "2020-09-25T10:01:46+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549369d9a1a", "title": "Please don't use sys.sp_columns!", "url": "https://sqlblog.org/2020/09/21/please-dont-use-sys-sp_columns", "published_at": "2020-09-21T09:00:23+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454937322bc7", "title": "When pigs fly: My first Windows build in over a decade", "url": "https://sqlblog.org/2020/09/16/when-pigs-fly-windows-pc", "published_at": "2020-09-16T21:04:59+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-454937ea6827", "title": "T-SQL Tuesday #130: Automate your stress away", "url": "https://sqlblog.org/2020/09/08/t-sql-tuesday-130-automate", "published_at": "2020-09-08T12:55:07+00:00" }, { "id": "01a0d1d4-a6e3-7015-adee-4549381861d2", "title": "Please stop using this UPSERT anti-pattern", "url": "https://sqlblog.org/2020/09/02/please-stop-using-upsert-anti-pattern", "published_at": "2020-09-02T12:54:44+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d6feeee2c", "title": "Sometimes you CAN upsize a column in-place", "url": "https://sqlblog.org/2020/08/19/sometimes-you-can-upsize-a-column-in-place", "published_at": "2020-08-19T12:14:15+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d70a4f417", "title": "Altering a column ONLINE might still be disruptive and size-of-data", "url": "https://sqlblog.org/2020/08/19/altering-column-online-size-of-data", "published_at": "2020-08-19T06:00:56+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d7114ce68", "title": "Help improve STRING_SPLIT without losing backward compatibility", "url": "https://sqlblog.org/2020/08/11/help-improve-string-split", "published_at": "2020-08-11T12:49:46+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d71b175fe", "title": "Using Taylor Swift to explain my job to my 7-year old", "url": "https://sqlblog.org/2020/08/05/taylor-swift-to-explain-my-job", "published_at": "2020-08-05T13:03:14+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d71c18222", "title": "A reliable and flexible replacement for sp_MSforeachdb", "url": "https://sqlblog.org/2020/08/04/reliable-flexible-replacement-sp_msforeachdb", "published_at": "2020-08-04T09:00:00+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d71d5e50f", "title": "Some weekend maintenance here on sqlblog.org", "url": "https://sqlblog.org/2020/08/03/some-weekend-maintenance-sqlblog-org", "published_at": "2020-08-03T12:39:41+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d727fa96f", "title": "Troubleshooting error 18456", "url": "https://sqlblog.org/2020/07/28/troubleshooting-error-18456", "published_at": "2020-07-28T09:00:00+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d732abfe4", "title": "T-SQL Tuesday #128: Learn from others", "url": "https://sqlblog.org/2020/07/14/t-sql-tuesday-128-learn-from-others", "published_at": "2020-07-14T15:41:15+00:00" }, { "id": "01a0d1d4-ec74-7209-b981-891d7395bdc3", "title": "Be an ally and a nuisance", "url": "https://sqlblog.org/2020/06/24/be-an-ally-and-a-nuisance", "published_at": "2020-06-24T17:25:40+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a3768cfedda", "title": "Keep relevant system_health data longer", "url": "https://sqlblog.org/2020/06/17/keep-relevant-system-health-data-longer", "published_at": "2020-06-17T13:36:08+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a3768e00e8c", "title": "T-SQL Tuesday #127: Measure twice, cut once", "url": "https://sqlblog.org/2020/06/09/t-sql-tuesday-127-measure-twice-cut-once", "published_at": "2020-06-09T09:00:50+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a3769cb691c", "title": "Replace legacy splitting functions with STRING_SPLIT", "url": "https://sqlblog.org/2020/06/01/string-split-replace", "published_at": "2020-06-01T13:15:37+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a3769d6a3e1", "title": "Get to the system_health file target a little easier", "url": "https://sqlblog.org/2020/05/28/system-health-file-target-easier", "published_at": "2020-05-28T13:34:03+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376a48fd7f", "title": "Index and partition space usage – Part 3", "url": "https://sqlblog.org/2020/05/27/index-and-partition-space-usage-part-3", "published_at": "2020-05-27T13:45:08+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376b3a726a", "title": "Heaps, LOBs, and aggregates: A bad combination", "url": "https://sqlblog.org/2020/05/26/heaps-lobs-aggregates-bad-combo", "published_at": "2020-05-26T13:12:25+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376b7a1bc1", "title": "Bad Habits to Kick: Relying on undocumented behavior", "url": "https://sqlblog.org/2020/05/12/bad-habits-to-kick-relying-on-undocumented-behavior", "published_at": "2020-05-12T09:00:00+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376be9d099", "title": "Happy Cinco de Mayo and Happy Taco Tuesday!", "url": "https://sqlblog.org/2020/05/05/happy-cinco-de-mayo-and-happy-taco-tuesday", "published_at": "2020-05-05T15:03:38+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376c1f4a51", "title": "Index and partition space usage – Part 2", "url": "https://sqlblog.org/2020/05/04/index-and-partition-space-usage-part-2", "published_at": "2020-05-04T09:00:52+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376cfe67a6", "title": "\"0 to 60\": Switching to indirect checkpoints", "url": "https://sqlblog.org/2020/05/01/0-to-60-indirect-checkpoints", "published_at": "2020-05-01T09:01:40+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376de38a47", "title": "Removing the default trace – Part 3", "url": "https://sqlblog.org/2020/04/22/removing-the-default-trace-part-3", "published_at": "2020-04-22T12:37:13+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376e432b73", "title": "Index and partition space usage – Part 1", "url": "https://sqlblog.org/2020/04/07/file-and-filegroup-space-usage-part-1", "published_at": "2020-04-07T13:30:15+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a376f11cb1b", "title": "Removing the default trace – Part 2", "url": "https://sqlblog.org/2020/04/06/removing-the-default-trace-part-2", "published_at": "2020-04-06T12:43:04+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a37700d38d9", "title": "Blogging is for more than just traffic", "url": "https://sqlblog.org/2020/03/27/blogging-is-for-more-than-just-traffic", "published_at": "2020-03-27T13:24:46+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a3770975bfb", "title": "A minor office reorg – Part 3", "url": "https://sqlblog.org/2020/03/22/a-minor-office-reorg-part-3", "published_at": "2020-03-22T15:29:32+00:00" }, { "id": "01a0d1d4-ec75-7284-a7c8-1a37713ef964", "title": "Please help with STRING_SPLIT improvements", "url": "https://sqlblog.org/2020/03/20/please-help-string-split-improvements", "published_at": "2020-03-20T13:52:14+00:00" } ] posts Claim your blog

Back to sqlblog.org

Blog · corpus.blog/blogs/sqlblog.org/posts

sqlblog.org

sqlblog.org

2022

New features in T-SQL for SQL Server 2022 original ↗

25 May 2022

Obscure changes in SQL Server 2022: Metadata original ↗

24 May 2022

Leadership award from MSSQLTips.com original ↗

11 May 2022

T-SQL Tuesday #150: My first technical job original ↗

10 May 2022

Find a string in some or all databases original ↗

9 May 2022

A minor CPU upgrade original ↗

19 Apr 2022

Building DBML syntax from metadata original ↗

13 Apr 2022

Populate dimension tables dynamically – Parts 1 & 2 original ↗

8 Apr 2022

Why I always start CTEs with a statement terminator original ↗

6 Apr 2022

All you NOLOCK lovers better read this!original ↗

1 Apr 2022

Interview with Kevin Kline for Orange Matter original ↗

9 Mar 2022

Advanced report examples using PIVOT and GROUPING SETS original ↗

7 Mar 2022

FORMAT is convenient but expensive – part 2 original ↗

1 Mar 2022

String aggregation over the years original ↗

17 Feb 2022

FORMAT is convenient but expensive – part 1 original ↗

16 Feb 2022

Mixed Extents Podcast: 2022.02.14 original ↗

14 Feb 2022

Performance of Docker + Mac: Intel vs. Apple silicon original ↗

2 Feb 2022

Just enable indirect checkpoints everywhere, please!original ↗

18 Jan 2022

T-SQL Tuesday #146: Preconceived notions original ↗

11 Jan 2022

Azure SQL Edge and Docker on Apple silicon original ↗

7 Jan 2022

Serializing clustered columnstore deletes original ↗

5 Jan 2022

2021

Ladybug, Connect, and UserVoice: RIP original ↗

31 Dec 2021

2021 : Community Influencer of the Year original ↗

29 Dec 2021

Using GREATEST and LEAST in Azure SQL Database original ↗

8 Dec 2021

Unboxing the MacBook Pro M1 Max original ↗

2 Dec 2021

Funemployment: Making a tidy workspace original ↗

24 Nov 2021

Trusting STRING_SPLIT order in Azure SQL Database original ↗

11 Nov 2021

Ordered string splitting in SQL Server with OPENJSON original ↗

8 Nov 2021

"I want to do X to all the Ys in database Z" – Part 1 original ↗

8 Nov 2021

2021 : The Year of the Exodus original ↗

5 Nov 2021

Find queries with index hints – not just in the plan cache original ↗

3 Nov 2021

Handle an unknown number of parameters with OPENJSON()original ↗

22 Oct 2021

Bad Habits to Kick: Avoiding NULL original ↗

21 Oct 2021

A handy search procedure original ↗

20 Oct 2021

Bad Habits to Kick: Abusing bit columns original ↗

14 Oct 2021

T-SQL Tuesday #143: Preparing for the worst… metadata original ↗

12 Oct 2021

Yes, data type names can still be case sensitive original ↗

4 Oct 2021

Refreshing tables with less disruption original ↗

29 Sept 2021

Consolidating links and resources original ↗

23 Sept 2021

Why I don't like the WHILE (1=1) pattern original ↗

8 Sept 2021

Finding problematic NOLOCK patterns – Part 4 original ↗

1 Sept 2021

Finding problematic NOLOCK patterns – Part 3 original ↗

18 Aug 2021

T-SQL Tuesday #141: Work/life balance original ↗

10 Aug 2021

Finding problematic NOLOCK patterns – Part 2 original ↗

3 Aug 2021

Finding problematic NOLOCK patterns – Part 1 original ↗

28 Jul 2021

Minimizing PAGELATCH_EX waits in SQL Server 2019 original ↗

23 Jul 2021

T-SQL Tuesday #140: What have you been up to with containers?original ↗

13 Jul 2021

Deprecated features to take out of your toolbox – Part 3 original ↗

1 Jul 2021

SQL Server 2019 adventures on CentOS 7.5 original ↗

24 Jun 2021

How to USE a calendar table – Part 3 original ↗

16 Jun 2021

How to USE a calendar table – Part 2 original ↗

28 Apr 2021

How to USE a calendar table – Part 1 original ↗

22 Apr 2021

Maintaining LastModified without triggers original ↗

1 Apr 2021

Deprecated features to take out of your toolbox – Part 2 original ↗

15 Mar 2021

My two least favorite data types original ↗

9 Mar 2021

When does SQL Server think YYYY-DD-MM is a valid date?original ↗

4 Mar 2021

Deprecated features to take out of your toolbox – Part 1 original ↗

22 Feb 2021

Unique constraints where order doesn't matter original ↗

19 Feb 2021

Performance of sys.partitions original ↗

19 Jan 2021

Maybe you do want to collect database name in Extended Events original ↗

14 Jan 2021

T-SQL Tuesday #134: Give me a break!original ↗

12 Jan 2021

A use case for sp_prepare / sp_prepexec original ↗

11 Jan 2021

2020

An Extended Events conundrum: collect_database_name original ↗

23 Dec 2020

2020 : Community Influencer of the Year original ↗

22 Dec 2020

T-SQL Tuesday #133: What (else) have you learned from presenting?original ↗

8 Dec 2020

T-SQL Tuesday #132: The pandemic original ↗

10 Nov 2020

DBCC CHECKDB for "very large databases"original ↗

5 Nov 2020

Parse parameter default values using PowerShell – Part 3 original ↗

16 Oct 2020

T-SQL Tuesday #131: My favorite SQL Server analogy original ↗

13 Oct 2020

Parse parameter default values using PowerShell – Part 2 original ↗

1 Oct 2020

Parse parameter default values using PowerShell – Part 1 original ↗

25 Sept 2020

Please don't use sys.sp_columns!original ↗

21 Sept 2020

When pigs fly: My first Windows build in over a decade original ↗

16 Sept 2020

T-SQL Tuesday #130: Automate your stress away original ↗

8 Sept 2020

Please stop using this UPSERT anti-pattern original ↗

2 Sept 2020

Sometimes you CAN upsize a column in-place original ↗

19 Aug 2020

Altering a column ONLINE might still be disruptive and size-of-data original ↗

19 Aug 2020

Help improve STRING_SPLIT without losing backward compatibility original ↗

11 Aug 2020

Using Taylor Swift to explain my job to my 7-year old original ↗

5 Aug 2020

A reliable and flexible replacement for sp_MSforeachdb original ↗

4 Aug 2020

Some weekend maintenance here on sqlblog.org original ↗

3 Aug 2020

Troubleshooting error 18456 original ↗

28 Jul 2020

T-SQL Tuesday #128: Learn from others original ↗

14 Jul 2020

Be an ally and a nuisance original ↗

24 Jun 2020

Keep relevant system_health data longer original ↗

17 Jun 2020

T-SQL Tuesday #127: Measure twice, cut once original ↗

9 Jun 2020

Replace legacy splitting functions with STRING_SPLIT original ↗

1 Jun 2020

Get to the system_health file target a little easier original ↗

28 May 2020

Index and partition space usage – Part 3 original ↗

27 May 2020

Heaps, LOBs, and aggregates: A bad combination original ↗

26 May 2020

Bad Habits to Kick: Relying on undocumented behavior original ↗

12 May 2020

Happy Cinco de Mayo and Happy Taco Tuesday!original ↗

5 May 2020

Index and partition space usage – Part 2 original ↗

4 May 2020

"0 to 60": Switching to indirect checkpoints original ↗

1 May 2020

Removing the default trace – Part 3 original ↗

22 Apr 2020

Index and partition space usage – Part 1 original ↗

7 Apr 2020

Removing the default trace – Part 2 original ↗

6 Apr 2020

Blogging is for more than just traffic original ↗

27 Mar 2020

A minor office reorg – Part 3 original ↗

22 Mar 2020

Please help with STRING_SPLIT improvements original ↗

20 Mar 2020