Blogs

Featured Blog Posts

sorting version numbers (Oracl

a recent question had me looking for more on this, here's one I found that's interesting:

Found this at ask tom (by, Laurent Schneider from Switzerland) http://sqlfiddle.com/#!4/3f22a/1    

Read More

Scheduling OS Tasks To Run Aft

So you've managed to create a task that is triggered by the end of a SQL Server maintenance plan (No? See my predecessor blog on the basics). And you would like to pass some detail(s) of that task to the program you are calling.

Very easy. For instance, I compress my backups using 7z with maximu

Read More

Query itself, output into itse

http://www.experts-exchange.com/Software/OfficeProductivity/OfficeSuites/MSOffice/Excel/Q28123245.html#a39155373

Read More

Move all SharePoint databases

I answer this question at least once a month:  "How do I move my databases to a new SQL Server??"

I've wanted to write an entry on this topic for some time now, but something always stands in the way (kids, clients, etc).  

Rather than copying and pasting from my notes, an

Read More

Recent Activity