SQL Server Code,Tips and Tricks, Performance Tuning

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...

I haven't posted for a while because I have been working on SQL Admin Hacks, Tips and Tricks lately. it is still a work in progress but...

SQL Server 2008 Release Candidate 0 has been made available to the general public. There are 2 versions (and 3 flavors of each) ISO or DVD D...

There is a puzzle on LessThanDot The goal is to identify all friday the thirteenths for a given timeframe. We'll use a relatively small ...

Myself and a bunch of friends have been working on Less Than Dot for a while now. The site has a forum , blogs and a wiki . More info why w...

Create this table CREATE TABLE #bla (SomeVal uniqueidentifier) INSERT #bla VALUES ( 'D903D52D-DBFA-4904-9D95-F265152A391F' ) what ...

I have interviewed Erland Sommarskog, you can find that interview here: Interview With Erland Sommarskog About SQL Server and Transact SQL E...

I interviewed Craig Freedman about Indexing, Query Plans And Performance and more. You can find that interview here: Interview With Craig Fr...

Last week Kalen Delaney wrote Did You Know? I have a question for you on DBA Blunders! I though the comments were very interesting, S we di...

I did some spring cleaning yesterday, I got rid of some old or obsolete books. I asked some people at work if they want any of these books a...

Mladen Prajdić just released SSMS Tools PACK 1.0 . SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Micr...

This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The ...

Without running this what do you think will be printed? SET ROWCOUNT 0 DECLARE @ int SET @ = 6 IF @@ROWCOUNT = 1 PRINT 'yes' E...

I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there wer...

In the Who do you want to see interviewed next? (sqlblog) and Who do you want to see interviewed next? (here) blog post I asked for some nam...

In the Who do you want to see interviewed next? (sqlblog) and Who do you want to see interviewed next? (here) blog post I asked for some nam...