Welcome to Sign in | Join | Help

noiembrie 2010 - Posts

A new error started showing up in SQL Server 2008 SP2 installations: The database cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. 661 sure is earlier than 662, so what seems Read More...
When SQL Server 2005 introduced BEGIN TRY and BEGIN CATCH syntax, it was a huge improvement over the previous error handling based on @@ERROR check after each statement. Finally, T-SQL joined the rank of programming languages, no more just a data access Read More...
Some intersting things happened in the SQL Server certification space while I was away. Joe Sack announced A New Path to Microsoft Certified Master: SQL Server 2008 . And at the same time released some content that we (SQLskills) recorded for the new Read More...
TechEd Europe 2010 ended yesterday. I thought I'd write about it when I got home, but now I'm unsure if that will happen in a timely manner. I'm waiting at the fourth different gate in Dulles for my flight home (last of three) to Portland. Read More...
Along with SQLPASS Summit 2010 announcements on SQL Server “Denali” features the MSDN site has published preliminary content on some of these features. Going over the “HADR” Overview (SQL Server) content we can get an early idea Read More...
Quick correction to my PowerShell Denali CTP1 post here . Max Trinidad did the obvious get-command call and found some new PowerShell cmdlets related to the new HADR feature. Knew I should have tried that. ;-) Read More...
OK, last one for the evening, its getting late in Berlin. And BTW, we might have some Denali goodness here at TechEd. Search for "futures", perhaps. There a new hint for spatial queries in Denali CTP1, namely, SPATIAL_WINDOW_MAX_CELLS. This Read More...
Only because I've been waiting for it since I first saw try-catch back in 2005 beta 2 or something. In dirt-simple code: begin try delete jobs end try begin catch throw end catch Nuff said. Error 547 is sooooo much more backward compatible than error Read More...
Once upon a time, there was to be a SQL Server-based file system for Windows. This file system would not only let you search on file properties like filename and file length, but also on what's known as "Extended Properties". For an idea Read More...
SQL Server Denali CTP1 was released today. I don’t want to be the fiftieth person to post the link to the download; reference Ed's blog posting for the location. This is a repost (with some corrections now that the CTP is actually out) of a Read More...
Just having a look at PowerShell support in SQL Server Denali CTP1. In Denali you must install PowerShell V2 or it will be installed as part of the installation process. Although the minishell architecture of SQLPS is unchanged so far. Rumor is that changing Read More...