https://piotrbach.com/topics/sql-server Explore practical SQL Server guides on queries, indexing, data design, migrations, troubleshooting and database performance for modern web applications. Thu, 16 Jul 2026 09:30:58 GMT Wed, 23 Sep 2026 09:59:46 GMT en BachPlatform / Umbraco CMS https://piotrbach.com/blog/reset-an-umbraco-6-admin-password-in-sql-server/ Reset an Umbraco 6 administrator password in SQL Server with the correct legacy hash, then recycle the IIS App Pool before testing the backoffice login. Wed, 23 Sep 2026 06:25:14 GMT Piotr Bach https://piotrbach.com/blog/reset-an-umbraco-6-admin-password-in-sql-server/ https://piotrbach.com/blog/examine-umbraco-property-values-given-data-type/ A practical, read-only T-SQL technique for finding published content that uses a specific data type in Umbraco 13 Sat, 15 Aug 2026 12:09:58 GMT Piotr Bach https://piotrbach.com/blog/examine-umbraco-property-values-given-data-type/ https://piotrbach.com/blog/debugging-slow-publishing-in-umbraco-13-at-325k-nodes/ After upgrading a production-scale Umbraco installation from 11.5.0 to 13.4.1, publishing and unpublishing became extremely slow and database lock errors appeared frequently. The application contained approximately 325,000 documents. This is how we traced the problem to a regression in Umbraco Core. Tue, 30 Jul 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/debugging-slow-publishing-in-umbraco-13-at-325k-nodes/ https://piotrbach.com/blog/how-to-fix-ssl-certificate-trust-issues-when-connecting-to-sql-server/ Learn how to fix the SQL Server error “The certificate chain was issued by an authority that is not trusted”, why it has become more common with newer SQL clients, and when TrustServerCertificate=True is an acceptable workaround. Sun, 14 Jul 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/how-to-fix-ssl-certificate-trust-issues-when-connecting-to-sql-server/ https://piotrbach.com/blog/creating-a-sql-server-login-for-an-existing-domain-user-in-ssms/ If a Windows domain account already exists but cannot access SQL Server, you normally do not create another Windows account or a SQL-authentication password. You create a SQL Server login for the existing Windows principal, then grant only the access it needs. Sat, 02 Mar 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/creating-a-sql-server-login-for-an-existing-domain-user-in-ssms/ https://piotrbach.com/blog/how-to-create-a-sql-server-login-for-a-windows-domain-user-with-powershell/ If an existing Windows domain account receives Login failed for user because SQL Server has no corresponding login, you can create the Windows-authenticated SQL Server login from PowerShell. This article keeps the original SMO-based approach while clarifying the permissions and security implications. Sun, 25 Feb 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/how-to-create-a-sql-server-login-for-a-windows-domain-user-with-powershell/ https://piotrbach.com/blog/reset-identity-values-in-sql-server-with-dbcc-checkident/ How to inspect and reseed an IDENTITY column correctly, including the important difference between DELETE and TRUNCATE TABLE. Fri, 16 Feb 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/reset-identity-values-in-sql-server-with-dbcc-checkident/ https://piotrbach.com/blog/how-to-count-rows-in-all-sql-server-tables/ Use partition metadata for a fast database overview, or run exact counts when the precise number of rows is required. Fri, 09 Feb 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/how-to-count-rows-in-all-sql-server-tables/ https://piotrbach.com/blog/search-for-text-across-all-sql-server-tables/ A practical read-only script for locating an unknown text value across character columns without hard-coding the database structure. Wed, 31 Jan 2024 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/search-for-text-across-all-sql-server-tables/ https://piotrbach.com/blog/sql-server-index-maintenance-rebuild-reorganize/ A practical guide to finding rowstore index maintenance candidates, understanding what rebuild and reorganize actually change, and running maintenance without unnecessarily hurting a live application. Thu, 24 Mar 2022 06:00:00 GMT Piotr Bach https://piotrbach.com/blog/sql-server-index-maintenance-rebuild-reorganize/