Jump to content

  • Log In with Google      Sign In   
  • Create Account


Memories are Better

Member Since 03 Feb 2012
Offline Last Active Jul 05 2014 11:28 AM

Topics I've Started

SQL Server Table naming conventions

26 May 2014 - 01:35 PM

When you create a new table in SQL Server the default name is dbo.Table_# with # being the new table value. I rename my tables without the dbo. and it is almost always plural.  Looking at TFS collections I noticed all the tables were named with one of the following prefixes Codesense.tbl_ / dbo. / dbo.tbl_ where they were mostly singular names regardless of the prefix.

 

There is a fair amount of noise online on whether tables should be plural / singular online but nothing really mentioned prefixes such as dbo. or dbo.tbl_.

 

My question isn't really about naming tables with plural / singular names but more about the dbo. dbo.tbl_ prefix. Is this the SQL version of Hungarian notation where I can freely avoid or is there some kind of rule where it is best to follow this practice and name tables with dbo. / dbo.tbl_ prefixes?

 

Edit: This applies to other areas of the DB too, almost everything is created with dbo. but I figured I would figured I would talk about the table prefixes only


Solved - SharpDX - XAudio error in windows 8

06 April 2014 - 08:05 PM

This error doesn't happen in Win 7 and seems to only occur in Win 8 when debug flags are used. I have updated SharpDX libraries too and rebuilt but still have the issue.

 

A first chance exception of type 'SharpDX.SharpDXException' occurred in SharpDX.dll

An exception of type 'SharpDX.SharpDXException' occurred in SharpDX.dll but was not handled in user code

Additional information: HRESULT: [0x80040154], Module: [Unknown], ApiCode: [Unknown/Unknown], Message: Class not registered

 

This occurs when creating the XAudio device using the following code

xAudioDevice = new XAudio2(xAudioDebugFlags, ProcessorSpecifier.DefaultProcessor);

Using the default constructor doesn't give any errors however I want debug flags on so I use this. I have messed around a bit with flags / processor specifier and the error occurs when "XAudio2Flags.DebugEngine" is used. This is a normal desktop app and I have no other issues with running and for what it's worth no COM issues of my own, assuming this is a COM issue.


.NET Native

04 April 2014 - 06:17 AM

I am amazed this hasn't been posted or mentioned, I did a search but found nothing which is odd as DX12 was announced.

 

Links: http://blogs.msdn.com/b/dotnet/archive/2014/04/02/announcing-net-native-preview.aspx and http://msdn.microsoft.com/en-US/vstudio/dn642499.aspx

 

I haven't tried it out and I know it is Win Store atm but the blog / FAQ sounds promising for all things .NET. One of the things that really caught my eye was:

 

Will this allow C# developers better experience with developing highly graphical apps and/or games?

Yes. The .NET Native compiler shares parts of the code base with the Microsoft C++ optimizer.

 

However I am not entirely sure what it means by 'better experience', I would assume performance but it somewhat implies that people have been having performance issues with developing gfx apps in C# which I always was under the impression was rare simply due to how much content and work would be required to reach that, as in AAA quality products. I haven't even bothered attempting to make a store app but for those of you who have was performance issues noticeable in store games made in C#? Let me put it another way, I have been on the same project since early 2012, the project is for desktop and is growing with a lot of content yet performance issues have not occurred once, where C++ would have made a noticeable difference, despite pushing the limits gracefully and 95% being C#. Perhaps I am looking too much into this but it reads like there has been performance concerns with C# and store apps. I suppose it doesn't matter either way as even if it was it will soon become a problem of the past.

 

Another thing that made me do a happy dance and is worth a mention here is:

 

However, apps will get deployed on end-user devices as fully self-contained natively compiled code (when .NET Native enters production), and will not have a dependency on the .NET Framework on the target device/machine

 

At the risk of starting a language war, which let's be honest MS somewhat attracts in the first paragraph "This preview release of .NET Native offers you the performance of C++ with the productivity of C#.  .NET Native enables the best of both worlds!", how does this change things? Although mono and things like xamarin exist, does .NET native and MS new direction mean .NET languages in the near future will be cross platform (naturally without mono) that perform just as good at C++?

 

There are a lot of quotes I removed because it was practically a copy paste, due to excitement, but this is something I feel worthy of staying here.

 

Because .NET Native uses the C++ optimizer to generate binaries it eliminates the need for an obfuscator in most cases.

 

Again I know this is for window store atm but I think it is safe to assume in the future this will be for all things .NET

 

In case no one has the initial blog posting: http://blogs.msdn.com/b/dotnet/archive/2014/04/03/the-next-generation-of-net.aspx Have a look at RyuJIT as well as other features


Adding new RAM, is a format required?

07 February 2014 - 12:11 PM

I am replacing my motherboard. My current mobo has 2 RAM slots and I only ended up buying 8gb of RAM. I ordered exact RAM (same make, model, speed, size etc) again as new mobo has 4 slots.

 

I could setup new mobo with 8gb now, format and reinstall everything. However will my comp moan when I add more RAM in a few days when it arrives? Resulting in a format now (after mobo change) and a format then after RAM increase

 

Anyway my question is when installing new RAM will the comp whine and be all weird about things being different, or will it just accept the new RAM and deal with it?

 

New mobo is Asus Z87-Plus, nothing fancy as I am not a gamer, I don't really need anything extreme for what I am doing. The RAM I have now and the one ordered is Corsair 2x4GB so in total 4x4GB, again nothing fancy or extreme.

 

Edit: I don't mind waiting but im impatient and Amazon have been rather sloppy in dispatching the RAM (still in 'Dispatching Now' stage) figured I would get the mobo out of the way, but if another format is required when I do I may as well wait.


[Win 8 Store] Permanently removing apps from store account

31 January 2014 - 09:42 PM

When you download an app in windows store, then delete it, it uninstalls fine but on my store account it shows but as 'Not Installed' yet still appears on my account. How do I permanently delete it from my account? Just to clarify I am not talking about deleting apps from my comp but from my windows store account that holds the data of what I downloaded, which isn't stored locally.

 

I tend to be a super clean freak when it comes to my comp, if I am never going to use an app, listen to a song, watch a movie etc it will get deleted regardless of memory. Obviously this issue isn't causing any major problems but it would be nice if I could delete it from my account data for good too. I did a search and could only find info on how to remove the app from the comp which is trivial anyway, I just want it removed from account but it seems (or at least it feels like it) I can only access this info via windows store and get no option to do so.

 

 

Oh and for the sake of things and just to have a nice comment online considering all the hate that is going around. I have to say I love Windows 8, the UI is perfect, the quick boot or wtf its called is hilariously fast and I would rate win 8.1 as my fav OS for many reasons including the ones given. I used windows server 2012 before but didn't care much for any new non-server features but win 8.1 on my dev machine is <3, I am actually starting to like and find apps useful on my desktop.


PARTNERS