Recently I was asked if Microsoft Access is actually very powerful. It is! We have created systems that contained more than a million records in some of the tables-
Maryland company – database management
Another Maryland (in Rocville) company here- We have a web-based system written in PHP – MySQL. How do you recommend backing the database up (Database Management)?
Phil in Maryland
a PHP coding tip
When using PHP, you shouldn’t be using the code to check to see if someone is a admin user or not. That is something you should do with sessions.
Microsoft Access
Views in SQL Server vs. Queries in Microsoft Access: They are essentially the same thing!
Queries and Tables CCD, LLC
What is the difference between queries and tables? (in Microsoft Access for example)
Origins of PHP
Hypertext Preprocessor (PHP) is a widely used, general-purpose scripting language that was originally designed for Web Development to produce dynamic web pages.
If your firm is in Gaithersburg, Germantown, Rockville, or anywhere in the Maryland area, and you need some help with computer programming, please contact us!
SQL Server with Access
SQL Server can work seamlessly with Microsoft Access: SQL Server is the back end that contains tables and queries, while Access contains the forms and code.
Access databases vs. Microsoft Access
Access databases are just one component of the Microsoft Access program-
Database Management in Maryland
Hello,
Where can I get Database Management done in Maryland? Can you recommend an experienced firm?
JW in Gaithersburg
SQL Server missing transaction logs
Is there there an easy way to determine if you are missing transaction logs for a SQL Server database?
Yes!
Try the following code:
SELECT D.[name] AS [db_name], D.[rec_model_desc]
FROM sys.databases D LEFT JOIN
(
SELECT BS.[db_name],
MAX(BS.[backup_finish_date]) AS [last_log_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = ‘L’
GROUP BY BS.[db_name]
) BS1 ON D.[name] = BS1.[db_name]
WHERE D.[rec_model_desc] <> ‘SIMPLE’
AND BS1.[last_log_backup_date] IS NULL
ORDER BY D.[name];