SQL Server Code,Tips and Tricks, Performance Tuning

Can't wait for C# 3.0 and LINQ? Well you don't have to! Dynamically query SQL databases today in LINQ: no more struggling with antiq...

Hahaha, is this a babelfish translation? FROM: BILLY BANGURAABUJA,NIGERIA E-MAIL: billy_bangura2005@yahoo.co.uk DEAR ONE PERMIT ME TO INFOR...

Hi and welcome to another fascinating SQL summer teaser. Summer it is except inPrinceton where it was 50 degrees this week. There was no tea...

Channel 9 has posted a SQL Server 2005 Integration Services screen cast. From the site: This geekSpeak is all about SQL Server 2005 Integrat...

I have too many CDs and decided to throw out some 'old' software. I either have newer versions or no need for it anymore.

Microsoft Corp. today announced key milestones achieved within the business intelligence (BI) marketplace, including IDC’s recognizing Micro...

Don't forget, today is the day of the SQL Server 2008 Live Meeting Event. Here is what I got in my inbox: We wanted to remind you that o...

Run this first CREATE TABLE #j (n varchar (15)) DECLARE @a int SET @a = 1 WHILE @a BEGIN INSERT #j SELECT NULLIF ( REPLICATE ( '1...

LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relat...

SQL Server 2008 July CTP Web Chat July CTP Public Web Chat 08/13/07 Add to my Calendar SQL Server 2008 July CTP Live Meeting Schedule Enterp...

Stole this tease from my friend Mark . The teaser for this week is not really a teaser, this time you will have to write some code instead o...

Conchango are making available version 1 of our SQL Server Monitor Gadget for Windows Vista Sidebar The gadget does exactly what it says on ...

Who said you can’t gamble at work and what is Scrum anyway? Scrum is an agile process for developing software. With Scrum, projects progress...

A couple of days ago I was flipping channels (like any man ought to do without interference from the wife/girlfriend). I noticed The Hills H...

Here is an update of what I accomplished in the first 20 days Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration S...

Here is a fun teaser. NULLIF will return a null value if the two specified expressions are equivalent. So to give an example DECLARE @v var...

It looks like SQL Server 2008 has nanosecond + microseconds precision for the time datatype If you run the following [edit]I just looked at ...

From the last section (5.0 Deprecated Features) in the read me file 5.0 Deprecated Features This section covers SQL Server 2005 features tha...

Download it here: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395 What is new? Enterprise Reporting Engine Impro...

Yes it looks like it is a done deal: News Corp. Appears to Have Enough Votes to Clinch Deal Bancroft family members owning 32% of Dow Jones...