A Tidy Database is a Fast Database: Why Index Management Matters
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
2024-11-11
2,685 reads
Articles
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
2024-11-11
Step by step guide to setup PostgreSQL on Docker
Learn how to get started with PostgreSQL using a container to practice database skills.
2024-11-08
1,081 reads
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
2024-11-08
What’s In Your Development Database? The Answer: Production Data
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted a poll here on the blog and on a few of my social media feeds, and here were the results:
2024-11-06
Your Personal ChatGPT Tutorial
This tutorial will show how to use an AI model with Python to respond to queries.
2024-11-04
4,566 reads
Creating Views in MongoDB
Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB
2024-11-04
Live webinar - Prioritizing security: Essential strategies for IT leaders
In today's rapidly evolving landscape, managing the security of large and complex database estates is a critical challenge for organizations. Join us for a webinar on Nov 21 covering “Prioritizing security: Essential strategies for IT leaders,” where Redgate’s security experts will share their tips on how you can safeguard your database estate and minimize reputational risk. There will also be a Q&A session where you can get expert advice from our panelists.
2024-11-04
A Guide to SQL Security in Django
If you encounter Django in your environment, are you thinking about SQL Injection and security? If not, read this article and learn how to protect your data.
2024-11-01
768 reads
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
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers