Paulo Morgado

Playing With SQL Server CLR Integration – Part IV (Deploying To SQL Server 2005)

With all developed and tested on my laptop using SQL Server 2008, it’s time to deploy to the company’s test machine running SQL Server 2005. The first thing I ran into when executing: CREATE ASSEMBLY [MyAssembly] AUTHORIZATION [dbo] FROM '...\MyAssembly...

Playing With SQL Server CLR Integration – Part III

You might have noticed that I used LINQ in my last Playing With SQL Server CLR Integration posts ( Part I , Part II ). I couldn’t make it work with the standard Visual Studio 2008 SQL CLR project template. Changing the Target Framework to .NET Framework...

Playing With SQL Server CLR Integration – Part II

On my last post , I showed how to convert a property bag stored in text to a CLR Table-Valued Function . I started thinking that I could retrieve the property values, but I couldn’t change them or add new properties. Passing a table as a parameter is...

Playing With SQL Server CLR Integration – Part I

I’m currently working with an application that stores a property bag in a SQL Server column like this: [[[name1]]] value1 [[[name2]]] value2.1 value2.2 [[[name3]]] value3 Don’t ask me why it’s done like this. It just is. The application decodes this property...

Tip: Connecting To A Database Using Windows Authentication With Different Credentials Using SQL Server Management Studio

It is a good security practice to use Windows Authentication to connect to SQL Server because you don’t need to write the password on some configuration file or registry entry. This practice also brings governance benefits. Managing users becomes part...

Microsoft Releases SQL Server 2008

SQL Server 2008 is finally out and comes with the Entity Framework , which means that SP1 for Visual Studio 2008 and the .NET Framework is almost out.

The Architecture Tool Space Keeps Growing

The tool space for software architecture has been growing. There are new tools and continuous improvement in the existing ones. Framework Design Studio Last month Krzysztof Cwalina from Microsoft released the Framework Design Studio at MSDN Code Gallery...

Techdays Portugal 2008 - For A World 2.0

Microsoft Portugal will be hosting Techdays 2008 from Mars 12 nd to 14 th , right after the Portuguese launch of Microsoft Visual Studio 2008 , Microsoft SQL Server 2008 and Microsoft Windows Server 2008 on Mars 11 th . This is the biggest and greatest...

Custom Generators For SQL Data Generator 1.0 Beta

SQL Data Generator will be a great tool when redgate releases it. David Connell has a detailed post on how to build your own generator where he explains the concepts and ideas behind developing generators for SQL Data Generator 1.0 Beta . Andrew Clarke...