2016-03-18
PowerShell – Query Database Remotely
The basic syntax for sending a query to SQL Server using PowerShell. sqlcmd -S SERVER_NAME -d...
database
2011-10-25
SQL Server – Find Stored Procedures User Can Access
http://msdn.microsoft.com/en-us/library/ms190310.aspx Returns a report that has information about user permissions for an object, or statement permissions,...
2011-05-16
HTML Checkboxes
Occasionally, you discover something that you have been doing wrong for a long time. Sometimes it...
2010-07-08
Finding Duplicate Records In Database
SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*) If...