How to modify SQL information into specific models, eg dropdownlists
Hello,
We are using ms sql atm and we have successfully established a JDBC connecting, between our database and frontend on HTML/JSP We have also successfully retrieved column information but cannot model it into any other form. We are using NetBeans to establish the connection. If anyone could help insert the information into a drop-down menu we woudl be greatful. The following is what we have and what we have been trying.
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<table id="table1">
<input type="text" id="textbox1" value="">
<input type="submit" id="buttonz" onclick="hoping">
</table>
<sql:query var="result" dataSource="jdbc/Test">
SELECT*
FROM ERIT
</sql:query>
<table border="1">
<!-- column headers -->
<tr>
<c:forEach var="columnName" items="${result.columnNames}">
<th><c:out value="${columnName}"/></th>
</c:forEach>
</tr>
<!-- column data -->
<c:forEach var="row" items="${result.rowsByIndex}">
<tr>
<c:forEach var="column" items="${row}">
<td><c:out value="${column}"/></td>
</c:forEach>
</tr>
</c:forEach>
</table>
</body>
</html>
- Edited by AZeBuilder Thursday, April 19, 2012 7:35 AM
- Changed type Papy Normand Thursday, April 26, 2012 5:22 PM not related to SQL Server Data Access
Reply:
I am sorry to tell you that this forum is not suitable for this question though your question is related to sql server somewhere. It says this forum is for data access to SQL Server using SQL Native Client, OLEDB, ODBC, ADO, WDAC/MDAC, JDBC, or SOAP/HTTP.. But your question is more about web page. It's better to ask it in a jsp forum or asp.net forum. More related professors there will miss this related questions if it posted in this forum.
smiling~
------------------------------------
List Visible to only specified member
Hi,
I have created 1 custom list.
and also created a list new form for same custom list on default page of Sites. now i want give permission to this list.
means only specified member should only able to see this list form. please let me know what are d alternative solutions
- Edited by Nilesh Nimje Monday, April 23, 2012 6:38 AM
Reply:
Hi Nilesh Nimje,
You can stop inheriting permission associated to that item and then assign specfic permission.
- Point your mouse to the arrow icon in the item list and select Manage Permissions.
- In the ribbon, click Stop Inheriting Permissions in the Inheritance group. The new popup appears asking you to comfirm the inheritance. Click OK.
- Click Grant Permissions in the Grant group.
- In the Grant Permissions windows, select Grant users permission dierctly and then select specific permission you want.
This document greatly meets what you need: Best practices for using fine-grained permissions (SharePoint Products and Technologies)
Regards,
T.s
SharePoint in Vietnam | Blog | Twitter
- Edited by Thuan SoldierMVP Monday, April 23, 2012 7:01 AM
------------------------------------
punteggi, visual basic 2010 per windows phone
Salve a tutti
Ho creato la mia prima app per windows phone in visual basic e vorre far in modo che clickando un tasto si possa scrivere il proprio nome e salvare il punteggio attuale solo se questo risulta superiore uno dei 10 punteggi gia` archiviati.
Ossia:
1) Come faccio a far in modo che si crei un file con le "highscores" e che questi accetti solo 10 punteggi/utente?
2) Come faccio a far sovrascrivere il "punteggio attuale" se maggiore di uno di quelli presenti?
Purtroppo ho trovato solo pochi esempi e solo in c# ma a me servirebbe in VB2010.
Grazie a tutti per il vostro tempo
- Moved by Jesse Jiang Tuesday, April 24, 2012 7:38 AM (From:Windows Mobile Development)
Reply:
------------------------------------
Creating a Mirrored boot disk... EFI partitions don't exist
I have tried following http://support.microsoft.com/kb/951985 but the boot disk that I am wanting to mirror doesn't have the EFI or MSR partitions as described in step 4b
Partition ### Type Size Offset ------------- ---------------- ------- ------- Partition 1 System 200 MB 1024 KB <- EFI PARTITION Partition 2 Reserved 128 MB 201 MB <- MSR PARTITION Partition 3 Primary 50 GB 329 MB
When I installed the original OS (2008 (x64) R2, Standard), I deleted the partitions (via the install gui) and then let the install create the new one(s). After installing all I have is two primary partitions. No mention of "System" or "Reserved".
- Changed type Vincent Hu Wednesday, April 25, 2012 1:39 PM
Reply:
Does your BIOS support EFI?
Regards
Milos
------------------------------------
Reply:
Is your current system disk a MBR or GPT disk? Please select the system disk in Diskpart on your computer and then run list partition command, paste the output here.
- Edited by Vincent Hu Thursday, April 26, 2012 7:39 AM
------------------------------------
solved
solved
- Edited by iamveryblur Monday, April 23, 2012 3:42 AM
- Changed type Nicholas Li Wednesday, April 25, 2012 8:04 AM
Reply:
------------------------------------
Sharepoint 2010 - When a Webpart is hidden for visitors it affects the UI in IE 7
Hi,
I am working on a Blog Site in sharepoint 2010. The Blog Tools Webpart which is by default there in the site is visible only for groups who have contribute access to the Post list . But it is not visible to Vistors . It is affecting the UI in IE 7.It looks fine in IE 8 .I have appiled a custom master page to my site.
Please guide in resolving this Issue.
Thanks,
Pallavi
- Moved by Lhan Han Friday, April 20, 2012 1:28 AM sp2010 (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
Reply:
It is correct that uses at least need to have contributor permission to see the "Blog Tools" web part. Users with visitors permission cannot see the "Blog Tools" web part. It is normal.
I would like to confirm the exact symptom you mean on IE 7 and IE 8.
Best Regards,
Sally Tang
------------------------------------
What is a good enterprise general set up for a window server to practice on at home? Give you own set up if possibe along with specs such as memory or how much hdd used to make the setup happen?
Reply:
Might check out technet labs as well.
http://technet.microsoft.com/en-us/virtuallabs/bb467605
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
------------------------------------
Reply:
To set-up your test environment, download these items.
Download Windows Virtual PC
http://www.microsoft.com/windows/virtual-pc/download.aspx
Download Evaluation version to try out Windows Server 2008 R2
http://www.microsoft.com/en-us/server-cloud/windows-server/2008-r2-trial.aspx
Download Windows 7 Enterprise 90-day Trial
http://technet.microsoft.com/en-us/evalcenter/cc442495
Make sure you enable Virtualization Support for your Laptop/Desktop to start with.
Configure BIOS for Hardware Assisted Virtualization (HAV) PCs
http://www.microsoft.com/windows/virtual-pc/support/configure-bios.aspx
Use the steps here to promote your first DC-
Windows Virtual PC Evaluation Guide
http://technet.microsoft.com/en-us/library/dd744684(v=WS.10).aspx
How to promote Windows Server 2008 machine to domain controller – step-by-step guide
http://www.brajkovic.info/windows-server-2008/how-to-promote-windows-server-2008-machine-to-domain-controller-step-by-step-guide/
Sachin Gadhave (MCP, MCTS)
------------------------------------
Reply:
Hello,
beside the already given information it will be helpful to know what you are trying to test for?
For Microsoft certification labs, mostly 2 DC/DNS/GC will be enough, additional 2 member servers and 2 client OS machines.
Sometimes only 1 of each will be required. This depends really on the courses you'll take.
My lab for testing and playing with new OS is mostly 2 DC/DNS/GC, 1 member server and 1 client machine.
Enterprise level from my point of view consist of a forest with child domains, multiple sites and a routed network, which you cannot really simulate with one computer and only using VMs on this machine.
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/
Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
OK thanks Meinolf Weber what you gave as a reply was really what I was actually asking for as far as set up I really appreciate it. But what do you mean by GC? I think I know what it means but I am not sure. Also what I am trying to test for is the Enterprise Administration level certification and of course the Server Administrator Certification before that. If you have any more info reguarding this information to add to this discussion I would greatly appreciate it now that I have giving you what I am trying to test for.
Also do you know any good resources that I can use to study for that help me pass my certifications for Windows Server or a foundation that I can start out as to get to Enterprise Certification that give me a good foundation.
------------------------------------
Reply:
Thank you Dave I really appreciate it I didnt know that Microsoft offered this as far as practicing for different software this would be a good start to learn and a get a good hands on Windows Server and building my forest. I really appreciate your help and time to responding to my question. If you have any more information please feel free to give.
What resources did you use to get the certification that you are at now?
------------------------------------
Reply:
Also for the credentials you gave me for the Microsoft Certification Labs how much memory and HDD space will you think I need to control all of that.
Memory and HDD for 2 member servers and 2 Client machines and also 1 of each as far as member server and client each per network if I went that route?
------------------------------------
Reply:
- Merged by Tiger LiMicrosoft employee Monday, April 23, 2012 8:30 AM
------------------------------------
Reply:
Hello,
GC = Global catalog server, by default the first installed DC in the domain and it is recommended to have at least 2 per domain, more details in http://support.microsoft.com/kb/223346/en-us
For the preparation of the exams you will have the lab courses for basic configuration and learning already prepared for the specific course you'll take. In your case you should think about the self-paced learning books as series or single ones.
Be aware that you need a powerful machines to have multiple VMs running. At least 4GB RAM and a dual core processor should be minimum. Hard disk space of course is also important as the VMs are roundabout 10 GB size, depending on the installed server roles.
Server administrator http://www.microsoft.com/learning/en/us/book.aspx?id=11759&locale=en-us
Enterprise administrator http://www.microsoft.com/learning/en/us/Book.aspx?ID=15653&locale=en-us
Please compare them as they are different in only one exam, so it may be cheaper buying the single book alone, 70-646, and the Enterprise Core pack.
For certification details please use the following forum http://social.technet.microsoft.com/Forums/en-US/CertGeneral/threads
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/
Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
Hello,
please stick to one thread only per topic http://social.technet.microsoft.com/Forums/en/winservergen/thread/4e676d92-e2e4-4762-b271-6dc925d3ddcd
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/
Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
1. First of all, Use official study guides that MS Press, in your case it is
MCITP Windows Server 2008 Server Administrator: Training Kit 3-Pack: Exams 70-640, 70-642, 70-646
2. Very useful are books
Morimoto, R, et.all : Windows Server 2008 R2 Unleashed, SAMS
Minasi,M,et.all: Mastering Microsoft Wiindows Server 2008 R2,SYBEX
Regards
Milos
------------------------------------
Reply:
When you say 4GB of ram did you mean that as far as per DC or did you want it split between 2 Dc's as 2 GB per domain controller?
Also you were saying have at least 10 GB per VM unless I an doing a redundant DC of course am I correct?
------------------------------------
Reply:
Hello,
"When you say 4GB of ram did you mean that as far as per DC or did you want it split between 2 Dc's as 2 GB per domain controller?"
i am talking about the machine used for the installation from VMware, Virtual PC or whatever hypervisor you will use to built your lab machine.
"Also you were saying have at least 10 GB per VM unless I an doing a redundant DC of course am I correct?"
VMs with the new OS version will grow up to 10 GB size each and sometimes more, so you have the need for enough disk space on the machine storing the VMs. So with 2 DCs and one member server you need at least 10 GB per VM + the virtual RAM you configure for each, 1GB is enough to learn, so this counts up to at least 33 GB space only for the VM part, still can be more.
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/
Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
- Edited by Meinolf Weber Sunday, April 22, 2012 5:07 PM
------------------------------------
Reply:
So you are saying install Windows Server with 1GB of ram and then have my 2 DC's with 1GB of Ram for those as well and a member server with 1GB or ram then with inall all 3 of these VM's have 10GB of Virtual Hard Drive space for each VM. Is that correct of what you are trying to say?
If I went with 2 GB of ram how much room would that give me to do more as far adding more roles. If I added more roles to learn more what roles would you recommened or say if I added every role how much ram would I need for that. I am asking becasue I think in the Microsoft books they take you through all the roles so I am saying if I wanted to do all the roles how much ram would youthink I need then to install in each domain and then in member servers to follow up with along with HDD space if you know and if not do you know where i can find this information at?
------------------------------------
Reply:
Already enough info. has been supplied on this topic however, here are my 2 cents.
For practice, you do not need 2 DCs (Meinolf already suggested this option)
Here are the specs of my lab setup.
Host machine - laptop with 2 GB RAM,160 GB HDD and Intel Core 2 duo processor ( VT enabled ), Win 7 64bit
I use both Windows Virtual PC and Oracle VM virtualbox; I do not prefer VMware Workstation as its a commercial application as well a resource hungry application when compared to Win virtual PC and Oracle Virtual Box.
I run VMs with bare minimum requirements.
Win XP - 128 MB RAM & 4 GB HDD
Win 2003 - 256 MB RAM & 4 GB HDD
Win 7 - 512 MB RAM & 10 GB HDD
Win 2008 - 512 MB RAM & 10 GB HDD
Win 8 Consumer Preview - 700 MB RAM & 20 GB HDD
Win Server 8 Beta - 700 MB RAM & 25 GB HDD
P.S. HDD used for VMs are Dynamically Expanding Disks !
If you are planning to setup SCCM and Exchange, then you need separate VMs with higher RAM.
Some suggestions here which are applicable ONLY for VMs used for practicing ( LAB Setup )
Always use dynamically expanding disks ( you get this option when setting up virtual machines both in Virtual PC and Virtual Box ) in that way, only committed disk space is used, will not occupy much hard disk space.
You can use Trial Versions of Operating System for testing ( no need to register them )
Always use Internal Network as virtual NICs (both Virtual PC and Virtualbox)
Do not access Internet on Virtual machines to avoid any malware infections( Internet will be enabled if NAT is used in virtual NICs )
Do not install AV on virtual machines that will simply overburden virtual machines
Patch updates are not needed on lab machines as those will be used only for practicing
Once an OS is installed on a VM, its better to create a backup (backup .vhd or .vdi files), if at all a VM is screwed up while doing testing, you can simply delete the VM and use the backed up .vhd or .vdi file to get new VM up and running in few minutes of time !
Hope that helps
A UNIVERSE without WINDOWS is CHAOS !
This posting is provided "AS IS" with no warranties or guarantees and confers no rights.
About Me !!!
- Edited by Santosh Bhandarkar Monday, April 23, 2012 3:25 AM typo
------------------------------------
Metro Start Screen and Search
When using the start screen the search functionality adds extra steps over the previous methods used in the instant search of Windows 7 and Windows Vista.
Previously, for example, if I wanted to open a file called "bridges" I could type "bridges" into the instant search, and I would get a consolidated list of applications, settings and files that related in some way to the text I typed. If my search was precise enough then I could just hit enter, irrespective of the type of result (be it App, Setting or file). I could also just use the arrow keys to go through the list for less precise results.
Now the type of result is segregated into Apps, Settings and Files. So even if the result provided zero Apps or settings but one file result, I must click on "Files" and then select the result I am after.
I would love to see a consolidated result list that provided all results based on relevance irrespective of the type of file so if I know what to type to get the search to hit the bullseye so to speak. It will do just that. It would be great to see the results categorised into ALL, Apps, Files and Settings.
Additionally because the Start Screen does not support context menus like before, it is not easily possible to perform an alternative action to a search result, such as "send to", "open with", "open location" or "properties", these are things that I commonly did with the start menu in the past that will be missed dearly when moving to Windows 8.
I love the idea of Metro, and I hope it succeeds, however I hope that these shortcomings can be addressed before release.
Thanks.
PokeyStuff
Reply:
When using the start screen the search functionality adds extra steps over the previous methods used in the instant search of Windows 7 and Windows Vista.
Previously, for example, if I wanted to open a file called "bridges" I could type "bridges" into the instant search, and I would get a consolidated list of applications, settings and files that related in some way to the text I typed. If my search was precise enough then I could just hit enter, irrespective of the type of result (be it App, Setting or file). I could also just use the arrow keys to go through the list for less precise results.
Now the type of result is segregated into Apps, Settings and Files. So even if the result provided zero Apps or settings but one file result, I must click on "Files" and then select the result I am after.
I would love to see a consolidated result list that provided all results based on relevance irrespective of the type of file so if I know what to type to get the search to hit the bullseye so to speak. It will do just that. It would be great to see the results categorised into ALL, Apps, Files and Settings.
Additionally because the Start Screen does not support context menus like before, it is not easily possible to perform an alternative action to a search result, such as "send to", "open with", "open location" or "properties", these are things that I commonly did with the start menu in the past that will be missed dearly when moving to Windows 8.
I love the idea of Metro, and I hope it succeeds, however I hope that these shortcomings can be addressed before release.
Thanks.
PokeyStuff
My sentiments exactly. The loss of the context menu is the biggest setback. I would routinely use "Send To," "Open with," and "Open file location."
You can still use context menus when searching, kind of. To do so, you must initiate a search from the Windows Explorer search box.
------------------------------------
Windows 7 & Excel, docking bug
Hej,
So the other day I was using Excel for some work I needed to do. Maximized the window with the mouse, very nice feature in 7. Ups, wrong minotor I docked the window on. So I wanted to move it to the other monitor. But wait, I could not undock it when trying to undock it from maximized with the mouse. So clearly a bug ... wheater its in Windows 7 or Office that causes the window to not be undockable from maximized I dont know ...
Its no problem when its docked to either left or right ... but, not impossible to undock from maximized with the mouse ...
Its also written here: http://ifyoudo.net/post/2009/09/14/Windows-7-Excel-docking-bug.aspx
best regards
Mikael Syska
MIS
- Changed type Dale Qiao Tuesday, December 1, 2009 8:31 AM Feedback
Reply:
Do you mean that you want to move the excel from one monitor to another in maximized window? How are two monitors positioned, in row or in line? Sometimes it isn't convenient to dock the window using the mouse. I recommend you to use combination keys to dock the window and see if it works.
Maximized: Win + Up
Minimized: Win + Down
Right: Win + Right
Left: Win + Left
Hope it helps.
Dale
------------------------------------
Reply:
Hi,
Do you mean that you want to move the excel from one monitor to another in maximized window? How are two monitors positioned, in row or in line? Sometimes it isn't convenient to dock the window using the mouse. I recommend you to use combination keys to dock the window and see if it works.
Maximized: Win + Up
Minimized: Win + Down
Right: Win + Right
Left: Win + Left
Hope it helps.
Dale
I know its possible to do that ... but as I descriped above ... you can't undock it with the mouse and you can with all other windows when its maximized ...
And yes, you can undock it with the win + Arrows ... but still ... I see this as a bug that its not possible with the mouse.
// ouT
MIS
------------------------------------
Reply:
Best Regards
Dale
------------------------------------
Reply:
I got this link send from a microsoft employe that said I should try and post the bug here, and now I know its beeing taking care of.
mvh
MIS
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
And now 2012 - and its still not cured. The Excel developers have always had this odd idea that they need to be different - even in the customisation screens you cant Browse to set say the default Save path - why?
------------------------------------
Social website
hello any1 there to support?
Reply:
I want to disccuss some about new social website
------------------------------------
Reply:
Please mark my response as an answer if appropriate.
Learn.SharePoint.com
------------------------------------
Filtering data in SSRS.
Hello all,
I have created a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset. The dataset retrieves data by executing a stored procedure. The report contains a table and a matrix that use the dataset. I need to limit data that is displayed in the table while ensuring that the matrix is unaffected. What should I do?
A. Add a filter to the dataset.
B. Add a filter to the matrix.
C. Add a filter to the table.
D. Add a parameter to the stored procedure that filters the result set.
Pankaj Kumar Yadav-
- Edited by Pankaj067 Sunday, April 22, 2012 1:15 PM
Reply:
Hi Pankaj,
The earlier down the line you do the filtering, the better the report performance will be. If you were to filter the matrix or table your report would have to retrieve all the data from the stored procedure and then filter out the unwanted values. This adds overhead to the report processing time.
I would do the filtering in the stored procedure if that gets the result you want in your report. To ensure your matrix is unaffected, have your stored procedure return at least one of each value you want to show up in your matrix, even if the measure is null. You can accomplish this by doing an outer join on the matrix values. For example, if you want one column for each month, you can take your result set from your query and outer join it on the date table:
SELECT DT.Month, MQ.* FROM myquery as MQ right outer join
(Select distinct Month from DIM_Date) as DT ON DT.Month = MQ.Month
In this way you will end up with at least one row of data for every month.
Cheers,
Martina
Martina White
------------------------------------
Reply:
Hi There
I think you need to put a filter on the tablix in this case. you can bring the data from stored procedure once and your matrix will consume the whole data. As your requirement says that you just need to filter the tablix just put a filter on tablix. This is what I think recommend as best practice.
I hope this help
Many thanks
Syed Qazafi Anjum
------------------------------------
Seriously I still have to develop Log in SQL Server?
Hello!
For the record,
Microsoft could ever leaving native to each table creation a log table that would be supplied with basic information pertaining to log as User, time, information changes, etc.. it could appear on and could trigger a user-configurable fields with parameter passing in black box scheme.
I hope the folks at microsoft have understood, I think I have very archaic to automate something that could already be easily automated. Wanna waste my time in business and not in detail, important, but to development is detail.
Thanks for the available space and attention.
For the record, I know the audit. But you have to connect the monitor server resource consuming and not necessarily might get interested in a cost-efficient logging of all transactions, or make them on the same server, etc..
Alessandro.
Reply:
Might you elaborate more your question here ..?
Shehap (DBA /DB Analyst/DB Architect) Think More deeply of SQL Stress Stabilities
------------------------------------
Reply:
1. Not all the businesses would need it.
2. I believe developing such solution would be time/money consuming and not be used by many.
You can file a request on connect.microsoft.com for better attention and response from Microsoft Product Team.
Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter
------------------------------------
Exchange 2007 Message Tracking Log Parsing
Good Day,
I am able to get a csv file from the exchange 2007 message tracking log using the Get-MessageTrackingLog cmdlet using exchange management console. Find below a single line from the csv file along with headers;
Timestamp,ClientIp,ClientHostname,ServerIp,ServerHostname,SourceContext,ConnectorId,Source,EventId,InternalMessageId,MessageId,$_.Recipients,$_.RecipientStatus,TotalBytes,RecipientCount,RelatedRecipientAddress,$_.Reference,MessageSubject,Sender,ReturnPath,MessageInfo
"2/27/2012 12:10:38 PM",192.168.1.100,exchange1.test.local,192.168.1.100,exchange1,,,STOREDRIVER,RECEIVE,9,<user2@test.com",,7988,2,,,"FW: New Domain ",testuser@iprocess.com,testuser@iprocess.com,04I:
Please excuse the wrapping. If you notice, the "$_.Recipients" field has multiple email addressess when the email is sent to multiple users. What we'd like to do is, replicate the entry for each recipient so that the output looks something like this;
"2/27/2012 12:10:38 PM",192.168.1.100,exchange1.test.local,192.168.1.100,exchange1,,,STOREDRIVER,RECEIVE,9,<",,7988,2,,,"FW: New Domain ",testuser@iprocess.com,testuser@iprocess.com,04I:
"2/27/2012 12:10:38 PM",192.168.1.100,exchange1.test.local,192.168.1.100,exchange1,,,STOREDRIVER,RECEIVE,9,<user2@test.com",,7988,2,,,"FW: New Domain ",testuser@iprocess.com,testuser@iprocess.com,04I:
The recipients are delimited by a single space.
Im beginning to dwelve into powershell, though Im no expert. Any help on this would be greatly appreciated.
Regards
Crackinspine...
Reply:
Although I am no expert in PowerShell either, I have done a bit of looping with CSV files. A possible solution to this would be to create a loop off that one variable. if it were stored in an array you could do something like this:
$log = Import-Csv c:\messagetrackinglog.csv
foreach ($line in $log)
{
foreach ($Address in $line.Recipients){
write-host $line.timestamp,$line.ClientIP,$line.ClientHostname,$Address
}
}
It may need some tweaking, but this should give you a good start.
JAUCG
------------------------------------
Split to Off-topic forum
- Split by Max Meng Monday, April 23, 2012 2:05 AM Split for format
Windows 7 problems using Internet Explorer 8 -vs- Firefox 3.5
- Changed type Ronnie VernonMVP Wednesday, July 22, 2009 7:02 PM Comment
Reply:
Seems to work fine since i installed Windows 7 approximately 1 month ago. However, find some problems trying to access Yahoo Mail & Facebook when attempting to use Internet Explorer 8. No problems accessing Yahoo Mail or Facebook using Firefox. FYI
Have you tried download Internet Explorer 9? Are you using 32 Bit or 64 Bit?
------------------------------------
Thinking of Building a RAID 0 Array From Three or Four 480 GB SSDs - Your Thoughts?
At the moment on my Dell Precision workstation I have a 2 TB C: partition made from two spinning Western Digital RE4 1 TB drives. Performance is quite good, but there are some big operations on this powerful system that I find are still limited by drive throughput.
Specifically, things like Visual Studio-based software builds, which access many, many different files (not to mention write a lot of files) seem to be limited not so much by throughput as by the fact that so much head seeking has to take place to get the jobs done. And yes, my drives are defragged (automatically by Windows). Another drive-limited operation is my occasional use of Photoshop for graphics-intensive work on very large files, and still another is VMware virtual machine operation.
My current WD RE4 (spinning) drives have big RAM caches (which of course add together in RAID arrangement), but that's not nearly enough.
I have used about 800 GB of space on drive C: so far in 2+ years of hard Windows 7 use, so I may not need a full 2 TB capacity. I use D: (another large spinning drive) for storage of data that doesn't need super high speed access.
To increase throughput on this system, I've been looking at OCZ Vertex 3 VTX3-25SAT3-480G 2.5" MLC Internal Solid State Drives.
Specifically, I'm considering replacing my two current spinning drives with, say, three or four of these fast SSD puppies in order to put disk performance through the roof.
At the moment I have an on-motherboard RAID controller with 3 x SATA2 connectors to spare, though I believe getting a modern dedicated RAID controller with SATA3 ports will be a good idea, as these OCZ drives can outperform SATA2. I'm not sure which to get though.
What are your experiences in using multiple SSDs to make a large RAID 0 partition?
Actual experience would be very helpful here; I'm aware of a lot of information (and misinformation) about using SSDs in RAID. I welcome everyone's comments, but please refrain from speculation.
Thanks in advance!
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
- Changed type Arthur Xie Thursday, April 12, 2012 6:22 AM
Reply:
Be aware that TRIM is not supported in RAID mode at this time. OCZ SSDs feature built-in garbage collection to ensure optimal performance after time, and you can also create an image of your RAID array to be restored following a secure erase of each individual drive. Secure erasing each SSD and then recreating the array will allow for maximum performance.
HTH
Milos
------------------------------------
Reply:
Thanks, Milos.
Performance degradation owing to write amplification is not a good plan... Maybe the two technologies (RAID and SSD) are not quite ready to be married yet...
I wonder whether one of the OCZ PCIe cards (e.g., the high performance RVD3MIX2-FHPX4-960G MAX IOPS model) might be an even better solution. It claims all the performance that I could get from 3 or 4 SATA3 drives in a RAID arrangement but without the secondary issues. It handles TRIM, for example.
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
------------------------------------
Reply:
Hi,
To use multiple SSDs to make a large RAID 0 partition will not allow for maximum performance. TRIM is not supported in RAID mode when you using SSDs.
------------------------------------
Reply:
Ivan-Liu, you appear to be repeating or rephrasing a lot of very muddled lore to be found out there about SSDs... Can you please be more specific about why you think maximum performance will be sacrificed, and to what level performance would be sacrificed? I understand a bit about write amplification.
What you say doesn't fit with tests such as this one:
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
------------------------------------
Reply:
For what it's worth, I've progressed in developing this idea. In the interest of progressing methodically and learning as I go, I now have two SSDs in RAID0 using a HighPoint 2720SGL PCIe RAID controller.
This so far is a blazingly fast combination! Over 1 gigabyte/second throughput and 0.2 millisecond latency. Next step will be to build a RAID0 with 4 SSDs.
TRIM is not needed, as the drives are smart enough to clean up internally after sectors are rewritten.
It's surprising how few people are using these technologies - they really speed up Windows.
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
------------------------------------
Smart Fortress 2012 malicius software issue
Hi everyone. I am using MS Essentials and windows firewall as well as full updates on pcs for protection against malicious software like Smart Fortress 2012. This particular one though passed undetected from MS essentials and infected the system (windows XP SP3). This virus mimics an antivirus program and among other things it does is to render the user unable of using control panel , his antivirus and also unable to log in safe mode. I've recently seen the same thing happen to other systems with windows 7 running, so I can't blame the use of an outdated OS like windows XP, Although MS has launched removal tools for such cases, is there any chance that essentials will have an update to catch these malicious software before they enter the system and remove them ?Besides the removal tool, does anyone have any proposals on how to remove that kind of malware and how one can be protected from such attacks? Thank you for your time.
Server / Network Configuration Advice Needed (VPN/Firewall/User Control/Internet Access/etc)
Description
I am a novice when it comes to server and network configuration, and trying to learn as much as I can. I know there must be many ways to achieve what I want to do. The way I land up doing it will more than likely not be ideal, but I am looking for a solution that is "good enough" for me with my limited resources. I have a small business and I need to set up my servers to cater for the following:
- VPN Access from outside - when connected, users should still be able to browse unrestricted internet which is not channeled through the VPN
- User access control - to control who can access certain network drives/folders etc. (currently I have configured as workgroup, and not domain)
- File server - to have a central repository for simple document storage
- Gateway / firewall - to protect the private network from public attack. All internet access provided from within the private network should be routed through a gateway so that traffic can be monitored, web filtering etc.
- Hyper-V - I have a few virtual servers running various applications
So the question is, how many server instances will I need, or can I do everything on one instance? (e.g. do I need a dedicated VPN server, file server, AD server, firewall server, etc? or can I have all these features on one server?)
Environment
1 physical desktop PC used as server
8GB ram
Windows Server 2008 R2 Standard SP1
Intel Core 2 Quad 2.5Ghz
Currently set up as workgroup
2 network cards
2 wireless modem/routers (one can be used as an access point)
My current setup is as follows:
Internet ==> Firewall Router ==> Private Workgroup Network -->Host Server / VPS1 / VPS2 / VPS3 / Laptops / etc.
Once the VPN is set up none of the servers must be exposed directly to the public internet.
I will highly appreciate any feedback given.
Thanks
- Changed type Tiger LiMicrosoft employee Thursday, April 19, 2012 9:35 AM
Reply:
I would suggest:
- VPN Access from outside - when connected, users should still be able to browse unrestricted internet which is not channeled through the VPN
Separate server for RRAS to configure for VPN access. To allow the VPN client to have unrestricted access, in the client side Windows VPN connection, uncheck the box that says "Use remote gateway.
Note: RRAS should not be installed on a DC.
.
- User access control - to control who can access certain network drives/folders etc. (currently I have configured as workgroup, and not domain)
Ideally, you would rather have a domain dfor these requirements. It's a mess to do it with a workgroup. If you want to stick with a workgroup, then you have to either create identical user accounts on the server and the workstations, or provide instructions to use credentials to map a drive to the server, or printers, etc. However, people may pass the credentials around to each other. With AD, that possibility is vastly minimized, and you have central control.
.
- File server - to have a central repository for simple document storage
See response to question above
.
- Gateway / firewall - to protect the private network from public attack. All internet access provided from within the private network should be routed through a gateway so that traffic can be monitored, web filtering etc.
Your router/firewall should be sufficient, however you can't get web traffic usage, and it will be difficult to control inappropriate sites. You have two options, install a separate server and use TMG to control all access to the internet. There are third party add-ons to enhance web control, reports, etc. Note: TMG should not be on a DC.
The other poor-man's option (using the term loosely), is to use OpenDNS servers for your DNS Forwarders (www.opendns.com). You can generally control what websites is accessible or that you want blocked, and create reports, etc, but you can't control or watch individual internal users. TMG can.
.
- Hyper-V - I have a few virtual servers running various applications
The server you have should be sufficient. I would recommend to use Enterprise Edition, which the license will allow you with the same DVD, to install it as a HyperV host and up to 4 HyperV guests, all part of the license.
.
Also, I would like to add, that for your needs with all this, except TMG, that I would honestly sduggest to look into Small Business Server. For the small amount of money it costs, you get A LOT with it. And it has RRAS/VPN and other features all part of it with a simple and easy to use wizard. Read more on the Essentials and Premium Add ON versions:
http://www.microsoft.com/en-us/server-cloud/windows-small-business-server/default.aspx
.
Ace Fekay
MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php
This posting is provided AS-IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
Hi David,
Thanks for posting here.
After read you post I believe our "Small Business Server" Standard all-in-one solution is just suitable to all the goals we are going to achieve.
It is not just contain all these features we want but also quite easy to configure and maintain, just take look the introductions in the links below:
http://www.microsoft.com/en-us/server-cloud/windows-small-business-server/default.aspx
Windows Small Business Server 2011 Standard
http://technet.microsoft.com/en-us/library/gg490793.aspx
We can also get good suggestions form SBS forum:
http://social.technet.microsoft.com/Forums/en/smallbusinessserver/threads
Thanks.
Tiger Li
Tiger Li
TechNet Community Support
------------------------------------
Reply:
Thanks guys,
I will look into SBS, but I am also finding it useful to learn about all of this by doing it myself, since we have large expansion plans ahead and I want to plan for great things :)
------------------------------------
Re-create Protection Group
Hi all,
I've stopped the protection of a group as our customer has added 100GB of Data to the replica. This being replicated over a 2mb connection would take forever. I've manually moved a copy of the data in to the replica location and want to recreate the protection group so that I can consistency check the data and get it back in Sync.
Within the GUI, there is an inactive replica available. What's the best way for me to reinitiate protection of this group?
Thanks
Craig
Reply:
Hi all,
I've stopped the protection of a group as our customer has added 100GB of Data to the replica. This being replicated over a 2mb connection would take forever. I've manually moved a copy of the data in to the replica location and want to recreate the protection group so that I can consistency check the data and get it back in Sync.
Within the GUI, there is an inactive replica available. What's the best way for me to reinitiate protection of this group?
Thanks
Craig
Hi Craig,
The answer to your question is outlined in the second half of one of my posts from a while back. Here is the link:
http://www.buchatech.com/2011/07/mark-inactive-protected-data-active-in-dpm/
My Blog | www.buchatech.com | www.dpm2010.com
If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer". This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing!
- Edited by BuchatechMVP Saturday, April 21, 2012 6:39 AM
------------------------------------
need help with error code 80246005
Reply:
------------------------------------
No comments:
Post a Comment