Browse by Tags

• Links and News
• Technology and Internet

• XSD To Relational Database Model Converter -- XSD2DB

  A requirement in a small project I've been working on recently came up for mapping an XSD directly to an RDBMS schema on the fly (i.e. an incoming XML schema needs to be generated into an RDBMS schema structure at runtime...I won't get into specifics as to why), so I started searching for a way to to do this via the BCL. The new SQL Server SMO libraries looked promising, however they are vast and patience quickly lost out to a some good ol' one on one Google time. I ended up stumbling across this... Posted Jan 21 2007, 05:53 PM by Jayson Knight with | with 1 comment(s) Filed under: Technology and Internet, Tools and Resources, Links and News, SQL Server

• More SQL Server 2005 Management Studio Woes

  I posted earlier about some SQL Server 2005 Management Studio (SSMS) gripes I've come across; I recently came across another really big one that I really feel the need to air out: It's next to impossible to export an entire database to a new database on the same machine via the SSMS GUI. Sure, the option is there (right click a db, tasks, export data), and the wizard is pretty similar to the one we had via SQL Server 2000's Enterprise Manager, except for one glaring "feature": The only objects you... Posted Feb 12 2006, 05:58 PM by Jayson Knight with | with 7 comment(s) Filed under: Tools and Resources, SQL Server

• Free Microsoft SQL Server 2005 Training

  Huge ups to Mark for sending me an email linking to a ton of free SQL Server 2005 online training from Microsoft (though unfortunately it looks like the “virtual labs” part of the training won’t be available until early February of next year). I usually just go out and buy a ton of books when new technology comes out, but given the price of tech books these days, I’ll take anything that’s free…especially if it’s straight from the source (in this case, Microsoft... Posted Dec 18 2005, 07:07 PM by Jayson Knight with | with no comments Filed under: Tools and Resources, SQL Server