Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude
2024-07-01
Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating
2024-06-28
2,791 reads
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
2024-06-28
In this new article, we examine how to work with OneLake storage.
2024-06-26
1,118 reads
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes.
2024-06-26
Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices
2024-06-24
3,946 reads
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, it often finds its way into SQL Server databases and needs to be managed alongside other data types.
2024-06-24
This article discusses how one person implemented Row Level Security in PostgreSQL to help with a data migration from a single tenant to a multi-tenant database structure.
2024-06-21
1,056 reads
What are the best days of the week and times of the day to post a question at StackOverflow.com?
2024-06-21
2024-06-19
3,117 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
We have veeam backups happening everyday on a server where all sql databases are...
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
Hi I am trying to assign the value of the variable using the output...
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers