41554 blogs · [ { "id": "01a0d1d5-30e2-702d-8b47-649914d72a9e", "title": "Illogical errors can be a factor of the plan", "url": "https://sqlblog.org/2020/03/19/illogical-errors-can-be-a-factor-of-the-plan", "published_at": "2020-03-19T12:57:14+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499153bcfc9", "title": "Changing a function's interface but staying backward compatible", "url": "https://sqlblog.org/2020/03/18/function-interface-back-compat", "published_at": "2020-03-18T13:06:21+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499157bd864", "title": "Attaching / restoring databases inside a container", "url": "https://sqlblog.org/2020/03/15/attaching-restoring-databases-inside-a-container", "published_at": "2020-03-15T15:05:40+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649915812378", "title": "Additional tips for working from home", "url": "https://sqlblog.org/2020/03/12/additional-tips-for-working-from-home", "published_at": "2020-03-12T17:08:56+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499163b38e5", "title": "Measure Delayed Durability impact", "url": "https://sqlblog.org/2020/03/04/measure-delayed-durability-impact-in-sql-server-2016-and-later", "published_at": "2020-03-04T09:00:37+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499170b25b5", "title": "Removing the default trace – Part 1", "url": "https://sqlblog.org/2020/03/02/removing-the-default-trace-part-1", "published_at": "2020-03-02T09:01:25+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499172c40c8", "title": "Checkpoint monitoring with Extended Events", "url": "https://sqlblog.org/2020/02/17/sql-server-checkpoint-monitoring-with-extended-events", "published_at": "2020-02-17T14:16:44+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649917be9e0d", "title": "T-SQL Tuesday #123: Life hacks", "url": "https://sqlblog.org/2020/02/11/t-sql-tuesday-123-life-hacks", "published_at": "2020-02-11T12:32:55+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649918aac7ca", "title": "Use caution with this dynamic management function!", "url": "https://sqlblog.org/2020/02/04/caution-dm_db_database_page_allocations", "published_at": "2020-02-04T09:00:48+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649918ebac87", "title": "Fun with (columnstore) compression on a very large table – Part 3", "url": "https://sqlblog.org/2020/02/03/fun-with-columnstore-compression-on-a-very-large-table-part-3", "published_at": "2020-02-03T20:13:32+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649919793343", "title": "Use soft deletes to slow ghost record growth", "url": "https://sqlblog.org/2020/01/29/soft-deletes-availability-group", "published_at": "2020-01-29T13:24:03+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499197a29e2", "title": "A minor office reorg – Part 2", "url": "https://sqlblog.org/2020/01/25/a-minor-office-reorg-part-2", "published_at": "2020-01-25T21:07:35+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991a6740c0", "title": "A minor office reorg – Part 1", "url": "https://sqlblog.org/2020/01/21/a-minor-office-reorg-part-1", "published_at": "2020-01-21T05:05:57+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991b5dd854", "title": "T-SQL Tuesday #122: Imposter syndrome", "url": "https://sqlblog.org/2020/01/14/t-sql-tuesday-122-imposter-syndrome", "published_at": "2020-01-14T09:00:23+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991c3f57c2", "title": "Fun with (columnstore) compression on a very large table – Part 2", "url": "https://sqlblog.org/2020/01/07/fun-with-columnstore-compression-on-a-very-large-table-part-2", "published_at": "2020-01-07T09:01:51+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991c5ea947", "title": "A simple use case for columnstore indexes", "url": "https://sqlblog.org/2020/01/06/simple-use-case-columnstore-indexes", "published_at": "2020-01-06T14:10:57+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991d562977", "title": "2019 : Community Influencer of the Year", "url": "https://sqlblog.org/2020/01/02/2019-community-influencer", "published_at": "2020-01-02T09:00:41+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991d6f6850", "title": "Fun with (columnstore) compression on a very large table – Part 1", "url": "https://sqlblog.org/2019/12/27/fun-with-columnstore-compression-on-a-very-large-table-part-1", "published_at": "2019-12-27T09:01:54+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991e3c701c", "title": "Using metadata to troubleshoot metadata", "url": "https://sqlblog.org/2019/12/18/metadata-meets-metadata", "published_at": "2019-12-18T16:44:51+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991f16a97b", "title": "T-SQL Tuesday #121: Gifts", "url": "https://sqlblog.org/2019/12/10/t-sql-tuesday-121-gifts", "published_at": "2019-12-10T22:31:05+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64991fd6a49a", "title": "Filtered indexes and forced parameterization (redux)", "url": "https://sqlblog.org/2019/12/03/filtered-indexes-forced-parameterization", "published_at": "2019-12-03T09:05:03+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-64992006c891", "title": "Should we still chunk delete operations?", "url": "https://sqlblog.org/2019/12/03/should-still-chunk-deletes", "published_at": "2019-12-03T08:00:19+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649920427bb2", "title": "Introducing Big Data Clusters", "url": "https://sqlblog.org/2019/11/21/introducing-big-data-clusters-and-sql-server-2019", "published_at": "2019-11-21T10:00:25+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-6499204ea307", "title": "SQL Server 2019: Setup enhancements", "url": "https://sqlblog.org/2019/11/11/sql-server-2019-installation-enhancements", "published_at": "2019-11-11T14:14:38+00:00" }, { "id": "01a0d1d5-30e2-702d-8b47-649920e1d641", "title": "Memory-optimized tempdb metadata", "url": "https://sqlblog.org/2019/11/07/memory-optimized-tempdb-metadata-in-sql-server-2019", "published_at": "2019-11-07T19:58:20+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3bb7390c", "title": "Thoughts on SQL Server 2019 editions", "url": "https://sqlblog.org/2019/11/01/thoughts-sql-server-2019-editions", "published_at": "2019-11-01T16:50:45+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3be61d0b", "title": "Simulating ON DELETE CASCADE", "url": "https://sqlblog.org/2019/10/28/simulating-on-delete-cascade", "published_at": "2019-10-28T00:00:10+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3cd99cda", "title": "Impact of UTF-8 support in SQL Server 2019", "url": "https://sqlblog.org/2019/10/15/impact-of-utf-8-support", "published_at": "2019-10-15T00:00:28+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3d8cc9bc", "title": "T-SQL Tuesday #119: Changing my mind", "url": "https://sqlblog.org/2019/10/08/t-sql-tuesday-119-changing-my-mind", "published_at": "2019-10-08T15:31:41+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3df8e7e4", "title": "Document columns across systems", "url": "https://sqlblog.org/2019/10/02/document-column-attributes", "published_at": "2019-10-02T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3e239960", "title": "Forced parameterization, meet filtered indexes", "url": "https://sqlblog.org/2019/09/19/forced-parameterization-meet-filtered-indexes", "published_at": "2019-09-19T13:43:43+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3ef4c382", "title": "Use meaningful port numbers for Docker containers", "url": "https://sqlblog.org/2019/09/14/quick-tip-multiple-docker-containers", "published_at": "2019-09-14T20:52:16+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3f393b72", "title": "Bad Habits to Kick: Avoiding the schema prefix", "url": "https://sqlblog.org/2019/09/12/bad-habits-to-kick-avoiding-the-schema-prefix", "published_at": "2019-09-12T11:20:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e3f76f8a0", "title": "Another limitation of STRING_SPLIT", "url": "https://sqlblog.org/2019/09/03/another-limitation-in-the-string_split-function", "published_at": "2019-09-03T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e4044d6a1", "title": "Partitioning data without partitioning", "url": "https://sqlblog.org/2019/08/27/partitioning-data-in-sql-server-without-using-partitioned-tables", "published_at": "2019-08-27T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e413d657e", "title": "How to modify user-defined table types", "url": "https://sqlblog.org/2019/08/08/how-to-alter-user-defined-table-type-in-sql-server", "published_at": "2019-08-08T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e41495079", "title": "SQL Server 2019: Execution plan enhancements", "url": "https://sqlblog.org/2019/08/01/sql-server-2019-execution-plan-enhancements", "published_at": "2019-08-01T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e419bac58", "title": "SQL Server Management Studio 18.2", "url": "https://sqlblog.org/2019/07/26/sql-server-management-studio-18-2-2-mb-text-grid-output", "published_at": "2019-07-26T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e41cf6b31", "title": "Find integer columns to downsize", "url": "https://sqlblog.org/2019/07/25/find-sql-server-integer-columns-to-make-skinnier", "published_at": "2019-07-25T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e42543c49", "title": "Four T-SQL syntax rules I always follow", "url": "https://sqlblog.org/2019/07/11/four-sql-server-syntax-rules-i-always-follow", "published_at": "2019-07-11T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e4283b6a5", "title": "Simplify date period calculations", "url": "https://sqlblog.org/2019/06/27/simplify-date-period-calculations-in-sql-server", "published_at": "2019-06-27T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e4351f358", "title": "NOLOCK anomalies, issues, and inconsistencies", "url": "https://sqlblog.org/2019/06/18/sql-server-nolock-anomalies-issues-and-inconsistencies", "published_at": "2019-06-18T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e44408cb3", "title": "Five things I wish I knew earlier in my career", "url": "https://sqlblog.org/2019/05/08/five-things-i-wish-i-knew-when-i-started-my-sql-server-career", "published_at": "2019-05-08T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e44b562c7", "title": "CASE expression overview", "url": "https://sqlblog.org/2019/04/30/case-expression-overview", "published_at": "2019-04-30T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e44d4b697", "title": "Query extended properties from multiple databases", "url": "https://sqlblog.org/2019/04/05/query-extended-properties-from-multiple-databases", "published_at": "2019-04-05T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e45103623", "title": "Manage SQL Server Agent history more effectively", "url": "https://sqlblog.org/2019/03/26/manage-sql-server-agent-history-more-effectively", "published_at": "2019-03-26T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e459ceac7", "title": "An intro to Accelerated Database Recovery", "url": "https://sqlblog.org/2019/03/06/accelerated-database-recovery-in-sql-server-2019", "published_at": "2019-03-06T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e45f3081d", "title": "Charlotte User Group: Fix slow queries. Fast.", "url": "https://sqlblog.org/2019/02/21/charlotte-fix-slow-queries-fast", "published_at": "2019-02-21T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e46163a1a", "title": "Bulk loading on a budget – Part 2", "url": "https://sqlblog.org/2019/02/14/scale-sql-server-bulk-loading-on-a-budget-part-2", "published_at": "2019-02-14T00:00:00+00:00" }, { "id": "01a0d1d5-6670-7334-ba60-e54e46a31289", "title": "Bulk loading on a budget – Part 1", "url": "https://sqlblog.org/2019/02/07/scale-sql-server-bulk-loading-on-a-budget-part-1", "published_at": "2019-02-07T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c65665bdd", "title": "Make DMV queries backward compatible", "url": "https://sqlblog.org/2019/01/29/make-sql-server-dmv-queries-backward-compatible", "published_at": "2019-01-29T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c65d3b103", "title": "Scalar UDF inlining", "url": "https://sqlblog.org/2019/01/22/scalar-udf-inlining-in-sql-server-2019", "published_at": "2019-01-22T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c65f778a5", "title": "Four ways to improve scalar function performance", "url": "https://sqlblog.org/2019/01/11/four-ways-to-improve-scalar-function-performance", "published_at": "2019-01-11T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c66be9d28", "title": "2018 : Community Influencer of the Year", "url": "https://sqlblog.org/2018/12/28/2018-community-influencer", "published_at": "2018-12-28T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c66cc2b4c", "title": "Find events with overlapping date ranges", "url": "https://sqlblog.org/2018/12/26/using-tsql-to-find-events-that-overlap-or-dont-in-sql-server", "published_at": "2018-12-26T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c675038c8", "title": "SQL Server 2019: APPROX COUNT DISTINCT", "url": "https://sqlblog.org/2018/12/19/sql-server-2019-approxcountdistinct-function", "published_at": "2018-12-19T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c679f16e7", "title": "SQL Server support for TLS 1.2 – Read this first!", "url": "https://sqlblog.org/2018/11/17/s1-tls-1-2-support-read-first", "published_at": "2018-11-17T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c67eaa785", "title": "Exploring scalar UDF inlining", "url": "https://sqlblog.org/2018/11/12/sql-server-2019-scalar-udf-inlining", "published_at": "2018-11-12T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c68e150d7", "title": "sp_ineachdb: Execute in the context of each database – Part 2", "url": "https://sqlblog.org/2018/10/22/sp-ineachdb-2", "published_at": "2018-10-22T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c69a928e1", "title": "SQL Server 2019: ADD SENSITIVITY CLASSIFICATION", "url": "https://sqlblog.org/2018/10/12/sql-server-2019-add-sensitivity-classification", "published_at": "2018-10-12T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6a454a76", "title": "SQL Server 2019: sys.dm_db_page_info", "url": "https://sqlblog.org/2018/10/08/sql-server-2019-sysdmdbpageinfo", "published_at": "2018-10-08T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6b223584", "title": "What to do (or not do) about top wait stats", "url": "https://sqlblog.org/2018/10/05/sqlperf-top-wait-stats", "published_at": "2018-10-05T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6b67972a", "title": "sp_ineachdb: Execute in the context of each database – Part 1", "url": "https://sqlblog.org/2018/10/04/sp-ineachdb-1", "published_at": "2018-10-04T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6bdb80b3", "title": "T-SQL Tuesday #106: INSTEAD OF triggers", "url": "https://sqlblog.org/2018/09/11/t-sql-tuesday-106-instead-of-triggers", "published_at": "2018-09-11T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6c90d558", "title": "Migrating from AnswerHub to WordPress: A tale of 10 technologies", "url": "https://sqlblog.org/2018/09/10/sqlperf-migrating-sqlperformance-answerhub-wordpress", "published_at": "2018-09-10T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6cf40fdd", "title": "Table variable deferred compilation", "url": "https://sqlblog.org/2018/09/06/table-variable-deferred-compilation", "published_at": "2018-09-06T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6d6672ba", "title": "Customize notifications for DDL changes", "url": "https://sqlblog.org/2018/08/27/customize-sql-server-notifications-for-ddl-changes", "published_at": "2018-08-27T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6debe223", "title": "Get started with SQL Server 2017 LocalDB", "url": "https://sqlblog.org/2018/08/01/getting-started-with-sql-server-2017-express-localdb", "published_at": "2018-08-01T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6e8c1fa7", "title": "MERGE with caution", "url": "https://sqlblog.org/2018/07/24/merge-with-caution", "published_at": "2018-07-24T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6f644621", "title": "Beware key order in missing index recommendations", "url": "https://sqlblog.org/2018/07/17/beware-key-order-missing-index-recommendations", "published_at": "2018-07-17T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c6fbb372d", "title": "T-SQL Tuesday #104: Code I'd hate to live without", "url": "https://sqlblog.org/2018/07/10/s1-t-sql-tuesday-104", "published_at": "2018-07-10T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c7078b7c0", "title": "Solving GDPR \"forget me\" requests", "url": "https://sqlblog.org/2018/07/02/solving-gdpr-forget-me-requests", "published_at": "2018-07-02T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c7106c3db", "title": "Using FOR XML PATH and STRING_AGG to denormalize data", "url": "https://sqlblog.org/2018/06/22/using-for-xml-path-and-string-agg-to-denormalize-data", "published_at": "2018-06-22T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c71bb1ba1", "title": "Data cleanup is more important with GDPR", "url": "https://sqlblog.org/2018/06/12/data-cleanup-becomes-more-important-with-gdpr", "published_at": "2018-06-12T00:00:00+00:00" }, { "id": "01a0d1d5-a1ae-71c5-85a4-bb5c727b4f58", "title": "Affect all triggers at once with dynamic SQL", "url": "https://sqlblog.org/2018/05/30/script-triggers-from-any-database", "published_at": "2018-05-30T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00df03023d", "title": "T-SQL Tuesday #102: Giving back", "url": "https://sqlblog.org/2018/05/08/s1-t-sql-tuesday-102-giving-back", "published_at": "2018-05-08T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00dff7cd49", "title": "UNION and data type mismatches", "url": "https://sqlblog.org/2018/05/07/issue-with-union-and-columns-with-mismatched-data-types", "published_at": "2018-05-07T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e097f704", "title": "Simulating TRY_CONVERT in SQL Server 2008 – Part 2", "url": "https://sqlblog.org/2018/04/25/simulating-try-convert-2008-2", "published_at": "2018-04-25T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e13d8852", "title": "Simulating TRY_CONVERT in SQL Server 2008 – Part 1", "url": "https://sqlblog.org/2018/04/02/simulating-try-convert-2008-2-2", "published_at": "2018-04-02T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e1fd5acc", "title": "Troubleshoot the Dedicated Administrator Connection", "url": "https://sqlblog.org/2018/03/07/troubleshooting-the-sql-server-dedicated-administrator-connection", "published_at": "2018-03-07T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e27e31af", "title": "Do tabs vs. spaces affect T-SQL performance?", "url": "https://sqlblog.org/2018/02/28/do-tabs-vs-spaces-affect-tsql-performance", "published_at": "2018-02-28T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e2b304b5", "title": "T-SQL Tuesday #99: Roundup", "url": "https://sqlblog.org/2018/02/20/t-sql-tuesday-99-roundup", "published_at": "2018-02-20T16:40:14+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e390197b", "title": "T-SQL Tuesday #99: Random collections", "url": "https://sqlblog.org/2018/02/13/t-sql-tuesday-99-random-collections", "published_at": "2018-02-13T13:40:21+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e3d34aa4", "title": "Q & A from our parameter sniffing webinars", "url": "https://sqlblog.org/2018/02/07/sqlperf-parameter-sniffing-webinar", "published_at": "2018-02-07T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e48396fb", "title": "T-SQL Tuesday #99: Dealer's choice (invite)", "url": "https://sqlblog.org/2018/02/06/t-sql-tuesday-99", "published_at": "2018-02-06T12:00:47+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e51e725a", "title": "Optimize for ad hoc workloads – per database", "url": "https://sqlblog.org/2018/02/01/optimize-for-ad-hoc-workloads-at-the-database-level", "published_at": "2018-02-01T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e619bdc3", "title": "Solve old problems with STRING_AGG and STRING_SPLIT", "url": "https://sqlblog.org/2018/01/19/solve-old-problems-with-new-string-agg-and-string-split-functions", "published_at": "2018-01-19T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e6adc49d", "title": "Same content, new home", "url": "https://sqlblog.org/2018/01/18/same-old-content-brand-new-home", "published_at": "2018-01-18T16:56:50+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e6b7e4dd", "title": "Is your SQL Server environment ready for GDPR?", "url": "https://sqlblog.org/2018/01/05/is-your-sql-server-environment-ready-for-gdpr", "published_at": "2018-01-05T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e7a3ce59", "title": "2017 : Community Influencer of the Year", "url": "https://sqlblog.org/2017/12/22/community-influencer-2017", "published_at": "2017-12-22T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e816619d", "title": "Changes to CXPACKET wait types", "url": "https://sqlblog.org/2017/12/18/tip5207-changes-to-sql-server-cxpacket-wait-types", "published_at": "2017-12-18T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e8dbb1c5", "title": "Best practices with date/time types", "url": "https://sqlblog.org/2017/11/15/tip5206-sql-server-datetime-best-practices", "published_at": "2017-11-15T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e9085d2b", "title": "T-SQL Tuesday #96: Difference makers", "url": "https://sqlblog.org/2017/11/14/s1-t-sql-tuesday-difference-makers", "published_at": "2017-11-14T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00e9cebf9b", "title": "Database engine changes in SQL Server 2017", "url": "https://sqlblog.org/2017/10/04/tip5119-overview-of-database-engine-changes-in-sql-server-2017", "published_at": "2017-10-04T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00ea4a9d68", "title": "More on resumable online index rebuilds", "url": "https://sqlblog.org/2017/09/20/tip5094-more-on-resumable-online-index-rebuilds-in-sql-server-2017", "published_at": "2017-09-20T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00eb1eee1e", "title": "T-SQL Tuesday #93: Looking back at bad interviews", "url": "https://sqlblog.org/2017/08/08/looking-back-at-bad-interviews", "published_at": "2017-08-08T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00eb6e3f35", "title": "Virtual log file monitoring in SQL Server 2017", "url": "https://sqlblog.org/2017/07/25/tip5008-virtual-log-file-monitoring-in-sql-server-2017", "published_at": "2017-07-25T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00ec194990", "title": "T-SQL Tuesday #92: Lessons learned the hard way", "url": "https://sqlblog.org/2017/07/11/s1-t-sql-tuesday-92-lessons-learned-hard-way", "published_at": "2017-07-11T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00ed0f8a5b", "title": "Deal with STRING_SPLIT's single-character delimiter", "url": "https://sqlblog.org/2017/06/22/tip4940-dealing-with-the-singlecharacter-delimiter-in-sql-servers-stringsplit-function", "published_at": "2017-06-22T00:00:00+00:00" }, { "id": "01a0d1d5-e82b-7166-8c99-2c00eddc628f", "title": "Performance myths: Oversizing string columns", "url": "https://sqlblog.org/2017/06/14/sqlperf-performance-myths-oversizing-strings", "published_at": "2017-06-14T00:00:00+00:00" } ] posts Claim your blog

Back to sqlblog.org

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

sqlblog.org

sqlblog.org

2020

Illogical errors can be a factor of the plan original ↗

19 Mar 2020

Changing a function's interface but staying backward compatible original ↗

18 Mar 2020

Attaching / restoring databases inside a container original ↗

15 Mar 2020

Additional tips for working from home original ↗

12 Mar 2020

Measure Delayed Durability impact original ↗

4 Mar 2020

Removing the default trace – Part 1 original ↗

2 Mar 2020

Checkpoint monitoring with Extended Events original ↗

17 Feb 2020

T-SQL Tuesday #123: Life hacks original ↗

11 Feb 2020

Use caution with this dynamic management function!original ↗

4 Feb 2020

Fun with (columnstore) compression on a very large table – Part 3 original ↗

3 Feb 2020

Use soft deletes to slow ghost record growth original ↗

29 Jan 2020

A minor office reorg – Part 2 original ↗

25 Jan 2020

A minor office reorg – Part 1 original ↗

21 Jan 2020

T-SQL Tuesday #122: Imposter syndrome original ↗

14 Jan 2020

Fun with (columnstore) compression on a very large table – Part 2 original ↗

7 Jan 2020

A simple use case for columnstore indexes original ↗

6 Jan 2020

2019 : Community Influencer of the Year original ↗

2 Jan 2020

2019

Fun with (columnstore) compression on a very large table – Part 1 original ↗

27 Dec 2019

Using metadata to troubleshoot metadata original ↗

18 Dec 2019

T-SQL Tuesday #121: Gifts original ↗

10 Dec 2019

Filtered indexes and forced parameterization (redux)original ↗

3 Dec 2019

Should we still chunk delete operations?original ↗

3 Dec 2019

Introducing Big Data Clusters original ↗

21 Nov 2019

SQL Server 2019: Setup enhancements original ↗

11 Nov 2019

Memory-optimized tempdb metadata original ↗

7 Nov 2019

Thoughts on SQL Server 2019 editions original ↗

1 Nov 2019

Simulating ON DELETE CASCADE original ↗

28 Oct 2019

Impact of UTF-8 support in SQL Server 2019 original ↗

15 Oct 2019

T-SQL Tuesday #119: Changing my mind original ↗

8 Oct 2019

Document columns across systems original ↗

2 Oct 2019

Forced parameterization, meet filtered indexes original ↗

19 Sept 2019

Use meaningful port numbers for Docker containers original ↗

14 Sept 2019

Bad Habits to Kick: Avoiding the schema prefix original ↗

12 Sept 2019

Another limitation of STRING_SPLIT original ↗

3 Sept 2019

Partitioning data without partitioning original ↗

27 Aug 2019

How to modify user-defined table types original ↗

8 Aug 2019

SQL Server 2019: Execution plan enhancements original ↗

1 Aug 2019

SQL Server Management Studio 18.2 original ↗

26 Jul 2019

Find integer columns to downsize original ↗

25 Jul 2019

Four T-SQL syntax rules I always follow original ↗

11 Jul 2019

Simplify date period calculations original ↗

27 Jun 2019

NOLOCK anomalies, issues, and inconsistencies original ↗

18 Jun 2019

Five things I wish I knew earlier in my career original ↗

8 May 2019

CASE expression overview original ↗

30 Apr 2019

Query extended properties from multiple databases original ↗

5 Apr 2019

Manage SQL Server Agent history more effectively original ↗

26 Mar 2019

An intro to Accelerated Database Recovery original ↗

6 Mar 2019

Charlotte User Group: Fix slow queries. Fast.original ↗

21 Feb 2019

Bulk loading on a budget – Part 2 original ↗

14 Feb 2019

Bulk loading on a budget – Part 1 original ↗

7 Feb 2019

Make DMV queries backward compatible original ↗

29 Jan 2019

Scalar UDF inlining original ↗

22 Jan 2019

Four ways to improve scalar function performance original ↗

11 Jan 2019

2018

2018 : Community Influencer of the Year original ↗

28 Dec 2018

Find events with overlapping date ranges original ↗

26 Dec 2018

SQL Server 2019: APPROX COUNT DISTINCT original ↗

19 Dec 2018

SQL Server support for TLS 1.2 – Read this first!original ↗

17 Nov 2018

Exploring scalar UDF inlining original ↗

12 Nov 2018

sp_ineachdb: Execute in the context of each database – Part 2 original ↗

22 Oct 2018

SQL Server 2019: ADD SENSITIVITY CLASSIFICATION original ↗

12 Oct 2018

SQL Server 2019: sys.dm_db_page_info original ↗

8 Oct 2018

What to do (or not do) about top wait stats original ↗

5 Oct 2018

sp_ineachdb: Execute in the context of each database – Part 1 original ↗

4 Oct 2018

T-SQL Tuesday #106: INSTEAD OF triggers original ↗

11 Sept 2018

Migrating from AnswerHub to WordPress: A tale of 10 technologies original ↗

10 Sept 2018

Table variable deferred compilation original ↗

6 Sept 2018

Customize notifications for DDL changes original ↗

27 Aug 2018

Get started with SQL Server 2017 LocalDB original ↗

1 Aug 2018

MERGE with caution original ↗

24 Jul 2018

Beware key order in missing index recommendations original ↗

17 Jul 2018

T-SQL Tuesday #104: Code I'd hate to live without original ↗

10 Jul 2018

Solving GDPR "forget me" requests original ↗

2 Jul 2018

Using FOR XML PATH and STRING_AGG to denormalize data original ↗

22 Jun 2018

Data cleanup is more important with GDPR original ↗

12 Jun 2018

Affect all triggers at once with dynamic SQL original ↗

30 May 2018

T-SQL Tuesday #102: Giving back original ↗

8 May 2018

UNION and data type mismatches original ↗

7 May 2018

Simulating TRY_CONVERT in SQL Server 2008 – Part 2 original ↗

25 Apr 2018

Simulating TRY_CONVERT in SQL Server 2008 – Part 1 original ↗

2 Apr 2018

Troubleshoot the Dedicated Administrator Connection original ↗

7 Mar 2018

Do tabs vs. spaces affect T-SQL performance?original ↗

28 Feb 2018

T-SQL Tuesday #99: Roundup original ↗

20 Feb 2018

T-SQL Tuesday #99: Random collections original ↗

13 Feb 2018

Q & A from our parameter sniffing webinars original ↗

7 Feb 2018

T-SQL Tuesday #99: Dealer's choice (invite)original ↗

6 Feb 2018

Optimize for ad hoc workloads – per database original ↗

1 Feb 2018

Solve old problems with STRING_AGG and STRING_SPLIT original ↗

19 Jan 2018

Same content, new home original ↗

18 Jan 2018

Is your SQL Server environment ready for GDPR?original ↗

5 Jan 2018

2017

2017 : Community Influencer of the Year original ↗

22 Dec 2017

Changes to CXPACKET wait types original ↗

18 Dec 2017

Best practices with date/time types original ↗

15 Nov 2017

T-SQL Tuesday #96: Difference makers original ↗

14 Nov 2017

Database engine changes in SQL Server 2017 original ↗

4 Oct 2017

More on resumable online index rebuilds original ↗

20 Sept 2017

T-SQL Tuesday #93: Looking back at bad interviews original ↗

8 Aug 2017

Virtual log file monitoring in SQL Server 2017 original ↗

25 Jul 2017

T-SQL Tuesday #92: Lessons learned the hard way original ↗

11 Jul 2017

Deal with STRING_SPLIT's single-character delimiter original ↗

22 Jun 2017

Performance myths: Oversizing string columns original ↗

14 Jun 2017