Yearly Archive: 2007

November CTP : more impressions of SSMS changes

November CTP : more impressions of SSMS changes

A little over a month ago, I posted some thoughts on a few of the new features in SSMS that I found (not) useful (see /blogs/aaron_bertrand/archive/2007/11/18/november-ctp-initial-impressions-of-ssms-changes.aspx). In addition to learning that the server prefix...

Connect needs an "Ignored" status

Connect needs an "Ignored" status

The SQL team seems to have been quite busy recently, commenting on and closing out many bugs and suggestions that have been raised, I suppose as they close out work on the SQL Server...

Registered Servers become more useful

Registered Servers become more useful

In playing with the latest CTP for SQL Server 2008, I stumbled across some new context menu items for a server group node in Registered Servers.  You can now right-click a group node and...

A theory on how "TOP" is determined in "TOP SQL Server Downloads"

A theory on how "TOP" is determined in "TOP SQL Server Downloads"

It's pretty simple, really.  I think they prioritize the downloads they are proud of, instead of the ones that are most popular or that are most needed.  When I went looking for SP2 for...

Casey Kasem is in the machine

Casey Kasem is in the machine

Here's a neat database implementation.  Have a song in your head, but don't remember the name?  Got a microphone hooked up to that workstation of yours?  Then head on over to midomi.com, where they...

November CTP (CTP5) is now publicly available!

November CTP (CTP5) is now publicly available!

What are you waiting for?  Go get it! http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884 Why are you still reading this? 

November CTP : Initial impressions of SSMS changes

November CTP : Initial impressions of SSMS changes

[Updates below in BOLD.]On loading SSMS for the first time, I noticed a few things.  First of all, the row(s) affected message is now prefixed with information on the instance and login relevant to...

Resistance is futile!  The CLR is everywhere.

Resistance is futile! The CLR is everywhere.

This week I picked up my new car and was a bit amused to see this on their version of iDrive: What's funnier is, like Java threatened to take over the appliance world 10...

MSDN, ISOs, and SQL Server Hotfixes

MSDN, ISOs, and SQL Server Hotfixes

Ok, this may be a bit off-topic, but I'm getting really annoyed that so many products are being offered only as ISO images.  Why is it that I can set up a virtual machine...

Quick Update : New Cumulative Update has been released

Quick Update : New Cumulative Update has been released

Microsoft has released a new cumulative update (build 3200) for SQL Server 2005. http://support.microsoft.com/default.aspx/kb/941450 Adam has pointed out that the wording in the article is incorrect; it calls these post-SP3 updates, which is obviously...

Elaborations on my SQL Server 2008 slides

Elaborations on my SQL Server 2008 slides

After attending a few sessions at PASS, based on much newer builds of SQL Server 2008, I have some additional information to complement what I have published in my slides (since I am not...

"What's New in Katmai?" – slide deck and demo files

"What's New in Katmai?" – slide deck and demo files

I have posted the slide deck and demo files for the SQL Server 2008 talk I presented to SQL Server user groups in Charlotte NC, Warwick RI and Waltham MA.  There are 11 .sql...

Speaking engagements on SQL Server 2008

Speaking engagements on SQL Server 2008

Last month I prepared a webinar on the new features in Katmai for the Charlotte SQL Server User Group.  Based on that I have agreed to present similar materials (in person!) for a couple...

New Cumulative Update is available

New Cumulative Update is available

A new CU (Build 3186) has been issued by Microsoft: http://support.microsoft.com/kb/939537/Though unlike previous updates, this one is not readily available for public consumption.  You must fill out a form to obtain the download… I...

Planning on using Notification Services?  Don't bother…

Planning on using Notification Services? Don't bother…

Tonight we saw the release of the July CTP (odd name for something released late July 31st, but that's another story) of Katmai.  With it comes the following blurb, deep in the fifth section...

Be careful with Open Table

Be careful with Open Table

Yes, you were already aware of 40 or 50 reasons not to use Open Table.  I have one more.  Say you are creating a table with a composite key that includes a binary column. ...

Some new and updated SQL Server 2005 builds

Some new and updated SQL Server 2005 builds

Updated: 2007-07-02 Continuing with a great tradition, I present again an updated list of SQL Server builds and hotfixes that have been released since the last time I posted a similar list (beginning of May). ...

Staying on top of SQL Server 2005 builds and hotfixes

Staying on top of SQL Server 2005 builds and hotfixes

For years I have been an advocate of making any and all hotfix information available to the public.  I used to stumble upon new builds in the KB by accident, and so I took it...

Playing with CDC in Katmai

Playing with CDC in Katmai

Change Data Capture (CDC) is something DBAs around me have been screaming about for ages.  For auditing and other reasons, we have needed to rely on 3rd party tools from companies like Lumigent, whose motto...

Playing with DMF in Katmai

Playing with DMF in Katmai

I've long been anticipating the Declarative Management Framework (DMF, not to be confused with dynamic management functions!) in Katmai.  We were given an early peek at the product in March, but it was essentially...

Katmai news

Katmai news

There is a public CTP coming out this morning.  It was supposed to be published on Connect at 8:30 AM ET, but maybe they meant a different time zone?  Anyway, an interesting "by the way"...