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


Article Categories

Archives

Post Categories

Blog Roll

Cool Sites

SQL Server

There are 9 entries for the tag SQL Server
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 ......

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 ......

Bruce Johnson of Object Sharp writes about a puzzling performance issue that took a little head-scratching to solve. In the end it came down to a data type mismatch between the parameter variable and the field definition. The parameter was nvarchar(40) and the field was defined as char(36). SQL was converting the field values to nvarchar(40) instead of converting the single parameter value to char(36). It makes sense that it would convert the char(36) to nvarchar(40) because converting the other ......

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: ......

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 ......

That's right! Launched at TechEd Europe just hours ago. Go to the VS 2005 Express Homepage for all the details. You can also read the Express Team's Blog. You can also check out the C# RSS Reader sample application that comes with the C# Express Edition. How about an Express Edition of SQL Server 2005? You got it! Oh, and did I mention that these are available to ANYONE! No MSDN subscriptions required. Also announced at TechEd is the MSDN Product Feedback Center. Now that's cool! Wow! What an exciting ......

We had a couple of the boys from Panorama Software in today to give us a demo of their business intelligence offering. To be honest, I was expecting to be less than impressed. In a nutshell, this is a front end to OLAP. All I have to say is AMAZING! This product is one of the best applications I have seen. They provide information in a rich browser that uses DHTML (I believe) so there's no JVM or ActiveX to worry about, they have an Excel plug in, and they can also integrate with SQL Server's new ......