MrTelly

1

votes
3

answer
674

views

Sql Server Backup Sizes

Does anyone have real world experience of backup compression in Sql 2008, I'd like to know how it performs compared to Sql 2005 + winrar. Currently when I back up a I get a 14G file. Using rar shrinks it to
MrTelly
1

votes
1

answer
51

views

Tools/Techniques to use our ability to think spatially

What software/UI techniques can leverage our spatial memory? I think and remember in physical space, often the location of something is as important as it's content. For instance I keep an untidy desk, but I know where to find things, I use different parts of my (multiscreen) desktop for different...
MrTelly
1

votes
3

answer
113

views

Legacy Data Feed, trade off between Standards, Xml and Performance

We're working with legacy data feeds and apps that consume them. We want to introduce Xml but the additional performance overhead is hard to justify. How have you addressed this issue? We're working with a number of pre-existing data feeds, often files in a well known directory which are updated eve...
MrTelly
1

votes
2

answer
0

views

Writing video frames with variable framerate

I'm using the AVIFile Wrapper to create video from my WPF app. I'm using CompositionTarget to grab an image for each frame but I'm having problems with framerate. As my app slows down with heavy data load, the CompositionTarget frame rate drops. With less video frames, when I play back these parts a...
MrTelly
1

votes
1

answer
0

views

HIbernate - bulk loading child objects

How can I get NHibernate to hook up child objects automatically or bulk load children rather than lazy loading for each parent? I have a large number of parent objects all of the same type. Each of them has two bags of child objects. As I need to load all the parents and children objects as quickly...
MrTelly
1

votes
3

answer
844

views

Office 2007 and WPF

I've recently been using Excel and Powerpoint 2007, and it's seems clear that the shapes are using WPF. Edit - I know the shapes have existed in Office for ever, that is not my question. Look at the fill possibilites for shapes in 2007, look at that gradient fill, look at its parameters - that's th...
MrTelly
0

votes
0

answer
17

views

Sql Server Read text file with varying numbers of fields

How can I read variable width records into Sql Server? In my delimted text file, each record can have a varying number of fields - there are 20 core fields, and then a repeating set of extra fields. So a record will have a minimum of 20 fields but could have 200 fields. There isn't a row of FieldNam...
MrTelly
6

votes
3

answer
2.1k

views

Giving candidates interview questions in advance of the interview [closed]

I'm going to be interviewing for a small team of creative/developers in the next few months. I'm thinking of getting each candidate to put together a short pitch, based on our ideas so I know they get what we're trying to acheive. Of course we'll communicate all that prior to the actual interview, a...
MrTelly
2

votes
3

answer
1.8k

views

Unix commands from C#

Is there an implementation of a Unix shell and commands as a .Net assembly. This could be a wrapper around cygwin, or a standalone built from public domain source. The kind of commands I'd really like to be able to use are wc, tar, cpio, ps, kill, cat, at ... how cool would it be to do this (Pseudo...
MrTelly
2

votes
2

answer
2.8k

views

Analysing Excel VBA/Macro code

Is there a tool which will analyse/parse an entire Excel workbook and let us see all the macros, functions, VBA code? I've been given a large number of Excel spreadsheets to analyse, we need to know what they do and how they do it, with a view to creating documentation, and/or re-writing. In many in...
MrTelly
2

votes
3

answer
2.9k

views

Identify individual sql user in SQL profiler And activity monitor

We're using SQL 2005 and want to identify individual users so we can trace their SQL for performance purposes, but we're finding it hard to unique identify who is who. We're using SQL 2005 with connection pooling so every user has the same user in the Activity Monitor. Their NT user name doesn't app...
MrTelly
2

votes
1

answer
671

views

Update/Insert sql table from SSAS cube

Is it possible, preferably using tsql or MDX, to read data from cube and use it to update or add records in a sql table?
MrTelly
2

votes
1

answer
272

views

Comparing the 'similarity' of two .net object values

I have a generic C# class comparer routine which reads values from objects and then compares their properties one by one using reflection. var value1 = property.GetValue(object1, null); var value2 = property.GetValue(object2, null); if (!value1.Equals(value2)) { ...... Thing is I'm getting differen...
MrTelly
3

votes
4

answer
314

views

Three value variables, max, min, actual

A long while ago I developed systems using Egeria an expert system language. It had a really useful feature where variables had three values, a min, max and current. In this way the probability of a partly known value could calculated, with the results ending up as a range. I can't remember the synt...
MrTelly
4

votes
11

answer
540

views

Ratio of real code to supporting code

I'm finding only about 30% of my code actually solves problems, the rest is taken up by logging, tests, parameter checking, exceptions, error handling and so on. Do you find that in your code, and is there an IDE/Editor that allows you to hide code that's not interesting? OTOH are there languages wh...
MrTelly
1

votes
3

answer
3.1k

views

Sql Server, find all rows that have been updated by a statement

Is there a way of finding all the rows that have been updated by a single statement, sql itself must be tracking this as it could roll back the update if required. I'm interested in finding all the changed rows as I'm getting performance hit using update triggers. I have a some large (2M-10M) row ta...
MrTelly
3

votes
5

answer
603

views

Creating Stored Procedures that can work with different tables

I need to use the same Stored Procedures against many tables all with the same structure in my DB. This is data loaded from customers,with one table/customer and the data needs calculations/checks run before it's loaded to our DataWarehouse. So far these are the options and issues I've found and I'm...
MrTelly
7

votes
8

answer
650

views

Replacement or Migration strategy for Excel/Access

Is there a way of offering the flexibility of Excel/Access development that end users love while instilling centralised IT management so data and logic is secure, backed up, version controlled etc. The common options are to re-write in C#/ASP.Net/Java/Python/Your Choice, but that takes away control...
MrTelly
3

votes
2

answer
291

views

Managing DB reference data and it's related code

Reference Data, or lookup tables are things like CustomerType, ProductType and so on. They change infrequently, occasionally a new type is added or an old one retired. In code they're often reproduced as enums/constants, and also used to populate combo boxes. Adding a new Type shouldn't break existi...
MrTelly
3

votes
1

answer
1.8k

views

A lightweight templateable WPF shape

I'm using ellipses and other shapes as onscreen markers, I would like others to be able to change these visuals using templates. However, as shape doesn't support templating I'm forced to create a basic UserControl, which defaults to show an ellipse, and then use that instead of the basic shape. Has...
MrTelly
3

votes
5

answer
124

views

Narrow band extensible message format

I'm putting together a technical response to tender, one of the requirements is to pass messages using an extensible format over a narrow bandwidth network (10 bytes/sec or so). To make life easy on the server, which will be receiving info from 1000's of devices I'd like to use Xml. To help with the...
MrTelly
3

votes
2

answer
151

views

Creating/compling .net data class within an application

Is there a pattern, Xml structure, architecture technique we can use to create simple data holder class code that we can deserialise to/from and do that at runtime? We're in the early design stage of a .Net project and one of our goals is to make the resulting system extensible through configuration...
MrTelly
2

votes
4

answer
2.2k

views

In Memory Database

I'm using SqlServer to drive a WPF application, I'm currently using NHibernate and pre-read all the data so it's cached for performance reasons. That works for a single client app, but I was wondering if there's an in memory database that I could use so I can share the information across multiple ap...
MrTelly
3

votes
1

answer
4.2k

views

WPF Layer Control

I'm in need of a WPF layer control that does the following 1) Have multiple layers of content on top of each other. 2) Ability to turn layers on/off at design and runtime, ie we need a UI maybe something like a tabbed control 3) Move layers up/down the stack 4) Change opacity for layers Now I know a...
MrTelly
2

votes
1

answer
1.2k

views

Graphical code analysis

I'm using SubVersion in conjunction with Hudson, and I like the feature that shows the how the unit tests, build time, disk usage grow over time. I'm a believer in code metrics to get a first cut appraisal of a code base - especially useful when starting with a new client. Are there any tools that c...
MrTelly
2

votes
3

answer
2k

views

Creating closed spatial polygons

I need to create a (large) set of spatial polygons for test purposes. Is there an algorithm that will create a randomly shaped polygon staying within a bounding envelope? I'm using OGC Simple stuff so a routine to create the well known text is the most useful, Language of choice is C# but it's not t...
MrTelly
3

votes
2

answer
919

views

COM on 64 Bit Platform

I'm using a 3rd party COM Library with C#, all works fine on 32 bit XP. I use tlbimp to create the wrapper, add a reference all works. However, when porting to our Server environment which is 64 bit Windows Server 2008, I've run into a road block. The code below only runs properly when I right click...
MrTelly
5

votes
1

answer
2.2k

views

Constants and Include files in TSQL

Is it possible to include a set of 'constant' values in a TSQL stored procedure? I have a situation where I'm using an integer field to store bit values and I have small set of 'constant' values that I use to insert/select against that field DECLARE @CostsCalculated int = 32 DECLARE @AggregatedCalcu...
MrTelly
3

votes
1

answer
658

views

Esper and SQS

I'm wondering if anyone here has tried using Esper to process stuff from the Cloud? Specifically Amazon's Simple Queueing Service. I've googled about this, and we know it's feasible, but it would be nice to know if anyone has tried it. Even better has anyone tried putting Esper into the cloud as wel...
MrTelly