improve.dk - simple GUI

OrcaMDF Studio Release + Feature Recap | Mark S. Rasmussen

Improve.dk Spined HTML

OrcaMDF Studio Release +Full-lengthRecap | Mark S. Rasmussen Mark S. Rasmussen improve.dkWell-nighMe Pages Categories Archive Nov 25 2011 OrcaMDF Studio Release +Full-lengthRecap SQL Server - OrcaMDF Comments Just well-nigh two and a half months have passed since I last posted an OrcaMDF full-length recap. Since then I’ve been rented peekaboo three of the top SQL Server conferences – SQLBits, PASS and SQL Rally. It’s been spanking-new chatting well-nigh OrcaMDF and getting some feedback on where to take it, thanks to all of you! Though I’ve been busy, I’ve moreover managed to put some work into OrcaMDF in the meantime. New features A non-exhaustive list of additions since my last post: Support for multi-file databases. Exposing metadata through standard SQL Server DMVs. Optimized performance by increasingly light weight usage of byte arrays, as well as sharing a single instance of the table schema between all rows. I’ve moreover widow support for the pursuit uneaten data types: money smallmoney uniqueidentifier User specified types And just one increasingly minor thing… OrcaMDF StudioWorldwideamong much of the feedback I got was something withal the lines of: Awesome project! I definitely want to try it out, but I haven’t had the time yet. To be honest, it’s been somewhat cumbersome to try out OrcaMDF. You had to download the source, compile it yourself and then write your own using to unquestionably invoke OrcaMDF. It’s never been my intention for it to be directly end user usable, as that’s just not my focus. However, to modernize upon OrcaMDF, I need increasingly usage feedback. As a result, I decided to create OrcaMDF Studio – an UI on top of OrcaMDF, permitting you to query user tables, dmvs and wiring tables without looking at any of the lawmaking at all. What you’re seeing here is OrcaMDF showing the contents of the Product table in a standard AdventureWorks 2008 database:Wiringtables OrcaMDF Studio exposes all of the wiring tables (that it currently supports & parses), just like normal tables: Dynamic Management Views OrcaMDF moreover exposes all of the currently supported DMVs, just like any other table: User tables, indexes & schemas Finally, OrcaMDF moreover exposes all of the user tables, including their schemas, indexes and alphabetize schemas: Error reporting As OrcaMDF, and the Studio, is still far from production ready, you’ll probably run into unsupported scenarios or worldwide bugs. If you do, OrcaMDF Studio will report it to you, as well as save a stack trace in the using directory. Here’s an example of a typical error – trying to unshut a table with an unsupported post type (xml for example): If you squint in the ErrorLog.txt file that’s written to the using directory, you’ll see an exception like this: 25-11-2011 00:41:21 ---------- System.ArgumentException: Unsupported type: xml(-1) at OrcaMDF.Core.MetaData.DataColumn..ctor(String name, String type, Boolean nullable) in D:ProjectsOrcaMDFsrcOrcaMDF.CoreMetaDataDataColumn.cs:line 135 at OrcaMDF.Core.MetaData.DataColumn..ctor(String name, String type) in D:ProjectsOrcaMDFsrcOrcaMDF.CoreMetaDataDataColumn.cs:line 20 at OrcaMDF.Core.MetaData.DatabaseMetaData.GetEmptyDataRow(String tableName) in D:ProjectsOrcaMDFsrcOrcaMDF.CoreMetaDataDatabaseMetaData.cs:line 155 at OrcaMDF.Core.Engine.DataScanner.ScanTable(String tableName) in D:ProjectsOrcaMDFsrcOrcaMDF.CoreEngineDataScanner.cs:line 31 at OrcaMDF.OMS.Main.loadTable(String table) in D:ProjectsOrcaMDFsrcOrcaMDF.OMSMain.cs:line 158 Completely unrecognized data that just gives an indication of where the error occurred. If you run into issues like these, I would fathom if you would send me the ErrorLog.txt file so I can debug potential issues. All issues, requests, error reports, etc. should be sent to my email. Database version support OrcaMDF has been ripened for, and tested with, SQL Server 2008 R2. Some operations will work on SQL Server 2005, but many will goof since some of the wiring tables have variegated schemas. OrcaMDF does not differ and will thus throw up once you hit those differences. I’ll add an wresting layer + support for both at a later time. Opening live databases OrcaMDF Studio will have to take a read lock on the database file(s) for now. As SQL Server takes sectional locks on the files, this ways you can’t unshut a live database. You can either uncouple the database, take it offline, backup-restore-detach or simply use a non-attached database to uncork with. For a later release, I’ll add will-less VSS snapshot functionality. System requirements OrcaMDF is built on top of the .NET Framework 4.0 – as such, you will need to have it installed for OrcaMDF Studio to run. OrcaMDF Studio will run on both x64 and x86 machines. Disclaimer Once again, OrcaMDF + Studio is experimental software. I requite no guarantees whatsoever, and you’re using it at your own risk. OrcaMDF will not write anything to disk and will thus not, in any way, modify your database files. However, I strongly suggest that you do not use this on a production database, either way. OrcaMDF neither knows nor cares well-nigh security. No matter who owns that schema or object, OrcaMDF will parse it just fine – no need for pesky usernames and passwords. However, OrcaMDF does not support Transparent Data Encryption, so databases using TDE will not be supported. Download You can download the OrcaMDF Studio binary release at the OrcaMDF Github project page. Please don’t overly download OrcaMDF anywhere else, you risk that someone modifies the source and distributes their own version. Always get it from the Github project page. Once you download it, simply unpack it and run the OrcaMDF.OMS.exe application: Note that this is a debug build – hence the .pdf files. Debug builds will be slightly slower than release builds, but it does enable me to get full stack traces if/when an exception occurs. Once OrcaMDF stabilizes, I’ll provide both debug and release versions. Mark S. Rasmussen I'm the CTO at iPaper where I petting with databases, mold lawmaking and maintain the overall technical & team responsibility. I'm an voracious speaker at user groups & conferences. I love life, motorcycles, photography and all things technical. Say hi on Twitter, write me an email or squint me up on LinkedIn. CATEGORIES .NETAS/Flex/FlashAmazon Web ServicesComputer ScienceConferences and PresentingIISLifeMiscMiscellaneousPerformancePokerSQL ServerSQL Server - CommunitySQL Server - Data TypesSQL Server - InternalsSQL Server - OptimizationSQL Server - OrcaMDFSQL Server - TricksTestingTools of the TradeUmbracoVisual StudioWebWindbgWindows ARCHIVE 201420132012201120102009200820072006 Copyright © 2014 Mark S. Rasmussen