41554 blogs · [ { "id": "01a0d1d6-20ac-7347-868e-7c9d2c9865d4", "title": "Protect yourself from harmful DML", "url": "https://sqlblog.org/2017/05/15/tip4885-safeguard-to-avoid-costly-mistakes-for-update-or-delete-statements-in-sql-server-management-studio", "published_at": "2017-05-15T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2d552192", "title": "T-SQL Tuesday #90: Shipping database changes", "url": "https://sqlblog.org/2017/05/09/s1-t-sql-tuesday-90-shipping-database-changes", "published_at": "2017-05-09T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2e06fbe6", "title": "Performance impact of Row-Level Security", "url": "https://sqlblog.org/2017/03/27/tip4778-performance-impact-of-sql-server-2016-rowlevel-security", "published_at": "2017-03-27T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2e6893b5", "title": "Performance myths: Clustered vs. non-clustered indexes", "url": "https://sqlblog.org/2017/03/17/sqlperf-performance-myths-clustered-vs-non-clustered", "published_at": "2017-03-17T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2e76f1da", "title": "Harmful, pervasive SQL Server performance myths", "url": "https://sqlblog.org/2017/03/09/sqlperf-pervasive-sql-server-myths", "published_at": "2017-03-09T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2f33c179", "title": "Who changed temporal table data?", "url": "https://sqlblog.org/2017/02/27/tip4722-auditing-who-changed-temporal-table-data-in-sql-server", "published_at": "2017-02-27T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2f440351", "title": "T-SQL Tuesday #87: Shiny new toys", "url": "https://sqlblog.org/2017/02/14/s1-t-sql-tuesday-87-shiny-new-toys", "published_at": "2017-02-14T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2f968b14", "title": "Managing temporal table history", "url": "https://sqlblog.org/2017/02/10/tip4674-managing-temporal-table-history-in-sql-server-2016", "published_at": "2017-02-10T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d2ff4b1d6", "title": "Follow-up #1 on leading wildcard seeks", "url": "https://sqlblog.org/2017/02/08/sqlperf-follow-up-1-leading-wildcard-seeks", "published_at": "2017-02-08T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d306fb913", "title": "One way to get an index seek for a leading %wildcard", "url": "https://sqlblog.org/2017/02/03/sqlperf-seek-leading-wildcard-sql-server", "published_at": "2017-02-03T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d309a3925", "title": "Benefits of SCHEMABINDING in SQL Server", "url": "https://sqlblog.org/2017/01/31/tip4673-benefits-of-schemabinding-in-sql-server", "published_at": "2017-01-31T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d30ed067e", "title": "More on recovering access to SQL Server", "url": "https://sqlblog.org/2017/01/27/tip4672-more-on-recovering-access-to-a-sql-server-instance", "published_at": "2017-01-27T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d31b00a11", "title": "Performance surprises: GROUP BY vs. DISTINCT", "url": "https://sqlblog.org/2017/01/26/sqlperf-surprises-assumptions-group-by-distinct", "published_at": "2017-01-26T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d328e9aa1", "title": "T-SQL Tuesday #86: My favorite Connect items", "url": "https://sqlblog.org/2017/01/10/s1-t-sql-tuesday-86-favorite-connect-items", "published_at": "2017-01-10T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d334f9ff5", "title": "SQL Server 2017: STRING_AGG performance – Part 2", "url": "https://sqlblog.org/2017/01/06/sqlperf-sql-server-v-next-string_agg-performance-part-2", "published_at": "2017-01-06T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d33e8709f", "title": "2016 : Community Influencer of the Year", "url": "https://sqlblog.org/2016/12/31/community-influencer-2016", "published_at": "2016-12-31T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d3417cb6f", "title": "SQL Server 2017: STRING_AGG performance – Part 1", "url": "https://sqlblog.org/2016/12/28/sqlperf-sql-server-v-next-string_agg-performance", "published_at": "2016-12-28T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d34ea8f7b", "title": "T-SQL Tuesday #85: Are your backups worthless?", "url": "https://sqlblog.org/2016/12/13/s1-backups-worthless", "published_at": "2016-12-13T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d35d2a330", "title": "Memory limits in SQL Server 2016 SP1", "url": "https://sqlblog.org/2016/12/12/sqlperf-memory-limits-sp1", "published_at": "2016-12-12T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d35ff9798", "title": "Top 5 reasons for wrong results in SQL Server", "url": "https://sqlblog.org/2016/11/17/tip4569-top-5-reasons-for-wrong-results-in-sql-server", "published_at": "2016-11-17T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d3643f1b9", "title": "VS Code on Mac meets SQL Server on Linux (in Docker)", "url": "https://sqlblog.org/2016/11/16/s1-vs-code-mac-sql-linux-docker", "published_at": "2016-11-16T00:01:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d36616dab", "title": "A BIG DEAL: SQL Server 2016 Service Pack 1", "url": "https://sqlblog.org/2016/11/16/sqlperf-big-deal-sp1", "published_at": "2016-11-16T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d36c0ad04", "title": "New features in SQL Server 2016 SP1", "url": "https://sqlblog.org/2016/11/16/tip4574-new-features-in-sql-server-2016-service-pack-1", "published_at": "2016-11-16T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d375ea06d", "title": "Can comments hamper stored procedure performance?", "url": "https://sqlblog.org/2016/11/09/sqlperf-comments-hamper-performance", "published_at": "2016-11-09T00:00:00+00:00" }, { "id": "01a0d1d6-20ac-7347-868e-7c9d37f09949", "title": "#BackToBasics: CAST vs. CONVERT", "url": "https://sqlblog.org/2016/11/02/s1-backtobasics-cast-vs-convert", "published_at": "2016-11-02T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f906608b55", "title": "Cleaning up the master database", "url": "https://sqlblog.org/2016/10/27/tip4530-cleaning-up-the-sql-server-master-database", "published_at": "2016-10-27T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f9068b8397", "title": "SentryOne Plan Explorer 3.0 Demo Kit", "url": "https://sqlblog.org/2016/10/07/s1-plan-explorer-3-0-demo-kit", "published_at": "2016-10-07T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f9073bf317", "title": "#BackToBasics: Always lower case data types", "url": "https://sqlblog.org/2016/10/04/s1-backtobasics-lower-case-data-types", "published_at": "2016-10-04T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f907d512e6", "title": "Avoid ORDER BY in views", "url": "https://sqlblog.org/2016/10/04/tip4488-avoid-order-by-in-sql-server-views", "published_at": "2016-10-04T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f9084cdf66", "title": "Pattern matching: More fun when I was a kid", "url": "https://sqlblog.org/2016/09/06/sqlperf-pattern-matching", "published_at": "2016-09-06T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f908728f1a", "title": "#BackToBasics: Naming stored procedures", "url": "https://sqlblog.org/2016/09/01/s1-backtobasics-naming-stored-procedures", "published_at": "2016-09-01T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90941b72f", "title": "Widening an IDENTITY column – Part 4", "url": "https://sqlblog.org/2016/08/04/sqlperf-widening-identity-column-4", "published_at": "2016-08-04T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f9099dc6e4", "title": "#BackToBasics: Great debates – Unicode", "url": "https://sqlblog.org/2016/08/03/s1-backtobasics-unicode", "published_at": "2016-08-03T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f909f483ab", "title": "Beware of side-channel attacks in Row-Level Security", "url": "https://sqlblog.org/2016/07/21/tip4379-beware-of-sidechannel-attacks-in-rowlevel-security-in-sql-server-2016", "published_at": "2016-07-21T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90a11c724", "title": "Where do I get SQL Server 2016 Developer Edition?", "url": "https://sqlblog.org/2016/07/15/s1-get-developer-edition", "published_at": "2016-07-15T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90a691b79", "title": "T-SQL Tuesday #80: CREATE OR REPLACE", "url": "https://sqlblog.org/2016/07/12/s1-t-sql-tuesday-080", "published_at": "2016-07-12T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90aaa079f", "title": "Paying attention to estimates", "url": "https://sqlblog.org/2016/07/11/sqlperf-paying-attention-estimates", "published_at": "2016-07-11T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90b388f84", "title": "#BackToBasics: DATEFROMPARTS", "url": "https://sqlblog.org/2016/07/06/s1-backtobasics-datefromparts", "published_at": "2016-07-06T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90b5d5f3e", "title": "A potential improvement for statistics updates: MAXDOP", "url": "https://sqlblog.org/2016/07/01/sqlperf-statistics-maxdop", "published_at": "2016-07-01T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90c431cec", "title": "T-SQL Tuesday #79: A weird trick still missing from SQL Server", "url": "https://sqlblog.org/2016/06/14/s1-t-sql-tuesday-079", "published_at": "2016-06-14T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90c4b71c2", "title": "#BackToBasics: An updated \"Kitchen Sink\" example", "url": "https://sqlblog.org/2016/06/01/s1-backtobasics-updated-kitchen-sink-example", "published_at": "2016-06-01T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90c755f6a", "title": "T-SQL Tuesday #78: RID lookup vs. key lookup", "url": "https://sqlblog.org/2016/05/10/sqlperf-rid-lookup-faster-key-lookup", "published_at": "2016-05-10T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90d5ac3a9", "title": "#BackToBasics: Definitions of SQL Server release acronyms", "url": "https://sqlblog.org/2016/05/04/s1-back-to-basics-release-acronyms", "published_at": "2016-05-04T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90de8829e", "title": "STRING_SPLIT: Follow-up #2", "url": "https://sqlblog.org/2016/04/22/sqlperf-string-split-follow-up-2", "published_at": "2016-04-22T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90e518e94", "title": "STRING_SPLIT: Follow-up #1", "url": "https://sqlblog.org/2016/04/19/sqlperf-string-split-follow-up-1", "published_at": "2016-04-19T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90e91c504", "title": "Performance surprises: DATEADD", "url": "https://sqlblog.org/2016/04/11/sqlperf-surprises-dateadd", "published_at": "2016-04-11T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90f2e8c23", "title": "#BackToBasics: Dating responsibly", "url": "https://sqlblog.org/2016/04/06/s1-backtobasics-dating-responsibly", "published_at": "2016-04-06T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90f593bbb", "title": "On telemetry collected by SQL Server", "url": "https://sqlblog.org/2016/04/04/sql-server-telemetry", "published_at": "2016-04-04T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f90f7aee6e", "title": "More ways to discover changes in new versions of SQL Server", "url": "https://sqlblog.org/2016/03/30/s1-more-changes-sql-server", "published_at": "2016-03-30T00:00:00+00:00" }, { "id": "01a0d1d6-5810-729e-88c5-54f910635e86", "title": "Performance surprises: STRING_SPLIT", "url": "https://sqlblog.org/2016/03/18/sqlperf-string-split", "published_at": "2016-03-18T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528edea2468d", "title": "Instant File Initialization: Impact during setup", "url": "https://sqlblog.org/2016/03/11/sqlperf-ifi-tempdb-setup", "published_at": "2016-03-11T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528edeac908c", "title": "Extracting ShowPlan XML from Extended Events", "url": "https://sqlblog.org/2016/03/10/tip4210-extracting-showplan-xml-from-sql-server-extended-events", "published_at": "2016-03-10T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528edf881715", "title": "Bad cardinality estimates from SSMS plans – redux", "url": "https://sqlblog.org/2016/03/04/sqlperf-bad-cardinality-estimates-ssms-redux", "published_at": "2016-03-04T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528edfa7f6aa", "title": "#BackToBasics: The beauty of the synonym", "url": "https://sqlblog.org/2016/03/02/s1-backtobasics-synonym", "published_at": "2016-03-02T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee057307e", "title": "Performance surprises: SET NOCOUNT ON", "url": "https://sqlblog.org/2016/02/26/sqlperf-nocount", "published_at": "2016-02-26T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee077834d", "title": "The Numbers Table, Explained – Part 2", "url": "https://sqlblog.org/2016/02/26/tip4177-the-sql-server-numbers-table-explained-part-2", "published_at": "2016-02-26T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee12f37dd", "title": "The Numbers Table, Explained – Part 1", "url": "https://sqlblog.org/2016/02/18/tip4176-the-sql-server-numbers-table-explained-part-1", "published_at": "2016-02-18T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee1f71a23", "title": "Widening an IDENTITY column – Part 3", "url": "https://sqlblog.org/2016/02/17/sqlperf-widening-identity-column-3", "published_at": "2016-02-17T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee2733b12", "title": "Widening an IDENTITY column – Part 2", "url": "https://sqlblog.org/2016/02/11/sqlperf-widening-identity-column-2", "published_at": "2016-02-11T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee28aba57", "title": "Pin the blame on the query", "url": "https://sqlblog.org/2016/02/09/s1-pin-the-blame-on-the-query", "published_at": "2016-02-09T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee2fab7c3", "title": "#BackToBasics: The \"runaway\" query", "url": "https://sqlblog.org/2016/02/03/s1-backtobasics-the-runaway-query", "published_at": "2016-02-03T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee32c1629", "title": "Widening an IDENTITY column – Part 1", "url": "https://sqlblog.org/2016/01/29/sqlperf-widening-identity-column-1", "published_at": "2016-01-29T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee39b83ec", "title": "Comparing string splitting / concatenation methods", "url": "https://sqlblog.org/2016/01/22/sqlperf-comparing-splitting-concat", "published_at": "2016-01-22T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee3f2bf48", "title": "Subjectivity: Naming standards", "url": "https://sqlblog.org/2016/01/18/s1-subjectivity-naming-standards", "published_at": "2016-01-18T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee41465e8", "title": "Can columnstore help pagination workloads?", "url": "https://sqlblog.org/2016/01/15/sqlperf-columnstore-pagination", "published_at": "2016-01-15T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee4bceaca", "title": "Remove duplicates from strings", "url": "https://sqlblog.org/2016/01/14/tip4140-removing-duplicates-from-strings-in-sql-server", "published_at": "2016-01-14T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee4bd0885", "title": "Advanced JSON techniques – Part 3", "url": "https://sqlblog.org/2016/01/07/tip4138-advanced-json-techniques-in-sql-server-2016-part-3", "published_at": "2016-01-07T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee58dbb3b", "title": "#BackToBasics: Common table expressions (CTEs)", "url": "https://sqlblog.org/2016/01/06/s1-backtobasics-ctes", "published_at": "2016-01-06T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee596e1b8", "title": "Dropping support for ancient versions", "url": "https://sqlblog.org/2015/12/31/ancient-versions", "published_at": "2015-12-31T08:21:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee5c81ae1", "title": "SQL Server 2016: Availability group enhancements", "url": "https://sqlblog.org/2015/12/17/sqlperf-availability-group-enhancements", "published_at": "2015-12-17T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee673ee16", "title": "More showplan improvements? Yes, please!", "url": "https://sqlblog.org/2015/12/08/sqlperf-more-showplan-improvements", "published_at": "2015-12-08T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee6be0aa9", "title": "Partitioning on a budget", "url": "https://sqlblog.org/2015/12/04/sqlperf-partitioning-on-a-budget", "published_at": "2015-12-04T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee6d10adc", "title": "How I spot not-yet-documented features in SQL Server CTPs", "url": "https://sqlblog.org/2015/12/02/fishing-for-features-in-ctps", "published_at": "2015-12-02T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee77d52b7", "title": "SQL Server 2016: In-memory OLTP enhancements", "url": "https://sqlblog.org/2015/11/30/sqlperf-in-memory-oltp-enhancements", "published_at": "2015-11-30T00:00:00+00:00" }, { "id": "01a0d1d6-95ae-73b7-b8c6-528ee8507768", "title": "Replace CONTEXT_INFO() with SESSION_CONTEXT()", "url": "https://sqlblog.org/2015/11/19/tip4094-phase-out-contextinfo-in-sql-server-2016-with-sessioncontext", "published_at": "2015-11-19T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef1803162e4", "title": "Please help improve SQL Server statistics!", "url": "https://sqlblog.org/2015/11/12/sqlperf-please-help-improve-sql-server-statistics", "published_at": "2015-11-12T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef1809572d3", "title": "T-SQL Tuesday #72: Models gone wild!", "url": "https://sqlblog.org/2015/11/10/s1-t-sql-tuesday-72-models-gone-wild", "published_at": "2015-11-10T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef181641dd6", "title": "Advanced JSON techniques – Part 2", "url": "https://sqlblog.org/2015/11/03/tip4081-advanced-json-techniques-in-sql-server-2016-part-2", "published_at": "2015-11-03T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef1825a4378", "title": "Advanced JSON techniques – Part 1", "url": "https://sqlblog.org/2015/10/30/tip4073-sql-server-2016-advanced-json-techniques-part-1", "published_at": "2015-10-30T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18280f31b", "title": "Service Broker enhancements in SQL Server 2016", "url": "https://sqlblog.org/2015/10/26/sqlperf-service-broker-enhancements", "published_at": "2015-10-26T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef182e32e3b", "title": "SERVERPROPERTY options to phase out @@VERSION", "url": "https://sqlblog.org/2015/10/22/s1-new-serverproperty-options-to-help-phase-out-version", "published_at": "2015-10-22T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef183233753", "title": "A cheat sheet for native date and time formats", "url": "https://sqlblog.org/2015/10/13/tip4052-build-a-cheat-sheet-for-sql-server-date-and-time-formats", "published_at": "2015-10-13T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef183c28b3b", "title": "Maintain a grouped running MAX (or MIN)", "url": "https://sqlblog.org/2015/10/08/sqlperf-grouped-running-max", "published_at": "2015-10-08T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef1844645b2", "title": "Cleanly uninstall stubborn SQL Server features", "url": "https://sqlblog.org/2015/10/06/tip4050-cleanly-uninstalling-stubborn-sql-server-components", "published_at": "2015-10-06T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18453102a", "title": "SQL Server 2016: Getting tempdb a little more right", "url": "https://sqlblog.org/2015/09/30/s1-sql-server-2016-tempdb-fixes", "published_at": "2015-09-30T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef184b05466", "title": "Search all string columns in all databases", "url": "https://sqlblog.org/2015/09/30/tip4039-search-all-string-columns-in-all-sql-server-databases", "published_at": "2015-09-30T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18500a6ea", "title": "Follow-up on cursor options", "url": "https://sqlblog.org/2015/09/22/sqlperf-cursor-options-2", "published_at": "2015-09-22T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef185da14e6", "title": "SQL Server 2016: Always Encrypted", "url": "https://sqlblog.org/2015/09/15/tip4011-sql-server-2016-always-encrypted", "published_at": "2015-09-15T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef1860685a3", "title": "Row-Level Security limitations and troubleshooting", "url": "https://sqlblog.org/2015/09/02/tip4005-sql-server-2016-row-level-security-limitations-performance-and-troubleshooting", "published_at": "2015-09-02T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef186610a98", "title": "An intro to Row-Level Security", "url": "https://sqlblog.org/2015/08/31/tip4004-sql-server-2016-row-level-security-introduction", "published_at": "2015-08-31T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef186a2a937", "title": "Some limitations of Dynamic Data Masking", "url": "https://sqlblog.org/2015/08/20/tip4002-understand-the-limitations-of-sql-server-dynamic-data-masking", "published_at": "2015-08-20T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18748a123", "title": "Always Encrypted performance: A follow-up", "url": "https://sqlblog.org/2015/08/17/sqlperf-always-encrypted-performance-follow-up", "published_at": "2015-08-17T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef187d74f61", "title": "Identify candidate tables for Stretch Databases", "url": "https://sqlblog.org/2015/08/13/tip3689-identify-candidate-tables-for-sql-server-2016-stretch-databases", "published_at": "2015-08-13T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef188d5467e", "title": "Performance impact of Always Encrypted", "url": "https://sqlblog.org/2015/08/11/sqlperf-perf-impact-always-encrypted", "published_at": "2015-08-11T00:01:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef188e58f6d", "title": "T-SQL Tuesday #69: Always Encrypted limitations", "url": "https://sqlblog.org/2015/08/11/s1-t-sql-tuesday-69-always-encrypted-limitations", "published_at": "2015-08-11T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef189aef895", "title": "bAd HAbiTs tO kiCk: BEinG CarELesS aBOut cAsE", "url": "https://sqlblog.org/2015/08/07/s1-bad-habits-careless-about-case", "published_at": "2015-08-07T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18a204baf", "title": "What I mess up whenever I install SQL Server on a new VM", "url": "https://sqlblog.org/2015/07/31/s1-mess-up-setup", "published_at": "2015-07-31T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18a6707b8", "title": "Prepare for an upgrade with the SQL Server Upgrade Advisor", "url": "https://sqlblog.org/2015/07/29/tip3688-prepare-for-an-upgrade-with-the-sql-server-2016-upgrade-advisor", "published_at": "2015-07-29T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18b141bd4", "title": "I have an aversion to @@VERSION", "url": "https://sqlblog.org/2015/07/22/aversion-version", "published_at": "2015-07-22T00:00:00+00:00" }, { "id": "01a0d1d6-cb82-738b-830f-9ef18bdeae03", "title": "T-SQL Tuesday #68: All features with defaults", "url": "https://sqlblog.org/2015/07/14/s1-t-sql-tuesday-68-defaults", "published_at": "2015-07-14T00:00:00+00:00" } ] posts Claim your blog

Back to sqlblog.org

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

sqlblog.org

sqlblog.org

2017

Protect yourself from harmful DML original ↗

15 May 2017

T-SQL Tuesday #90: Shipping database changes original ↗

9 May 2017

Performance impact of Row-Level Security original ↗

27 Mar 2017

Performance myths: Clustered vs. non-clustered indexes original ↗

17 Mar 2017

Harmful, pervasive SQL Server performance myths original ↗

9 Mar 2017

Who changed temporal table data?original ↗

27 Feb 2017

T-SQL Tuesday #87: Shiny new toys original ↗

14 Feb 2017

Managing temporal table history original ↗

10 Feb 2017

Follow-up #1 on leading wildcard seeks original ↗

8 Feb 2017

One way to get an index seek for a leading %wildcard original ↗

3 Feb 2017

Benefits of SCHEMABINDING in SQL Server original ↗

31 Jan 2017

More on recovering access to SQL Server original ↗

27 Jan 2017

Performance surprises: GROUP BY vs. DISTINCT original ↗

26 Jan 2017

T-SQL Tuesday #86: My favorite Connect items original ↗

10 Jan 2017

SQL Server 2017: STRING_AGG performance – Part 2 original ↗

6 Jan 2017

2016

2016 : Community Influencer of the Year original ↗

31 Dec 2016

SQL Server 2017: STRING_AGG performance – Part 1 original ↗

28 Dec 2016

T-SQL Tuesday #85: Are your backups worthless?original ↗

13 Dec 2016

Memory limits in SQL Server 2016 SP1 original ↗

12 Dec 2016

Top 5 reasons for wrong results in SQL Server original ↗

17 Nov 2016

VS Code on Mac meets SQL Server on Linux (in Docker)original ↗

16 Nov 2016

A BIG DEAL: SQL Server 2016 Service Pack 1 original ↗

16 Nov 2016

New features in SQL Server 2016 SP1 original ↗

16 Nov 2016

Can comments hamper stored procedure performance?original ↗

9 Nov 2016

#BackToBasics: CAST vs. CONVERT original ↗

2 Nov 2016

Cleaning up the master database original ↗

27 Oct 2016

SentryOne Plan Explorer 3.0 Demo Kit original ↗

7 Oct 2016

#BackToBasics: Always lower case data types original ↗

4 Oct 2016

Avoid ORDER BY in views original ↗

4 Oct 2016

Pattern matching: More fun when I was a kid original ↗

6 Sept 2016

#BackToBasics: Naming stored procedures original ↗

1 Sept 2016

Widening an IDENTITY column – Part 4 original ↗

4 Aug 2016

#BackToBasics: Great debates – Unicode original ↗

3 Aug 2016

Beware of side-channel attacks in Row-Level Security original ↗

21 Jul 2016

Where do I get SQL Server 2016 Developer Edition?original ↗

15 Jul 2016

T-SQL Tuesday #80: CREATE OR REPLACE original ↗

12 Jul 2016

Paying attention to estimates original ↗

11 Jul 2016

#BackToBasics: DATEFROMPARTS original ↗

6 Jul 2016

A potential improvement for statistics updates: MAXDOP original ↗

1 Jul 2016

T-SQL Tuesday #79: A weird trick still missing from SQL Server original ↗

14 Jun 2016

#BackToBasics: An updated "Kitchen Sink" example original ↗

1 Jun 2016

T-SQL Tuesday #78: RID lookup vs. key lookup original ↗

10 May 2016

#BackToBasics: Definitions of SQL Server release acronyms original ↗

4 May 2016

STRING_SPLIT: Follow-up #2 original ↗

22 Apr 2016

STRING_SPLIT: Follow-up #1 original ↗

19 Apr 2016

Performance surprises: DATEADD original ↗

11 Apr 2016

#BackToBasics: Dating responsibly original ↗

6 Apr 2016

On telemetry collected by SQL Server original ↗

4 Apr 2016

More ways to discover changes in new versions of SQL Server original ↗

30 Mar 2016

Performance surprises: STRING_SPLIT original ↗

18 Mar 2016

Instant File Initialization: Impact during setup original ↗

11 Mar 2016

Extracting ShowPlan XML from Extended Events original ↗

10 Mar 2016

Bad cardinality estimates from SSMS plans – redux original ↗

4 Mar 2016

#BackToBasics: The beauty of the synonym original ↗

2 Mar 2016

Performance surprises: SET NOCOUNT ON original ↗

26 Feb 2016

The Numbers Table, Explained – Part 2 original ↗

26 Feb 2016

The Numbers Table, Explained – Part 1 original ↗

18 Feb 2016

Widening an IDENTITY column – Part 3 original ↗

17 Feb 2016

Widening an IDENTITY column – Part 2 original ↗

11 Feb 2016

Pin the blame on the query original ↗

9 Feb 2016

#BackToBasics: The "runaway" query original ↗

3 Feb 2016

Widening an IDENTITY column – Part 1 original ↗

29 Jan 2016

Comparing string splitting / concatenation methods original ↗

22 Jan 2016

Subjectivity: Naming standards original ↗

18 Jan 2016

Can columnstore help pagination workloads?original ↗

15 Jan 2016

Remove duplicates from strings original ↗

14 Jan 2016

Advanced JSON techniques – Part 3 original ↗

7 Jan 2016

#BackToBasics: Common table expressions (CTEs)original ↗

6 Jan 2016

2015

Dropping support for ancient versions original ↗

31 Dec 2015

SQL Server 2016: Availability group enhancements original ↗

17 Dec 2015

More showplan improvements? Yes, please!original ↗

8 Dec 2015

Partitioning on a budget original ↗

4 Dec 2015

How I spot not-yet-documented features in SQL Server CTPs original ↗

2 Dec 2015

SQL Server 2016: In-memory OLTP enhancements original ↗

30 Nov 2015

Replace CONTEXT_INFO() with SESSION_CONTEXT()original ↗

19 Nov 2015

Please help improve SQL Server statistics!original ↗

12 Nov 2015

T-SQL Tuesday #72: Models gone wild!original ↗

10 Nov 2015

Advanced JSON techniques – Part 2 original ↗

3 Nov 2015

Advanced JSON techniques – Part 1 original ↗

30 Oct 2015

Service Broker enhancements in SQL Server 2016 original ↗

26 Oct 2015

SERVERPROPERTY options to phase out @@VERSION original ↗

22 Oct 2015

A cheat sheet for native date and time formats original ↗

13 Oct 2015

Maintain a grouped running MAX (or MIN)original ↗

8 Oct 2015

Cleanly uninstall stubborn SQL Server features original ↗

6 Oct 2015

SQL Server 2016: Getting tempdb a little more right original ↗

30 Sept 2015

Search all string columns in all databases original ↗

30 Sept 2015

Follow-up on cursor options original ↗

22 Sept 2015

SQL Server 2016: Always Encrypted original ↗

15 Sept 2015

Row-Level Security limitations and troubleshooting original ↗

2 Sept 2015

An intro to Row-Level Security original ↗

31 Aug 2015

Some limitations of Dynamic Data Masking original ↗

20 Aug 2015

Always Encrypted performance: A follow-up original ↗

17 Aug 2015

Identify candidate tables for Stretch Databases original ↗

13 Aug 2015

Performance impact of Always Encrypted original ↗

11 Aug 2015

T-SQL Tuesday #69: Always Encrypted limitations original ↗

11 Aug 2015

bAd HAbiTs tO kiCk: BEinG CarELesS aBOut cAsE original ↗

7 Aug 2015

What I mess up whenever I install SQL Server on a new VM original ↗

31 Jul 2015

Prepare for an upgrade with the SQL Server Upgrade Advisor original ↗

29 Jul 2015

I have an aversion to @@VERSION original ↗

22 Jul 2015

T-SQL Tuesday #68: All features with defaults original ↗

14 Jul 2015