TSQL – Loop Through Result Set WITHOUT Cursors Writer #1, 2013-05-202024-09-02 There is some controversy about using cursors in TSQL. Overall, I believe they tend to… Continue Reading
PHP Regular Expressions – Remove Comments From SQL Text Writer #1, 2013-03-01 This short block of PHP code takes a SQL script and removes the “dash-dash” and… Continue Reading
TSQL – Simple Loop Through Result Set Using Cursor Writer #1, 2013-02-012024-09-02 (If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This… Continue Reading
SQL Server – Script Out a Database Role and Securables Writer #1, 2013-01-102024-06-20 Sometimes, as a DBA, you will have to copy a database role to another instance,… Continue Reading
SQL Server Profiler New Templates Failing Writer #1, 2012-12-19 Upon trying to create a trace template in SQL Server Profiler, I was able to… Continue Reading
SQL Server Profiler New Templates Failing Writer #1, 2012-12-19 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… Continue Reading
Basic PHP Data Setup Writer #1, 2012-12-14 Ideally, when setting up a data-driven PHP site, you should have your configuration and database… Continue Reading
SQL Server – Email Results of Stored Procedure Conditionally Writer #1, 2012-12-10 Within a Stored Procedure, you may want the results of a particular query emailed to… Continue Reading
SSMS MDI Trick Writer #1, 2012-12-07 This trick is for SSMS users who like the MDI (window) environment. If you’ve noticed… Continue Reading
WordPress Not Creating Line Breaks Writer #1, 2012-02-12 This still works but the UPDATE below is better The solution to WordPress not recognizing… Continue Reading