Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.
During the Preliminary Investigation and Problem Analysis phases, an Analyst collected numerous samples, including documents, forms, and reports. Explain how these samples will prove useful for Analysis at later stages of System development.
A question has come up around the following situation where a number of analysts will building data mining models in a specific analysis services databases.
- There is one AS DB for each modeling "project" and the analysts assigned to work on the "project" are grouped together in Windows Security Groups.
- The analysts are only allowed to access the AS DB for their project. To support this security model, we've implemented scripts to create the AS DB for the "project" and then a Role is created within the AS DB called "Administrator" and the members of this role are the members of the corresponding Windows Security Group.
The AS DB, role and membership are created by a machine "admin". After the AS DB is created, it appears that the only way an analyst can build models using Visual Studio (Business Intelligence Workbench) in the AS DB while maintaining the security model is to do the following:
- Run Visual Studio (or BI Workbench) - Select File -> Open -> Analysis Services Database, then specify the database that they have access to.
In this "online" modeling environment, things are working fine. The question is -- is it possible for an analyst to create an Analysis Services Project in Visual Studio and "bind" it to already-created AS DB? This doesn't appear to work, but I may be missing something.
I have a problem where Backup Exec crashed during a backup of a SQL database and now SQL show 3 extent lock that are now redundant. These cannot be removed from Enterprise manager Is it therefore possible to remove them directly from the master database ??
I need to syncronize two separate databases. One is SQL Server the other is MySql. I don't have a lot of experience with MSSQL and need a little advice on how best (in terms of speed especially) to gather records that have been added since the last sync and any that have been modified. The table in question has datetime fields for both, the time each record was created (CreatedTime) and the time that the record was last modified (ModifiedTime). Sync will happen daily.
I have worked out a few ways I might do this with DATEADD or DATEDIFF, but my question is, what is the most effecient way? Currently I'm just looking for a way to get inserted and updated records from SQL Server to MySQL. I may have to do a two way sync of some sort later.
I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks
I was wondering if anyone could suggest a web-based help desk systemthat uses MS SQL server that also has a knowledge base and also allowssupport employees to log how much time they have spent on eachparticular ticket. I'm after an 'affordable' system that would be usedby about 35 people.Otherwise, if you can think of a better place to ask around, let meknow!Regards,Belinda
I have a client that would like to archive all of the documents .word, .xls, .pdf, .jpg, email coorespondance, etc. into some sort of database so in the near future when the project starts up again all of the information is in a clear consise format. I was hoping that this forum could provide some guidance in selecting a software package and a discussion on how to proceed.
I have 6 gigs of documents in a folder on our server. I was planning on delivering the organized data on a external hard drive after putting the data into some sort of database. I would like to include metadata about each particular document. like who created the document, Key words about the document's purpose, time frame the document is revelant for, and so on.
I would like to use a database structure and possibly hot link the document to the DB. I would like to use xml (if possible) for the metadata.
any help is greatly appreciated on this I can be reached at
Im having a hard time deciding what approach should I take. The scenario is this: I have developed various systems (inventory, HR, accounting, etc.). All this systems are (and should be) tightly integrated with one another. At present, for all these systems, i've used a single DB prefixing the tables with the systems name (eg. Inventory.Items).
My question is: did I did the right (and practical) thing? Or should I create a DB for each system to organize them? The problem with multiple DBs is some system uses the other system's table(s). Example, if i created a separate DB for accounting, and a separated DB for inventory, and another for HR, how am I going to relate inventory and HR's accounts to the accounting DB's table? I want a single instance for each table; I don't want to create another account table for inventory or HR so I can enforce integrity. And if different DBs, is there a performance impact on this?
Or is there another way? My concern is performance and manageability. Please help. Thanks!
I currently run SQL Server 2005 64-bit Developer Edition (Service Pack 2 - it will be SP 3 as soon as I can get hold of it). I am running this on a stand-alone box with Windows Server 2003 as the OS.
Soon, I will be buying another computer for a colleague who will be running SQL Server as specified above. However, I am not happy with Windows Server and am wondering about changing to either XP 64-bit or Vista 64-bit. The machine will not be networked.
I would welcome advice on this since, in some ways, I would be happy enough to use XP or Vista, and think that 64-bit development is more likely on Vista than on other Windows OS's. However, I am not convinced that SQL Server 2005 works with Vista and, like everyone else, have heard plenty of complaints about Vista.
I'm working on an income deferral problem and we are using IRR to end up calculating periodic income.
As an example, I have the following inputs:
Number of periods = 9 Initial Loan = 21.46 Instalment amount =15.30 Future value=0 Guess=0.1 (10%)
Using a compiled function from Visual Studio in SQL Server 2008 we get a result of 70.71656373
Using a Microsoft Access function we get NaN
Using Microsoft Excel we get NaN
Using a web calculator we get 70 (ish, the calculator rounds the numbers)
I know that the numbers are odd, some of our data is dirty so we do expect that. I was expecting the SQL process to kick out an error (therefore converting the result into 0), but it doesn't.
Hey guys want a suggestion from you I am a Masters Student here in USA This forum helped me a lot when I was doing internship.My university is offering tution wavier for these to jobs "1)backup systems support 2)Database admin" .I know MySql also took course for basic database . The question is if any of you please tell me what all I have to do in these job if ...if ... :) I get this job .Thanks based on your answer only I will apply for this job its 20 hrs a week commitment with college assignment .
We're planning to migrate our db to new and more disk drives, fasterRAID levels and more dedicated disk usage(e.g. placing the translog ondedicated disks). The db server runs on Win2003.Right now we're thinking about what file system to use on the newdrives. We opt for performance, but expect reliability as well.(Goeswithout saying, IMHO ;-))
I was going over this article , and was intrigued by this statement "If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express."
What are simultaneous connections? Is this related to Max worker threads defined as 255 on other editions? How does underlying OS impose how many connections can be done to SQL server. And finally how many simultaneous connections can be done in Windows Server 2003?
I want to change the (dateformat) columns in (syslanguages) tables from dmy to mdy in SQL Server 2005, but the update query did not success, and error message (Ad hoc updates to system catalogs are not allowed) .
I am using SQL 2005 with reporting services, I have very basic reports, most users can print fine with the print icon in the toolbar, some users get the Blue screen and have to reboot. They have the rsclientprint.dll loaded in the browser, we have deleted it and reloaded, what do I do ?
I am in the process of learning SSIS to step into a business intelligence role in my company, which is a Microsoft CRM/GP VAR. I plan to use SSIS for building data warehouses. However, I'm aware that my company also uses a tool called Scribe to integrate data from non-CRM systems into Microsoft CRM. Can anyone explain to me the difference between SSIS and Scribe? Can SSIS reasonably accomplish what my company now uses Scribe to do? Mostly, Scribe seems to be used for scheduled one- or two-way scheduled data pushes.
We are currently utilizing a risk management software that is using a SSMS back end. However the database is extremely normalized and hard to find data. I am looking for one particular item (column) to bounce against another report I created, to find the delta's.
I found an XML string that looks to have data captured in it, almost like VB marked up in XML. This XML has the column name (source and the desitination column). However when I go into the other tables I am unable to find either column?
Could it be that the application is referencing the XML strings in the column to present the data through the application? Is this some sort of way to prevent people from back dooring their data? Maybe I just missed the table with the column name.
I am a Windows Sysadmin (Active Directory, infrastructure, etc) with light knowledge of SQL 2005. I can set up the database cluster on a shared storage device, I know how to get the heartbeat, do simple backups, etc.
My question pertains to disaster recovery. Right now, we use a product called DoubleTake to copy our database over and 'assume' the identity of the failed SQL server. There are two problems with this -- cost of the license of DoubleTake, and additionally, is it the best method?
I have read before, that you don't need to be a DBA to set up a DR scenario for SQL. My goal really is to have two databases -- one in our production location, and one in a DR location that is pretty much cold (for licensing issues).
If our production database should go down, then it would fail over to the DR site.
What is involved in doing this, what type of steps are required, do you NEED a DBA to manage this, or can a sysadmin (such as myself) take care of it? Also, is it worth having DoubleTake to do this job, and does it do a better or worse job, are there limitations, etc.
Thank you for any replies you can give, and please keep in mind that I'm far from a DBA .
I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. Here is where I am stuck. Some systems may have multiple cases opened within the same span of another cases however we would consider this one failure:
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000 System ACase22013-07-12 16:27:50.0002013-07-12 16:29:12.000 System ACase32013-07-12 17:30:32.0002013-07-12 17:40:11.000 System ACase42013-07-12 19:00:24.0002013-07-12 19:04:14.000 System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
Lets say System A generated those 5 cases however Case 2,3 and 4 all happened within the same period as Case 1 so those 4 cases should count as one failure so my end result should be
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000 System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
And that system should show me 2 failures. I was thinking of using a temp table but not sure if that is possible as I am stumped on how to compare the dates to be able to validate if they fall within the range of an older case and whether or not to include them into the new Temp Table.
hi guys, i am having a truble in accesing the server 2005 express edition from my client systems in server 2003 domain network. i get server not accessible. whereas my domain is working perfectly. i really tried alot and i have enable tcpip and named pipes and i am still getting errors while accessing. i have also created user reights for the domain users to access sql server. still i couldn't able to access it.
please guide me to over come this issue. I'm dying.My project is similar to SAP concept project and i am doing it in a production industry.so each department as to access the data from the server to update their daily production and activity.
Hi,I have a SQL that is working fine: SELECT DISTINCT T1.ATCkod FROM ATC_tot T1 JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%' JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%' WHERE T1.Typ_lakemedel = @KodNow I need to have a description together with the ATCkod, tablename ATC columnname ATCdesc. ATC_tot.ATCkod = ATC.ATCkod. I have tried Inner join without success. Any good suggestions ...?
I would like to create table by T-SQLand need to specify DescriptionBut I can't find any sample to add Description property by T-SQL Additionally, I also would like modify Description property by T-SQL. What can I do ????? Please help me ......
Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this
UPDATE Taylors SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description:: WHERE RefNo =::RefNo::
Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'. Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers
Hello, it seems I forgot how to do it, I want to create a query to get the column description table, I mean get structure without data. I remember it was select DESC or something like that, donno if im right!!!
Hi all, I need to get the error description from the SQL Server in a SP. For ex:
I have one insert statement which is inserting some values in a tabUserMaster table. If user tries to insert any duplicated row then following error is retruned [in Query analyzer].
Server: Msg 2601, Level 14, State 3, Procedure csp_ProvisionUser, Line 70 Cannot insert duplicate key row in object 'CoreUser' with unique index 'IDX_CoreUser_UserName'. The statement has been terminated.
I want to trap this whole message in a variable. How to do this..... :(
I am having trouble bringing "description" column in to my sp and them at the out put. in the ppatient_status_mstr there is a column called“description” which has patient status such as “discharged” “termed collection” etc... How do I use the SP to bring this description into application? I am assigning it to @mytext. I am not sure how to declare “description” in the SP? Every time I use it I get errors like:
Msg 4104, Level 16, State 1, Procedure CheckStatus, Line 20 The multi-part identifier "pm.alerts_ind" could not be bound. Msg 207, Level 16, State 1, Procedure CheckStatus, Line 40 Invalid column name 'description'. Msg 207, Level 16, State 1, Procedure CheckStatus, Line 43 Invalid column name 'description'.
I want to say if user picks a description from application . show me that description in output. But I am having trouble how to use the description? I am not sure if my “IF” statements are correct either?
Here is the procedure
ALTER PROCEDURE [dbo].[CheckStatus] (@enc_id varchar(36) OUTPUT, @Mytext varchar(50) OUTPUT, @data_ind Char(1) OUTPUT) AS BEGIN DECLARE @alerts_ind char(1)