Browse by Tags
All Tags »
SQLServer (
RSS)
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...
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...
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...
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...
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...
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 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...
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...
Filed under: .NET, Community, Events, Microsoft, MSDN, MVP, SQLServer, VisualStudio, Windows, Techdays, TechdaysPT08
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...
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...
Filed under: .NET, WinForms, ASP.NET, SoftDev, C#, Microsoft, MSDN, SQLServer, XML, VisualStudio, WCF, WPF, WF, WindowsClient, LINQ
red-gate just released version 3 of SQL Prompt .