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.
(If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This is the basic query text to use whenever you need to loop through a result set in SQL Server using TSQL. In this example we are getting every database name and printing it out.
There is a feature that is not available for Gmail that should be, but I have the workaround. What feature is missing? The one that lets you separate your email based on whether the sender is in your contact list or not.
MIUI (mee-you-eye) is a ROM that is available on the Android platform. If you’re bored with your stock look-and-feel of your Android piece, or tired of the quirks in your current ROM, you should have a look at MIUI.
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 to create the role but… Read More »
In honor of December 21, 2012, I have extracted this from an old post on benjf.com. Please enjoy my “best practices” for predicting the end of the world. See you on December 22. New Doomsday Prediction Rules I would like to lay out some rules for predicting the end of the world. This will be… Read More »
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 application would close itself without… Read More »
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 the entire Profiler application would… Read More »
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 ways to further break apart… Read More »
While most people believe that only whackos and kooks believe in weather control, those who have done their homework on the subject know otherwise. Not only is it provable that the technology exists, but you can prove that everyone in congress and the senate already know about it. In the US CODE, USC Title 15… Read More »