Retrieving data as XML using stored procedure
On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here...
What if you encounter Error number: 20598 with SQL Server replication ?
Today on one of the sql server I encountered an interesting scenario, one of the dbas accidentally deleted data from subscriber...
Gotcha when restoring database with restrictive access !
Starting from DB2 V9.1, IBM added a parameter on the CREATE DATABASE command called RESTRICTIVE. Â When this parameter is...
DB2 10 arrives !
IBM announces DB2 10 for Linux Unix and Windows ! Â Code named Galileo, DB2 10 arrives with some neat features....
SQL Server 2012 Licensing model
With SQL Server 2012, Microsoft has changed its licensing model along with “consolidating” the different types of editions. Gone is...
Denali is on its way !
Microsoft is coming out with a new version of SQL Server , codenamed ‘Denali’ a.k.a SQL Server 2012. Â It boasts...