In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.
2023-05-03
Understanding how roles and privileges work in Postgres is key to understanding the next, and often more confusing part of security, object ownership.
2023-05-03
For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can cause a lot of downtime and have a negative effect on business operations. However, with the introduction of Accelerated Database Recovery (ADR), Microsoft SQL Server has added a potent new feature that greatly enhances database availability and […]
2023-05-02 (first published: 2023-04-03)
2,705 reads
In this article, you will see how ChatGPT works with a database project.
2023-05-01
12,528 reads
Judging from my experience working with business stakeholders across several organizations, slicing data by current week, previous week, two weeks ago, and so on has become a requirement for reporting. I will demonstrate a simple approach to achieve this requirement.
2023-05-01
This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain.
2023-05-01
See how the new, open-source sqlcmd works with containers to kickstart the development experience.
2023-04-28
3,177 reads
In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.
2023-04-28
We are proud and honored to announce DPWIT-Mental Health and Wellness Day, May 5th,2023,
2023-04-28
This article examines how one can structure a pipeline for processing real-time data using Kafka and Informatica.
2023-04-26
4,650 reads
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
I’m not trying to start up a debate whether you should use tabs or...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers