1 Comments

If you add a new table and mark the ID column as primary key, but you forgot to set the int or bigint to auto increment, you can not fix this in the SQL Management Studio.

image

There are several ways to do this, I ended up removing the primary key, dropping the column and re-creating it.

Dropping the column also gave me the error about dropping the whole table and re-creating it. So I had to do this with some SQL, so no GUI today but just these two small SQL statements. I hope it helps, otherwise it is just an online backup for when I forget how I fixed this.

alter table YOURTABLENAME add YOURCOLUMNNAME bigint IDENTITY(1,1) primary key
alter table YOURTABLENAME drop column YOURCOLUMNNAME 

Good luck!

 

ps. when you use select @@version you get to see what version of SQL server you are using. I had

Microsoft SQL Server 2008 (SP3) - 10.0.5520.0 (X64)
    Jul 11 2014 16:11:50
    Copyright (c) 1988-2008 Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
This blogpost http://sqlserverbuilds.blogspot.nl/ has a nice list of different versions.

Pin on pinterest Plus on Googleplus Post on LinkedIn
0 Comments

Surface 3 vs Surface Pro 3 costs

As a proud Surface Pro 3 user, I would like to point out why the Surface 3 (not pro) won’t make it in the Netherlands. There has been a dutch review on tweakers.net http://tweakers.net/reviews/4001/microsoft-surface-3-review-degelijke-tablet-met-een-hoge-prijs.html and they gave the device a 6 (on a scale from 1 to 10) and after over 300 comments, they changed it to a 7.

The Surface 3 is 499 in the USA. In the Netherlands, that is 599 euros inc VAT (btw) a typecover is 149 and a pen is also 49. That makes a total of 797 euro. It is 609 euro at the microsoft store (without pen and cover)

So 797 for 64gb entry level surface 3 and 729 + 149 + 49 = 927 for the 128gb variant.

The 64 gb variant has 2gb while the surface pro has an i3 and 4gb ram for 738 euro ex cover (867 inc cover and pen) that is a 70 euro difference.

When you compare the 128gb model: the pro has an i5 for 949 + 129 (cover) = 1078 euro vs the non-pro: 927 makes a 151 euro difference for an i5 cpu and both having 4gb ram.

 

iPad Air 2 costs

the 64gb version is 539 euro

the 128gb version is 664 euro

The keyboards from Logitech are around 90 euro and there is no real pen/stylus option. so the 64gb will be 629 inc cover and the 128gb will be 754 euro. compared to the surface 3, people will buy Apple products even though they cannot really multitask or use a pen/stylus.

 

Conclusion

I think that the Dutch consumer won’t buy the awesome device just because of the price difference and the current Apple hype. If the price drops, I would really recommend this device to people. Definitely because the upcoming release of Windows 10 and the free upgrade. I will stay a happy and proud Surface Pro 3 user and would not switch for a million. I hope this helps people make a decision purely based on prices. Would be great to see a surface 3 price drop in the Netherlands. That would change everything.


Pin on pinterest Plus on Googleplus Post on LinkedIn
0 Comments

Lazy productive I as a developer am, I did not want to write a stored procedure. So I ended up with a lot of SQL statements which needed to be combined and executed only if the previous one succeeds.

However there was a timeout during the execution. It was strange because when I copy pasted the SQL statement in SMSS it worked perfectly and fast too. My mistake was to use a new SqlCommand object which was not part of the transaction. I needed to re-use the same sqlcommand. Here is some working code:

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["myConString"].ToString()))
{
    con.Open();

    SqlCommand cmd = con.CreateCommand();
    SqlTransaction transaction = con.BeginTransaction();

    cmd.Connection = con;
    cmd.Transaction = transaction;

    try{
    
        cmd.CommandText = "SELECT productcode FROM products WHERE productid = " + productid;
        string code = cmd.ExecuteScalar().ToString();
    
        cmd.CommandText = "SELECT ProductID, ProductWeight, ProductEuroPrice, OrderID FROM ORDERPICKINGPRODUCTS WHERE orderid = " + orderid + " AND productid = " + productid;
        SqlDataReader sdr = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        dt.Load(sdr);
    
        cmd.CommandText = "DELETE FROM ORDERPICKINGPRODUCTS WHERE orderid = " + orderid + " AND productid = " + productid;
        cmd.ExecuteNonQuery();
        transaction.Commit();
    }
    catch(Exception e)
    {
        transaction.Rollback();
    }
}
I know that it is better to use parameters https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters%28v=vs.110%29.aspx

And the AddWithValue method… But this is just pseudo code and not in production. So don’t worry!

This is just a small sample to help people with a strange timeout which you can encounter if you use an sqlcommand outside the transaction.

 

Good luck!

Pin on pinterest Plus on Googleplus Post on LinkedIn
0 Comments

Hyper-V disables the fastboot option. One of the main advantages of the surface pro is having the fastboot option, which disappears after having hyper-v enabled. Hyper-V is enabled if you install the windows phone dev tools and if you want to run vhd files. Hanselman made a blogpost about adding an extra bootoption to switch between with and without hyper-v

 

But after installing the january firmware update, it gave me the blue screen with both boot entries, each time I boot.

This can be disabled in Windows. Press the windows key + pause/break and go to the ‘advanced system settings’. in tab ‘advanced’ click the button ‘settings’ next to “boot- and recoverysettings”

image

remove the checkbox to disable the list of operating systems and hit ok and that’s it. Enjoy the speed of the fastboot with the surface pro 3.

Pin on pinterest Plus on Googleplus Post on LinkedIn
0 Comments

I have developed several small apps for Windows Phone. Most of the time it is just to test how publishing an app works. I have developed an app for wp7, wp8.0, wp8.1 and universal apps and they are all free in the windows (phone) store. I try to earn back my developer fee of 19 euro by adding some small ads to it. I have used the adrotator version 1 and version 2 plugin and Microsoft's  own admediator.

You can download that visual studio extension of the visualstudio gallery website.

and you can read how to use admediator on msdn.

my three ad networks are:

  • mobfox
  • smaato
  • pubcenter

My conclusion: pubcenter has the best revenue and smaato serves the most ads. Please let me know if you disagree or have some advice. You can download my excel report here.

 

p.s. here is a 27 minute video of the admediator control on channel 9.

p.p.s. more info on the windows blog http://blogs.windows.com/buildingapps/2014/11/07/how-to-maximize-the-impact-of-windows-ad-mediation-for-windows-phone/

Pin on pinterest Plus on Googleplus Post on LinkedIn