Paulo Morgado

.NET Development & Architecture

This Blog

Syndication

Search

Sponsored By

Tags

News

Unit Test Today! Get Typemock Isolator!

Books

 

Events

Visitors

Visitor Locations

Community

Email Notifications

Archives

Profile

Browse by Tags

All Tags » SQLServer (RSS)
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...

Posted Sat, Jun 13 2009 9:39 by Paulo Morgado | 2 comment(s)

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...

Posted Fri, Jun 12 2009 1:11 by Paulo Morgado | with no comments

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...

Posted Fri, Jun 12 2009 0:52 by Paulo Morgado | with no comments

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...

Posted Fri, Jun 12 2009 0:41 by Paulo Morgado | with no comments

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...

Posted Mon, May 4 2009 0:34 by Paulo Morgado | 6 comment(s)

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.

Posted Wed, Aug 6 2008 23:44 by Paulo Morgado | with no comments

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...

Posted Mon, May 5 2008 0:33 by Paulo Morgado | 2 comment(s)

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...

Posted Wed, Feb 6 2008 21:45 by Paulo Morgado | with no comments

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...

Posted Sun, Jan 27 2008 23:11 by Paulo Morgado | 2 comment(s)

Filed under: , , ,

Visual Studio 2008 and .NET Framework 3.5 shipped!
Visual Studio 2008 and .NET Framework 3.5 has finally shipped. MSDN subscribers can download the final version of Visual Studio 2008 from MSDN Subscription Downloads , but anyone can get a trial version or an Express Edition . The .NET Framework 3.5 contains...

Posted Wed, Nov 21 2007 0:21 by Paulo Morgado | with no comments

SQL Prompt 3 is out!
red-gate just released version 3 of SQL Prompt .

Posted Mon, Jan 22 2007 22:24 by Paulo Morgado | with no comments

Filed under: ,