41554 blogs · [ { "id": "01a0d1d8-72af-7330-9e4b-6b76497e6df3", "title": "The old \"do as I say, not as I do\" problem", "url": "https://sqlblog.org/2010/12/14/the-old-do-as-i-say-not-as-i-do-problem", "published_at": "2010-12-14T09:15:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764a229434", "title": "T-SQL Tuesday #13: Business Expectations", "url": "https://sqlblog.org/2010/12/13/t-sql-tuesday-13-business-expectations", "published_at": "2010-12-13T20:40:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764b203f8d", "title": "Deriving sets using SEQUENCE", "url": "https://sqlblog.org/2010/12/13/sql-server-v-next-denali-deriving-sets-using-sequence", "published_at": "2010-12-13T08:58:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764bd29b05", "title": "Find unused indexes with Policy-Based Management", "url": "https://sqlblog.org/2010/11/30/tip2177-find-unused-sql-server-indexes-with-policy-based-management", "published_at": "2010-11-30T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764c220770", "title": "More intuitive tool for reading execution plans", "url": "https://sqlblog.org/2010/11/24/tip2170-more-intuitive-tool-for-reading-sql-server-execution-plans", "published_at": "2010-11-24T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764c7768d9", "title": "Exploring THROW", "url": "https://sqlblog.org/2010/11/22/sql-server-v-next-denali-exploring-throw", "published_at": "2010-11-22T13:20:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764ca30128", "title": "An intro to Contained Databases", "url": "https://sqlblog.org/2010/11/16/sql-server-v-next-denali-contained-databases", "published_at": "2010-11-16T19:02:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764d9a10ed", "title": "SQL Server 2012: Books Online", "url": "https://sqlblog.org/2010/11/13/sql-server-v-next-denali-books-online", "published_at": "2010-11-13T23:17:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764de27c65", "title": "The instance is down. What happened?", "url": "https://sqlblog.org/2010/11/12/sql-server-v-next-denali-the-instance-is-down-what-happened", "published_at": "2010-11-12T18:36:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764e4b447d", "title": "Using SEQUENCE", "url": "https://sqlblog.org/2010/11/11/sql-server-2012-using-sequence", "published_at": "2010-11-11T14:04:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764e76856b", "title": "Pagination with OFFSET", "url": "https://sqlblog.org/2010/11/10/sql-server-v-next-denali-using-the-offset-clause-paging", "published_at": "2010-11-10T20:33:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764e7e7df0", "title": "SQL Server 2012: Breaking change to #temp tables", "url": "https://sqlblog.org/2010/11/09/sql-server-v-next-denali-breaking-change-to-temp-tables", "published_at": "2010-11-09T20:05:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764e9c31e0", "title": "T-SQL Tuesday #12: Are hotshot DBA skills necessary?", "url": "https://sqlblog.org/2010/11/02/t-sql-tuesday-are-hotshot-dba-skills-necessary", "published_at": "2010-11-02T02:08:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764ea1dfe0", "title": "My bucket list", "url": "https://sqlblog.org/2010/10/26/my-bucket-list", "published_at": "2010-10-26T09:42:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764ee0586a", "title": "Fun with software: Uninstalling SQL Server Evaluation Edition", "url": "https://sqlblog.org/2010/10/25/fun-with-software-uninstalling-sql-server-2008-r2-evaluation-edition", "published_at": "2010-10-25T21:12:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b764f88c971", "title": "Moving on up… but not to the East Side", "url": "https://sqlblog.org/2010/10/18/moving-on-up-but-not-to-the-east-side", "published_at": "2010-10-18T09:46:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b76506289ab", "title": "Data type consistency", "url": "https://sqlblog.org/2010/09/29/tip2123-sql-server-data-type-consistency", "published_at": "2010-09-29T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b76510a76a9", "title": "Updating a table with HTML data from a file", "url": "https://sqlblog.org/2010/09/10/updating-a-table-with-html-data-from-a-file", "published_at": "2010-09-10T18:45:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b7651503c74", "title": "A quick workaround to a misleading ASPState problem", "url": "https://sqlblog.org/2010/09/10/a-quick-workaround-to-a-misleading-aspstate-problem", "published_at": "2010-09-10T17:46:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b76515c20d9", "title": "Use consistent naming conventions", "url": "https://sqlblog.org/2010/09/09/tip2110-use-consistent-sql-server-naming-conventions", "published_at": "2010-09-09T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b765193366f", "title": "Keep your DDL Trigger audit table in check", "url": "https://sqlblog.org/2010/08/31/tip2101-keeping-your-sql-server-ddl-trigger-audit-table-in-check", "published_at": "2010-08-31T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b76527ffa01", "title": "Bad Habits to Kick: Inconsistent naming", "url": "https://sqlblog.org/2010/08/22/whats-in-a-name", "published_at": "2010-08-22T16:12:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b7652bed80f", "title": "Use DDL Triggers to track database changes", "url": "https://sqlblog.org/2010/08/09/tip2085-sql-server-ddl-triggers-to-track-all-database-changes", "published_at": "2010-08-09T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b7652f341bc", "title": "Backward compatibility: Changing a relationship", "url": "https://sqlblog.org/2010/07/28/tip2074-make-your-sql-server-database-changes-backward-compatible-when-changing-a-relationship", "published_at": "2010-07-28T00:00:00+00:00" }, { "id": "01a0d1d8-72af-7330-9e4b-6b7652f92d96", "title": "Backward compatibility: Renaming an entity", "url": "https://sqlblog.org/2010/07/26/tip2071-make-your-sql-server-database-changes-backward-compatible-when-renaming-an-entity", "published_at": "2010-07-26T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cc8ceb703", "title": "[OT]: How to make a bajillion dollars", "url": "https://sqlblog.org/2010/07/14/ot-how-to-make-a-bajillion-dollars", "published_at": "2010-07-14T22:07:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cc98980a4", "title": "T-SQL Tuesday #8: How learning has changed", "url": "https://sqlblog.org/2010/07/13/t-sql-tuesday-008-how-learning-has-changed", "published_at": "2010-07-13T19:36:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cc9fe4f63", "title": "Splitting a list of integers: Another roundup", "url": "https://sqlblog.org/2010/07/07/splitting-a-list-of-integers-another-roundup", "published_at": "2010-07-07T18:35:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cca2277a6", "title": "Welcome to the jungle, CLR!", "url": "https://sqlblog.org/2010/07/06/welcome-to-the-jungle-clr", "published_at": "2010-07-06T19:52:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccaab9064", "title": "Backward compatibility: Dropping a column", "url": "https://sqlblog.org/2010/06/29/tip2050-make-your-sql-server-database-changes-backward-compatible-when-dropping-a-column", "published_at": "2010-06-29T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccaec6e73", "title": "Two BULK INSERT issues I worked around recently", "url": "https://sqlblog.org/2010/06/14/two-bulk-insert-issues-i-worked-around-recently", "published_at": "2010-06-14T20:23:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccbd31172", "title": "Backward compatibility: Adding a new column", "url": "https://sqlblog.org/2010/06/09/tip2035-make-your-sql-server-database-changes-backward-compatible-when-adding-a-new-column", "published_at": "2010-06-09T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccc93aabe", "title": "Unicode compression in SQL Server 2008 R2", "url": "https://sqlblog.org/2010/05/28/tip2019-unicode-compression-in-sql-server-2008-r2", "published_at": "2010-05-28T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccd45b72c", "title": "Tagged: 5 things SQL Server should drop", "url": "https://sqlblog.org/2010/05/11/tagged-5-things-sql-server-should-drop", "published_at": "2010-05-11T11:20:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cce23a5a0", "title": "Track and log stored procedure use", "url": "https://sqlblog.org/2010/05/10/tip2003-simple-process-to-track-and-log-sql-server-stored-procedure-use", "published_at": "2010-05-10T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cce404428", "title": "Find all columns of a specific data type using Policy-Based Management", "url": "https://sqlblog.org/2010/04/28/tip1993-find-all-sql-server-columns-of-a-specific-data-type-using-policy-based-management", "published_at": "2010-04-28T00:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccea18940", "title": "The pros and cons of learning", "url": "https://sqlblog.org/2010/03/31/the-pros-and-cons-of-learning", "published_at": "2010-03-31T17:27:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cceb7021f", "title": "Yes, you can benefit from both data and backup compression", "url": "https://sqlblog.org/2010/03/15/yes-you-can-benefit-from-both-data-and-backup-compression", "published_at": "2010-03-15T17:18:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227ccf5bb893", "title": "The ethics of aggregating other peoples' content", "url": "https://sqlblog.org/2010/03/10/the-ethics-of-aggregating-other-peoples-content", "published_at": "2010-03-10T18:20:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd053e0b4", "title": "Bad Habits to Kick: Ignoring I/O", "url": "https://sqlblog.org/2010/03/08/bad-habits-to-kick-ignoring-i-o", "published_at": "2010-03-08T21:14:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd09c65a2", "title": "Bad Habits to Kick: The uber-view", "url": "https://sqlblog.org/2010/03/07/bad-habits-to-kick-creating-the-uber-view", "published_at": "2010-03-07T18:52:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd0d2b740", "title": "MacGyver moments", "url": "https://sqlblog.org/2010/02/20/macgyver-moments", "published_at": "2010-02-20T13:42:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd193ebcc", "title": "Bad Habits to Kick: Inconsistent table aliasing", "url": "https://sqlblog.org/2010/02/16/bad-habits-to-kick-inconsistent-table-aliasing", "published_at": "2010-02-16T00:20:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd1f4367c", "title": "Bad Habits to Kick: Ignoring least privilege", "url": "https://sqlblog.org/2010/02/12/bad-habits-to-kick-ignoring-the-principle-of-least-privilege", "published_at": "2010-02-12T11:36:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd225c816", "title": "Bad Habits to Kick: Blind SQL Server installs", "url": "https://sqlblog.org/2010/02/10/bad-habits-to-kick-blind-sql-server-installs", "published_at": "2010-02-10T18:48:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd318ee4e", "title": "Bad Habits to Kick: IDENTITY columns on every table", "url": "https://sqlblog.org/2010/02/08/bad-habits-to-kick-putting-an-identity-column-on-every-table", "published_at": "2010-02-08T01:33:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd3c4cdf5", "title": "Injection is not always about SQL", "url": "https://sqlblog.org/2010/02/07/injection-is-not-always-about-sql", "published_at": "2010-02-07T14:38:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd4513e6a", "title": "Management Studio Tips & Tricks, version 1.0", "url": "https://sqlblog.org/2010/01/30/management-studio-tips-tricks-version-1-0", "published_at": "2010-01-30T18:00:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd4f82205", "title": "Decrypting: A question of morals, ethics, or both?", "url": "https://sqlblog.org/2010/01/24/decrypting-a-question-of-morals-ethics-or-both", "published_at": "2010-01-24T23:33:00+00:00" }, { "id": "01a0d1d8-a804-70ec-ab06-227cd54034d0", "title": "\"What three events brought you here?\"", "url": "https://sqlblog.org/2010/01/19/what-three-events-brought-you-here", "published_at": "2010-01-19T17:03:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf5000843", "title": "When you don't follow your own bad habits advice…", "url": "https://sqlblog.org/2010/01/14/when-you-dont-follow-your-own-bad-habits-advice", "published_at": "2010-01-14T18:05:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf5fc1a9f", "title": "Mixing OLTP and reporting using indexed views", "url": "https://sqlblog.org/2009/12/29/mixing-oltp-and-reporting-using-indexed-views", "published_at": "2009-12-29T10:40:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf6a53792", "title": "Playing with page compression – for real", "url": "https://sqlblog.org/2009/12/29/playing-with-page-compression-for-real", "published_at": "2009-12-29T00:46:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf6e72eaf", "title": "On software bloat…", "url": "https://sqlblog.org/2009/12/16/on-software-bloat", "published_at": "2009-12-16T12:29:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf75d01db", "title": "What is so bad about EAV, anyway?", "url": "https://sqlblog.org/2009/11/19/what-is-so-bad-about-eav-anyway", "published_at": "2009-11-19T19:41:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf7a18014", "title": "Finding stored procedures containing %string%", "url": "https://sqlblog.org/2009/11/09/finding-stored-procedures-containing-string", "published_at": "2009-11-09T14:30:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf7d97f07", "title": "Bad Habits to Kick: Mis-handling date / range queries", "url": "https://sqlblog.org/2009/10/16/bad-habits-to-kick-mis-handling-date-range-queries", "published_at": "2009-10-16T14:41:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf855c1bc", "title": "Bad Habits to Kick: Alias types", "url": "https://sqlblog.org/2009/10/14/bad-habits-to-kick-using-alias-types", "published_at": "2009-10-14T23:07:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf8f9ee80", "title": "Bad Habits to Kick: Visual designers", "url": "https://sqlblog.org/2009/10/14/bad-habits-to-kick-using-the-visual-designers", "published_at": "2009-10-14T18:08:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cf9b254aa", "title": "Bad Habits to Kick: Abusing triggers", "url": "https://sqlblog.org/2009/10/12/bad-habits-to-kick-abusing-triggers", "published_at": "2009-10-12T22:08:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfaa4aadb", "title": "Bad Habits to Kick: Choosing the wrong data type", "url": "https://sqlblog.org/2009/10/12/bad-habits-to-kick-choosing-the-wrong-data-type", "published_at": "2009-10-12T17:51:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfae919d6", "title": "Bad Habits to Kick: Assumptions about IDENTITY", "url": "https://sqlblog.org/2009/10/12/bad-habits-to-kick-making-assumptions-about-identity", "published_at": "2009-10-12T00:23:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfb82a29f", "title": "Bad Habits to Kick: Inconsistent naming conventions", "url": "https://sqlblog.org/2009/10/11/bad-habits-to-kick-inconsistent-naming-conventions", "published_at": "2009-10-11T14:06:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfc6d8f36", "title": "Bad Habits to Kick: SELECT * / omitting the column list", "url": "https://sqlblog.org/2009/10/10/bad-habits-to-kick-using-select-omitting-the-column-list", "published_at": "2009-10-10T14:47:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfd645e49", "title": "Bad Habits to Kick: SELECT or RETURN instead of OUTPUT", "url": "https://sqlblog.org/2009/10/09/bad-habits-to-kick-using-select-or-return-instead-of-output", "published_at": "2009-10-09T17:01:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfdfc7b58", "title": "Bad Habits to Kick: Dashes and spaces in entity names", "url": "https://sqlblog.org/2009/10/09/bad-habits-to-kick-using-dashes-and-spaces-in-entity-names", "published_at": "2009-10-09T13:39:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfec2bf3b", "title": "Bad Habits to Kick: Varchar without length", "url": "https://sqlblog.org/2009/10/09/bad-habits-to-kick-declaring-varchar-without-length", "published_at": "2009-10-09T10:04:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cfeccbffa", "title": "Bad Habits to Kick: Table aliases like (a, b, c) or (t1, t2, t3)", "url": "https://sqlblog.org/2009/10/08/bad-habits-to-kick-using-table-aliases-like-a-b-c-or-t1-t2-t3", "published_at": "2009-10-08T19:48:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cff85797c", "title": "Bad Habits to Kick: Old-style JOINs", "url": "https://sqlblog.org/2009/10/08/bad-habits-to-kick-using-old-style-joins", "published_at": "2009-10-08T12:26:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149cffed2f32", "title": "Bad Habits to Kick: Looping to populate large tables", "url": "https://sqlblog.org/2009/10/07/bad-habits-to-kick-using-loops-to-populate-large-tables", "published_at": "2009-10-07T19:17:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149d0099c21a", "title": "Bad Habits to Kick: ORDER BY ordinal", "url": "https://sqlblog.org/2009/10/06/bad-habits-to-kick-order-by-ordinal", "published_at": "2009-10-06T11:49:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149d0163f9af", "title": "[Tagged]: How I became a dork", "url": "https://sqlblog.org/2009/10/06/tagged-how-i-became-a-dork", "published_at": "2009-10-06T09:01:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149d01bafad5", "title": "More testing of Unicode compression", "url": "https://sqlblog.org/2009/10/04/more-testing-of-unicode-compression-in-sql-server-2008-r2", "published_at": "2009-10-04T19:24:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149d022c68cd", "title": "Manage multi-instance cluster failovers with different hardware", "url": "https://sqlblog.org/2009/09/18/managing-multi-instance-cluster-failovers-with-different-hardware", "published_at": "2009-09-18T16:52:00+00:00" }, { "id": "01a0d1d8-e15a-7297-8be1-149d0281108a", "title": "SQL Server MVP Deep Dives: eBook and pre-order ready soon!", "url": "https://sqlblog.org/2009/09/16/sql-server-mvp-deep-dives-ebook-and-pre-order-ready-soon", "published_at": "2009-09-16T22:26:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d60405507", "title": "Ladies and gentlemen, start your semi-colons!", "url": "https://sqlblog.org/2009/09/03/ladies-and-gentlemen-start-your-semi-colons", "published_at": "2009-09-03T14:13:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6057505c", "title": "Blogging about what to blog about", "url": "https://sqlblog.org/2009/09/02/blogging-about-what-to-blog-about", "published_at": "2009-09-02T14:15:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d61274304", "title": "SQL Server 2008 R2: Digging deeper into Unicode compression", "url": "https://sqlblog.org/2009/08/23/sql-server-2008-r2-digging-deeper-into-unicode-compression", "published_at": "2009-08-23T17:50:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d61518044", "title": "SQL Server 2008 R2: A quick experiment in Unicode compression", "url": "https://sqlblog.org/2009/08/11/sql-server-2008-r2-a-quick-experiment-in-unicode-compression", "published_at": "2009-08-11T15:17:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6180c91a", "title": "More on splitting lists of integers", "url": "https://sqlblog.org/2009/08/06/more-on-splitting-lists-custom-delimiters-preventing-duplicates-and-maintaining-order", "published_at": "2009-08-06T17:44:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6198bbc7", "title": "Processing a list of integers: My approach", "url": "https://sqlblog.org/2009/08/01/processing-a-list-of-integers-my-approach", "published_at": "2009-08-01T13:42:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d61b2d1b0", "title": "When will my backup / restore / index maintenance finish?", "url": "https://sqlblog.org/2009/07/30/when-will-my-backup-restore-index-reorganize-finish", "published_at": "2009-07-30T18:56:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d62558190", "title": "Oh, the horror! Please stop telling people they should shrink their log files!", "url": "https://sqlblog.org/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files", "published_at": "2009-07-27T12:27:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6352edfd", "title": "Hiding your list of databases", "url": "https://sqlblog.org/2009/07/19/for-shared-sql-server-providers-hiding-your-list-of-databases-from-customers", "published_at": "2009-07-19T12:26:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d64341def", "title": "Resource Governor whitepaper is now available", "url": "https://sqlblog.org/2009/07/14/resource-governor-whitepaper-is-now-available", "published_at": "2009-07-14T23:15:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d64f18f23", "title": "Why is IntelliSense not working?", "url": "https://sqlblog.org/2009/07/01/why-is-intellisense-not-working", "published_at": "2009-07-01T15:05:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d65ad568f", "title": "What to do when Management Studio hangs?", "url": "https://sqlblog.org/2009/06/25/what-to-do-when-management-studio-hangs", "published_at": "2009-06-25T16:52:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d660affc8", "title": "Why is disaster recovery an afterthought?", "url": "https://sqlblog.org/2009/06/21/why-is-disaster-recovery-an-afterthought", "published_at": "2009-06-21T13:44:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6619c1de", "title": "Using a Mac in a Windows world", "url": "https://sqlblog.org/2009/05/30/using-a-mac-in-a-windows-world", "published_at": "2009-05-30T01:10:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d66814ad9", "title": "To err is Celko, but vendor implementations may vary", "url": "https://sqlblog.org/2009/04/30/to-err-is-celko-but-vendor-implementations-may-vary", "published_at": "2009-04-30T17:42:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6723169f", "title": "Negative sentiment", "url": "https://sqlblog.org/2009/04/23/negative-sentiment", "published_at": "2009-04-23T00:04:13+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6788daea", "title": "Correcting DATETIME values (and Agent!) due to an incorrect system clock", "url": "https://sqlblog.org/2009/04/11/correcting-datetime-values-and-agent-due-to-an-incorrect-system-date", "published_at": "2009-04-11T17:55:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6884b8fe", "title": "Six reasons you should be nervous about parallelism", "url": "https://sqlblog.org/2009/03/21/six-reasons-you-should-be-nervous-about-parallelism", "published_at": "2009-03-21T14:34:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d68b3fb47", "title": "Prune the servers in the Connect To dialog in SSMS", "url": "https://sqlblog.org/2009/03/18/managing-the-mru-list-for-the-connect-to-server-dialog-in-ssms", "published_at": "2009-03-18T11:55:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d694f1583", "title": "SQL Server does not care about the order of your bulk file!", "url": "https://sqlblog.org/2008/12/16/sql-server-does-not-care-about-the-order-of-your-bulk-file", "published_at": "2008-12-16T19:29:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6a3b2b64", "title": "SQL Quiz: Career challenges", "url": "https://sqlblog.org/2008/12/11/sql-quiz-career-challenges", "published_at": "2008-12-11T14:29:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6a69cb70", "title": "Troubleshoot Service Broker with the errorlog", "url": "https://sqlblog.org/2008/11/28/troubleshooting-service-broker-through-sql-server-error-logs", "published_at": "2008-11-28T14:39:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6a814ff9", "title": "My reasons for upgrading to SQL Server 2008", "url": "https://sqlblog.org/2008/11/18/my-reasons-for-upgrading-to-sql-server-2008", "published_at": "2008-11-18T16:57:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6b556514", "title": "I forgot how fun it is to set up a new machine!", "url": "https://sqlblog.org/2008/11/06/i-forgot-how-fun-it-is-to-set-up-a-new-machine", "published_at": "2008-11-06T22:18:00+00:00" }, { "id": "01a0d1d9-1061-72ca-ab25-c19d6be6ee4f", "title": "My stored procedure \"best practices\" checklist", "url": "https://sqlblog.org/2008/10/30/my-stored-procedure-best-practices-checklist", "published_at": "2008-10-30T18:40:00+00:00" } ] posts Claim your blog

Back to sqlblog.org

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

sqlblog.org

sqlblog.org

2010

The old "do as I say, not as I do" problem original ↗

14 Dec 2010

T-SQL Tuesday #13: Business Expectations original ↗

13 Dec 2010

Deriving sets using SEQUENCE original ↗

13 Dec 2010

Find unused indexes with Policy-Based Management original ↗

30 Nov 2010

More intuitive tool for reading execution plans original ↗

24 Nov 2010

Exploring THROW original ↗

22 Nov 2010

An intro to Contained Databases original ↗

16 Nov 2010

SQL Server 2012: Books Online original ↗

13 Nov 2010

The instance is down. What happened?original ↗

12 Nov 2010

Using SEQUENCE original ↗

11 Nov 2010

Pagination with OFFSET original ↗

10 Nov 2010

SQL Server 2012: Breaking change to #temp tables original ↗

9 Nov 2010

T-SQL Tuesday #12: Are hotshot DBA skills necessary?original ↗

2 Nov 2010

My bucket list original ↗

26 Oct 2010

Fun with software: Uninstalling SQL Server Evaluation Edition original ↗

25 Oct 2010

Moving on up… but not to the East Side original ↗

18 Oct 2010

Data type consistency original ↗

29 Sept 2010

Updating a table with HTML data from a file original ↗

10 Sept 2010

A quick workaround to a misleading ASPState problem original ↗

10 Sept 2010

Use consistent naming conventions original ↗

9 Sept 2010

Keep your DDL Trigger audit table in check original ↗

31 Aug 2010

Bad Habits to Kick: Inconsistent naming original ↗

22 Aug 2010

Use DDL Triggers to track database changes original ↗

9 Aug 2010

Backward compatibility: Changing a relationship original ↗

28 Jul 2010

Backward compatibility: Renaming an entity original ↗

26 Jul 2010

[OT]: How to make a bajillion dollars original ↗

14 Jul 2010

T-SQL Tuesday #8: How learning has changed original ↗

13 Jul 2010

Splitting a list of integers: Another roundup original ↗

7 Jul 2010

Welcome to the jungle, CLR!original ↗

6 Jul 2010

Backward compatibility: Dropping a column original ↗

29 Jun 2010

Two BULK INSERT issues I worked around recently original ↗

14 Jun 2010

Backward compatibility: Adding a new column original ↗

9 Jun 2010

Unicode compression in SQL Server 2008 R2 original ↗

28 May 2010

Tagged: 5 things SQL Server should drop original ↗

11 May 2010

Track and log stored procedure use original ↗

10 May 2010

Find all columns of a specific data type using Policy-Based Management original ↗

28 Apr 2010

The pros and cons of learning original ↗

31 Mar 2010

Yes, you can benefit from both data and backup compression original ↗

15 Mar 2010

The ethics of aggregating other peoples' content original ↗

10 Mar 2010

Bad Habits to Kick: Ignoring I/O original ↗

8 Mar 2010

Bad Habits to Kick: The uber-view original ↗

7 Mar 2010

MacGyver moments original ↗

20 Feb 2010

Bad Habits to Kick: Inconsistent table aliasing original ↗

16 Feb 2010

Bad Habits to Kick: Ignoring least privilege original ↗

12 Feb 2010

Bad Habits to Kick: Blind SQL Server installs original ↗

10 Feb 2010

Bad Habits to Kick: IDENTITY columns on every table original ↗

8 Feb 2010

Injection is not always about SQL original ↗

7 Feb 2010

Management Studio Tips & Tricks, version 1.0 original ↗

30 Jan 2010

Decrypting: A question of morals, ethics, or both?original ↗

24 Jan 2010

"What three events brought you here?"original ↗

19 Jan 2010

When you don't follow your own bad habits advice…original ↗

14 Jan 2010

2009

Mixing OLTP and reporting using indexed views original ↗

29 Dec 2009

Playing with page compression – for real original ↗

29 Dec 2009

On software bloat…original ↗

16 Dec 2009

What is so bad about EAV, anyway?original ↗

19 Nov 2009

Finding stored procedures containing %string%original ↗

9 Nov 2009

Bad Habits to Kick: Mis-handling date / range queries original ↗

16 Oct 2009

Bad Habits to Kick: Alias types original ↗

14 Oct 2009

Bad Habits to Kick: Visual designers original ↗

14 Oct 2009

Bad Habits to Kick: Abusing triggers original ↗

12 Oct 2009

Bad Habits to Kick: Choosing the wrong data type original ↗

12 Oct 2009

Bad Habits to Kick: Assumptions about IDENTITY original ↗

12 Oct 2009

Bad Habits to Kick: Inconsistent naming conventions original ↗

11 Oct 2009

Bad Habits to Kick: SELECT * / omitting the column list original ↗

10 Oct 2009

Bad Habits to Kick: SELECT or RETURN instead of OUTPUT original ↗

9 Oct 2009

Bad Habits to Kick: Dashes and spaces in entity names original ↗

9 Oct 2009

Bad Habits to Kick: Varchar without length original ↗

9 Oct 2009

Bad Habits to Kick: Table aliases like (a, b, c) or (t1, t2, t3)original ↗

8 Oct 2009

Bad Habits to Kick: Old-style JOINs original ↗

8 Oct 2009

Bad Habits to Kick: Looping to populate large tables original ↗

7 Oct 2009

Bad Habits to Kick: ORDER BY ordinal original ↗

6 Oct 2009

[Tagged]: How I became a dork original ↗

6 Oct 2009

More testing of Unicode compression original ↗

4 Oct 2009

Manage multi-instance cluster failovers with different hardware original ↗

18 Sept 2009

SQL Server MVP Deep Dives: eBook and pre-order ready soon!original ↗

16 Sept 2009

Ladies and gentlemen, start your semi-colons!original ↗

3 Sept 2009

Blogging about what to blog about original ↗

2 Sept 2009

SQL Server 2008 R2: Digging deeper into Unicode compression original ↗

23 Aug 2009

SQL Server 2008 R2: A quick experiment in Unicode compression original ↗

11 Aug 2009

More on splitting lists of integers original ↗

6 Aug 2009

Processing a list of integers: My approach original ↗

1 Aug 2009

When will my backup / restore / index maintenance finish?original ↗

30 Jul 2009

Oh, the horror! Please stop telling people they should shrink their log files!original ↗

27 Jul 2009

Hiding your list of databases original ↗

19 Jul 2009

Resource Governor whitepaper is now available original ↗

14 Jul 2009

Why is IntelliSense not working?original ↗

1 Jul 2009

What to do when Management Studio hangs?original ↗

25 Jun 2009

Why is disaster recovery an afterthought?original ↗

21 Jun 2009

Using a Mac in a Windows world original ↗

30 May 2009

To err is Celko, but vendor implementations may vary original ↗

30 Apr 2009

Negative sentiment original ↗

23 Apr 2009

Correcting DATETIME values (and Agent!) due to an incorrect system clock original ↗

11 Apr 2009

Six reasons you should be nervous about parallelism original ↗

21 Mar 2009

Prune the servers in the Connect To dialog in SSMS original ↗

18 Mar 2009

2008

SQL Server does not care about the order of your bulk file!original ↗

16 Dec 2008

SQL Quiz: Career challenges original ↗

11 Dec 2008

Troubleshoot Service Broker with the errorlog original ↗

28 Nov 2008

My reasons for upgrading to SQL Server 2008 original ↗

18 Nov 2008

I forgot how fun it is to set up a new machine!original ↗

6 Nov 2008

My stored procedure "best practices" checklist original ↗

30 Oct 2008