December 2007 - Posts

• 2008: Initializing Table Data with Row Constructors

  Well, I am just discovering this feature, mostly because I never saw it demoed at any of the sessions I have attended so far on 2008. Not that it was kept particularly hidden, I have seen the title before, but I hadn't tried it out, or seen the depth Read More... Posted Wednesday, December 05, 2007 8:50 PM by drsql | 10 Comments

• Changing the owner of a database

  Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about Read More... Posted Wednesday, December 05, 2007 12:06 AM by drsql | 3 Comments Filed under: SQL Server, T-SQL