T-SQL – How to output day name from date
The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019 would output Saturday. SELECT DateName( weekday , GETDATE() ) as…
Microsoft SQL
T-SQL – How to output day number from date
The following T-SQL statement shows how output the day from a date. For example, 16 March 2019 would output 16. SELECT DateName( day, GETDATE() ) as Day_From_Date
MS SQL Server 2008 – How to update value using SELECT results
The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft SQL server (T-SQL) -- and will not work in MySQL.…
SQL Management Studio – How to create read only users
The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio. This may be helpful if you need to give access…
SCCM Log File Location List
The client logs are located in the %WINDIR%\System32\CCM\Logs folder or %WINDIR%\SysWOW64\CCM\Logs (for x64 OS). The SCCM server log files are located in the <INSTALL_PATH>\Logs or SMS_CCM\Logs folder. IIS logs can…