Posted by
Jason Massie 
on Friday, March 21, 2008 at 1:27 PM to
SQL Server 2008, SQL Shorts, SQL Server 2005, Windows Server 2008, tsql, Indexes, Offtopic, Virtualization, CTP6
356 Views |
1 Comments |
We regret to inform you of a passing in the SQL community. Read more here.
Rick Heiges has a post on my favorite new feature in SQL Server 2008, filtered indexes.
So does Decipherinfosys along with a good description on the difference of indexes and statistics if you need some background.
SQLBlogcasts has gotten an upgrade and Tony posts some great stats. Congrats!
Not SQL per say but the Hyper-V release candidate has been released. Speaking of Hyper-V, Sriram posts his slide decks on virtualizing SQL. Part 1 and Part 2.
This is a great starting point for SQL Server 2008 as is this. These come by way of the MSDN\Technet update blog.
The SQL Server 2005 sp3 debate continues.
The SQL ISV team posts a performance improving cursor rewrite sample. However, it is not ANSI compliant :) which is odd since most ISV tsql code needs to be portable.
Paul Nielson will be releasing a DVD.
While we are at it, check out the new SQL Server social network.
alt head: Got ADD?
read more
Posted by
Jason Massie on Friday, February 29, 2008 at 12:12 PM to
SQL Server 2008, SQL Shorts, Windows Server 2008, Heroes Happen Here, Boohoo, Data collection
378 Views |
0 Comments |
The big news of the week was the HH{H} launch. A lot of marketing fluff. Not just from MS but from vendors trying to ride the wave. That said, I think the rest of the year is going to be really exciting technology wise.
There are some good webcasts at the virtual event site through the slick but slightly buggy silver light interface. Check it out.
The MS SQL site got a facelift. I suspect it will replace the original site soon. Props to ThePremiers for breaking it.
Dan reports the return of the tsql debugger, object search and the new activity monitor. He demo'd these features and the other manageability features at the launch event.
SQL Server 2008 is setting records. Most impressively in loading 1TB+ in 30 minutes with SSIS. Read it on the SQLPerf site here and here, the SQLCAT site, Erin's blog, and Denis's blog.
Peter has the scoop about issues with SQL Server 2008 and leap year. Whoops :) Good thing they didn't launch today.
Linchi comments on the intel hexacore procs that should hit Q3-4.
Derek C drops knowledge on the SQL Server 2008 performance data collector.
This might be HAWTALTA to some but I consistently here people complaining about the speed of SQLWB. Jeff posts links to resources.
Bonnie posts the 2008 version of samples on codeplex. Direct dl here. Details here.
Check out this very detailed post on SNAC for the horse's mouth.
Andy has a no nonsense post on sparse columns.
I should have mentioned this last week. Simon did a great job in detailing full text in SQL Server 2008 in a series of posts. Start here.
Have a great weekend!
read more
Posted by
Jason Massie on Tuesday, February 05, 2008 at 10:02 PM to
Certifications, SQL Shorts, Windows Server 2008
188 Views |
0 Comments |
The big news of the week is Windows Server 2008 RTM'ing. Read more here.
The storage engine team has begin a series on bulk insert. It is definitely recommended reading. Part 1, Part 2, Part 3.
The SQL Server development customer advisory team has launched http://SQLCAT.com. They have some nice content.
There is some interesting commentary on obtaining certs on SQL here.
Simon S. releases a new version of the spatial viewer on codeplex. Get yer spatial on!
Edit:
This one just missed post but it looks cool so I will add it in,
Danny has just released a new SSMS plug in that can color code your connections. That way there are no more OMG moments.