Blog Home  Home RSS 2.0 Atom 1.0 CDF  
 
hoohee.com - Sunday, March 19, 2006
 Sunday, March 19, 2006

1. DBCC SHRINKFILE(mydbname_log, 1)
2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp
3. Quick and dirty: using sp_detach_db and sp_attach_db system stored procedures.
http://www.swynk.com/friends/krishnan/movedatabase.asp

3/19/2006 11:56:45 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   MSSQL  | 

WARNING: READ ON AND RUN ONLY IF YOU KNOW WHAT YOU ARE DOING.

sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE

3/19/2006 11:55:46 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   MSSQL  | 

Quick Options:
1. Restore from a backup copy.
2. Run the Rebuild Wizard (Rebuildm.exe).
3. Start sqlservr with the -T3607 option.
4. Force status reset by running (WARNING: THIS IS A DANGEROUS OPERATION USE ONLY IF YOU KNOW WHAT YOU ARE DOING) UPDATE SYSDATABASES SET STATUS=-32768 WHERE NAME='DBNAME'
5. Call Microsoft professional services.

Related Links:
http://support.microsoft.com/default.aspx?scid=kb;en-us;180500
http://support.microsoft.com/kb/165918/

WORKAROUND:
To work around this problem, perform the steps below. Note that the final step is critical.
1. Ensure that the device file is actually available.
2. Use the supplemental stored procedure sp_resetstatus to reset the status of a suspect database. For more information on sp_resetstatus, see the "Resetting the Suspect Status" topic in the SQL Server Books Online.If you have not already done so, create this procedure by executing the Instsupl.sql script, found in the Mssql\Install directory.
3. Use the supplemental stored procedure sp_resetstatus to reset the status of a suspect database. If you have not already done so, create this procedure by executing the Instsupl.sql script, found in the Mssql\Install directory. For more information on sp_resetstatus, see the "Resetting the Suspect Status" topic in the SQL Server Books Online.
4. Execute sp_resetstatus in the master database for the suspect database:

use master
go
exec sp_resetstatus msdb -- replace msdb with your database name

You will see the following output:

Prior to Update sysdatabases attempt for DBName='msdb', the mode=0
and status=328 (status suspect_bit=256). For DBName='msdb' in
sysdatabases, status bit 256 was forced Off and mode was forced to
0. WARNING: You MUST stop/restart SQL Server prior to accessing this
database!

5. Stop and restart SQL Server.
6. Verify that the database was recovered and is available.
7. Run DBCC NEWALLOC, DBCC TEXTALL, and DBCC CHECKDB.

3/19/2006 11:54:46 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   MSSQL  | 

This information is presented for your convenience and we do not take any responsibility for the use or misuse of this information.

1. Generate password of at least 8 characters in length.
2. Mix both alpha and numeric characters.
3. Don't use words from the dictionary.
4. Don't write your passwords down.
5. Random and meaningless strings are the best, if you can remember them.
6. Use a formula to with an easy to remember number and mix it with the reverse order of a word or string that you know by heart. As an example you can use ln(X) where X is the number you know and then take a word or string like "Hellomyfriend" and mix them. To be more concrete I will assume X is 1234. ln(X) = 7.1180162044653331234148038000684. Now we can mix with our string and the generated password becomes "7dn1ei1rf8ym0ol1le6H".

3/19/2006 11:52:07 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Miscellaneous  | 

OVERVIEW:
You can use this program as a service that runs in the background everytime you start your pc. It will check every 4 minutes for a change in your public IP address and update your ZoneEdit account if a change is detected.

The client is used to configure the service. All settings are persisted to the registry and password are encrypted. The passwords are displayed in plain text in the client; however, they are encrypted before saving to the registry.

Please make sure that the service is setup to Automatic startup, else you will have to run it everytime manually.


REQUIREMENTS:
Windows XP SP2 or Windows 2000 SP4 or Windows 2003
Microsoft .NET 1.1 (v1.1.4322)
Administrative privileges to install and run
Microsoft WWW Services (Web Server)


SHORT TODO:
- Start the service after setup
- Change the string we check for in the html page to a GUID generated during setup preferably
- Add logging using log4net
- Add more Dynamic DNS Services
- Might decide to move the settings from the registry to a file
- Add secure http communication where supported by the Dynamic DNS Service


YOUR COMMENTS:
We welcome your comments and opinion.

DOWNLOADS:
Source Code (41.4 KB)
Setup (74.3KB)


SOME of the AVAILABLE Dynamic DNS Services:
Service name URL
2MyDNS http://www.2mydns.com
ADSLDNS.org http://www.adsldns.org
Bell Canada http://bell.easydns.ca
BLRF.net DynDNS Service http://www.blrf.net/dyndns/
BlueLine Computers (DynDns of) http://dns.blueline.be
CanadaComputes Domains http://domains.canadacomputes.com
ChangeIP http://www.changeip.com
CheapNet http://www.cheapnet.net
CJB.NET http://www.cjb.net
d-ip.de http://www.d-ip.de
DipDNS Network http://www.dipdns.org/
dipserver.net http://www.dipserver.net
DNIP.net http://www.dnip.net
Dns2Fast http://www.dns2fast.com/
DNS4BIZ http://www.dns4biz.com/
DNSD.be http://www.dnsd.be
DnsDyn http://dnsdyn.com/
dnsExit.com http://www.dnsexit.com/
DNSKING.ch http://www.dnsking.ch
DNS Made Easy http://www.dnsmadeeasy.com
DNS Park http://www.dnspark.com
DNS Wizard http://www.dnswiz.com
DomainMonger http://www.domainmonger.com
DSLCity http://www.dslcity.net
dynaIP.com http://www.dynaip.com
DynDNS.com http://www.dyndns.com
DynDSL http://www.dyndsl.com
easyDNS http://www.easydns.com
eHostCanada http://easydns.ehostcanada.com
"eNom, Inc." http://www.enom.com
euroDynDNS http://www.eurodns.com
EveryDNS.net http://www.everydns.net
FreeDNS http://freedns.afraid.org/dynamic/
FrostByte http://www.frostbyte.co.uk/dns/
ipUpdater.com DNS Services http://www.ipupdater.com
MyDynIP.org http://www.mydynip.org
MyIP http://www.myip.org
MyServer.org http://www.myserver.org
Nerdcamp http://www.nerdcamp.net
nerdie.net DynRecord Services http://www.nerdie.net/
No-IP.com http://www.no-ip.com
Open Domain Server http://ods.org
Project GPL Hosting http://www.gplhosting.org/
SelfHOst http://selfhost.com
World Wide DNS http://www.worldwidedns.net
YYWeb http://www.yyweb.com
ZDnic http://www.zdnic.com/
ZoneEdit http://www.zoneedit.com

3/19/2006 11:40:47 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   YADDNS  | 

In this section of hoohee.com you will find various programs developed by yours truely.

Free, for a fee, or in source code, I have designed and developed over the years computer programs which you might find interesting.

Two of the major programs I have developed are listed under separate categories on this site:

  1. Broadcast Power 2.0
  2. Power 98

You might want to start off your journey with YADDS.

Enjoy.

3/19/2006 11:32:59 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Software  | 

This category contains miscellaneous technical stuff!

The word technical to me means:

  • A developed use of a technique
  • Knowledge of technology
  • Technical education
  • Technical resources
  • Programming
  • Source Code
  • Software development methodologies and other
3/19/2006 11:28:02 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Technical  | 

Reliable, easy-to-maintain and operates at significantly lower costs, Broadcast Power 2.0 automates your daily music programming, radio station management and commercial scheduling.

Designed from the ground up for digital radio operations, Broadcast Power 2.0 is an easy-to-configure, secure and robust single program with multiple modules.

Broadcast Power 2.0 eliminates the need for carts and CDs. It holds more data and offers a proven return-on-investment ROI.

Professional network scheduling – the right ad, at the right time, on the right station. Alterations to scheduling are easier, too.

Broadcast Power 2.0 minimises drudgery. A complete log of every task is recorded. Human resources can be channeled into more creative tasks.

You can use Broadcast Power 2.0 to program or automate all on-air broadcasts. It is a complete on-air and post production solution.

Broadcast Power 2.0 has a dedicated website, check it out: http://www.bp2x.com/

If you're interested, bp2x.com has lots of video tutorials for grabs. Feel free to download and let us know what you think or how we can improve the program. We value your comments.

3/19/2006 11:16:54 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Broadcast Power 2.0  | 

If you're looking for the Power 98 downloads page, you've got it right here.

Latest help file for Power 98:
Power98.chm (2.5 MB)

Power 98 v 1.8.0.10 SETUP:
Power98v1.8.0.10Setup.exe

Reports:
Reports

Scroll Strings:
ScrollStrings.zip

Ad Scheduler v 1.0.0.29 SETUP:
Ad Schedulerv1.0.0.29.exe

Ad Scheduler Importer:
AdSchedulerImporter.zip

DB Convert v 1.5:
DB Convert 1.5.exe

DB Convert v 1.8:
DB Convert 1.8.exe

Visdata:
VISDATA.zip

 

The applications above require the Visual Basic runtime to be installed on your machine. Although, the installer attempts to install the required DLL's, due to the wide variety of versions available out there on the different Windows OS versions, you can try to download and install the microsoft Visual Basic redistribution pack from the following URL: http://www.microsoft.com/downloads/details.aspx?FamilyId=7B9BA261-7A9C-43E7-9117-F673077FFB3C&displaylang=en

3/19/2006 10:39:58 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Downloads  | 

POWER 98 is a program designed to aid broadcasting radio stations on air and in post production.

It is a full feature program in the sense that it has most features that you (as a radio station) may require.
The idea first came when I was a DJ back in 1992. Ads at that time where recorded on tapes and were played one tape after the other. That was a hassle for the DJ because at times the tape recorder would not read the tape properly, at other times, the DJ could miss an ad or misplace it on air. Further, the quality was awful.
In addition to the said above, the DJ used to have CDs with the radio station jingles and others with his own jingles. So that meant working with a CD player to broadcast jingles.
Not only that was a problem, the manager of the station used to keep piles of papers for the schedule of the ads and their cost along with many other related paper work.
I was back then a computer science student. A friend of mine (Robert Sayegh) and I started designing and writing a program that would do all of these function. We succeeded and called it POWER STATION. It was a hell of a program at the time. We added also a database for the songs, their location, their number and related info.
The program however, lacked functionality, interface, ease of use and other nuts and bolts. In October 1998, I started, from the ground up, designing and coding POWER 98. To my expectation, it came out fabulous.

 

What POWER 98 can do and what features it has are listed below:

1    It can play ads with a 0.6 sec mix. In other words, there is no empty space between ads. You control how ads are played on air by adjusting the silence in the beginning of the ad or at the end.

2    It has 15 sets of 36 jingles for each DJ, easily accessible through the keyboard or by using the mouse.

3    It has a search function for songs available at the station along with the info of the last time the song was played and whether you are allowed to play it or not.

4    When you find a song you can play it from the program if the management has put it in the computer.

5    Two songs can be played at the same time (mixed, cut, or faded).

6    Jingles can be played at the same time as songs are playing or ads are playing (It's up to you to decide what you want to do).

7    The program is password protected. Each user has a login name and password.

8    The program logs all DJs logins and can calculate their salaries.

9    A special advanced search screen, for songs, is available.

10   DJs don't have to worry about selecting an ad spot by selecting the time and date of the spot. The program takes care of that and prompts the DJ to press on ENTER or click on the play button for the ads. The ad retrieval function is automatic.

11   A special program comes with POWER 98 for you to schedule your ads.

12   A second program was written for you to enter the songs, jingles, cuts, etc. for your library.

13   A program called NIGHT PLAY, part of POWER 98, helps you write lists of songs to be played sequentially or randomly with the ability to choose the mix time of the songs or the fade in and out intervals for two consecutive songs.

14   NIGHT PLAY allows you to play jingles within songs.

15   With NIGHT PLAY you can mix two songs or stop a playing song at three different intervals that the program chooses from at random.

16   A utility screen is designed to help you create users (DJs, broadcasters, ...) and specify the privelages of each (which parts of the program are they allowed to use, etc.).

17   You can divide your ads by segments, customers, agencies, and assign prices, free ads per X number of ads, and other functionality.

 

 

For an exhaustive list of features you will have to read through the help file one topic at a time, or you can contact me.

3/19/2006 10:30:37 PM (AUS Eastern Daylight Time, UTC+11:00)  #    Comments [0]   Power 98  | 
Copyright © 2008 Emile Bassil. All rights reserved.