I have a couple questions I hope someone might be able to answer, or
rather point me in the correct direction.
I am an independant developer and I am working on a small CRM for small
businesses. Nothing fancy, but built with c# and the .NET framework.
In my study of other CRM's like Microsoft, Clarify, and Misc I have
noticed something things that I do not understand.
1. When using a database, are customers and the customers
cases/problems kept in seperate tables?
2. When logging notes and misc, how is text formatted/kept in the
database. I see notes inside cases that are formatted and keep the
formatting after the cases are written the the DB.
Thanks for any info, and I am sure I am asking more then simple
questions.
Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:
It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.
Fixture contains the details about the fixture like date and fixture id and has it been played
Team contains team info like team id, name, associated graphic
TeamFixture is the table which links the fixture to it's home and away team.
TeamFixture exists to prevent a many to many type relationship.
Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!
I actually work in an organisation and we have to find a solution about the data consistancy in the database. our partners use to send details to the organisation and inserted directly in the database, so we want to create a new database as a buffer database to insert informations from the partners then make an update to the main database. is there a better solution instead of that?
Hello everyone,I have a webcontrol that uses database-structures alot, it uses the system tables in SQL to read column information from tables. To ease the load of the SQL server I have a property that stores this information in a cache and everything works fine.I am doing some research to find if there are anyway to get information from the SQL server that the structure from a table has changed.I want to know if a column or table has changed any values, like datatype, name, properties, etc.Any suggestions out there ?!
I have a system that basically stores a database within a database (I'msure lots have you have done this before in some form or another).At the end of the day, I'm storing the actual data generically in acolumn of type nvarchar(4000), but I want to add support for unlimitedtext. I want to do this in a smart fashion. Right now I am leaningtowards putting 2 nullable Value fields:ValueLong ntext nullableValueShort nvarchar(4000) nullableand dynamically storing the info in one or the other depending on thesize. ASP.NET does this exact very thing in it's Session State model;look at the ASPStateTempSessions table. This table has both aSessionItemShort of type varbinary (7000) and a SessionItemLong of typeImage.My question is, is it better to user varbinary (7000) and Image? I'mthinking maybe I should go down this path, simply because ASP.NET does,but I don't really know why. Does anyone know what would be the benifitof using varbinary and Image datatypes? If it's just to allow saving ofbinary data, then I don't really need that right now (and I don't thinkASP.NET does either). Are there any other reasons?thanks,dave
Hi All,Can u please suggest me some books for relational database design ordatabase modelling(Knowledgeable yet simple) i.e. from which we couldlearn database relationships(one to many,many to oneetc.....),building ER diagrams,proper usage of ER diagrams in ourdatabase(Primary key foreign key relations),designing smallmodules,relating tables and everything that relates about databasedesign....Coz I think database design is the crucial part of databaseand we must know the design part very first before starting up withdatabases.....Thanks and very grateful to all of you....Vikas
Hi All, I am designing database where few of the master tables will reside in different database or in case different server. Scenario is Server "A" with Database "A" may host the "Accounts" table. Server "B" with Database "B" may host the "Product" table. I am designing database "Project" which will hosted in Server "A". My application requires this master tables [readonly access] as data inserted in my application refers this tables. Also there are reports to be generated which refer this tables. How do i design my database and sql queries? I am thinking of approach of having equivalent tables created in my database and writing service which keep tables in my database in sync. This will ensure good perfomance during transaction and reports as they will need to refer this table locally as opposed to different database or different server.
Any thoughts on above approach?? or any better/standard way for such scenarios ?
Thanks in Advance. Your inputs will be of great help.
Online US Searchable Map of the 50 US States. Users search criteria is the following: Query records by selecting state, county, then record. Each County table has 10-20 tables. All databases combined = 500MB and TLogs = 100MB.
How would you re-design a relational DB where users could query data by state-county-record. Currenty the DB's are created by the County of each state which creates hundreds of DB's in SQLServer with no realtionship to each US state. What would be the best design to ensure good performance, data integrity and maintenance? Would you create 1 DB with all 50 states, create 4 DB's and divide by region(N,S,E,W), 50 DB's of each state or leave it as is with each county it's on DB? Any suggestions would be appreciated.
I need to setup a new database with a .mdf file. Name of the database will be “socc� and username=socc1 and password=abcdefg . Should I create a new databse with name "socc" and restore it with the .mdf file ? How do I create the required username and password ? Does the .mdf file take care of everything?
I have a situtation where the business user wants to store the Historical Data along with the current data for Subject areas.
As a DBA i have been asked to tell them whether we need two separate set of databases for current Data and one for historical Data or just one structure holding both the current and Historical data , the current data is used downstream by many number of applications can you please guide me as to which approach would be better to take ]
One structure holds all and have indexed views for current data
separate structure for current and historical data
can you please tell me the Pros and cons of each approach.
I am trying get a database setup in my new install of VS 2005. I have a project on one PC where I just have VS2005 installed and i am able create a website, go to the APP_DATA folder and add a database. On another PC I have VS 2005 installed and then I installed SQL server 2005. Now I fail to connect to ??? when I try and enter the sercuity page of webconfig or try to add a database when I open the APP_DATA folder. There have been many things done on this PC between the install of the two mentioned packages and trying this database creation. However, I feel that something related to the install of SQL Server 2005 after VS 2005 has done something unexpected. Or, I need to manage something between the SQL Express version that got loaded with VS 2005 and the subsequent install of SQL Server. I just don't know what to look for at this point.
Our product has a MDF file included with the setup, this needs to be attached at the current SQL Server (Express or not). Where can we copy the MDF file during setup so it can be attached successfully ? We need a place where the account SQL Server is running under has write permissions.
I have aquired Windows XP Embedded. I went to install the Database, with SQL Server 2005 Express Edition and it said that MSDE 2000 or higher is required. I found in the MSDN library that one may use SQL Server 2005 Express to install the database, however, the installation is not finding my SQL Server instance, please help!
When I create the setup for the Teacher Starter Kit( Created with Visual Basic) (Click Once Setup) and install it in someone else computer, I can not find the SQL database ( in sense of opening it and tweak it in case i need to). the program works fine and store data, but where is the database?!! that I can not find. can you help me please? or explain.
Later On I would need to instal the ClickOnce setup of this application on a server in so everyone can reach it. is the the ClickOnce setup sufficient for this task. and will the database be added to the SQL SERVER databases ?
I currently have a single Access database with the following information:
* A bunch of lookup tables * A bunch of "main tables" * A "snapshot" of our entire portfolio created from various joins using the main tables and lookup tables. This "snapshot" is about 22MB and is deleted and recreated sometimes on a daily basis. I compact the database regularly to keep the size down. There are other snapshots.
The snapshots are creates by various Access queries and there are various VBS / VB6 codes that either modifies the data or formats/dumps data from this database into Excel.
I'm planning on upsizing this to a SQL 2005 server and am planning on this:
1 database with the lookup tables 1 database with the "main tables" 1 database with the snapshots
All the databases set to auto-shrink...
Is this the best way to approach this?
The VBS / VB6 modules will be eventually migrated to VB.NET and ASP.NET
I am new to SQL Server 7 and am not sure how to handle setting up/importing FoxPro databases. The consultants that setup the database before me have combined all of the FoxPro databases into one big database in SQL server. The reasoning was that for user applications to have access to different databases in SQL they would need a connection for each database they are using, so if all the data is put into one database then the user would only have one database connection instead of 6 or 7.
Does this make sense to anyone? Someone else thought that this might have been true is SQL Server 6.5 but not in SQL Server 7.0. Any help will be appreciated.
Hi, I'm having an issue setting up Database Mirroring. The environment here could be an issue.
I'm trying to set this up using 2 different servers both are SQL Ent Edition SP2, windows 2003. I'm not using a witness at this time. The 2 servers do not belong to a domain. They are both in workgroups.
I can setup the endpoints and everything up to the point just before I start mirroring. The issues happen when I go to start mirroring. It gives me a nasty error "please use a FQDN to establish the endpoints. The problem here is I don’t have any FQDN for these servers since they're in a Workgroup.
So, my question here is and I haven't found anything stating that you can't set up mirroring in a workgroup environment but is it possible? I'm assuming since its yelling at me for a FQDN that I can't. Is there any other ways to implement mirroring without a domain?
We have vendor that is implementing an employee self serve application for current and potential employees (employment applications). There is a web server in our DMZ that has the application installed but also on the server is a SQL database that has names and social security numbers. This server will also query the backend accounting server for earnings statements and W2s. We have a Cisco ASA as the firewall and SSL to protect client authentication from the Internet. There is no SSL between the web server and the accounting server. The fact that the SQL database on the web server containing SSN associated with names concerns me. It seems that none of this information is masked or encrypted and can be seen if the server was to ever be compromised.
My idea of such a service involves a web server that queries the backend database over SSL and presents the information to the user over SSL. No personally identifiable information would be resident on the web server at all, just a facade. That is not the case and it is not what we described to them as to what we want.
It seems they have installed it the only way they know how which is not secure, or maybe it is, that's why I am here. They have installed this at numerous locations and they actually wanted any and all ports open between the web server and the backend accounting server. It took us a while to get them to follow the rule of least privilege but we essentially had to do it ourselves.
Also on our main webserver for our Internet site I found the test database they used almost 2 years ago to test this application along with names and SSN. This was before I arrived and there is no encryption or authentication for this server. Is this good secure practice? All my training says no but it is hard to believe a mutli-million dollar organization is this ignorant. I guess it shouldn't surprise me, TJX didn't pay attention either.
I saw this thread which provide some good information but I am not a database admin and I am not familiar with SQL services, etc.
My questions are: Is their implementation secure? Does anyone know where I can find more info regarding web services and HIPAA? I read where 2 firewalls are required but would like documentation to show. Any suggestions on how to implement this securely?
Hello room, I am newbie to Database mirroring. I have 3 window server 2003 running in window virtual server 2005. Server1 of sql 2005 instance: -- SQLDev01 Server2 of sql 2005 instance: -- SQLDev02 Serve3 of sql 2005 instance: -- SQLDev03 The servers are running on DC and the sql servers was setup with Window authentication mode only. Also, All the sql instances'services are running under single domain user name. e.g: sqladmin.
I have tried to setup manually and t-sql and both running into some issues. Can anyone help and share t-sript to setup database mirroring.? Thanks for the help. TJ
We just migrated to Microsoft SQL Server 2005 about six months ago. Everything seems went on very well. Database itself and most of our programs which access the database all are working just fine. But recently we encountered a database accessing problem. We have a program which reads database using a login ID and a password. The program works fine when programmer A log onto the server and run it. But when another programmer, say programmer B, log onto the server and try to run the same program with the same login ID and password. Accessing to the database was denied. Both programmer A and B have the same Database Adminstrator privilege. What did we do wrong is setting up the database? Can any of you help us solving the mystery? Thanks. Happy Holiday.
Im a beginner in ASP.NET and SQL. Please tell me how to run and paste a few tags on "SQLCMD T-SQL execution command line utility" (90ToolsBinn). Its SQL Express 2005. I cant paste a tag of an ASP.NET beginners site http://www.asp.net/GuidedTour/default.aspx). I cant set up a data base without doing it.
When attempting to run this installer (SQLCMD T-SQL execution command line utility), I get the DOS screen but not the 1> command prompt. If I leave the screen alone, the DOD command window closes after about 5 seconds. "C:Program FilesMicrosoft SQL Server90ToolsinnSQLCMD" -S "machine-nameSqlExpress"
If I retry the prompt, same thing happens. Attempts to Paste the script are unsuccessful, and the DOS command screen closes on it's own.
I am looking for a Step-by-Step document for setting up and configuring of database mirroring if one is available. I have gone through BOL and found some related documentation but want to see if a step-by-step document is available. If so can any one please direct me to the resource.
Hello, I am designing my first database with 5 tables for a demo project and am not sure if it works. an example below.2 of the many things I want visitors to the site to do is find a company by the industry sector they belong to,..andwhat sort of service or products they can supply. For instance a Employment agency maybe under professional services Table 1 Customer Customer_ID = primary key,,,, Sector_ID = Foreign keyComapany Name, Address, Phone, Postcode etcTabel 2 Industry SectorsSector_ID = primary key,,,,Customer_ID= foreign key banking, Education,Prof Services, etc Table 3 Trading ActivityTrading_ID = primary key,,,,Sector_ID = Foreign key, Products_ID= FkEmployment Agent, School, Lawyer etcTable 4 ProductsProducts_ID = primary key,,,,Trading_ID = foreign keySupply frozen foods, transport services, sports goods, etc Table 5 Account Account_ID = primary key,,,,Customer_ID = foreign keyAccount Name, Credit Limit, Payment Terms, Open date, Account contact etc One big point of confusion is, can I have the Customer_ID from the principal Customers tablein every table as a foreign key or must the tables be chained together one after the other as such. Advice appreciatedThanks
Hi, I need a hand with designing a database. I am collecting results from a survey which has the following questions: Call ref? How did you place your support call? Were you satisfied with the amount of time you had to wait until getting acknowledgement of the support call placed? 1 = very satisfied and 10 = very unsatisfied. How happy were you with the customer service you received upon placing the support call? 1 = very unhappy and 10 = very happy.How satisfied were you with the amount of time you had to wait until you heard from an engineer? 1 = very satisfied and 10 = very unsatisfied. How satisfied were you with the time taken to get your problem/query resolved? 1 = very satisfied and 10 = very unsatisfied Did you feel the engineer had enough knowledge to deal with your call? 1 = very good and 10 = not very good Overall how satisfied were you with the support call placed? 1 = very satisfied and 10 = very unsatisfiedIs there anything we can do to improve the quality of the support and service you received? I want to store this in a database. Obviously I want to use best practice for design, normalisation etc. The stumbling block I am coming accross is the fact that each question has a number and each question has a score from 1 to 10 and storing this in the database. Any help appreciated! Thanks Andrew
I am creating database tables for company testimonials. Database columns: name, position, companyname, comment, service we provided. My question is that for each company - may have a multitude of different services from us, and different people with different positions in the same company may make comments. What is best practice for putting this db structure together? Thanks Andrew
Can anyone tell me how can i design database architecture for the Table Category & Product...so that i can make N-level entity relation....I have database in SQL SERVER 2000.
I guess I am confused about something and need some help. I am looking at a database schema for about 20 tables in a database. I noticed that the firstcolumn in each table Is some type of Id. For example StudentId,TestId etc.Where the Id is a unique numeric sequential value. So I have some questions?1- Do these Id's act as what are called indexes for the table?(Unique indexes)2- If the answer to 1 is correct, then how do I create these unique indexes? Is it as simple as declaring the Id column as the primary key and that this value will be generated automatically upon insert? 3- Is it necessary to have an Id column for every table, or may I only do it for a few of them?4. In relation to Question2, what do I need to do, so that the Id column will automatically be created when someone inserts a value into the database table with an ID column. For example here are two sample tables StudentsInfo StudentId<PK> Name Age 1 Mark 33 2 Jill 23 3 Mary 25 PersonalInfo Name<FK> SocialSecurity Address MajorMark 324-444-3342 15 Elm ArtJill 888-888-8998 21 North ScienceMary 876-777-2344 18 Byle Music