Programming
This short block of PHP code takes a SQL script and removes the “dash-dash” and “/**/” comments from it. Of course, many languages, including PHP itself, use the “/**/” comment style so this could apply to PHP scripts, as well.
- 2013-03-01
Sometimes, as a DBA, you will have to copy a database role to another instance, such as when you have to move something from development to testing or production. Recently, I discovered that using the SSMS “script as” option doesn’t help very much at all. It simply generates a statement...
- 2013-01-10
- 1
Upon trying to create a trace template in SQL Server Profiler, I was able to name the trace but there were no events to choose from in the “Events Selection” tab, even when the “Show All Events” box was checked. If I clicked the “Column Filters” button the entire Profiler...
- 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 was able to name the trace but there were no events to choose from in the “Events Selection” tab, even when the “Show All Events” box was checked. If I clicked the “Column Filters” button...
- 2012-12-19
Ideally, when setting up a data-driven PHP site, you should have your configuration and database connection code separate from your code that generates content. What I want to display is a simple way to keep things separate and simple to work with. I use a config/index/data file structure. There are...
- 2012-12-14
Within a Stored Procedure, you may want the results of a particular query emailed to you, but only if there is a result. In other words, I don’t want to be notified when the result set size is 0.
- 2012-12-10
This trick is for SSMS users who like the MDI (window) environment. If you’ve noticed that new windows open with the instance connection hidden, then read on. I have your fix! Just open a query window, minimize it, and leave it there. After that, new windows will open at the...
- 2012-12-07
This still works but the UPDATE below is better The solution to WordPress not recognizing line breaks is to tweak your source code. You will need a way to edit the HTML on your site. Go to wp-includes -> post-template.php Search for “function the_content“. At the end of that function...
- 2012-02-12