Here’s a nice little snippet of T-SQL code that will reindex all tables in the database with one line of code: EXEC sp_msForEachTable @COMMAND1= ‘DBCC DBREINDEX ( “?”)’ Keep in mind that the DBCC DBREINDEX command will put a lock on the table while it does its thing, so you may not want to do [...]
Amazon announced their new Route 53 DNS service a few days ago. Never one to let a gizmo go untested, I immediately signed up and I’m now hosting DNS for eal.us through Route 53. Looks good, but I wish there were a nice control panel to front it…setting everything up via API (and manually edited XML [...]
For the supremely geeky among us… Recently, my copy of SQL Server 2008 Management Studio began failing with this error message: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following [...]
After applying updates, I was unable to launch Microsoft Outlook 2007. Every time I tried, it would open the frame of the main window, then fail with a modal dialog box: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. I ran Microsoft Office Diagnostics (which usually can fix these kinds of issues — [...]
I had a client ask me today to help with converting a bunch of WMV video files (Windows Media – Video) so that he could store them on his T-Mobile G1 and watch them. After a bit of digging, I found a wonderful tool called HandBrake that exists to do nothing but convert videos between [...]
This is wonderful! A company in South Africa is going to begin using homing pigeons to transfer data between its two offices, which are roughly 50 miles apart. Currently they use broadband to transfer about 4GB of encrypted data between the facilities. It takes about six hours to transfer the data. Instead, they’ll put the [...]
Google released their own browser a couple of days ago, and it’s fantastic. As with all things Google, it’s sparse and simple, but hides lots of sophisticated capabilities underneath it all. I’ve been running it since it came out, and have had virtually zero problems with it (with the exception of one really poorly done [...]
If you manage lots of Windows servers like I do, then you’ve doubtless found Microsoft’s very nice “Remote Desktops” utility. This one isn’t the built-in “Remote Desktop Connection” tool which allows you to connect to one server at a time. No, this one has a little more smarts, and will save multiple server definitions and [...]
Here are a couple of outstanding pieces of software that I’ve run across lately. One is highly recommended because you need it. The other is highly recommended if you need it. SyncBackSE from 2BrightSparks You need to back up your data. Trust me on this, you NEED to do it. I’m on the tail end of [...]
A friend turned me on to SugarCRM yesterday. What a fantastic app! This is a “CRM” (or Customer Relationship Management) application that runs entirely on a web server. There's a free version of Sugar available, too, if you've got the know-how to install it. It's a relatively painless install on a LAMP (Linux/Apache/MySQL/PHP) server. I'm [...]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Mar | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | |||
Verse:
John 3:16; Jn 3:16; John 3
Keyword:
Salvation, Jesus, Gospel
With Operators:
AND, OR, NOT, “ â€
