Tags
Articles in Database,SQL
A future world without the SQL Server Image/Text/NText data types. Now's the time to start planning for that future...
Jose Barreto's Blog - SQL Server 2008 and Unstructured Data "SQL Server 2008 introduces two new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. ...
From : Gregs Cool [Insert Clever Name] of the Day
2008 Mar 23
Readability
Readability Stats: Word Count: 312; Sentence Count: 37; Grade Level: 3.4
Introducing SQL Server Data Services ( SSDS ) by Nigel Ellis - Mix08 Video Download of Presentation
The speakers for the Microsoft Sync Framework, ADO.NET Data Services, and SQL Server Data Services mentioned the one-two punch you get from leveraging these services together. SQL Server Data Services is a web...
From : David Hayden - Florida .NET Developer - C# and SQL Server
2008 Mar 12
Readability
Readability Stats: Word Count: 52; Sentence Count: 5; Grade Level: 7.5
Let Live Search know when you update your website
UPDATE: Google also has a ping service that works in the exact same way. You can find it at http://www.google.com/ping?sitemap=[your sitemap URL] Microsoft’s Live Search along with Yahoo and Ask d...
From : .NET slave
2008 Mar 12
Readability
Readability Stats: Word Count: 264; Sentence Count: 27; Grade Level: 5.1
Decompiling Silverlight 2 Apps – Enter the XAP
When you build a Silverlight 2 application, you compile your source files (inc. XAML and embedded resources) into assemblies (dlls). Those assemblies (plus any 3rd party ones plus MS assemblies that are not pa...
From : The Moth
2008 Mar 09
Readability
Readability Stats: Word Count: 317; Sentence Count: 33; Grade Level: 4.2
Building Great AJAX Applications from Scratch Using ASP.NET 3.5 and Visual Studio 2008 - MIX 08 Presentation
Building Great AJAX Applications from Scratch Using ASP.NET 3.5 and Visual Studio 2008 - MIX 08 Presentation by David Hayden, Florida ASP.NET Web Developer Brad Abrams hit a homerun with his MIX 08 P...
From : David Hayden - Florida .NET Developer - C# and SQL Server
2008 Mar 07
Readability
Readability Stats: Word Count: 398; Sentence Count: 34; Grade Level: 4.4
SQL Server 2008 FILESTREAM - Writing a file to a FILESTREAM column
Zach Skyles Owens - SQL Server 2008 FILESTREAM and WPF MediaElement - Part 2 (Writing FILESTREAM Data)Wow... It's been a long time coming. I promised that I would explain in more detail how to write FILESTRE...
From : Gregs Cool [Insert Clever Name] of the Day
2008 Mar 04
Readability
Readability Stats: Word Count: 468; Sentence Count: 60; Grade Level: 4.1
T-SQL Update or Insert Logic -
Jeremiah Clark's Blog - SQL: If Exists Update Else Insert "This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to...
From : Gregs Cool [Insert Clever Name] of the Day
2008 Feb 20
Readability
Readability Stats: Word Count: 214; Sentence Count: 33; Grade Level: 1.8
Building an N-Layer ASP.NET Application with LINQ, Lambdas and Stored Procedures
.NET 3.5 has a lot of great new features that can significantly enhance developer productivity. I've been spending some time lately working on a little sample application that demonstrates how an N-Layer...
From : Dan Wahlins WebLog
2008 Feb 19
Readability
Readability Stats: Word Count: 671; Sentence Count: 50; Grade Level: 8.7
High Performance LINQ To SQL - Compiled Queries - O/R Mappers - Ecommerce Websites
High Performance LINQ To SQL - Compiled Queries - O/R Mappers - Ecommerce Websites by David Hayden, Florida ASP.NET Developer, Filed: LINQ To SQL It should be of no surprise that an O/R Mapper will a...
From : David Hayden - Florida .NET Developer - C# and SQL Server
2008 Feb 19
Readability
Readability Stats: Word Count: 770; Sentence Count: 43; Grade Level: 10.2
Debugging Custom Actions: Leaked Handles
Debugging custom actions isn't exactly the easiest action to do; Windows Installer spawns separate processes - remoting servers - to run in-process custom actions. Any opportunity to diagnose issues without de...
From : Heath Stewarts Blog
2008 Feb 12
Readability
Readability Stats: Word Count: 267; Sentence Count: 10; Grade Level: 6.9
Being IN in LINQ to SQL - Or How I learned to Love Contains (aka Getting Linq to SQL to generate a T-SQL WHERE clause that includes an IN)
So today was my first time really playing with Linq to SQL (or any flavor of Linq for that matter). I'm prototyping a new feature and wanted to see how Linq could help... The biggest road block? Trying to fig...
From : Gregs Cool [Insert Clever Name] of the Day
2008 Jan 30
Readability
Readability Stats: Word Count: 860; Sentence Count: 165; Grade Level: K
Maintaining Unique Indexes with IGNORE_DUP_KEY
A few months ago, I wrote a post describing how SQL Server maintains unique indexes while avoiding false uniqueness violations. In this post, I'm going to look at how SQL Server maintains unique indexes ...
From : Craig Freedmans WebLog : Aggregation
2008 Jan 30
Readability
Readability Stats: Word Count: 1528; Sentence Count: 80; Grade Level: 5.3
ASP.NET MVC Example Application over Northwind with the Entity Framework
Over last month over the holidays, Lance Olson and I spent some time porting ScottGu's excellent MVC example over the Entity Framework. I thought I'd share the results here and get your thoughts\feedback...
From : Brad Abrams
2008 Jan 29
Readability
Readability Stats: Word Count: 2954; Sentence Count: 267; Grade Level: 5.6
LINQ to SQL vs. LINQ to Entities Smackdown!
OK, maybe not a smackdown... but it sure sounded like a good title. There's a great paper on MSDN that describes the similarities and differences in LINQ to SQL and LINQ to Entities from the Entity Framework....
From : Kirk Allen Evans Blog
2008 Jan 29
Readability
Readability Stats: Word Count: 175; Sentence Count: 11; Grade Level: 6.9
Importing a textfile to a typed dataset (failing and resolving)
I guess as developers we're used to solving the difficult problems, this task isn't working because of dependancy X, Y and Z - so we code around that, handshake with this and validate the other. But as a deve...
From : VB & .NET Blogs @ vbCity.com
2008 Jan 28
Readability
Readability Stats: Word Count: 264; Sentence Count: 15; Grade Level: 9.1
