database

How can I efficiently update a database with external data sources?

I'm trying to populate a table with user information in a MS SQL database with information from multiple data sources (i.e. LDAP and some other MS SQL databases). The process needs to run as a daily scheduled task to ensure that the user information table is updated frequently. The initial attempt at this query/ update script was writt...

How do you migrate SQL Server Database Diagrams to another Database?

My team recently rebuilt their SQL Server 2005 development database from scratch using the TFS source files. Afterwards, we had a nice clean database that more closely matched our test and production environments. However, we also lost the database diagrams that had been created over the months in the old development database. Does any...

Do database views affect query performance?

Are database views only a means to simplify the access of data or does it provide performance benefits when accessing the views as opposed to just running the query which the view is based on? I suspect views are functionally equivalent to just the adding the stored view query to each query on the view data, is this correct or are there ...

Need a smaller alternative to GUID for DB ID but still unique and random for URL

I have looked all of the place for this and I can't seem to get a complete answer for this. So if the answer does already exist on stackoverflow then I apologize in advance. I want a unique and random ID so that users in my website can't guess the next number and just hop to someone else's information. I plan to stick to a incrementing ...

Selectively filling a dataset

I need to change what rows are grabbed from the database based upon a few flags. How can I do this? My current code is like this: this.tblTenantTableAdapter.Fill(this.rentalEaseDataSet.tblTenant); Say if I wanted only rows that the id was greater than 50, how would I do that? Edit: The code to access the database was autogenerated b...

Going from VisualStudio generated Database stuff to Programmer Generated

I'd like to be able to better access the database so I can execute queries (primarily because I don't understand/know the API for it, but I do know SQL). I don't want to remove everything Visual Studio has done because a lot is already built upon it, but how can I get an object that I can use to execute SQL queries. This is Visual Studi...

Delphi TeeChart only showing one record from dataset

Using Delphi Steema TeeChart component, if I link a BarSeries to a dataset using the user interface, it shows up fine, but if I do it using code (which I need to), it's only showing one bar, even when I have several records in the database. What am I doing wrong? Code: var i:Integer; Bar:TBarSeries; begin ADataSet.Close; AD...

Any Static Code Analysis Tools for Stored Procedures?

Are there any static code analysis tools for stored procedures written particularly in PL/SQL and T-SQL? ...

Selecting items in multi-select listbox from delimited database string field

I'm trying to build an "edit" page for a database record that can be edited and saved back to the database. One of the fields will be a multi-select listbox that will need to highlight the appropriate list items in a hard-coded list when loaded. Using C#, how do I populate a multi-select listbox -- with the appropriate items selected -...

Native primary key or auto generated one?

As a rule is it better to use native primary keys (ie existing columns or combination of columns) or set your primary key to an auto generating row of integers? EDIT: It has been pointed out to me that this very similar to this question. The consensus here is to use surrogate keys, which was my natural inclination, but my boss told me ...

File Vs Database

I'm going to implement an Access Control List for each individual user so they can assign access to their own resources so they can hide stuff, for example, from their mothers, but show their friends. Now storing ACL in a database seems like it can get pretty insane when each user is also a group, which can have many sub groups. So I'm ...

What tools would you used to write a modular database in Python?

I am building a modular application in python. The plugins are not known until runtime. I envisage that many plugins will create/read/update data, which they themselves care about, and other plugins may care about too. An approach I am considering: one plugin may be concerned with Users. Another plugin may be interested in one or m...

How to read de Exchange Database ??

Hello, im creating an application that have to read and update Contacts Information (like phone number, email, etc..) from Microsoft Exchange... Does any one know how can i connect to a MS Exchange DB ?? ...

Creating a data driven web front end quickly

Over the last few years, I can't count how many web front ends I've had to create over a relatively simple database schema to fasciliate data entry. I have to imagine that someone out there has written a framework I can use to simplify the creation of these kind of simple GUIs. Doing a quick google, the following look like the key playe...

Using integers and requiring multiplication vs. using decimals as a data type - what are your thoughts?

What are your thoughts on this? I'm working on integrating some new data that's in a tab-delimited text format, and all of the decimal columns are kept as single integers; in order to determine the decimal amount you need to multiply the number by .01. It does this for things like percentages, weight and pricing information. For examp...

Several machines running same software, some won't connect to firebird

I'm pretty perplexed... I've got 5 different test computers, all relatively blank Windows XP machines running similar hardware specs. I run a silent install of the FireBird (Classic) database and my application. Some computers require "localhost:" (or 127.0.0.1) before the database location to make a connection, and some simply don't wor...

Is there a way in SQL to ask "what changed?"?

Often I find myself working on a new project with a giant RDBMS whose schema I don't yet understand. I want to be able to mark a checkpoint in the database, do something in the app, and then go back to the database and ask it which tables changed (and ideally, what records changed). Is there a way to do something like this with SQL? I...

Best Database Change Control Methodologies

As a database architect, developer, and consultant, there are many questions that can be answered. One, though I was asked recently and still can't answer good, is... "What is one of, or some of, the best methods or techniques to keep database changes documented, organized, and yet able to roll out effectively either in a single-deve...

Python libraries to construct classes from a relational database? (ORM in reverse)

Are there any Python object-relational mapping libraries that, given a database schema, can generate a set of Python classes? I know that the major libraries such as SQLObject, SQLAlchemy, and Django's internal SQL ORM library do a very good job of creating a DB schema given a set of classes, but I'm looking for a library that works in r...

How to merge multiple datatables into one?

I have multiple excel files which I open as datatable I want to merge all this datatables single DataTable in .net. eg, Apr09.xls,May09.xls,Jun09.xls All have dataas follows Apr09.xls EMPCODE,PresentDays 0001 ,30 0002 ,21 May09.xls EMPCODE,PresentDays 0001 ,25 0002 ,30 New datatable will be as follows EMPCODE,PresentDa...