I am a student teacher who wants to futuristically create dynamic
websites featuring communication and information for both students and
parents, which link to my teacher records (grades and student portfolio
evidence documents). I am an absolute beginner to Dynamic Websites.
I am able to create static webpages in Dreamweaver MX together with
multimedia, rollovers, tables, buttons etc (I have the basic suite -
not ColdFusion). I have XP Home SP2 and all current updates,
which appears to include .Net Framework 1.1 sp1. I am running
Trend 2007 firewall. I do have basic (but old) database knowledge
and can create strings in Excel to manipulate cell data. Other
than that I learned to program in BASIC about 25 years ago (I wrote
several games such as TICTACTOE etc - so I sort of know how programing
operates. However, other than that I have never learned to
actually program or code. I'm not opposed to learning; however, I suspect that from scratch this is quite an undertaking.
I would like to install the free 'Express' packages...after searching
the web in a confused and looping mannar to find out exactly what I
need to install (and how) etc. I have investigated PHP, MySQL
etc, as well as copious quantities of .Net and ASP.Net through the
microsoft website and forums, and macromedia and other beginner
tutorials.
This is what I understand I will have to do:
install webmatrix as a web server to provide local ability to test and view my dynamic web pages.
install .Net Framework 2.0 (I only have 1.1 currently)
install SQL Express as an application side-server (I have downloaded MySQL as a database - not yet installed).
install VWD Express
install VB Express
install either C#, C++ Express (I've read that Java is not wonderfully secure or some such)
install MySQL database (I also do need a DB, don't I? - I've done
some basic tutorials and this appears easy enough to learn - I only
have Student/Teacher Office 2003, so no Access (and I can't afford to
purchase on a poor student budget)).
Is this correctt? Have I covered it all (when Micromedia MX is
included)? Is this the correct installation order? Have I
doubled up anywhere? Have I done my homework efficiently?
There appears to be a conglomeration of information, but no step by
step instructions as to exactly what is needed in order to create
dynamic webpages that are testable and viewable and exactly what order
to install them on. And lastly, will this enable me to create the
type of thing I have described as per above? Which language
should I choose - C# or C++ - I understand that C++ provides more
controlled functionality - however, isn't C# newer?
Precise answers to my queries, and advice for my misconceptions would be greatly appreciated.
PS - beginner - please don't use jargonistic language.
This is taken directly from a job requirement (names are not mentioned to protect the ignorent...I meant Innocent): The employee must occasionally lift and/or move up to 25 pounds. While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk or hear; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl.
I am considering buying a new home PC but want to make sure it can handle SQL 2005. Most of what Im looking at comes with XP Home edition. I found this:
saravanan writes "hi, At present i am a B.E. i am quite intrested in sql servers. i want to be a full fleged DBA. so please guide me , what are the basic requirements and necessary exams to be given for the same and become a DBA in a minimum required time?"
For SQL 2000, what are the licensing requirements for a clustered environment? I thought you needed datacenter for the OS, is there a clustered version of sql server, or do you need 2 copies of enterprise edition. Also, if you cluster can you license sql cals for clients, or do you have to do by processor?
I have a sql server (2k sp4), a web server and a development machine. I need to install sql server reporting services and am confused as to the prerequisites and as to what gets installed where. Is there a server install and a client install or do I run the same install on both (and deselect what's not required on each). Sorry it's a bit vague but in my research various people have told me various different things.
I couldn't find an answer anywhere on the site, if there is one, could you please let me know where to go? Thanks.
Here goes. We receive large csv files, around a million records a month. What we need to do is: - Of course, import these records - Be able to run failry heavy reports on around 3 months worth of data (about 3 million records) - Wanting to store at least a years worth of data
What I need to know: - What server(s) spec (CPU, HDD, memory, etc) would we need to import and run reports quite fast. Don't want the reports/imports to take days to run. The reports will need to be run by about 3-5 people at the same time - What OS and database type should I use (I was looking at Windows/Linux and MS SQL/MySQL) - If we run these types of reports, can we use the same SQL server to run/store other applications (eg. CRM, etc) with no real impact on performance. There would be at least 20 people using the CRM database at the same time.
Can 2005 be installed on XP Media Center Edition? I looked on the SQL site, but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
What are the minimum requirements for setting up replication ? i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
I have seen it mentioned that, unlike with the MSDE where DTS runtime was covered, the new SSIS is not covered by the SQL Server 2005 Express.
Does anybody know of an official microsoft web page detailing comprehensively what is required.
As far as I can gather the client will need a full version of SQL Server 2005, enabling the installation of the client tools, which as far as I can tell are required for the running of the SSIS.
This statement could be totally wrong but clear information seems hard to come by and seems mainly hearsay.
What security settings are needed to allow users to veiw reports using SQL Server 2005 Reporting Services Web interface. We have tried adding users to Active Directory Groups and adding these groups to: the security of the folder containing the reports in Reporting Services and the security of the individual reports in Reporting Services. What am I missing? Does something need to be set when creating the report itself?
Just one quick question, will installing reporting services require the server to reboot or sql to restart? I'll do this to a production server and just wonder if I can do while the box is in use.
I recently was moved into an applications developers position here at the lawfirm I work at. Thusfar, its been alot of straight ASP, SQL2000, and Access. I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive.. Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000? Any assistance would be greatly appreciated. Brian
hello, What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc. One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct? And i am not getting database features in xp sp2. Can any one help me?
Does anyone know where can i find an information about hardware requirements for SQL-Server 2000. I mean information of different kind of cases (amount of users and transactions etc).
I had some issues yesterday with the fact that some of the tables I had indexed views for did not have a unique/clustered index. The tables had unique indexes and clustered indexes but not a unique/clustered index. What I was seeing were rows that should have been in the view, not showing up in a regular select but they would showup in a with noexpand hint.
To fix the problem I created a unique/clustered index on each of the underlying table but cannot find that requirement anywhere, is this a requirement and if so can someone tell me where to find it.
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
We have a win2003 server box that is using MS-SQL 2000. We have a 20user license on this server at the present time. We have a need toallow up to 5 simultaneous additional users access to a subset of thisdata from our IIS server. How does this affect my current SQL ServerLicense? We can restrict access via connection pooling, etc. Can weuse a 30 user license or must we go to a CPU license? Does anyoneknow where to find Microsoft licensing information on this?
We€™re doing a website for a TV station, and they want to have a live TV broadcast on their website, our experience is basically in CMS and portal solutions, but we never had any experience in live streaming, so this is all new to us, so we€™re looking for a technical and financial proposal with your suggestions and recommendations, this is the details of the project with some of the inquiries we have: -The signal is SDI (Pal 25 fps) -The output (online streaming) 15 fps -The user will have two options to view the movie in: 1. Low: 56K 2. High: 300K -The video should come within a customized designed page, probably as a code we can place inside an html table€™s cell, not as a link for external link -We€™re expecting about 200 users for the video each month; each user€™s logon time expected 10 min. -We have a Red hat Linux on our server that will host the site, and we use php/MySql technology.
Inquires: 1. Why Windows media is better then Real in terms of performance, can you provide us with a comparison table to include it to our client? 2. If we choose Windows media, what are the requirements we need to have, form both; the TV station side, and in our Linux server? And how much would it cost? 4. Is there any hardware required from the TV station side such as DVR, or some sort of encoder, if so; what€™s you€™re recommendations (type/ brand), please note that this is a TV station and it needs a high quality professional hardware 5. How (and this is probably the most ambiguous task) 5.1. Do you broadcast the digital signal coming from the encoder (I guess) to the server? 5.2. And then place this signal on a PHP page? Do you give us a link to embed in our code? 6. If we choose to host the live streaming on a separated server and include the URL in our code, would that still required from our server to support Windows media, or it doesn€™t matter as long as the video streaming is hosted on a Windows streaming server 7. How much disk space does it need to host a live streaming (with the details mentioned above)?
We would really appreciate your comments and suggestions, as this is our 1st time to dealing with live streaming.
Hi all. First, please accept my apologies for any obvious questions, as im very new to this!Anyway, 2 small questions: I dont have the 'server running' icon in the system tray... The little grey box with a green arrow. have i installed SQL incorrectly? This leads my to my other question:- After installation (which, i think went fine), i learnt that SQL Server Express cannot run with more than 1 CPU. But i have a Duel-Core. Would this cause problems?
Again, sorry if if missed any previous posts on this.
I have been advised to design multidimensional model based on the operation data model. What I have is ---- Couple of documents about the application. Data model of operational data. Now I have been told to create a datawarehouse from which any type of wuestion can be answered. This seems horrendous. Please guide.
We need to create a SQL server login that should not be having permissions to do any changes (CREATE/ALTER/DROP) on database objects like (Tables, views).But should be able to (CREATE/ALTER/DROP) stored procedures. Also using this login they should not be able to (CREATE/ALTER/DROP) databases.
Please let me if this is feasible in SQL Server 2005.
I'm developing a website that will be suported by a SQL Server database. The estimated number of records for that database will be around one million. I'm concerned with the possibility of my machine being unable to respond to the needs of such a database so i decided to acquire a new one. How do i calculate the hard disk and RAM i'm going to need for this database to function properly ? I know that i can make a HD prediction by adding the sizes of each field of my database and multiplying by one million but i don't know how much KBs each field occupy (some of them -few- will even be free text fields). And the RAM ?
Does this look correct for MERGE SYNTAX?I want to INSERT INTO the target table,new service contracts sold with the start date,from historical table by month, only if they don't exist in the target table, doing nothing if matched. . . but the source table is indexed Fiscal Period descending and I have multiple renewal versions of the same contract number in following years. . .
MERGE dbo.SERVICE_CONTRACTS_NEW AS Target USING (SELECT r.Customer_Acct, r.[Contract], r.Start_Period FROM dbo.ACTIVE CONTRACTS r ORDER BY r.FiscalPeriod ASC) AS Source ON Target.Account_Nbr = Source.Customer_Acct AND Target.[Contract] = Source.[Contract] WHEN NOT MATCHED BY TARGET THEN INSERT (Account_Nbr, [Contract], FiscalPeriod_Start) VALUES ( Source.Customer_Acct ,Source.[Contract] ,Source.Start_YYYYMM );
I was trying to install the Developer Edition of 2005 last night, and ran into a strange issue. I specified F:SQLDev as the installation directory, but the installer still refused to install claiming lack of disk space. Checking the disk cost, I saw that it was still asking for about 1.5 GB on my C: drive. I double checked, and I did specify the installation directory as F:SQLDev.
Is there documentation somewhere that describes why it would require space on the boot drive? Or am I missing a switch somewhere or something?
I am installing SQL Server 2005 Express as part of my setup. On Windows 2003 Servers with password policy enabled, the SQL Server 2005 Express installation fails. Here is the error I am getting - "the sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.". If I disable the password policy, the SQL Server 2005 Express installation is OK.
Is there a parameter that I can pass to the command line to get around this?
Is it necessary to have SSIS installed on the Server (SQL Server) in order to run SSIS programs? Or is SSIS just a client-side, developer tool that can create and test programs against various remote data sources (SQL, Oracle, flat files, etc.)?
What must be installed on the server in order to run SSIS programs?
