Easily Generate Table Change Scripts In SQL Server Management Studio

Something I found frustrating when designing databases, were the frequent changes made to tables. Managing the scripts can become quite tricky, especially if you are still in the design phase. This is made worse by code changes or change requests to existing data structures. Sometimes a person gets so caught up in the changes you need to make, that you forget about scripting these table changes.

Looking for something else? Try these links instead:

Here is a nice trick in SQL Server Management Studio to easily generate table change scripts. Never forget to script your changes again. (more…)

Continue ReadingEasily Generate Table Change Scripts In SQL Server Management Studio

The Daily Six Pack: January 27, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T.Dirk Strauss....Feature link: Apple Celebrates Thirty YearsApple put up celebratory posters with names of every Apple employee, past and present, Yoni HeislerOtherCompiling C# Code at Runtime, Lumír Lů KojeckýThe one thing you should know to get more productive in Visual Studio- Keyboard Mapping,…

Continue ReadingThe Daily Six Pack: January 27, 2014

Script Table Data In SQL Server Management Studio

How Do I Script Table Data In SQL Server

Script Table Data – I have used other tools to do this for ages. I can’t believe that I never knew that it existed in SQL Server Management Studio. Well ok, in my defence it isn’t quite the most ‘In-your-face’ setting. Nevertheless, it is very convenient and best of all, you don’t need to leave the IDE to script table data. So where is this function? Why, under Tasks of course. (more…)

Continue ReadingScript Table Data In SQL Server Management Studio

SQL Server Management Studio – Changing Default Data Type In Table Designer

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.

Looking for something else? Try these links instead:

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. (more…)

Continue ReadingSQL Server Management Studio – Changing Default Data Type In Table Designer

The Daily Six Pack: January 23, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Visual Studio 2013 Update Visual Studio 2013 Update 1, S. Somasegar Other What are Bitcoins? Stackdump, an offline browser for StackExchange sites Visual Studio Tips and Tricks: Enhanced Scroll Bar, Susan Ibach Implementation of TransactionScope…

Continue ReadingThe Daily Six Pack: January 23, 2014

South Africa 1981 and Technology

What was life like in South Africa 1981? Man, I can still remember that year. Yeah, shocking… I know. I was a young kid in South Africa 1981, but I was into all sorts of gadgets. I loved to take stuff apart and figure out how they worked. I remember taking apart my mom’s broken washing machine. That thing amazed me no end. Thinking back to 1981, I can’t really imagine the world back then as compared to today, 33 years later.

South Africa was in the throes of Apartheid, and I remember that quite vividly because the signs of it were all around. Signs like “Slegs Blankes” (Whites Only) littered parks, camping sights, cinemas, restaurants, restrooms and every other bit of everyday life as I knew it. My dad who was a doctor worked at a practice that has two entrances. One for whites and one for non-whites. My dad later later moved away from that practice and opened his own practice for non-whites only. (more…)

Continue ReadingSouth Africa 1981 and Technology

The Daily Six Pack: January 22, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Enable Disable Visual Studio Code Lens Visual Studio 2013 Tips & Tricks – Enable / Disable Code Lens, Senthil Kumar Other Enable, Disable Data Execution Prevention (DEP) in Windows 7| 8, Anand Khanse Visual Studio…

Continue ReadingThe Daily Six Pack: January 22, 2014