How do I change the password of a user in SQL Server?
The following example changes the password of login Mary5 to a strong password.
Microsoft SQL
How do I truncate a log file in SQL Server?
Shrinking a log file to a specified target size SQL Dev servers typically use “Simple” for the Recovery Mode while SQL Prod servers use “Full.” The SQL query below assumes that you are temporarily switching from Full Recovery Mode to Simple and then back to Full. The following example shrinks the log file in the AdventureWorks database … Read more
SQL Server User Mapping Error 15023: User already exists in current database.
When trying to map a database [go to Security > Logins > username > Properties > User Mapping > Select Database > set as db_owner and then okay, I keep on getting the following error message: User, group, or role ‘someuser’ already exists in the current database. (Microsoft SQL Server, Error: 15023) What is causing … Read more
Getting Started with the SQL Server JDBC Driver
I know that Java Database Connectivity (JDBC) doesn’t have much (if anything) to do with PHP, so I apologize in advance if you are tuning in expecting to find something PHP-related. However, I temper my apology with the idea that getting out of your comfort zone is generally beneficial to your growth. The fun part … Read more