OC Databases
@ocdatabases
We provide software training, tutoring and programming services in Microsoft Office and data technologies. Classes and tutoring conducted online via Zoom.
You might like
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 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
sqlbackupmaster.com
SQL Backup Master - Free SQL Backup Software
Free SQL Server backup software that automatically backs up your databases to cloud storage (Amazon S3, Azure, Dropbox, Google Drive) or local destinations. Easy setup, reliable scheduling, compres...
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,…
I was looking to include #moscowpriorites in #jira. Here is a link to a site that shows hw to do it. Very helpful! herndlbauer.com/blog/jira-mosc…
herndlbauer.com
How to Use MoSCoW Priorities in Jira?
One of the most popular ways to prioritize project requirements is the MoSCoW method. I will show you how to implement the MoSCoW prioritization into Jira.
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
youtube.com
YouTube
Tips and Tricks for Using SQL Server Management Studio Effectively
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
Here is an interesting link for #downloadingwebdata in to #excel. Just tried it with #Excel2016. Some things were a little different but it worked! lifewire.com/using-web-page…
Just dropped the price for #sql202 #sqlclass to $290 for 1 and 1/2 days. See ocdatabases.com/courses/comput… . Available online or at your facility in SoCal.
Lowered price of #MySQLintroduction class to $195. This is a good course for querying data. See below link for #MySQLcourse details...ocdatabases.com/list-courses.p…
United States Trends
- 1. Cowboys 69.8K posts
- 2. Nick Smith 17.3K posts
- 3. #WeTVAlwaysMore2026 978K posts
- 4. Kawhi 4,627 posts
- 5. Cardinals 31.5K posts
- 6. #LakeShow 3,516 posts
- 7. Jonathan Bailey 33.8K posts
- 8. #WWERaw 65.2K posts
- 9. Jerry 45.7K posts
- 10. Kyler 8,803 posts
- 11. #River 4,924 posts
- 12. No Luka 3,842 posts
- 13. Blazers 8,371 posts
- 14. Logan Paul 10.8K posts
- 15. Valka 5,075 posts
- 16. Jacoby Brissett 5,910 posts
- 17. #AllsFair N/A
- 18. Dalex 2,762 posts
- 19. Pacers 13.8K posts
- 20. Bronny 14.3K posts
Something went wrong.
Something went wrong.