2016-03-19
SQL Server – Find Stored Procedures User Can Access
Returns a report that has information about user permissions for an object, or statement permissions, in...
2016-03-19
SQL Server – Email Results of Stored Procedure Conditionally
Within a Stored Procedure, you may want the results of a particular query emailed to you,...
2016-03-19
SQL Server Profiler New Templates Failing
Source of info: http://www.mattbutton.com/2011/06/01/sql-profiler-templates-missing/ Upon trying to create a trace template in SQL Server Profiler, I was...
2016-03-19
TSQL – Simple Loop Through Result Set Using Cursor
This is the basic query text to use whenever you need to loop through a result...
2016-03-19
Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof, run...
2016-03-18
SQL Server – Find Missing Indexes With Script In Output
Source: http://sqlserverplanet.com/dmvs/missing-indexes-dmv SELECT mid.statement ,migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure ,OBJECT_NAME(mid.Object_id)...
2016-03-18
SQL Server – Download all RDL files from Report Server
—- Allow advanced options to be changed. –EXEC sp_configure ‘show advanced options’, 1 –GO —- Update...
2016-03-18
PowerShell – Query Database Remotely
The basic syntax for sending a query to SQL Server using PowerShell. sqlcmd -S SERVER_NAME -d...
2016-03-18
2016-03-18
PowerShell – Get Boot Time of Computer
Show Date/Time Of Last Boot Get-WmiObject -class Win32_OperatingSystem | Select-Object __SERVER,@{label='LastBootUpTime';expression={$_.ConvertToDateTime($_.LastBootUpTime)}}