Thursday, September 18, 2008

Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

›
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...
Monday, August 25, 2008

Interesting Bug/Feature In SQL Server 2008 RTM

›
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...
Sunday, August 17, 2008

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code

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

SQL Tip, Compiling Your SQL Without Running It to See If It Would Run

›
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...
Monday, August 11, 2008

Microsoft Visual Studio 2008 Service Pack 1 Available For Download

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

SQL Server 2008 is RTM

›
that is right and you can already download it from MSDN
Sunday, July 20, 2008

Microsoft Visual Studio Team System 2008 Database Edition GDR July CTP Released

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

sp_indexinfo an enhanced index information procedure

›
Tibor Karaszi has created a very useful index information stored procedure for SQL Server 2005 and up. This stored procedure will tell you t...
Wednesday, July 02, 2008

Awesome Collection Of ASP.NET Hacks, Tips and Tricks

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

Interview With SSIS Guru Jamie Thomson

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

I tried to keep it a secret but it is all over the internet: I am a SQL Server MVP

›
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...
1 comment:
Thursday, June 26, 2008

Working On SQL Admin Hacks, Tips and Tricks

›
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...
Tuesday, June 10, 2008

SQL Server 2008 Release Candidate 0 Available To The General Public For Download

›
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...
Friday, June 06, 2008

Puzzle: Friday the Thirteenths

›
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 ...
Sunday, June 01, 2008

Less Than Dot A New community Site Has Been Launched

›
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...
1 comment:
Tuesday, May 27, 2008

SQL Teaser uniqueidentifier

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

Interview With Erland Sommarskog About SQL Server and Transact SQL

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

Interview With Craig Freedman About Indexing, Query Plans And Performance

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

I have a question for you on DB development blunders!

›
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...
Monday, May 19, 2008

Spring Cleaning, Getting Rid Of Some Books

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