On his wonderful blog Rushi Desai has launched an interesting challenge:
http://blogs.msdn.com/rushidesai/default.aspx
If you're into Service Broker this is a challange that you shouldn't miss. Happy Messaging!
PS:Winner list's is here: http://rushi.
Read more →
If you need to setup two instances of Sql Server 2005 (I actually did it with Sql Server 2005 "Full" version and with the Express one) you can use the little sample you can find here:
Read more →
Some other things are changed in the April CTP concerning Encryption and Certificate creation. You can find documentation here:
More Encryption Syntax Changes in SQL Server 2005 Another Encryption Syntax Change: CREATE CERTIFICATE
Legacy Comments
Nishant Pandya
2006-04-07
re: Sql Server 2005 Encryption Changes in April CTP TEST
Read more →
I'm working on Service Broker and i've found a not documented (or maybe i haven't found the documentation?) change in the CREATE CERTIFICATE command.
The help says that you should do something like that to create your certificate from a file:
Read more →
Another event in June is scheduled to bring Sql Server 2005 power everywhere :-)
As you can see from this link the Roadshow will touch some Europeans cities and two dates are scheduled to be here in Italy.
Read more →
Last sunday I got stuck when I tried to use the XML Task of System Integration Services Control Flow toolbox.
I was using the April's CTP and the problem was.....the *documentation* :-D.
Read more →
Tomorrow and for the rest of the next week i'll partecipate (along with my collegues at http://www.factorysw.it/) at the first Italian SQL Server 2005 Technical conference as a speaker.
I'll talk about some of the most interesting (and sometimes discuted!
Read more →
I'm a freelancer consultant, and everytime i have to explain how to design & create code that runs fast, it is easy to maintain and that can support business requirements changes, i found myself talking for hours explaining why we should create Data Layers, why we should refactor our code, why we have to take care of database design and schema abstraction and so on.
Read more →
Since a lot of people are asking me where to find information on SQL Server 2005 version, I post here the most useful link on the topic:
Announce:http://www.microsoft.com/presspass/press/2005/feb05/02-24ExpandedProductSuitePR.asp
Versions Feature Comparison:http://www.
Read more →
I've found a trick to solve the problem of creating a hierarchical XML from a CTE query (exposed in this blog entry).
Since it's quite long i've posted it in this article:
Read more →
Finally i've managed to have a hierarchical xml result from a CTE Query.
I've discovered that SQL Server 2005 cannot do this natively, so at the end i've create a .
Read more →
After a long period full of work i've been able to play again with SQL 2005.
I was trying to apply PIVOTing to a real database that i ported to SQL 2005 ad i found the the query i wrote using the PIVOT operator gave me a "syntax error".
Read more →
Is it possible to finally have a nested XML document on a recursive query? Let's say that we have a classic parent-child relationship inside a table that is self-refernced. An example of this situation can be found in the Employees table of Northwind DB or in the shining new AdventureWorks DB, HumanResources.
Read more →
Hi to all readers!
I've been playing with SQL Server 2000 a lot, and now it's time to start to play seriusly with SQL Server 2005. I'm a SQL, XML and CLR lover, so SQL Server 2005 is my perfect enviroment.
Read more →