Totzkeeeeee's Blog

Just because I can...

  Home  |   Contact  |   Syndication    |   Login
  216 Posts | 4 Stories | 345 Comments | 321 Trackbacks

News


My blog is worth $14,678.04.
How much is your blog worth?

Tag Cloud


Archives

Post Categories

Image Galleries

Blog Roll

Cool Sites

Database

There are 13 entries for the tag Database
I’m currently working for a client on a PowerBuilder to WPF migration. It’s one of those “I could tell you, but I’d have to kill you” kind of clients and the quick-lime pits are currently occupied by the EMC tech…but I’ve said too much already. At approximately 3 or 4 pm that day users of the Batman[1] application here in Gotham[1] started to experience problems accessing the application. Batman[2] is a document management system here that also integrates with the ERP system. Very little goes on ......

Just started working with the Entity Designer Database Generation Power Pack and I must say it is a very solid first offering. Model first design is something new in EF4/VS 2010 and it's great to see a tool available that has evolved alongside VS 2010. I was very happy to see that it comes with the ability to synchronize with a database project right out of the box. In my opinion, this is the most valuable feature. In the past, the actual production database was considered to be the "truth". As our ......

In a word – wonderful. I’m doing some work on a project where somebody had a bit of a fetish for nested views. I’m not talking about one view inside another. I’m talking about one view that joins a couple of other views that each join to other views as well. I needed to add a value to the output of the outer-most view and before I added ~another~ join I wanted to know if the table in question was already joined in one of the nested views. Drilling down into them would have taken time. I remembered ......

That’s a mouthful. Back in November of 2008 Microsoft shipped the GDR (General Distribution Release) for the Database Edition of VSTS. This update changed the way the database is modelled internally and removed the need to have SQL Server installed locally. You can check out a review of my experience with this release here. The scope of the changes required at that time was such that we decided against updating. I had estimated approximately one full day to implement the changes to our stored procedures ......

Here are some notes about my experience when testing an upgrade to the general distribution release of the Database Edition. I installed the latest version of the VSTS Database Edition (GDR) on my laptop and loaded up a copy of the a database project. Everything converts pretty much ok with the only issue being unresolved cross-database references. DBPro is now model-based and as such does not require SQL Server to be installed locally. This also allows them to have project references to other databases ......

Hey there, In one of my data loads I have NULLs creeping into a foreign key column. I am looking up a domain name and getting an integer Id number back. The column is populated during the load by a Lookup Transformation in SSIS. A previous step in the process populates the lookup table with any values that don’t exist so it should be impossible for the subsequent lookups to fail. These null values had only recently appeared and coincided with some data back-filling we were doing. First issue: I had ......

Virtual PC and Virtual Server “virtualize“ (who'd a thunk it?) your PC's hardware and the virtual hard disks simply become a file on the file system. I use Microsoft Virtual Server R2 extensively for development work. Right now I'm using it while learning about VS Team System and Team Foundation Server. I have a Windows 2003 R2 domain controller, a W2K3 Application Server, and a W2K3 database server all running in a virtual environment on my PC. (ok, so it's a server class machine but ......

I have no idea what motivates some folks. Probably some kind of latent masochistic tendencies or something. Guest, obviously not his/her real name, (and to paraphrase the bard, an anonymous coward by any other name...) felt obliged to comment on my article relating the tale of our recent database migration attempt. No CRM system is without its faults. As with all software, its impossible to envision the demands 10 years down the road. Well duh! For the record, I wasn't slagging on Navision as a whole. ......

Just posted a new article outlining my experience as we tried to migrate our Navision ERP system from the native C/SIDE database to SQL Server 2000. Go check it out. It's worth it. bane (b n)n. 1) Fatal injury or ruin: “Hath some fond lover tic'd thee to thy bane?” (George Herbert). 2) a) A cause of harm, ruin, or death: “Obedience,/Bane of all genius, virtue, freedom, truth,/Makes slaves of men” (Percy Bysshe Shelley). b) A source of persistent annoyance or exasperation: ......

It seems that there are a few developers out there that are trying to petition Microsoft to keep VB6 alive. I'll repeat that. There are those that want VB6 to stick around. I'm pretty sure I know who a couple of them are. If ever there was a group of folks that just don't get it, it must be them. They have even gone so far as to suggest that VB6 and VB.NET should co-exist in the same IDE and that developers could even use both in the same solution and the interop could be handled seamlessly by the ......

Microsoft's Navision Attain ERP system is not the best in the world but for the SMB crowd it's a pretty solid offering with a lot of functionality. It's very easy to customize (and we've taken full advantage of that but that's a tale for another time) and quite user-friendly. The user interface is highly responsive and easily navigable with the keyboard. Anyone doing significant data-enty work knows the importance of that. Where Navision starts to fall down though is on the back end. The C/SIDE database ......

...but this is ridiculous. Check out these excerpts from this article on Wired News WN: "You (Jeffrey Rosen) relate a disturbing conversation with Larry Ellison in which he proposed aligning America's national security strategy with the Oracle business plan by building a national database that would include fingerprints. Ellison got testy when you raised privacy concerns. What's good for Oracle and Larry Ellison should be good for America, he seemed to say. Are the corporate market's needs driving ......

I've been working with our ERP system lately trying to do some BizTalk integration. Pretty simple conceptually but a royal pain in the ass when you get right down to it. We use Navision and it is hosted on the original C/SIDE database management system. ick. Now, if you are programming within Navision itself, life is not so bad. If, on the other hand, you have to get at the database using the ODBC driver, things get a little odd. The first thing that is weird is that you have to install the Navision ......