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
Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB
2024-11-04
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
Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.
2024-11-01
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
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
Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.
2024-10-25
This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.
2024-10-23
The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.
2024-10-21
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...
Hub Via Wa:62817825533 Alamat: Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng,...
Hub Via Wa:62817825533 Alamat: Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers