corpus.blog
41554 blogs · [ { "id": "01a0d1d7-b496-7392-8bc9-fe23d11b63eb", "title": "Generate a sequence without loops – Part 3", "url": "https://sqlblog.org/2013/01/18/sqlperf-generate-a-set-3", "published_at": "2013-01-18T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d1c239dc", "title": "Generate a sequence without loops – Part 2", "url": "https://sqlblog.org/2013/01/17/sqlperf-generate-a-set-2", "published_at": "2013-01-17T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d1fdfcfe", "title": "Generate a sequence without loops – Part 1", "url": "https://sqlblog.org/2013/01/16/sqlperf-generate-a-set-1", "published_at": "2013-01-16T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d2a81670", "title": "Potential enhancements to ASPState", "url": "https://sqlblog.org/2013/01/11/sqlperf-optimize-aspstate", "published_at": "2013-01-11T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d3963490", "title": "Should I use NOT IN, OUTER APPLY, LEFT OUTER JOIN, EXCEPT, or NOT EXISTS?", "url": "https://sqlblog.org/2012/12/27/sqlperf-left-anti-semi-join", "published_at": "2012-12-27T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d4766420", "title": "Minimize the impact of DBCC CHECKDB", "url": "https://sqlblog.org/2012/11/29/sqlperf-minimize-impact-of-checkdb", "published_at": "2012-11-29T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d5584c43", "title": "Bad cardinality estimates from SSMS execution plans", "url": "https://sqlblog.org/2012/11/02/sqlperf-misleading-estimates-from-plans", "published_at": "2012-11-02T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d637bd9a", "title": "Audit when triggers are enabled or disabled", "url": "https://sqlblog.org/2012/11/01/tip2802-auditing-when-triggers-are-disabled-or-enabled-for-sql-server", "published_at": "2012-11-01T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d72777eb", "title": "Beware misleading data from SET STATISTICS IO", "url": "https://sqlblog.org/2012/10/30/sqlperf-beware_statistics_io", "published_at": "2012-10-30T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d77bfeb5", "title": "Trimming time from datetime – a follow-up", "url": "https://sqlblog.org/2012/10/25/sqlperf-trim-time", "published_at": "2012-10-25T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d78af7e7", "title": "Script to create dynamic PIVOT queries", "url": "https://sqlblog.org/2012/10/16/tip2783-script-to-create-dynamic-pivot-queries-in-sql-server", "published_at": "2012-10-16T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d86f830f", "title": "Is the sp_ prefix still a no-no?", "url": "https://sqlblog.org/2012/10/15/sqlperf-sp_prefix", "published_at": "2012-10-15T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d888ea53", "title": "Checking if a non-LOB column needs to be updated", "url": "https://sqlblog.org/2012/10/03/sqlperf-conditional-updates", "published_at": "2012-10-03T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d88cf2a3", "title": "Hit-highlighting in full-text search", "url": "https://sqlblog.org/2012/09/24/sqlperf-hit-highlighting-in-full-text-search", "published_at": "2012-09-24T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d8dec02d", "title": "What impact can different cursor options have?", "url": "https://sqlblog.org/2012/09/20/sqlperf-cursor-options", "published_at": "2012-09-20T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d94f76fd", "title": "Revisit your use of the REMOTE join hint", "url": "https://sqlblog.org/2012/09/18/tip2765-revisit-your-use-of-the-sql-server-remote-join-hint", "published_at": "2012-09-18T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23d9ae8c51", "title": "How much impact can a data type choice have?", "url": "https://sqlblog.org/2012/09/13/sqlperf-data-type-choice", "published_at": "2012-09-13T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23da9146b3", "title": "Build a quota system for user-defined tables", "url": "https://sqlblog.org/2012/09/12/tip2764-build-a-quota-system-for-sql-server-user-defined-tables", "published_at": "2012-09-12T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23db0de88f", "title": "SQLSaturday #162: Cambridge, England", "url": "https://sqlblog.org/2012/09/09/sqlsaturday-162-cambridge-england", "published_at": "2012-09-09T18:08:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23db7d01b0", "title": "What is the most efficient way to trim time from datetime?", "url": "https://sqlblog.org/2012/09/05/sqlperf-what-is-the-most-efficient-way-to-trim-time-from-datetime", "published_at": "2012-09-05T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23dc5a2bba", "title": "Recover access to SQL Server", "url": "https://sqlblog.org/2012/08/30/tip2682-recover-access-to-a-sql-server-instance", "published_at": "2012-08-30T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23dcdfe806", "title": "What is the fastest way to calculate the median?", "url": "https://sqlblog.org/2012/08/29/sqlperf-median", "published_at": "2012-08-29T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23dd5d182e", "title": "Using named instances? Test your DAC connection!", "url": "https://sqlblog.org/2012/08/24/sqlperf-test-your-dac-connection", "published_at": "2012-08-24T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23dd8af82e", "title": "Performance impact of different error handling techniques", "url": "https://sqlblog.org/2012/08/22/sqlperf-error-handling", "published_at": "2012-08-22T00:00:00+00:00" }, { "id": "01a0d1d7-b496-7392-8bc9-fe23de67ea4d", "title": "Splitting strings: Now with less T-SQL", "url": "https://sqlblog.org/2012/08/16/sqlperf-splitting-strings-now-with-less-t-sql", "published_at": "2012-08-16T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cca2ed92e", "title": "T-SQL Tuesday #33: Schema switch-a-roo", "url": "https://sqlblog.org/2012/08/14/sqlperf-t-sql-tuesday-schema-switch-a-roo", "published_at": "2012-08-14T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cca85fb6d", "title": "Conditional Order By", "url": "https://sqlblog.org/2012/08/08/sqlperf-conditional-order-by", "published_at": "2012-08-08T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccb7e42ea", "title": "Splitting strings: A follow-up", "url": "https://sqlblog.org/2012/08/02/sqlperf-splitting-strings-follow-up", "published_at": "2012-08-02T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccc271014", "title": "When the DRY principle doesn’t apply: BITWISE operators", "url": "https://sqlblog.org/2012/08/01/sqlperf-dry-principle-bitwise-operations", "published_at": "2012-08-01T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cccd76a6c", "title": "Removing MDW – the Management Data Warehouse", "url": "https://sqlblog.org/2012/07/31/tip2473-removing-the-sql-server-management-data-warehouse", "published_at": "2012-07-31T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccd588a45", "title": "Split strings the right way – or the next best way", "url": "https://sqlblog.org/2012/07/26/sqlperf-split-strings", "published_at": "2012-07-26T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccd9f2163", "title": "Best approaches for running totals – updated for SQL Server 2012", "url": "https://sqlblog.org/2012/07/24/sqlperf-running-totals", "published_at": "2012-07-24T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccdaf17ac", "title": "Find queries with hints using DMVs", "url": "https://sqlblog.org/2012/07/24/tip2475-sql-server-queries-with-hints", "published_at": "2012-07-24T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccdafad13", "title": "Script to help conform to naming conventions", "url": "https://sqlblog.org/2012/06/19/tip2709-script-to-rename-constraints-and-indexes-to-conform-to-a-sql-server-naming-convention", "published_at": "2012-06-19T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccea5bf70", "title": "Tracking password changes", "url": "https://sqlblog.org/2012/06/13/tip2708-tracking-login-password-changes-in-sql-server", "published_at": "2012-06-13T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccf4170f1", "title": "Getting started with SQL Server 2012 LocalDB", "url": "https://sqlblog.org/2012/05/16/tip2694-getting-started-with-sql-server-2012-express-localdb", "published_at": "2012-05-16T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132ccf5a8744", "title": "Maintaining default trace history", "url": "https://sqlblog.org/2012/05/08/tip2695-maintaining-sql-server-default-trace-historical-events-for-analysis-and-reporting", "published_at": "2012-05-08T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd0548daf", "title": "Deciding between COALESCE and ISNULL", "url": "https://sqlblog.org/2012/04/30/tip2689-deciding-between-coalesce-and-isnull-in-sql-server", "published_at": "2012-04-30T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd11ab54f", "title": "A cautionary tale about CAL licenses in SQL Server 2012 Enterprise", "url": "https://sqlblog.org/2012/04/27/a-cautionary-tale-about-cal-licenses-in-sql-server-2012-enterprise", "published_at": "2012-04-27T13:05:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd11cb452", "title": "Minimize plan cache bloat", "url": "https://sqlblog.org/2012/04/24/tip2681-minimize-sql-server-plan-cache-bloat", "published_at": "2012-04-24T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd21aa8a7", "title": "Storing E-mail addresses more efficiently – Part 2", "url": "https://sqlblog.org/2012/04/12/tip2671-storing-email-addresses-more-efficiently-in-sql-server-part-2", "published_at": "2012-04-12T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd22af503", "title": "Participating in 3 SQL events in 8 days", "url": "https://sqlblog.org/2012/04/04/participating-in-3-sql-events-in-8-days", "published_at": "2012-04-04T12:08:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd260779c", "title": "Storing E-mail addresses more efficiently – Part 1", "url": "https://sqlblog.org/2012/03/13/tip2657-storing-email-addresses-more-efficiently-in-sql-server", "published_at": "2012-03-13T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd3061478", "title": "Why people think some SQL Server 2000 behaviors live on… 12 years later", "url": "https://sqlblog.org/2012/02/28/why-people-think-some-sql-server-2000-behaviors-live-on-12-years-later", "published_at": "2012-02-28T12:57:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd3735aa3", "title": "Checking for potential constraint violations before entering TRY / CATCH", "url": "https://sqlblog.org/2012/02/28/tip2632-checking-for-potential-constraint-violations-before-entering-sql-server-try-and-catch-logic", "published_at": "2012-02-28T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd3fb4113", "title": "Bad Habits to Kick: Believing everything you hear or read", "url": "https://sqlblog.org/2012/02/27/bad-habits-to-kick-believing-everything-you-hear-or-read", "published_at": "2012-02-27T14:52:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd49c0701", "title": "Troubleshoot IntelliSense in Management Studio", "url": "https://sqlblog.org/2012/02/01/tip2591-troubleshooting-intellisense-in-sql-server-management-studio-2012", "published_at": "2012-02-01T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd58123d9", "title": "Bad Habits to Kick: Thinking a WHILE loop isn't a CURSOR", "url": "https://sqlblog.org/2012/01/26/bad-habits-to-kick-thinking-a-while-loop-isnt-a-cursor", "published_at": "2012-01-26T17:50:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd6161214", "title": "Use snippets in SSMS to encourage consistent conventions", "url": "https://sqlblog.org/2012/01/25/tip2589-use-sql-server-code-snippets-to-encourage-consistent-conventions", "published_at": "2012-01-25T00:00:00+00:00" }, { "id": "01a0d1d7-dec5-723a-afcb-132cd6d1936f", "title": "Bad Habits to Kick: AS instead of = for column aliases", "url": "https://sqlblog.org/2012/01/23/bad-habits-to-kick-using-as-instead-of-for-column-aliases", "published_at": "2012-01-23T13:31:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e903b8e3b1", "title": "2011, a year in review", "url": "https://sqlblog.org/2012/01/20/blog-post-500-2011-a-year-in-review", "published_at": "2012-01-20T15:55:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e903f8cc24", "title": "Get alerts for specific login failed events", "url": "https://sqlblog.org/2012/01/17/tip2595-get-alerts-for-specific-sql-server-login-failed-events", "published_at": "2012-01-17T00:00:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e904720f72", "title": "T-SQL Tuesday #26: Second chances", "url": "https://sqlblog.org/2012/01/10/t-sql-tuesday-26-second-chances", "published_at": "2012-01-10T12:20:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9047860cf", "title": "T-SQL Tuesday #25: T-SQL tips and tricks", "url": "https://sqlblog.org/2011/12/13/t-sql-tuesday-25-t-sql-tips-n-tricks", "published_at": "2011-12-13T14:50:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9047a7553", "title": "Determining distribution of NULL values", "url": "https://sqlblog.org/2011/11/17/determining-distribution-of-null-values", "published_at": "2011-11-17T23:21:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90526e107", "title": "T-SQL Tuesday #24: Dude, where's the rest of my procedure?", "url": "https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure", "published_at": "2011-11-08T03:19:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e905b3ee6b", "title": "The case against INFORMATION_SCHEMA views", "url": "https://sqlblog.org/2011/11/03/the-case-against-information_schema-views", "published_at": "2011-11-03T12:49:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e905c251c7", "title": "Unexpected errors from table-valued functions", "url": "https://sqlblog.org/2011/10/20/unexpected-errors-from-table-valued-functions", "published_at": "2011-10-20T17:30:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9064729a0", "title": "Finding keyless tables across multiple servers", "url": "https://sqlblog.org/2011/10/20/finding-keyless-tables-across-multiple-servers", "published_at": "2011-10-20T15:07:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e907184a4b", "title": "What do BETWEEN and the devil have in common?", "url": "https://sqlblog.org/2011/10/19/what-do-between-and-the-devil-have-in-common", "published_at": "2011-10-19T15:37:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90785c90e", "title": "Printing SPID information along with DBCC output", "url": "https://sqlblog.org/2011/10/06/printing-spid-information-along-with-dbcc-output", "published_at": "2011-10-06T15:02:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9080acb74", "title": "T-SQL Tuesday #23: Well, that's a kick in the JOIN…", "url": "https://sqlblog.org/2011/10/04/t-sql-tuesday-23-well-thats-a-kick-in-the-join", "published_at": "2011-10-04T13:19:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9088b9b01", "title": "Policy-Based Management: facets and evaluation methods", "url": "https://sqlblog.org/2011/10/03/policy-based-management-which-facets-support-which-evaluation-methods", "published_at": "2011-10-03T16:04:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e908ad4b03", "title": "Will you use EOMONTH?", "url": "https://sqlblog.org/2011/09/22/sql-server-v-next-denali-will-you-use-eomonth", "published_at": "2011-09-22T16:45:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e908d2b9d8", "title": "Bad Habits to Kick: Date and time shorthand", "url": "https://sqlblog.org/2011/09/20/bad-habits-to-kick-using-shorthand-with-date-time-operations", "published_at": "2011-09-20T09:31:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e908ffd08e", "title": "Bad Habits to Kick: EXEC instead of sp_executesql", "url": "https://sqlblog.org/2011/09/17/bad-habits-to-kick-using-exec-instead-of-sp_executesql", "published_at": "2011-09-17T13:50:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e9097ba92a", "title": "Why generalizations are dangerous", "url": "https://sqlblog.org/2011/09/15/why-generalizations-are-dangerous", "published_at": "2011-09-15T20:19:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e909efc487", "title": "T-SQL Tuesday #21: Crap Code", "url": "https://sqlblog.org/2011/08/10/t-sql-tuesday-21-crap-code", "published_at": "2011-08-10T14:42:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e909fe14f6", "title": "sys.sp_hexadecimal: A quasi-system object?", "url": "https://sqlblog.org/2011/08/06/sys-sp_hexadecimal-a-quasi-system-object", "published_at": "2011-08-06T02:05:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90aee0290", "title": "T-SQL Tuesday #20: T-SQL best practices", "url": "https://sqlblog.org/2011/07/12/t-sql-tuesday-20-t-sql-best-practices", "published_at": "2011-07-12T08:44:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90b6215f8", "title": "Catalog views: Clear out a \"botched\" schema", "url": "https://sqlblog.org/2011/07/07/using-the-catalog-views-clearing-out-a-botched-schema", "published_at": "2011-07-07T12:16:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90c4e4036", "title": "[OT]: Dream cars", "url": "https://sqlblog.org/2011/06/10/ot-tagged-sql-dream-cars", "published_at": "2011-06-10T19:38:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90c9307c9", "title": "We don't always need mobile apps", "url": "https://sqlblog.org/2011/05/19/we-dont-always-need-mobile-or-web-equivalents-of-our-windows-applications", "published_at": "2011-05-19T15:21:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90d30cac1", "title": "Determine memory used per object", "url": "https://sqlblog.org/2011/05/19/tip2393-determine-sql-server-memory-use-by-database-and-object", "published_at": "2011-05-19T00:00:00+00:00" }, { "id": "01a0d1d8-0dad-707a-b2ab-93e90d7d05f4", "title": "A little PowerShell tip: Named instances", "url": "https://sqlblog.org/2011/05/03/a-little-powershell-syntax-tip-dealing-with-sql-server-named-instances", "published_at": "2011-05-03T19:32:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b3689fa8e6", "title": "If you disable the guest user, please read this!", "url": "https://sqlblog.org/2011/04/29/if-you-disable-the-guest-user-please-read-this", "published_at": "2011-04-29T15:42:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b369378c6b", "title": "Use DMVs to tune the Resource Governor", "url": "https://sqlblog.org/2011/04/28/tip2368-using-dmvs-to-adjust-sql-server-resource-governor-settings", "published_at": "2011-04-28T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b369f70fe2", "title": "SQL Server MVP Deep Dives Volume 2: Operation Smile", "url": "https://sqlblog.org/2011/04/19/sql-server-mvp-deep-dives-volume-2-operation-smile", "published_at": "2011-04-19T12:19:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36a16e19f", "title": "Identify deprecated T-SQL with a server-side trace", "url": "https://sqlblog.org/2011/03/24/tip2334-identify-deprecated-sql-server-code-with-a-server-side-trace", "published_at": "2011-03-24T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36ab79d94", "title": "T-SQL Tuesday # 16: Not the aggregate you're looking for", "url": "https://sqlblog.org/2011/03/08/t-sql-tuesday-16-this-is-not-the-aggregate-youre-looking-for", "published_at": "2011-03-08T16:49:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36b3d0c5e", "title": "How a columnstore index is different", "url": "https://sqlblog.org/2011/02/28/sql-server-v-next-denali-how-a-columnstore-index-is-not-like-a-normal-index", "published_at": "2011-02-28T13:34:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36b924ef0", "title": "My first few minutes with \"SQL Azure\"", "url": "https://sqlblog.org/2011/02/15/my-first-few-minutes-with-sql-azure", "published_at": "2011-02-15T10:22:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36c8180f5", "title": "Enforce naming conventions with Policy-Based Management", "url": "https://sqlblog.org/2011/02/10/tip2298-enforce-sql-server-database-naming-conventions-using-policy-based-management", "published_at": "2011-02-10T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36cf9619a", "title": "T-SQL Tuesday #15: Run T-SQL workloads remotely on multiple servers", "url": "https://sqlblog.org/2011/02/08/t-sql-tuesday-15-running-t-sql-workloads-remotely-on-multiple-servers", "published_at": "2011-02-08T15:10:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36d1f146e", "title": "Who created that user?", "url": "https://sqlblog.org/2011/02/02/who-created-that-user", "published_at": "2011-02-02T18:35:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36d6c8674", "title": "A bacon- (and module-) saving PowerShell incident", "url": "https://sqlblog.org/2011/02/01/a-bacon-and-module-saving-powershell-incident", "published_at": "2011-02-01T17:28:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36da64ee0", "title": "Capture index operations with a DDL trigger", "url": "https://sqlblog.org/2011/01/31/capturing-index-operations-using-a-ddl-trigger", "published_at": "2011-01-31T18:01:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36e370da2", "title": "Collect perf counters with PowerShell", "url": "https://sqlblog.org/2011/01/31/how-i-use-powershell-to-collect-performance-counter-data", "published_at": "2011-01-31T08:31:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36f2bae5e", "title": "PowerShell, Start-Job, -ScriptBlock = sad panda face", "url": "https://sqlblog.org/2011/01/29/powershell-start-job-scriptblock-sad-panda-face", "published_at": "2011-01-29T18:04:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36f649d28", "title": "Avoid external dependencies in triggers", "url": "https://sqlblog.org/2011/01/26/tip2231-avoid-external-dependencies-in-sql-server-triggers", "published_at": "2011-01-26T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36f8a6ddb", "title": "Deprecate UPDATE FROM? Not if I can help it!", "url": "https://sqlblog.org/2011/01/24/deprecate-update-from-not-if-i-can-help-it", "published_at": "2011-01-24T17:30:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36fc48912", "title": "Downgrading a database: \"You can't get there from here!\"", "url": "https://sqlblog.org/2011/01/21/downgrading-a-database-you-cant-get-there-from-here", "published_at": "2011-01-21T19:45:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b36fe62064", "title": "Identify inefficient power plans with Policy-Based Management", "url": "https://sqlblog.org/2011/01/18/tip2225-identify-sql-servers-with-inefficient-power-plans-using-policy-based-management", "published_at": "2011-01-18T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b370918516", "title": "T-SQL Tuesday #14: Resolutions", "url": "https://sqlblog.org/2011/01/10/t-sql-tuesday-14-resolutions", "published_at": "2011-01-10T22:18:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b37175e898", "title": "The fallacy of preventing plagiarism", "url": "https://sqlblog.org/2011/01/07/the-fallacy-of-preventing-plagiarism", "published_at": "2011-01-07T17:19:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b371d05a05", "title": "Goals for 2011", "url": "https://sqlblog.org/2010/12/30/goals-for-2011", "published_at": "2010-12-30T16:48:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b372afbce5", "title": "Identify and resolve key and RID lookups", "url": "https://sqlblog.org/2010/12/30/tip2195-identifying-key-and-rid-lookup-issues-and-how-to-resolve", "published_at": "2010-12-30T00:00:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b3739e13ac", "title": "The curious case(s) of the Microsoft product naming department", "url": "https://sqlblog.org/2010/12/20/the-curious-cases-of-the-microsoft-product-naming-department", "published_at": "2010-12-20T20:42:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b3744783fe", "title": "SQL Server 2012: Metadata enhancements", "url": "https://sqlblog.org/2010/12/20/sql-server-v-next-denali-metadata-enhancements", "published_at": "2010-12-20T11:09:00+00:00" }, { "id": "01a0d1d8-3fd0-71ff-a3d5-f0b374e63de2", "title": "What permissions are required for IDENTITY_INSERT?", "url": "https://sqlblog.org/2010/12/14/what-permissions-are-required-for-set-identity_insert-on", "published_at": "2010-12-14T13:48:00+00:00" } ] posts Claim your blog
Back to sqlblog.org
Blog · corpus.blog/blogs/sqlblog.org/posts

sqlblog.org

sqlblog.org

2013

Generate a sequence without loops – Part 3original ↗
18 Jan 2013
Generate a sequence without loops – Part 2original ↗
17 Jan 2013
Generate a sequence without loops – Part 1original ↗
16 Jan 2013
Potential enhancements to ASPStateoriginal ↗
11 Jan 2013

2012

Should I use NOT IN, OUTER APPLY, LEFT OUTER JOIN, EXCEPT, or NOT EXISTS?original ↗
27 Dec 2012
Minimize the impact of DBCC CHECKDBoriginal ↗
29 Nov 2012
Bad cardinality estimates from SSMS execution plansoriginal ↗
2 Nov 2012
Audit when triggers are enabled or disabledoriginal ↗
1 Nov 2012
Beware misleading data from SET STATISTICS IOoriginal ↗
30 Oct 2012
Trimming time from datetime – a follow-uporiginal ↗
25 Oct 2012
Script to create dynamic PIVOT queriesoriginal ↗
16 Oct 2012
Is the sp_ prefix still a no-no?original ↗
15 Oct 2012
Checking if a non-LOB column needs to be updatedoriginal ↗
3 Oct 2012
Hit-highlighting in full-text searchoriginal ↗
24 Sept 2012
What impact can different cursor options have?original ↗
20 Sept 2012
Revisit your use of the REMOTE join hintoriginal ↗
18 Sept 2012
How much impact can a data type choice have?original ↗
13 Sept 2012
Build a quota system for user-defined tablesoriginal ↗
12 Sept 2012
SQLSaturday #162: Cambridge, Englandoriginal ↗
9 Sept 2012
What is the most efficient way to trim time from datetime?original ↗
5 Sept 2012
Recover access to SQL Serveroriginal ↗
30 Aug 2012
What is the fastest way to calculate the median?original ↗
29 Aug 2012
Using named instances? Test your DAC connection!original ↗
24 Aug 2012
Performance impact of different error handling techniquesoriginal ↗
22 Aug 2012
Splitting strings: Now with less T-SQLoriginal ↗
16 Aug 2012
T-SQL Tuesday #33: Schema switch-a-roooriginal ↗
14 Aug 2012
Conditional Order Byoriginal ↗
8 Aug 2012
Splitting strings: A follow-uporiginal ↗
2 Aug 2012
When the DRY principle doesn’t apply: BITWISE operatorsoriginal ↗
1 Aug 2012
Removing MDW – the Management Data Warehouseoriginal ↗
31 Jul 2012
Split strings the right way – or the next best wayoriginal ↗
26 Jul 2012
Best approaches for running totals – updated for SQL Server 2012original ↗
24 Jul 2012
Find queries with hints using DMVsoriginal ↗
24 Jul 2012
Script to help conform to naming conventionsoriginal ↗
19 Jun 2012
Tracking password changesoriginal ↗
13 Jun 2012
Getting started with SQL Server 2012 LocalDBoriginal ↗
16 May 2012
Maintaining default trace historyoriginal ↗
8 May 2012
Deciding between COALESCE and ISNULLoriginal ↗
30 Apr 2012
A cautionary tale about CAL licenses in SQL Server 2012 Enterpriseoriginal ↗
27 Apr 2012
Minimize plan cache bloatoriginal ↗
24 Apr 2012
Storing E-mail addresses more efficiently – Part 2original ↗
12 Apr 2012
Participating in 3 SQL events in 8 daysoriginal ↗
4 Apr 2012
Storing E-mail addresses more efficiently – Part 1original ↗
13 Mar 2012
Why people think some SQL Server 2000 behaviors live on… 12 years lateroriginal ↗
28 Feb 2012
Checking for potential constraint violations before entering TRY / CATCHoriginal ↗
28 Feb 2012
Bad Habits to Kick: Believing everything you hear or readoriginal ↗
27 Feb 2012
Troubleshoot IntelliSense in Management Studiooriginal ↗
1 Feb 2012
Bad Habits to Kick: Thinking a WHILE loop isn't a CURSORoriginal ↗
26 Jan 2012
Use snippets in SSMS to encourage consistent conventionsoriginal ↗
25 Jan 2012
Bad Habits to Kick: AS instead of = for column aliasesoriginal ↗
23 Jan 2012
2011, a year in revieworiginal ↗
20 Jan 2012
Get alerts for specific login failed eventsoriginal ↗
17 Jan 2012
T-SQL Tuesday #26: Second chancesoriginal ↗
10 Jan 2012

2011

T-SQL Tuesday #25: T-SQL tips and tricksoriginal ↗
13 Dec 2011
Determining distribution of NULL valuesoriginal ↗
17 Nov 2011
T-SQL Tuesday #24: Dude, where's the rest of my procedure?original ↗
8 Nov 2011
The case against INFORMATION_SCHEMA viewsoriginal ↗
3 Nov 2011
Unexpected errors from table-valued functionsoriginal ↗
20 Oct 2011
Finding keyless tables across multiple serversoriginal ↗
20 Oct 2011
What do BETWEEN and the devil have in common?original ↗
19 Oct 2011
Printing SPID information along with DBCC outputoriginal ↗
6 Oct 2011
T-SQL Tuesday #23: Well, that's a kick in the JOIN…original ↗
4 Oct 2011
Policy-Based Management: facets and evaluation methodsoriginal ↗
3 Oct 2011
Will you use EOMONTH?original ↗
22 Sept 2011
Bad Habits to Kick: Date and time shorthandoriginal ↗
20 Sept 2011
Bad Habits to Kick: EXEC instead of sp_executesqloriginal ↗
17 Sept 2011
Why generalizations are dangerousoriginal ↗
15 Sept 2011
T-SQL Tuesday #21: Crap Codeoriginal ↗
10 Aug 2011
sys.sp_hexadecimal: A quasi-system object?original ↗
6 Aug 2011
T-SQL Tuesday #20: T-SQL best practicesoriginal ↗
12 Jul 2011
Catalog views: Clear out a "botched" schemaoriginal ↗
7 Jul 2011
[OT]: Dream carsoriginal ↗
10 Jun 2011
We don't always need mobile appsoriginal ↗
19 May 2011
Determine memory used per objectoriginal ↗
19 May 2011
A little PowerShell tip: Named instancesoriginal ↗
3 May 2011
If you disable the guest user, please read this!original ↗
29 Apr 2011
Use DMVs to tune the Resource Governororiginal ↗
28 Apr 2011
SQL Server MVP Deep Dives Volume 2: Operation Smileoriginal ↗
19 Apr 2011
Identify deprecated T-SQL with a server-side traceoriginal ↗
24 Mar 2011
T-SQL Tuesday # 16: Not the aggregate you're looking fororiginal ↗
8 Mar 2011
How a columnstore index is differentoriginal ↗
28 Feb 2011
My first few minutes with "SQL Azure"original ↗
15 Feb 2011
Enforce naming conventions with Policy-Based Managementoriginal ↗
10 Feb 2011
T-SQL Tuesday #15: Run T-SQL workloads remotely on multiple serversoriginal ↗
8 Feb 2011
Who created that user?original ↗
2 Feb 2011
A bacon- (and module-) saving PowerShell incidentoriginal ↗
1 Feb 2011
Capture index operations with a DDL triggeroriginal ↗
31 Jan 2011
Collect perf counters with PowerShelloriginal ↗
31 Jan 2011
PowerShell, Start-Job, -ScriptBlock = sad panda faceoriginal ↗
29 Jan 2011
Avoid external dependencies in triggersoriginal ↗
26 Jan 2011
Deprecate UPDATE FROM? Not if I can help it!original ↗
24 Jan 2011
Downgrading a database: "You can't get there from here!"original ↗
21 Jan 2011
Identify inefficient power plans with Policy-Based Managementoriginal ↗
18 Jan 2011
T-SQL Tuesday #14: Resolutionsoriginal ↗
10 Jan 2011
The fallacy of preventing plagiarismoriginal ↗
7 Jan 2011

2010

Goals for 2011original ↗
30 Dec 2010
Identify and resolve key and RID lookupsoriginal ↗
30 Dec 2010
The curious case(s) of the Microsoft product naming departmentoriginal ↗
20 Dec 2010
SQL Server 2012: Metadata enhancementsoriginal ↗
20 Dec 2010
What permissions are required for IDENTITY_INSERT?original ↗
14 Dec 2010
Previous Next