Rick Strahl's Web Log

WebLog Posts in Category Sql Server

Sql 2008 Management Tools: Can't save changes that require Recreation of Database
August 16, 2008 @ 6:31 pm

Ah here's a silly new default in SQL Server's Management Tools: When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the changes. Instead you'll be greeted by this friendly dialog: Notice that there's no option to save the changes - it's a hard rule that is applied and you...

74 comments

An easier Table Design View in Sql Server Management Studio
January 25, 2008 @ 12:33 am

One of the things that bugs me no end in Sql Server Management Studio is that the table designer's UI is a pain to use. Entering column properties is an excercise in mousercise. It turns out there's an easier way to do this with custom views in the DataBase Diagram Designer.

16 comments

First Impressions on LINQ to SQL
September 11, 2007 @ 12:45 pm

I've been experimenting with LINQ to SQL for the last few weeks and there's a lot to like as well as a few things to think about. In this editorial I'll describe some of the things that worked well and some of the issues I struggled with and how I worked around them.

14 comments

The SQL Data Tools in Orcas
August 27, 2007 @ 4:40 pm

The SQL data tools in Orcas are the first time I've actually looked at the database extensions for Visual Studio. When DataDude was released sometime last year it went straight into the Visual Studio DataBase Edition, but it wasn't part of Team Suite so I never actually had a chance to look at it...

12 comments

Generate Scripts in Sql Management Studio
March 08, 2007 @ 8:30 pm

Sql 2005 Management studio's Generate Scripts iritates the hell out of me with its Wizard based approach and no way to step through the choices after generation again.

9 comments

SQL Server 2005 Windows Security has gone out to lunch...
January 15, 2007 @ 3:37 pm

While experimenting with UAC on Vista, somehow, somewhere my SQL Server Windows Authentication has somehow disconnected itself from my SQL Server installation. SQL Server no longer sees the Administrators group AT ALL and so several database connections that have been working off integrated security now suddenly fail.

2 comments

Sql Server Bonk today
November 22, 2006 @ 5:09 pm

This morning my site went down due to SQL Server bonking out. Sql went down completely and wouldn’t restart until I rebooted.

2 comments