MS SQL
How to Fix SSL Certificate Trust Issues When Connecting to SQL Server
Learn how to resolve SSL certificate trust issues when connecting to a SQL Server on Windows. This tutorial covers certificate installation, connection...
7/14/2024How to Compare Indexes Between Two MSSQL Databases Easily
Learn how to compare MSSQL database indexes efficiently using a simple T-SQL script. Ensure database performance and consistency with our step-by-step guide
7/13/2024Creating a SQL Server login for an existing domain user in SSMS
Creating a login for an existing domain user and granting SQL Server privileges (ex. sysadmin role) in SQL Server Management Studio (SSMS) involves a series...
3/2/2024How to Count Records in MS SQL Server Database Tables
Discover how to count records across all tables using Cursor and Temporary Table. Download code to streamline your database analytics and management tasks
2/10/2024Searching for text across multiple tables in SQL Server
Searching for a specific string across multiple tables in an SQL Server database can be tricky. Here’s a guide on how to make the process easy
1/27/2024How to Examine Content Property Values for Given Data Type in Umbraco
Discover how to review content property values in Umbraco CMS v11 using T-SQL. It is tailored for developers looking to optimize content management, assess...
1/20/2024Umbraco Developer Key Skills
Master the key skills every Umbraco developer needs to succeed. From backend mastery with .NET Core to front-end finesse with modern frameworks, this guide...
12/18/2023Umbraco Redirect Url Table Data Truncated SQL Error
Learn how to resolve the Umbraco SQL truncation error with our expert guide. Discover solutions to extend URL lengths and optimize your CMS for peak performance
11/7/2023Umbraco is Always Loading Content From Database on Azure App Service
Explore a clever workaround to ensure Umbraco's performance on Azure Linux App Service. Learn to tackle the persistent content loading issue from the database
3/1/2023How to rebuild all indexes in MS SQL server database
Discover how to optimize your database indexes without extra tools. Learn how to identify indexes to heal based on avg_fragmentation and how to refresh the...
10/21/2020Mastering Paginated Deletions in MSSQL Tables
Remove records from large tables using the paginated deletion technique to avoid common pitfalls like bloated transaction logs and performance bottlenecks
9/15/2020Resetting Identity Column Values in SQL Server using DBCC CHECKIDENT
Learn how to use the DBCC CHECKIDENT function in SQL Server to reset identity column values. Understand why and when to reset identity with practical example
9/11/2020How to Delete Umbraco User Permanently
Explore the step-by-step process to delete an Umbraco user permanently. Understand the difference between deactivation and deletion, ensuring GDPR compliance.
8/13/2020