sql server Archives - Dirk Strauss

The Daily Six Pack: December 09, 2014

On 9 December, 2014 06:00:01, in The Daily Six Pack, by Dirk Strauss
Einstein Regarding Haters
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: Einstein Regarding Haters
Other
Even More
Extra
For more excellent content, have a look at these great sites

GeekLift

The Daily Six Pack: July 30, 2014

On 30 July, 2014 08:37:16, in The Daily Six Pack, by Dirk Strauss
Swift Introduction
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: Swift Introduction Part 2
Other
Even More
For more excellent content, have a look at these great sites

GeekLift

Tagged with:  

Execute Script Error Resolved In SQL Server Management Studio

On 27 February, 2014 01:00:45, in SQL, by Dirk Strauss

Execute Script Error – Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was ‘Insufficient memory to continue the execution of the program. (mscorlib)’. You might be wondering why I would even have such a large script to begin with. Well I had to import data from a file that I didn’t have access to any more, so I decided to script the table contents from the live database and import into my dev database for testing. Trying to run the query produced the error and I had to find an alternative way to get the data into my table.

Continue reading »

If there is one thing that I always had a pet peeve with, was the table designer column data type default in SQL Server Management Studio. You have no option (that I am aware of) to change the default column data type when creating a new data table in table designer. SQL Server Management Studio decides that using ‘nchar’ is the way to go. Well if you want to make your columns another data type, you need to manually select the default value and change it to the data type you want. I wanted to find a way to change that default. Turns out that there is an easy way to accomplish this.

Continue reading »

The Daily Six Pack: January 7, 2014

On 7 January, 2014 06:00:07, in The Daily Six Pack, by Dirk Strauss
Microsoft Fakes Framework
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

The past few weeks I haven’t been posting much on a regular basis. Now that 2014 is in full swing,  I’m ready for getting back to blogging. Below are some nice links for the new year. Interesting Tech predictions and some great Visual Studio tips. Also have a look at Jakub Chodounský’s great SQL Server Management Studio tip. Happy 2014 everyone!

Feature link: Microsoft Fakes Framework
Other
Even More
For more excellent content, have a look at these great sites

GeekLift

The Daily Six Pack: September 6, 2013

On 6 September, 2013 06:00:16, in The Daily Six Pack, by Dirk Strauss
LightSwitch Content Rollup Featured
A COLLECTION OF LINKS FOR LOVERS OF I.T.

Dirk Strauss

.

.

.

.

Feature link: LightSwitch Content Rollup
Other
For more excellent content, please visit

Existing Data And Visual Studio LightSwitch

On 16 August, 2013 07:00:16, in Programming, by Dirk Strauss

lightswitch existing dataExisting Data – LightSwitch has shown us this week how easy it is to create a fully data aware application in a very short amount of time and with minimal developer effort. But what about adding existing data?

I received a message from a reader in Johannesburg this week. His company used an Access database for one of their applications, but needed to migrate away from Access (probably because the data grew large enough to warrant the use of SQL). They had already created the SQL database and migrated the data, and now needed to quickly create a user interface.

His question to me was what technology he could use to create a GUI in the shortest amount of time, without having to learn how to program. Obviously I suggested LightSwitch.

Continue reading »

Tagged with:  
Tagged with: