This was an interesting post on the Programmability teams blog. I have come across a number of people asking for this feature as it works with Oracle. This blog describes one of the server options enabled with SQL Server to achieve the task. Read the blog here .
Once this does happen, this will be exciting. Trust me !!! I have been using the Table Analysis from the Excel Add-in and whenever I have showcased them, people have just loved it. Catch this space for specifics.
Craig has a couple of post on SQL Server 2008 Partitioned tables and Partitioned Indexes . Most interesting is the way Criag uses the ShowXMLPlan to explain the concepts. I sort of like this approach and is easy when writing articles. Earlier I used to have difficulty using the Execution Plan snapshot...
Here is a neat post around using Sort Warnings and how to use SQL Server Profiler to view the same. Read the post from Blogs.MSDN :).
Check out this cool article from the SQLOS team on the technet blogs. Read it here .
Download the June 2008 Feature Pack RC0 for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. Most important is the backward components for SQL 2005 and the data mining add-ins for Office 2007.
A neat article on DW concepts with SQL Server 2008 enhancements. Catch the same here .
Are you geek enough to win the entire office’s respect? Prove it. Play Server Quest, where you’ll navigate through the perils of office life, protect the server, and keep clear of the arrogant sales guy. Look for it online at www.server-quest.com . Play Server Quest…and give a geek a chance ...
I just uploaded a couple of articles on my website after a long time. Catch the same from the below links and feel free to drop your comments. Security in SQL Server 2005 - Part I DMVs - sp_who2 Script
Some good explanation on Memory Management , though not exhaustive atleast gives you a head-start to where to find data.