SQL – Query to find tables with column name
Find Tables with Column Name using SQL - Learn how to use this simple SQL query to identify tables containing a specific named column, like Gender, in your database. Supported…
Microsoft SQL
MS SQL Server 2008 – How to update value using SELECT results
This article explains how to use a SELECT query to update a value in Microsoft SQL Server 2008. It demonstrates an example where two tables, T_People and T_Artworks, are matched…
SQL Management Studio – How to create read only users
How to Create Read Only Users in SQL Database using MS SQL Server Management Studio. Learn step by step process to create a read only user for your SQL database.
SCCM Log File Location List
Discover the location and purpose of various log files in SCCM. From client logs to server logs, get insights for effective troubleshooting.