WiX 3 Tutorial: Solution/Project structure and Dev resources(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 3 months ago

First in a series of WiX tutorials that shows the recommended WiX project structure and its properties and lists some other WiX development resources. read more...

add a comment |category: C# |Views: 39

tags: WindowsInstaller wix C# another

Beyond Hello World: PostSharp with Gibraltar Software and SmartInspect(postsharp.org)

submitted by gfraiteur(988) 2 years, 6 months ago

Tracing has long been the "Hello, world" sample of Aspect-Oriented Programming .Yet, some advanced tools are available to .NET developers. Two of them deserve a special attention since their vendor provides aspects that can be directly used with PostSharp: Gibraltar and SmartInspect. read more...

add a comment |category: C# |Views: 162

tags: C# another

SQL Server - How to get the whole group of duplicate rows(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 7 months ago

A fast way how to get the whole duplicated group of rows in Sql Server 2005 and up. read more...

add a comment |category: Database |Views: 16

tags: SQLServer 2008 Database 2005 another

Introducing PostSharp 2.0: #4 - Visual Studio Add-In (postsharp.org)

submitted by gfraiteur(988) 2 years, 7 months ago

Gael Fraiteur shows the new PostSharp Add-In for Visual Studio allowing to answer two questions: (1) to which code elements is my aspect applied and (2) which aspects are applied to my code element. read more...

add a comment |category: C# |Views: 347

tags: C# another

Why I prefer surrogate keys instead of natural keys in database design(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 7 months ago

A practical field tested answer why are surrogate keys better than natural keys in database design. read more...

add a comment |category: Database |Views: 23

tags: SQLServer Design Database another

Introducing PostSharp 2.0: #1 - NotifyPropertyChanged (postsharp.org)

submitted by gfraiteur(988) 2 years, 8 months ago

Gael Fraiteur does first revelations about PostSharp 2.0 on a real-life example: implementing the INotifyPropertyChanged pattern with an aspect. Be safely seated! read more...

add a comment |category: C# |Views: 506

tags: C# another

Why would Visual Studio build always rebuild a solution? (weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

A simple problem with a weird solution. read more...

add a comment |category: Visual Studio |Views: 58

tags: VisualStudio another

The 24 hours of PASS - SQL Server live webcasts(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

This years biggest online SQL Server related event. It will last full 24 hours. Don't miss it! read more...

add a comment |category: Database |Views: 13

tags: SQLServer 2008 Database 2005 another

SQL Server 2005 – Fast Running Totals solution with ordered CTE update(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

The Running Totals problem is as old as accounting. This is the fastest Running Totals solution using ordered Common Table Expressions (CTE) direct update feature in SQL Server 2005 and up. read more...

add a comment |category: Database |Views: 43

tags: SQLServer 2008 Database 2005 another

How to check when was SQL Server installed with a T-SQL query(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 10 months ago

Sometimes you might want to check when was SQL Server installed witha query. this is how you do it. read more...

add a comment |category: Database |Views: 9

tags: SQLServer 2008 Database 2005 another

Adding one file to multiple projects in a .Net solution(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 11 months ago

There are times when you want to have one .cs or any other file in multiple projects. This is how you do it. read more...

add a comment |category: C# |Views: 14

tags: VisualStudio C# another

SQL Server 2008 Extended Events - high performance eventing system(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 11 months ago

Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events. read more...

1 comment |category: Database |Views: 19

tags: SQLServer 2008 Database Performance another

Free SQL Server 2008 Powerpoint dark template(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years ago

Just what the title says. read more...

add a comment |category: Database |Views: 36

tags: Presentation powerpoint Database another

Comparing SQL Server HASHBYTES function and .Net hashing(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years ago

Hashing comparison in .Net and SQL Server and things you have to be careful about. read more...

add a comment |category: Database |Views: 100

tags: SQLServer C# Database another

SQL Server - Find missing and unused indexes(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 1 month ago

How to find SQL Server indexes that should exists and those that shouldn't when performing index maintenance. read more...

add a comment |category: Database |Views: 43

tags: SQLServer 2008 Database 2005 another

SQL Server Reporting Services licensing(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 3 months ago

Links to good licensing documents from Microsoft. read more...

add a comment |category: Database |Views: 13

tags: Database another