Browse by Tags
All Tags »
SQL (RSS)
SQL Server 2008 (aka Katmai) allows seamless transition between relational and nonrelational data, enabling users to access documents as data, encode complex XML hierarchies within XML, and query across relational and text data. So how is this achieved?
Read More...
Customers often raise the following concerns and questions regarding the Database Mirroring feature of SQL Server 2005. In here, Don Vilen a Program Manager for SQL Server Database Mirroring and I have responded to some of these concerns and questions:
Read More...
SQL Server 2005 Compact edition runs as an in-process application, with a very small footprint (less than 2 MB disk footprint) offering you a good subset of the T-SQL features, and replication features of a full blown SQL install. DB Size is capped at
Read More...
For those of you who are interested in creating your first SQL Server 2005 Service Broker conversation but are impatient as I am, just grab the code below and give it a try: -- Enable service broker alter database [YOUR_DB_NAME] set enable_broker -- Create
Read More...
