OC Databases

Orange Coast Database Associates: The cost of fixing bugs. An interesting graphic by SDLC phase. d2associates.blogspot.com/2025/11/the-co…

Orange Coast Database Associates: Inserting a record with pyodbc d2associates.blogspot.com/2025/11/insert…

Just got John Sperling distinguished faculty award. @uopx. credly.com/badges/6f58181… via @credly

Top performers aren't just magically more productive - They're using these 6 techniques:

Creating an SQL Join in Python using pyodbc and Microsoft SQL Server at d2associates.blogspot.com.

Computer shortcuts Source: Techie Programmer

Orange Coast Database Associates: Parameterized ODBC book query. This query in the pyodbc series is the one discussed last week that avoids sql injection. d2associates.blogspot.com/2024/06/last-w…

Orange Coast Database Associates: This is the second in the series of using Python t... d2associates.blogspot.com/2024/05/this-i… Shows fetching and displaying records from SQL Server in Python using ODBC.

The AI data center value chain

The best performing stocks in the S&P 500 over the last 5, 10, 15, and 20 years... bilello.blog/newsletter

There are 3 functions to number rows in #SQL ROW_NUMBER => Unique consecutive values RANK => Ties have same value, after ties value equals row number DENSE_RANK => Ties have same value, consecutive numbers after ties Set the sort in the OVER clause FN() OVER ( ORDER BY... )

Orange Coast Database Associates: I am starting a brief series of posts on manipulat... d2associates.blogspot.com/2024/05/i-am-s…

I just got #XAMPP from @ApacheFriends apachefriends.org #opensource.

The following is a great free tool for automating #SQLExpress database backups. We are not being paid to post this, just passing on our recommendation. Simple and straightforward. We have been using it for some time - #SQLBackupMaster @ sqlbackupmaster.com

The last version of the climate cult mania was nominally the opposite of what it is now: existential concern about “global cooling” instead of global warming. But at its core it’s really the same thing: the agenda has little to do with climate and everything to do power, dominion, control and punishing the west.

I was looking to include #moscowpriorites in #jira. Here is a link to a site that shows hw to do it. Very helpful! #integrate-the-prioritization-in-jira" target="_blank" rel="nofollow noopener">herndlbauer.com/blog/jira-mosc…

This video goes into a lot of detail on using #SSMS. Tips and Tricks for Using SQL Server Management Studio Effectively youtu.be/Jy0ndgHzoIM via @YouTube

Finished adjusting our prices. Generally $165 for 1 day #micrsoftaccessclass, $195 for #sqlclasse and $245 for #databaseclass. 1/2 day #onlinetutor session $95.

Interesting article on #databasepopularity. Put out monthly. Apparently based on search traffic, social media, etc. #microsoftaccess is at #9. Surprised it is not higher. It is an ideal #desktopapp for small scale #businessreporting. db-engines.com/en/ranking

@finally_mitch You can very quickly develop business reporting programs. If you are just client server and need a desktop app it can be a very productive tool.

why any business would use Microsoft Access is beyond me