life n computers

[mlifeco-blog]

How to share your MAC address

This is for all windows computers -- click start Search for cmd Click it A black screen will come Then type below md c:\mlifeco Press enter ipconfig /all > c:\mlifeco\network_info.txt Press enter Then from your my computer goto c drive, then double click folder mlifeco, find the file network_info.txt and share it. Please note: if you have an error when pressing enter above, you probably don't have admin privileges and can't share MAC address.

[mlifeco-blog]

Cloud file syncing

So recently a cloud sync software ‘Cubby’ shut its services. Reason too much cost not enough demand etc.

One of the things we loved about Cubby in the world of cloud file sync was the ability to share, sync and folders files and folders from existing folder structure on your computer, not the ‘one folder’ where everything needs to be like Dropbox or Google drive.

Also Cubby made syncing easy, and syncing technically is not easy!

A bit of research has shown only the below two as alternatives:

- Syncplicity https://www.syncplicity.com/pricing/ , which has a free 10 GB personal version

and

- SugarSync which has no free version https://www.sugarsync.com/en/

Know about any others?

[mlifeco-blog]

SQL Server Cursor Code Generator

How many times have you found yourself googling the correct way of writing a SQL cursor.

After years of googling, writing, googling - decided it was worth making my life easy and write a SQL server cursor code generator.

It’s a simple app that can be found below. Needs .net 3.5.

Let me know how you go

https://www.dropbox.com/s/8k3kxeq4jhcmb44/SQLServerCursorGenerator.zip?dl=0

[mlifeco-blog]

How To: Automate "Generate Script" in SQL Server

Why you here?

If you are here below are the things that you are probably trying to achieve:

Trying to automate the "Generate Script" functionality in SQL Server to take a backup of all databases and the creation scripts - tables, functions, stored procedures, views etc

Trying to take a backup of your schema every night

Trying to do the above and put it in Source Control for versioning

Versioning of SQL Server databases schema

What you need before you start?

SQL Server (Express) Management Studio on the machine you are trying to create and backup the script on: http://tinyurl.com/423fqvc . Once installed please make sure you open it and can connect to your Database Server.

SQL Server Database Publishing Wizard on the machine you are trying to create and backup the script on Check if this is under: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe  or C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe  if not download from   SQL Server 2005: http://www.microsoft.com/download/en/details.aspx?id=5498 SQL Server 2008: http://stackoverflow.com/questions/1391013/sql-database-publishing-wizard-with-sql-server-2008 

Tortoise SVN on the machine you are trying to do the automatic commit of the database scripts on  Download from http://tortoisesvn.net/downloads.html 

SVN on the machine you are trying to do the automatic commit of the database scripts on  Download from http://subversion.tigris.org/servlets/ProjectDocumentList?folderID=11151&expandFolder=11151&folderID=91 

Visual Studio Express C# I just find programming using C# easier to create batch programs - you can use anything you like (Java etc.) Download from http://www.microsoft.com/express

Steps

Creating scripts for all databases on the server  1. Using your favorite coding language create a windows application (exe, bat) which does the below

Connects to your database server

Lists all the databases on server Select name From sys.sysdatabases 

Loops through the database names

Calls SqlPubWiz.exe for each database name (See Point 2 under "What you need before you start") And passes the below parameters to it: script -f -d DatabaseName -S DatabaseServer -U UserName -P Password C:\BACKUPFOLDER\DatabaseName.sql -schemaonly  Example Code in C#

Subversioning the scripts 2. Run the application created in Step 1, to create first version schemas/scripts of all your databases in your backup folder. 3. Add the first version of your databases schemas to your source control. 4. Right click the BACKUPFOLDER. Click "Tortoise SVN" then "Import". Connect your SVN server, create a folder for your schema backups and press OK. 5. Right click your BACKUPFOLDER again click "SVN Checkout" -- make sure your current directory is right. Once you click OK all your files will be "Versioned". Automating Add , Delete And Commit  6. Create a bat file and paste the below code in it (call it autocommit.bat)

svn cleanup %1 for /f "tokens=2*" %%i in ('svn status %1 ^| find "?"') do svn add "%%i" for /f "tokens=2*" %%i in ('svn status %1 ^| find "!"') do svn delete "%%i" svn commit -m "Automatic commit" %1

7. Pass the folder name to this bat file eg. autocommit.bat C:BackupFolder 

Schedule Backup 8. Goto Windows Task Scheduler and get it to run your first application that generates scripts for all databases first. 9. And then run the autocommit.bat batch file

[mlifeco-blog]

Calling SqlPubWiz.exe for every database on the database server. C#.

[mlifeco-blog]

How to hide tab in DNN Stuff Aggregator

keywords:

dot net nuke, tabs , aggregator

- Put all the content you have in module not as the description of the tab

and then remove everything in the description of the tab - WHEN i mean everything click BASIC TEXT BOX and remove the empty line HTML code too.

Now you can put all your view settings on your module and the tab will not show when empty (aka existing module not visible)

[mlifeco-blog]

aspnet_wp.exe: Managed' has exited with code 0 (0x0)

aspnet_wp.exe: Managed' has exited with code 0 (0x0)

Change your default debug browser

How to do that

http://www.cambiaresearch.com/c4/83b1ee3e-e1b9-40ef-9505-7276007635d4/Change-the-Default-Browser-in-Visual-Studio-2005-and-Visual-Web-Developer.aspx

[mlifeco-blog]

500 Internal Server Error on Godaddy - what is it?

If you are trying to find out what the 500 error actually means and failing there is an easy way

Create a web.config file, put below code in it

<configuration>  

<system.webServer>

    <httpErrors errorMode="Detailed" >

    </httpErrors>  

</system.webServer>

</configuration>

upload it to the root folder of your server.

And the error will be there for you.

[mlifeco-blog]

scam - they are just getting better at that

So a friend of mine sees an ad for a car on carsales.com.au contact the owner. Hears nothing back for a week

and then an email arrives from a certain Foxtel Manager is South Africa right now - covering the fifa world cup ofcourse - ready to sell her car at a very cheap rate as she doesnt care about it blah blah.

Just that this time she forces that she would like to the transaction to ebay - except she had removed the item recently due to too many queries. A simple googling of the item number says that there was actually an item on ebay with the same pics we saw on carsales at a way higher price - already sold - contacting the previous owner he says yeah the car had been sold last week - might be the new owners selling it.

Obviously suspicious we continue conversation ask for her unique car id to be ale to track the car. Don't get anything back in the email.

2 days later we get an email from ebay sales. hold on hold on it's from [email protected]

the email, template even the links are real (they link to ebay) but it says now that you have committed you have to transfer the money to this bank account using Western Union. There was even a link from ebay saying if you receive an email from ebay you will can see a copy of it when you login to the website - obviously there wasnt any copy

We dont reply for a while and then get an email again from ebay sales - but this time it's Kevin (Rudd?) - our sales coordinator from ebay (with the same email address) - making sure that everything is going well and reasserting that we need to trasnfer the money to the above account.

No reply. New email 2 days later. - from [email protected] - wow ebay switch domain so quickly

  Dear XYZ,   Thank you for using eBay, the Buyer Purchase Protection Branch. My name is Kevin and I will be the one who will assist you today.

You have been contacted by eBay . We have recorded 02XXXXXXX as your phone number but couldn`t reach you. Please update your contact information or phone us back at [phone] in order to ship the car today. 

  Sincerely,  Kevin

eBay Customer Support Specialist Buyer Purchase Protection Program - Building Trust in Transactions (sm).

-- eBay sent this email to you [email protected] about your account registered on www.ebay.com.

eBay sends these emails based on the preferences you set for your account. To unsubscribe from this email, change your notification preferences. Please note that it may take up to 10 days to process your request. Visit our Privacy Policy and User Agreement if you have any questions.

Copyright © 2010 eBay Inc. All Rights Reserved. Designated trademarks and brands are the property of their respective owners. eBay and the eBay logo are trademarks of eBay Inc. eBay Inc. is located at 2145 Hamilton Avenue, San Jose, CA 95125.  

We called - yes we did

Rang Kevin, He answered the phone.

Said he was in Qld. Told him I will be in Brisbane on the Friday and can come and inspect the car.

He going to call me back in 10 minutes.

Still waiting.... :)

[mlifeco-blog]

An attempt has been made to Attach or Add an entity that is not new, perhaps having been loaded from another DataContext - Why it happens and where to look

Under:

LINQ 2 SQL

Sources:

http://social.msdn.microsoft.com/Forums/en/linqtosql/thread/4afff02d-51df-41fe-80b8-a19feaa9b2a7

If you get this error - stop assuming stuff. Understand the error first 

The error simply means

You created an object (or extracted it using LINQ) from one instance of the DataContext and then tried to Attach (see below for more details) to another instance of the DataContext - LINQ to SQL doesn't like this.

eg. Where you might do this

//You create a DataContext Object

var dc = new MyDataContext();

//You get a customer from the data context. Here you might use LINQ etc to find your relevant customer

var customer = dc.Customers.First();

//You create a new Order Object and assign the customer to it.

var customerOrder = new Order();

customerOrder.Customer = customer;

//You create another DataContext Object

var dc2 = new MyDataContext()

//You attach insert this new cusomterOrder to it

dc2.Orders.InsertOnSubmit(customerOrder)

//You save

dc2.SubmitChanges()

EXCEPTION IS THROWN

In the above example even though you created a completely new object (customerOrder) and then inserted it to the another datacontext the "customer" property(object) was from another data context and hence you got the error.

How you might have created this error

- You are saving an instance of the object like 'customer' in a Session's variable. (or Logged in User) and then attaching/or making it a properly of a new object that you are now inserting/adding to another datacontext.

- You have 'customer' as a static object - and when 2 people are using the application (or webservice) at the same - it always uses the latest static object value which might have been created from a DataContext from another instance/user of the application i.e. if your DataContext is instance based while the static object isn't. Advise - get ride of static objects.

Understand the error. The error might not be due to an object you have created but a child object that was created from another instance (somehow) and hence causing the error.

[mlifeco-blog]

Lenove Ideapad - Unmute Mic

Open Realtek HD audio Manager (It shows in the same bar where u see the clock

go to the mixer tab

Next to the recording / record there is a Mic

click the Black Circle under the Mic control to make it Green

tadaa

[mlifeco-blog]

DotNetNuke - HTML Module table

if you are trying to replace the content / text that you have in a HTML Module - and googled everywhere - you just wasted your time like me. Anyways below is the simple solution

the table is called

HTMLText

If you want to replace it use something like

UPDATE HtmlText SET Content = REPLACE(Cast(Content as NVARCHAR(MAX)),'abc','xyz') WHERE Content LIKE '%abc%'

I had to CAST it as SQL Server doesn't like Content being a NTEXT field otherwise.

[mlifeco-blog]

ReportParameterValueNotSetException - subscription mode - SSRS

Cause:

You made a change in the Report (RDL) file. Saved it but Didn't build it - and then deployed it.

Restart Server

No no no definitely not the above. In my case it was because of one parameter depending on another which was set wrong. The above error is usually a distraction to another. If you  the above errored parameter is a default value (ticked DEFAULT) - try passing it the an actual value to find out what the real errored parameter is - then look at the ones it's dependent on. YES THERE IS AN Error with your parameter - the above error might not give/tell you the right one though? 

Moral: CHECK ALL PARAMETERS ARE BEING SET CORRECTLY - NOT JUST THE ABOVE ONE.