At a customer of ours, the sql server is configured to 1 for degree of parallelism. The server has 8 cpu's, so what would be reason to limit this degree to 1?
I'm dealing with a server running SQL Server 2000 SP1, and the logical filenames for one of the databases appear to contain trailing spaces. That is, this query:
select replace(name, ' ', 'X')
from sysfiles
Returns the expected names plus a long string of Xs.
How can I deal with this? I've tried running ALTER DATABASE... MODIFY FILE using the name (with and without spaces) and get an error message telling me the file does not exist.
I'm trying to connect to a user session who's using remote desktop on my windows server 2003 × 2024, from task manager users but it comes up with Connect Password Required. I tried his password that he uses to log on to RD but it wont work, i tried every password i know of and nothing. How do I connect to his session? What password do i use and if that's the one why wont it work? Thanks.
I'm looking for a password manager working on Windows, MacOSX and iPhone.
The password would be stock in the cloud so if I had a password into my iPhone it would automatically sync my PC and my Mac and vice versa.
I'm a CS uni student in a country with limited bandwidth, and I find that I download files (particularly install files) for reuse\reinstallation\giving to my friends.. I've kept these files in different folders, and now find it extremely hard to find them, and keeping track of obselete files (the almost weekly releases of iTunes versions, or latest 7zip release or the .Net framework installers). What I would like to find is a file manager that could support tags, so instead of hierachical folders, i could find\view files according to their tags...
I have an HTTP Server Service application which has its own logging mechanism. It's written in Delphi. I would like to provide a way for multiple clients to connect to this service and get a real-time update of the log. The log in the service moves rather fast, there's a lot of things to log. There may be up to 50 messages within 1 second at times. The existing log which is already implemented is not saved, it's only kept in the memory of the server service - where I will need to distribute it to any client which needs it. Once all clients have a log message, it should be deleted.
I intend to use HTTP to "ask" the server for the log, and respond with an XML packet. The connections are not keep-alive. The only problem is, the server should only send the client those log records which it needs, not everything. I have no way of the server pushing the log to the clients in real-time, so each client needs to repeatedly ask the server for the latest log records. This HTTP Server is very lightweight, and there is no session management. There isn't even any type of authentication.
The only way I see is for a client to register its self on the server, and whenever a log is issued on the server, it creates a copy of the log for each client, where each client has a log queue (string list). However, suppose there are 100 clients connected and expecting to receive this log. That means the server must create 100 copies of each log, add this log to the end of each client log queue, and wait for the client to request it. At that point, when the server replies with the XML log, it should flush (delete) whatever's in the queue. I'm worried however that this could cause memory issues. Each client log queue might get 100 log messages before the client requests the latest logs.
How should I go about doing this in the fastest way possible without hindering the performance of the server? I'm trying to avoid having to create a copy of each log for each client.
How do I disable the Gnome window manger keyboard control for control-alt-arrow (left, right, up, and down arrows) to scroll between workspaces?
This is a key binding I use in Emacs and the window manager is snarfing it before it gets to Emacs.
I'm looking for something I can install on a Linux server to create a remote calendar that I can sync with my iPhone.
Anything requiring setting up an Exchange Server connection on the iPhone is out since I already have one set up for work. I'd like to avoid a groupware package since all I really want is a calendar.
SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, our internal hosting group uses the default SQL Server 2005 collation SQL_Latin1_General_CP1_CI_AS. What are the potential issues we might face with MOSS 2007?
We're currently using SQL Server Express 2008 as backend for our TFS2010 install (Basic). Would it be possible to move to the standard (or better) version of SQL Server without any big hassels?
A quick question.
How many copies of the same movie are kept in a video server (a video streaming server)? Suppose a particular video is at max requested by 1000 users at the same instant of time, how many copies would be sufficient so that parallel streams can be provided to each user? Ideally 1 copy would solve the purpose, but what is the optimum number keeping the bandwidth and simultaneous access in mind?
Is there any way to allow access a network share on Windows Server 2008 to a specific Vista Home machine/user?
I have two Vista Home machines on my network (ugh) and I need a user from one of them to be able to access a network share on my new server 2008 DC. How ever I don't want to just allow "everyone" access.
When I boot Ubuntu from my USB hard drive, it says "Missing Boot MNGR". It only boots from CDs and DVDs.
This is an Acer Aspire with Windows 7 boot manager.
I wrote a small utility to script some key SQL Server configuration information. I had two goals for this utility: Assist with disaster recovery preparation Identify configuration changes I’ve released the application as open source through CodePlex. You can download it from CodePlex at the Script SQL Server Configuration project page. The application is a .NET 2.0 console application that uses SMO. It writes its output to a directory that you specify. Disaster Planning ScriptSqlConfig generates scripts for logins, jobs and linked servers. It writes the properties and configuration from the instance to text files. The scripts are designed so they can be run against a DR server in the case of a disaster. The properties and configuration will need to be manually compared. Each job is scripted to its own file. Each linked server is scripted to its own file. The linked servers don’t include the password if you use a SQL Server account to connect to the linked server. You’ll need to store those somewhere secure. All the logins are scripted to a single file. This file includes windows logins, SQL Server logins and any server role membership. The SQL Server logins are scripted with the correct SID and hashed passwords. This means that when you create the login it will automatically match up to the users in the database and have the correct password. This is the only script that I programmatically generate rather than using SMO. The SQL Server configuration and properties are scripted to text files. These will need to be manually reviewed in the event of a disaster. Or you could DIFF them with the configuration on the new server. Configuration Changes These scripts and files are all designed to be checked into a version control system. The scripts themselves don’t include any date specific information. In my environments I run this every night and check in the changes. I call the application once for each server and script each server to its own directory. The process will delete any existing files before writing new ones. This solved the problem I had where the scripts for deleted jobs and linked servers would continue to show up. To see any changes I just need to query the version control system to show many any changes to the files. Database Scripting Utilities that script database objects are plentiful. CodePlex has at least a dozen of them including one I wrote years ago. The code is so easy to write it’s hard not to include that functionality. This functionality wasn’t high on my list because it’s included in a database backup. Unless you specify the /nodb option, the utility will script out many user database objects. It will script one object per file. It will script tables, stored procedures, user-defined data types, views, triggers, table types and user-defined functions. I know there are more I need to add but haven’t gotten around it yet. If there’s something you need, please log an issue and get it added. Since it scripts one object per file these really aren’t appropriate to recreate an empty database. They are really good for checking into source control every night and then seeing what changed. I know everyone tells me all their database objects are in source control but a little extra insurance never hurts. Conclusion I hope this utility will help a few of you out there. My goal is to have it script all server objects that aren’t contained in user databases. This should help with configuration changes and especially disaster recovery.
Hi,
Can you recommend a password manager that syncs between an iPhone and (at least one, preferably several) Windows XP computers? Being able to generate passwords would of course be a nice addition, but is not required.
Thanks.
hello.my network manager in opensuse 11.2 kde environment not working.after clicking.nothing action is being takes place.what should i do.i have to connect to the internet thriugh this.i have airtel macromax usb plug and play device
Hi Guys,
We get a weekly Summary Network Report from our SBS 2008 server, delivered by email.
The report contains many alerts. We want to ignore some of them so that the report is all green and any alert will stand out. For example, we want to ignore the alert regarding the firewall being off on the server.
Is there a place where I can select what points to check and the level of some alerts (such as low remaining disk space), etc?
I'm having a rather tough time finding information on this since almost everything I read requires Management Studio installed in the server which I prefer not to do.
Also, to connect to it using SQL Server Management Studio installed on the client, are these settings ok?
ServerName: 10.232.234,1433\SQLEXPRESS
Login: sa
Password: password
Yes, I want to specify the port number in the client side since I have to go through a few firewalls which I have poke holes through to get to the SQL Default port 1433.
I bought a small 256MB slice from slicehost and installed Ubuntu 10.04 64bit and wordpress on it. Performance was dismal as apache was eating up all my memory. Once I did some taming of apache and switched to fCGI things ran fine.
Next I rebuilt as a 32 bit server, and performance was much better.
What benefit would I get from a 64 bit server. Is it all about the memory?
While i'm sure i can write a CRON to do this and some how open the ports on a network hd in my house, to be honest i'd rather spend a bit of money on some good software with a nice visual interface..
are there any such all-in-one server backup systems?
nightly backups of the MYSQL db
weekly backups of entire site (images etc)
my server is a VPS hosted by https://www.memset.com
Id like to know the answer to this question:
Are there any server hosting plans out there that provide a physical modem connected to the machine? I am writing an app that needs to send commands directly to a modem physically attached to the machine (obviously, it needs to be a dedicated server).
I'm doing the following to mount a remote server to a specific path on my server:
sshfs [email protected]:/backup/folder/ /home/myuser/server-backups/
However when I mount the server the folder permissions change (they become 700), and when I test my rsnapshot.conf file I get the following error:
snapshot_root /home/myuser/server-backups/ - snapshot_root exists \
but is not readable
What am I doing wrong ? should I mount the remote server with another user ?
There are numerous advantages to server scripting languages over client side languages in regards to creating web sites that are more compelling compared to a standard static site. Server side scripting are scripts that are executed on a web server during the compilation of data to return to a client. These scripts allow developers to modify the content that is being sent to the user prior to the return of the data to the user as well as store information about the user. In addition, server side scripts allow for a controllable environment in which they can be executed. This cannot be said for client side languages because the developer cannot control the users’ environment compared to a web server. Some users may turn off client scripts, some may be only allow limited access on the system and others may be able to gain full control of the environment. I have been developing web applications for over 9 years, and I have used server side languages for most of the applications I have built. Here is a list of common things I have developed with server side scripts.
List of Common Generic Functionality
Send Email
FTP Files
Security/ Access Control
Encryption
URL rewriting
Data Access
Data Creation
I/O Access
The one important feature server side languages will help me with on my website is Data Access because my component will be backed with a SQL server database.
I believe that form validation is one instance where I might see server-side scripts and JavaScript used interchangeably because it does not matter how or where the data is validated as long as the data that gets inserted is valid. However, I would have to say that my personal experience would have to sway me in deciding what type of languages to use for form validation because they both have advantages and disadvantages based on the each situation.