In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have […]
When designing a database, choosing good datatypes is important, but not necessarily all the time. Today Steve wonders if you still use fixed sting data types.
You can make SQL Server database development faster and easier with a FREE toolkit!
This article demos a novel way to report on the progress of your Flyway development project. It provides both SQL and PowerShell versions of code that extracts information for each database version from the Flyway schema history table and then plots it in a Gantt chart.
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.
The innovations and possibilities of cloud computing are exciting to Steve.
We want to hear from you! Tell us what's important to you by sharing your insights and preferences for PASS Data Community Summit 2022. Community feedback is at the heart of everything we do for Summit and your insights will help guide our planning for this year's conference, taking place online and in-person in Seattle, November 15 - 18, 2022.
To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers