I was sitting here thinking about the editorial when Kathi Kellenberger came to mind. She would frequently write about her favorite show, Star Trek. I too have been a fan of Star Trek since I was very young. However, my favorite show is a little more obscure and not as many people have seen it, […]
Learn how you can bulk set passwords using PowerShell for all your instances.
Helping others has been good for Steve's career and he encourages you to do it as well.
If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.
In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.
This article continues looking at python code in Power BI to produce charts.
We often live with our early decisions on technology, which can be a challenge over time.
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers