SQL Server Code,Tips and Tricks, Performance Tuning

I have created 6 new SQL Server Denali CTP3 posts These posts are about the new things introduced in SQL Server Denali CTP3, below is a list...

Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named...

Rod Colledge was kind to give the readers of Less Than Dot a chance to win a pdf copy of his book SQL Server 2008 Administration in Action ...

A buddy of mine Ted Krueger writes some really interesting SQL Server posts. Most of these posts focus more on administration than on develo...

The reason I am writing this post is that we now have RSS feeds on lessthandot for a specific author. In my case the RSS feed is the follow...

I have posted on this blog for a little over 3 years now and decided it is time to call it quits at this URL. All SQL Server related post fr...

SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 are available for download Download SQL Server 2005 Servic...

This was not the way I envisioned going back to Amsterdam. My mom past away today, two weeks shy of her 60th birthday Since my passport was ...

You might know that some friends and myself have launched a site named  LessThanDot , this is a site where users can collaborate via the  wi...

I interviewed Louis Davidson in 2005 about the 2005 edition of his book. I did another one today about Pro SQL Server 2008 Relational Databa...

Someone had a problem with 8 year old procs which started to fail after moving to SQL Server 2008 Of course he should have used ints, but le...

Take a look at this query. SELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT ( * ) , SUM ( … ) , AVG ( … ) FROM payment_t...

Let's say you have a big SQL script with a ton of code and you want to make sure it runs but you don't want to execute it because it...

Get it here: http://www.microsoft.com/downloads/thankyou.aspx?familyId=fbee1648-7106-44a7-9649-6d9f6d58056e&displayLang=en Here is the l...

that is right and you can already download it from MSDN

Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP is available for download In addition to providing support for SQL S...

Tibor Karaszi has created a very useful index information stored procedure for SQL Server 2005 and up. This stored procedure will tell you t...

We added a bunch of ASP.NET Hacks, Tips and Tricks we have the following categories 1 Applications 2 Caching 3 Controls 4 Database 5 Dates 6...

As promised yesterday, here is the link to the interview I did with jamie Thomson: Interview With SSIS Guru Jamie Thomson

So all over the internet is exaggerated,I became a SQL Server MVP today and was not going to do a blog post about it. However some other peo...