Using computed columns in SQL Server 2008

I’m going to have a quick look at computed columns in SQL server 2008 today and give a quick overview of how to create them and how they work.

Read more No Comments »

Attach SQL Server database that has no log LDF file

When trying to attach an .mdf file with not .ldf file you may get the following error.

Read more No Comments »

Example of creating a thread in C++ in linux using pthread

Below is an example of how to set up a thread using pthread_create in Linux to point to a class member.

Read more No Comments »

C++ on linux – undefined reference to `pthread_create’

Been playing around with C++ on Ubuntu the last few days. When I tried to compile a small project I’ve been working on I got this error.

Read more No Comments »

Shortcut to open and close region areas of a source file in Visual Studio

Found out a useful little shortcut today from a colleague at work to open and close regions with a couple of keystrokes rather than having to use the mouse.

Read more No Comments »

The type or namespace ‘DbContext’ could not be found (are you missing a using directive or an assembly reference?)

You might get this error when attempting to use the EntityObject generator template in Entity Framework in Visual Studio.

Read more 1 Comment »

SqlConnection Connection Timeout is being ignored

Today I had to run heavy duty query over a database when setting up dry runs for a migration of data. As such I needed to increase the time the application waiting before timing out.

Read more No Comments »

@@FETCH_STATUS() function in SQL Server

Shows the different values that can be returned by the @@FETCH_STATUS() function in SQL Server.

Read more No Comments »

System.Reflection.TargetInvocationException when adding Entity Framework to a project

You get the following error when you add an EF 4.x DbContext Generator item to your project.

Read more No Comments »

© 2017 Garry Passarella. All Rights Reserved. Facebook Twitter Twitter