MS SQL

Dive deep into the latest insights and breakthroughs surrounding MS SQL with our curated articles

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/2024

How 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/2024

Creating 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/2024

How 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/2024

Searching 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/2024

How 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/2024

Umbraco 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/2023

Umbraco 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/2023

Umbraco 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/2023

How 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/2020

Mastering 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/2020

Resetting 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/2020

How 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
↑ Top ↑