Optimize SQL LIKE Wildcard Searches
Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.
2024-11-01
Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.
2024-11-01
Unable to travel to Seattle this November? We have options for you to join in from the comfort of your own home or office, with a free livestream and on-demand access available to buy.
2024-11-01 (first published: 2024-10-18)
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2024-10-31 (first published: 2023-11-03)
3,589 reads
Timescale embeds advanced AI into PostgreSQL, the most popular database, leveling the playing field and equipping every developer to build AI—fast and hassle-free.
2024-10-30
200 reads
Learn how you can get data from AWS into Fabric in this article.
2024-10-30
1,066 reads
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions. Traditional relational databases, once the foundation of data management, often struggle to meet these modern demands, leading to delays and program slowdowns. In response, NewSQL databases, a new class of SQL systems, has emerged.
2024-10-30
Explore the fundamentals of Python's SQL transaction control, demonstrating how to control and enhance database operations for improved data integrity. The best practices and real-world examples for integrating strong transaction management in Python applications are covered in this article.
2024-10-28
1,573 reads
Learn about the Microsoft sessions at the 2024 PASS Data Community Summit from Bob Ward.
2024-10-28
165 reads
In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.
2024-10-28
Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
2024-10-25 (first published: 2011-06-13)
10,214 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers