Age of Empires
The America of 1776 will reach its 250th year in 2026.
2008, 2022
0505, 2022
Off to Cebu and about NAIA Parking Rates
Please read our Disclaimer Hello, Just recently, I’ve went on a business trip going to Cebu to visit one of our work sites. Preparing and packing stuff is plain and simple, scheduling a flight also went smooth, the only challenge was how do I get to the airport. I didn’t mean the how (direction) but the how (steps), Nowadays, we
0204, 2021
Find any Text in any Stored Procedure
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2014 (SP3-GDR) (KB4532095) – 12.0.6118.4 (X64) In case you need to find a certain text, a word or a string in your stored procedure assemblage, the following command will come in handy. Command: SELECT routine_name, routine_definition FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_definition LIKE ‘%<replace with your text>%’
3001, 2021
How to Check when an SQL Account was Last Modified
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) One day, some SQL agent jobs were no longer running, so Pao went to check the issue, he fired up his SQL Management Studio and went to check for the ailing jobs. Upon checking the error logs, he found out
2911, 2020
TypeError ReflectionFunction::__construct() expects parameter 1 to be string, array given
Please read our Disclaimer Works With-Laravel Framework 8.16.0 After a long hiatus, I’ve jumped from Laravel 5.8.30 to Laravel 8.16.0 to update my tools and that’s almost three (3) major versions I’ve missed. With a busy schedule I could not spare time to go through the change logs. And so it happens. Prior the 8.16.0 migration, I’ve used to create
2911, 2020
Enable Shell Command in your Microsoft SQL Database Server
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) As a Database Administrator, there are occasions that you would be needing to interact with the operating system from your SQL Management Studio such as running a dir check or you need to do a file import using the bcp utility
2410, 2020
Count the Number of Records for each Database Tables in MS SQL
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) In case you need a quick run of how many records (or rows) are there in your database tables. Command: Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or (CTRL+N) Copy
0910, 2020
Search a Value from any Columns in any SQL Tables
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Savra, our new database engineer needs to check existence of a certain keyword on the database. So she went for it… Command: Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or
2208, 2020
How to Check when a Table was Last Updated
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2008 (RTM) – 10.0.1600.22 (X64) Command: SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update, * FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID(‘[replace with your database name]’) AND OBJECT_ID = OBJECT_ID(‘[replace with your table name]’) Steps and Sample Usage: Open and log into your SQL Management Studio Open a New
2208, 2020
How to Join Unrelated SQL Tables
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Command: SELECT d.*, p.* FROM [AdventureWorks2016].[HumanResources].[Department] d JOIN [AdventureWorks2016].[Person].[Person] p ON 1 = 1 Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or (CTRL+N) Run the following commands: (Copy and Paste the code block to your Query Window)