Where to find the SQL Server 2005 Books Online?

You would think that http://www.microsoft.com/technet would have the SQL Server 2005 books, right?  GONG!!! Nope.  So where do you get the goods?  Well, this gets you into the age old debate about the audience for the product.  Is the audience IT Pro, DBA, Developer or all of the above?  That answer is pretty obvious.  DEVELOPER…


SQL Server 2005 Trip Wires

A number of changes and improvements have been made to SQL Server 2005.  Did I really need to state that?  One of the big improvements is in the management and security area.  The SQL Management Object (SMO) infrastructure replaces much of what used to be accomplished using SQL-DMO.  SMO is tightly integrated with Windows Management Instrumentation…

4

IT Heroes: Stories from the Trenches

Today the SST TechNet team launched the pilot of a new weekly blogcast interview program IT Heroes: Stories from the Trenches, the real stories of men and women in IT making a difference everyday. We talk with authors, innovators and implementers about emerging technologies, troubleshooting and remediation of common infrastructure issues and charitable contributions in…


A More Secure and Well Managed Infrastructure – links from the webcast

Today we kicked of an eighteen part webcast series titled, “A More Secure and Well Managed Infrastructure”.  As with any good name, most of us are referring to it internally as SWMI (pronounced Swimee).  During the course of part one, I did some desktop sharing to show you the various areas on the web to…

2

Is your SQL Server 2005 engine Pessimistic or Optimistic?

I just noticed another member of my team, Harold Wong, posted the demo script we used for testing pessimistic and optimistic concurrency controls in SQL Server 2005.  See http://blogs.technet.com/haroldwong/archive/2005/09/11/410594.aspx.  Warning, the scripts are really long since it’s a multipart demo.


Last Chance to Break It!!!

We just released the last version of SQL Server 2005 you get to break before we go into manufacturing of the real product.  Get the releases at http://www.microsoft.com/sql/2005/productinfo/ctp.mspx.  There are a couple of changes occurring with the product that you might want to be aware of. SQL Server 2005 Express Edition – the management tool…


Fun With Themes

I had lots of fun yesterday at my San Antonio SQL Server 2005 seminar.  During the demos, while doing backups and other processing intensive tasks, I gave up some performance to run a few funny videos.  You can see the videos at http://escapeyesterworld.com/.  They are a riot. Here’s a look at the desktop I used for…


Are you bad enough?

Everyone thinks they’re kewl.  You could be kewler riding around on one of these. The gang at Orange County Choppers is making Microsoft a custom chopper and it’s part of a contest from the SQL Server 2005 product group. What’s the catch?  Well, you need to migrate from Oracle to SQL Server and tell us your story. …

1

Got SQL 2005?

Normally I don’t repost stuff that is available from microsoft.com, but this is just too juicy to resist.  For months now it’s been fairly difficult to get your hands on the new version of SQL Server.  Usually Beta code is pretty easy to get.  Sure, you could download SQL Server 2005 Beta 2 Express Edition, but…