Application Runs Slow when Explorer is not running
Due to constraints, mainly from industry compliance, we need to have explorer stopped when our application is running. However, we have an application that runs prior to the main application to do maintenance on the machine to prepare it to run the application. We have other devices that it run fine on when explorer is stopped, but on a new device we are working with, it runs extremely slow.
This application starts services and does some DB maintenance.
Has anyone seen this before?
Robert Johnston
- Moved by Carey FrischMVP Thursday, February 7, 2013 2:10 AM Relocate
- Changed type tracycai Thursday, February 7, 2013 6:50 AM
Reply:
Hi,
Does the application run normally when explorer.exe is running?
Meanwhile, you may test the issue in Clean Boot mode to exclude the third party factors.
Tracy Cai
TechNet Community Support
------------------------------------
Reply:
Robert Johnston
------------------------------------
List of changes made to an application
Is there a SQL statement that will pull a complete list of changes made to an application?
- Changed type QuestionDude-Zack Thursday, February 7, 2013 3:28 PM Put in wrong forum
Reply:
Satya SKJ, Moderator - SQL Server MVP [Knowledge Sharing Network - www.sqlserver-qa.net]
Author of SQL Server 2008 R2 Administration cookbook.
Follow me @sqlmaster.
------------------------------------
Reasons for creating a separate database for staging / landing area?
Hello everybody,
my question is about datawarehousing techniques and the concept of staging the data from the source system 1:1 in some landing area. I've read in several places the term "staging database", and I've actually seen a couple of DWH-solutions where landing area is indeed a separate database.
Currently I'm thinking about potential advantages in storing the staging area in a separate database (instead of keeping just a bunch of tables in the stage schema of the DWH).
Points I've already considered:
-Storage considerations (want stage data to be stored on other storage medium that user- queryable data): Use filegroups. Filegroups also help with backup configuration – backup only filegroups you need to.
-Logical separation: Use schemes
-Security issues: Didn't find any situation where normal SQL Server security wouldn't suffice
-Isolate/manage performance effect of stage loading => Resource Governor
A valid scenario may be some mirrored database case where you want to keep the persistent part of your database in Full recovery model and don't want the stage inserts/deletes to pollute the transaction log and backups. But this is I guess not a normal situation for a DWH, we just use Simple recovery model with predefined time plan of loads and backups (full or incremental), in between the DWH is essentially read-only.
May be some scaling out arguments can come in play, but I'm pretty sure that performance degradation due to inter-server communication LinkedServer/OpenRowset (and you want to place the staging and data databases on different servers, otherwise it has nothing to do with scaling out) will in most cases cost more than the overhead for staging data itself.
The disadvantage of separating is obviously more complex environment (deployment, backups, housekeeping, user management etc.).
Would like to hear your thoughts on this topic. Please post :)
Reply:
On the same server, there no significant performance difference between using 2 databases and 2 schemas in the same database.
The reason to have a seperate "stage" database would primarily be to put it, now or later, on a seperate server to do the heavy processing, without affecting the reporting environment. If you integrate it to the same server/database, it may take significant resources to move to another server later.
------------------------------------
Reply:
Hello Tom,
thanks for answering. Yes, that's one of the reasons I'm aware of though I would like to concretize my question a bit: I separate the DWH into reporting (user queries), information (business logic) and stage (1:1 snapshot of the source data, one-off i.e. will be truncated before each load) layers, and I'm talking about idea of separating the stage area into an extra database. As there are not much heavy-lifting work being done when staging the data, probably the overhead is not worth it.
(Still looking for other other pro and contra points :) )
------------------------------------
SharePoint 2013 time sensitive task list calendar view in week view
Hi, SharePoint newbie here.
With the SharePoint 2013 task list calendar, is it possible to view your tasks in the week view allocated to specific time slots?
I've tried changing the Start Date and Due Date columns in the list from Date only to Date and Time, which allows you to specify the times for Start and Due date for the task, but then in the calendar week view it just slides the tasks in above the first time slot. (Above 8am in my case). What I need is to have a task across the calendar week view from say 1pm Monday - 1pm Friday.
Help would be much appreciated, thank you.
Computer to television
Reply:
How is it connected with dvi, vga, hdmi or something else?
------------------------------------
Discussing ETL development on MSFT platform
Hi Guys,
this is more of a discussion point than a question.
Over the last 10 years I have pioneered many new ideas. One of them is SeETL. This idea is going to change the future of ETL development.
The question is "are ETL developers on MSFT platform interested in what we have done"?
Feel free to ask questions or comment on this thread about what we have done. I think this as good a place as any to discuss SeETL and how it can be used in conjunction with SSIS.
These two videos will give you an idea of what we have done. I will explain in a few words below. But there is a LOT of information available about what we have done on our web site. Some people will love us, some people will hate us. Those who will hate us are the ones who build ETL for a living and do not want faster, better, cheaper ways of building ETL to become widely known. There are plenty of those guys around. Luckily they do not control budgets.
http://www.youtube.com/watch?v=3_wXs-vjZNk&feature=plcp
http://www.youtube.com/watch?v=E0PaMJIA7II&feature=plcp
Basically we have cut the cost of ETL development in about half even when a vendor ETL tool is used. I know that sounds like a "tall story" but it is true.
My background is I have been in IT 30 years building large batch systems...and ETL is just one more large batch system. I have been in BI for 21 years now. I built my first ETL tool in 1995 and it was used in many accounts to give me a competitive advantage on selling deals. So I know what I am talking about.
Starting in 2002 we migrated all our ETL knowledge into SeETL. It has developed over the last 10 years. It gives us a competitive advantage in ETL development to the tune of about 50%. It started out when I was talking to Ralph Kimball who suggested that "if you are so smart write an article about all the features are good ETL should have in it and I will publish it." That article, which never did get published, formed the initial design specs for SeETL.
SeETL allows us to completely prototype the ETL subsystem prior to actually using a vendor ETL tool. In our clients what we have been doing is building the ETL subsystems in SeETL, getting everything to work, getting the data models settled....doing all the testing on the prototype....and once the client is happy THEN migrate the ETL to the clients specified ETL tool. We have built a suite of tools that massively help us build data warehouses at our clients.
This is a client we did where we migrated the SeETL ETL to Informatica. http://www.youtube.com/watch?v=jBJWe9FxRxs&feature=plcp
We have ways and means to migrate our ETL to DataStage and Informatica very quickly. This all works on any standard database. DB2, Oracle, Sybase IQ, Netezza, MySQL are all proven platforms. But we are an MSDN and we develop on MSFT.
We have offered IBM and Informatica the opportunity to hire us to write an interface that will generate mappings for their tools. Up to them if they want to accept it.
I have contacted some old friends at MSFT to make the same offer to MSFT for SSIS...but I guess here is as good a place as any to mention that too.
The basic concept is very simple.
Forget about GUIs and build ETL directly from the mapping workbook using vb to read the workbook and generate what ever is necessary.
We have an older C++ engine but we can now also generate SQL directly. That means we are somewhat competitive to SSIS because we can do most of what SSIS can do. However, clients use SSIS for many more reasons than just getting the ETL done. There are also issues of support etc. So we see SeETL happily co-habiting with ETL tools...some people are using SeETL in production but most are using it only in development.
SeETL covers much more than just the ETL today. Anyone who takes a deeper look into the reports we provide out of the box will see that.
I am now in the process of making the whole idea of "write mappings and other directives in a spreadsheet and generate what is needed" into a widely accepted idea. I fully realise that I am going to be called "crazy" for this idea. I was also called "crazy" in 93-5 when I was talking about star schemas. But this idea is going to transform the world of BI. Just like star schemas did.
I very much own the idea of putting all the mapping definitions into a workbook and generating what is needed out of the workbook. This idea was invented in 2004 so there is more "prior art" than anyone can poke a stick at. We have quite a few big clients who have witnessed what we have been able to do. But as a small firm talking to people there is great resistance to this idea as per normal.....people who disbelieve new ideas are very committed to their disbelief...rather like sailors who said the world was flat.
So it is time to get this idea "out there" and widely accepted and adopted. And what better way than to offer some useful "free ware" and let people guide how the product evolves. The usual "free ware" standards apply. The software is free and the support is paid at normal support rates (which are lower than MSFT in any case).
What we are doing is making BI more accessible to more companies by lowing the cost of developing BI. This is good for everyone except people who make money out of coding ETL. The ideas I am bringing forward will put a lot of those guys out of work, just like computers put a lot of book keepers out of work. One caveat. You can't do this if you are in the german speaking region. We have an exclusive reseller in the german speaking region so you have to talk to them first.
SeETL for prototyping and design time work will remain free. There are lots of very useful reports and you can build your complete prototype. It will be a matter of your honour that you do not deploy the prototype into production. The only time we look for SeETL software fees is deployment to production. If a client develops in SeETL and deploys in SSIS and does not call us for support? Hooray for them. Good luck to them. (We actually make our real money out of selling data models not SeETL.)
In production we are looking to bring the price of ETL down as SeETL is more widely accepted. If SeETL is not widely accepted we will continue to sell it for its current price point of EUR20K to EUR50K to deploy into production for one company. A rounding error.
So it is really up to "the best and brightest" to decide for themselves if they want to use SeETL in production or just use it in development and deploy SSIS into production.
So...that is the proposal. The innovative idea that GUIs slow us down when building ETL, Data Models, etc, and that creating the input for such in an excel workbook and generating everything needed is a good idea. I know it is a good idea because at the end of a project our clients usually get the ETL in a vendor ETL tool and the data model in a data modelling tool. The whole end product looks "normal" and they switch over to "normal" support. A few clients use our tools for everything and they retain their advantage by doing that.
The point being? We get our clients to the end point faster and cheaper than anyone else.
So....Feel free to discuss this idea on this thread....good...bad...or otherwise. I am very interested in comments. I am interested to see if there are some guys here who are the "best and brightest" who would like to try out what it is we have done and evaluate it for themselves.
I am very much into "put the idea out there and see what happens." So far, not much. But that is exactly what selling star schemas was like in 93-95...by 2000 everyone had "discovered" star schemas thanks to Ralf Kimball and his books. We will see the same again in this tool I think.
Best regards
Peter Nolan
- Edited by peternolan9 Friday, September 21, 2012 5:50 PM
Reply:
I am curious what SeETL can do for me.
Can I manage SharePoint lists, consume WebServices, FTP files, access databases?
Do you have a complete list of capabilities Peter?
Arthur My Blog
------------------------------------
Reply:
Hi Arthur,
Sorry I have been away a while and not looking in here. Obviously my post is also to others who will read this.
If what your job is about is maintaining these applications/machines and anything to do with helping to promote their services or manage performance of the services then maybe it can help you. Please allow me to explain.
The target application for SeETL is data integration from operational systems to the data warehouse. The SSIS space. This is what I have been working on for 20 years now. So the tools that have been built are all about data integration.
I know if might "offend" some to say it here but we can get ETL built about 2x as fast and much more reliably at a higher quality than can be done with SSIS. MSFT would be well advised to check that out and put it to the test. After all, MSFT has far more opportunity to benefit from SeETL if it can do as I claim it can do.
To be clear about that, we can perform all prototyping with SeETL and then deploy to SSIS and you still get about a 50% cost reduction in that configuration and you pay us ZERO fees for the software. Our SeETL software is free so long as you do not deploy the generated ETL into production. The idea now is to get it widely deployed and used.
So....if what you are doing would lead to SSIS being the tool of choice in the MSFT world? We can help you cut the time and effort of doing that work even if you deploy SSIS into production. If SSIS is not the natural choice for what you are doing then we would likely not be the natural choice either.
I do not want anyone to misuse SeETL as that will only create dis-satisfaction. We now want a series of positive uses of SeETL so that we can add more and more happy clients to our current list of references. The people who use SeETL are almost "religious" about it and are surprised others do not "get it" faster. But this is what it was like with star schemas too.
Here are our public testimonials.
http://www.instantbi.com/Support/AllForums/tabid/84/forumid/57/scope/threads/Default.aspx
The list of features is rather a long one. I will put the links for the manuals below. There are now 50+ workbooks in beta and 95+ tables in the metadata dictionary.
SeETL can do everything from capture business requirements and initial logical models, through to generating the physical database objects, the views, the ETL and documenting the stored procedures and reports for any system. It is quite a complete package that no one else can do in one single package. You can even manage project plans in it. All the reports are only in RS so the MSFT community is the place to start talking about it.
The way to think about it is this. If you are a data warehouse architect and you are walking into a new client? SeETL is the toolkit built by the best in the business to make your life easier. Everything you need is in that toolkit. If a top flight data warehouse architect thinks of some new tool he needs? I would be really interested to hear about it to add it to the toolkit if it is a real need that can be widely used.
Why did it come out this way? One of my uncles was a builder. I used to labour for him as a kid. His son and I were the same age so two lads labouring for him was good for him and we had a lot of fun and learned a lot. He used to drum into me "a builder is only as good as his tools, use rubbish tools, get rubbish work". So we used to take great care of his tools and we learned what were good tools and what were bad tools for a builder.
So all my IT life, 30 years now, I have heeded the words of my uncle and whenever I see an opportunity to do a better job I build tools to help people in my role to reduce time and cost. When I was at IBM in the 80s I was the guy who invented some of the most key ideas to make their source code control software usable. A lot of software I wrote in the 80s went on to be enhanced and sometimes replaced with a "new generation".
So..SeETL is the "master craftsmans toolkit" if your job is building data warehouses.
The short explanation is that we have defined a workbook that captures directives and data. I think there 41 sheets defined in the workbook now but it is being extended rapidly. The next beta version has 50+ sheets.
Each sheet contains data or directives as to what it is supposed to do when processed by SeETL. SeETL Design Time is a vb.net application that reads the workbooks and generates code or places the data into the database as control information for the SeETL C++ runtime engines.
So, if you want to create a table? You put that into a workbook and generate create table statements. You want to create indexes, views, userids etc. All into the workbook.
The largest part of any DW job is documenting the mapping of sources to targets and then writing the code to implement that mapping. That's where 80% or more of your people cost is going to go over a 5 year period. With SeETL we document all the mappings usually into a single worksheet. We have mapped as many as 18,000 fields in a single worksheet.
From that worksheet we generate SQL to actually move the data as a prototype. The client may use that SQL in dev as a prototype or may move it into production. Most of our clients are DataStage, Informatica, SSIS users. So they migrate our prototype ETL into those tools at the end of the development project.
We are in no doubt we have the best way of doing this and neither are our clients. The testimonials are above. We only publish testimonials with people who add their linkedin so that prospective clients can see that the testimonials are real and not like some vendors might make up. So….here are the user guide links. There are 4 user guides that completely document the current release.
User Guides
01 – SeETL DesignTime User Guide
http://www.instantbi.com/LinkClick.aspx?fileticket=WcfXREXDSmQ%3d&tabid=59&mid=442
02 – SeETL MetaData Dictionary User Guide
http://www.instantbi.com/LinkClick.aspx?fileticket=zFi8OHsJNng%3d&tabid=59&mid=442
03 – SeETL RunTime User Guide
http://www.instantbi.com/LinkClick.aspx?fileticket=gVNO7ZVKIdI%3d&tabid=59&mid=442
04 – SeETL RunTime User Guide Appendicies
http://www.instantbi.com/LinkClick.aspx?fileticket=x0GymvUoQkM%3d&tabid=59&mid=442
Here is the link to our full list of marketing downloads.
http://www.instantbi.com/Support/AllForums/tabid/84/forumid/15/threadid/309/scope/posts/Default.aspx
Here is our new education video channel. This is what has been keeping us so busy. We have put up hours and hours of video going through very detailed examples of how to build ETL systems and data warehouses. It is all free.
http://www.youtube.com/user/InstantBIEducation/featured
Here is the link to the full download package for evaluation etc.
http://www.instantbi.com/LinkClick.aspx?fileticket=MTjMO1-KeP4%3d&tabid=59&mid=443
Lastly. We are now building our own data warehouse for our own sales efforts. We use dot net nuke as our web site. So we are building a dot net nuke related data warehouse.
As part of educating people we have released a portion of that data warehouse and staging area. This is real world work for ETL for a real world problem. A small business that is building its own sales and marketing data warehouse off dot net nuke and other data sources. You can get it here. The workbooks and all the generated code is in the package so you can see exactly how everything works.
Anyone with a passing knowledge of data warehousing and SSIS can read this package and understand why it is that we can do the work in half the time at half the cost.
http://www.instantbi.com/LinkClick.aspx?fileticket=SK3tZbj8Vyk%3d&tabid=59&mid=448
Now….A lot of people are very suspicious of me for putting this much information into the public. They are asking me "What is the catch, where do you make your money?"
The answer is simple. If you put our ETL into production we would like to be paid. Current list price is EUR20K to EUR50K depending on the size of the company. This is, essentially, free. We would like to see that price come down. So even if a company is very large? They can buy SeETL for EUR50K. A rounding error.
Just like MSFT, we ask to be paid for our time. Nothing unusual about that.
As I said. If the client does not put the ETL into production we do not ask to be paid for the SeETL software.
We have been winning our projects based on the fact we can price the project much lower than anyone else. And to do that we remove the discussion about SeETL by not charging for it in development. I wrote my first ETL tool in 95 and it was used to win projects all over AP. It was a cobol generator back in those days.
This really is a genuine effort to make widely available a set of tools that will cut the cost of BI implementations to make BI more widely available to anyone who wants it. There are no "catches". There are no "hidden costs". Use the software for free and if you want to put it into production pay a very modest fee. If lots of people want it in production the fee will become more modest. I am testing out a new way of doing business because I think it is the right thing to do.
For the last period we have made most of our money in data models and implementation of data models in large clients. We have great data models that are far more price competitive than anything anyone else has ever done.
We actually make more money if the client chooses NOT to buy SeETL because we get the work to migrate the prototype ETL to their standard ETL tools. Most people find it too hard politically to buy in a separate ETL tool if they have standardised on one. We know that. This is why SeETL is free for development.
When it is free for development the client project manager can say "Well, we are not thinking of displacing the standard ETL tool and we are not paying any money, we are simply using SeETL as a productivity tool in development."
This is "politically acceptable", especially when we say "we will not build your data warehouse without using our tools". In a recent apples to apples comparison we were 80% lower cost than Oracle PS for the ETL/data model construction.
So there is PLENTY of information in this post for anyone interested in reducing the cost of BI over at MSFT or any MSFT clients. If anyone wants to spread our links around feel free. We can not do much more than put all this information into the public and give the "best and brightest" a chance to use our software for themselves and decide for themselves if they want to adopt it in development. If anyone has a better idea? Feel free to share. Everyone will benefit if BI can be made cheaper.
One last thing for those here from MSFT. My old friends at IBM seem not to want to involve me because after I left IBM I took so many big deals off them. If anyone at MSFT wants to use my skills in designing winning proposals against the likes of IBM, Oracle, Teradata, SAP? Feel free to get in touch. Peter.nolan@instantbi.com.
When I was selling large SI deals for Hitachi and PwC my win rate was 75%. I also sold a lot of deals for Ardent when I was the Professional Services Manager for AP in the late 90s. I took some very big deals off IBM in the late 90s, the most notable of which was Telstra. One of IBMs biggest customers in <st1:country-region><st1:place>Australia</st1:place></st1:country-region>. They have not called me every since! LOL!! We have taken some data model deals off IBM of late too. We were working closely with Netezza and IBM cut us out after the buy out. So maybe MSFT would like a hand to compete with IBM?
Now that MSFT has a far more robust stack? It might be fun to help you guys sell against the other guys. Certainly they are doing nothing to help me! LOL!!
Peter Nolan
------------------------------------
Reply:
for those who are interested. We just released the beta version of SeETL 3.1.01 on the weekend. You can get it from here.
http://www.instantbi.com/LinkClick.aspx?fileticket=J7RWhm7lTWA%3d&tabid=59&mid=445
Included in this version is the ability to do mass emails and then push the emails into the data warehouse integrated with everything else. We are using dot net nuke as our web site and so we have released the portion of our own small data warehouse that links to dot net nuke as a freebie to show people how to integrate dot net nuke with solicitation emails and gathering responses etc.
It is all to show people how to reduce their costs of ETL and data warehouse development by providing a detailed example that has a real world use. The vast majority of companies today have a web site and need to do solicitation/responses for such things as newsletters and promotions. Then they need to link this with their ERP for the whole supply line process. This is what this example is demonstrating. Feel free to download it and go through what is there.
Peter Nolan
------------------------------------
Reply:
Hi All,
there has not been much discussion on this topic. I gather there is little interest in reducing the development effort for building data warehouses in the MSDN community. Not sure why that it but that's fine. We have released the GA for 3.1.01 and we created an announcement letter that we are posting in various places to let people know this is now available.
We have released a portion of our own little data warehouse for our web site that is based on dot net nuke. So there are about 200 tables copied from DNN across to a staging area and then a few of those are taken into the prototype data warehouse. This means you can go to school on the samples now provided as part of the GA product.
Those people who are DNN developers or hosters who would like to extend their offerings to include a data warehouse that contains their DNN data are welcome to go to school on what we have done. If you use SSIS in production and only SeETL in development there is no license fee. If you go into production with SQL ETL from SeETL there is a license fee.
People here are well smart enough to decide for themselves how they want to build ETL. SeETL is one more option that you now have available to you. We use it day in day out and have done so over the last 10 years. So we know it cuts our development times and gives our resellers an unassailable competitive advantage in pricing services. Now it is time for others to take a look and see if they want to do the same.
Here is the short announcement letter we are posting informally to places like this and linkedin discussions.
Please feel free to pass along to your colleagues who might be interested in reducing the cost of their ETL development.
IBIs SeETL 3.1.01 GA now freely available for development work
Hi All,
we recently released the GA version of SeETL 3.1.01. This software will help you reduce the development time of ETL by about 50% even if you go into production with a name brand ETL tool.
We have used SeETL (and its predecessors) on many projects over the last 17 years. It has been the "secret sauce" that has let us out compete other consulting firms because we can build the ETL in half the time and effort. I have been able to build ETL systems much faster and much cheaper than anyone else since the very first version of this software I wrote in 1995.
Now that it generates SQL as the ETL system as an option I have decided to make that component freely available for development. If you put the SQL into production rather than migrate the SeETL ETL to a name brand ETL tool then we have a modest license fee for that.
In 3.1.01 we have MASSIVELY extended the data that is captured by the "mapping spreadsheet". We now have 65 worksheets that capture all sorts of useful information about a BI project. From Business Requirements, to tables, views, indexes, all the way down to documenting every field on every report so as to gain proper data lineage. We now cover the full spectrum of a BI project. As far as I am aware SeETL is the ONLY BI development tool to do so.
The KILLER feature is that from the mapping definition workbook we generate finished SQL as the ETL subsystem. Others are starting to copy our idea of documenting the mappings in a workbook and generating the ETL into their tools. Informatica being the most notable. Imitation is the most sincere form of flattery.
In our new GA release we have included a small section of our own web site data warehouse. We use Dot Net Nuke as our company web site and we host some small web sites as well. So we keep an eye on page hits and downloads via a small data warehouse we built for our own sites. So you have an ETL system to "go to school on" in the GA download.
This is my contribution back to my industry to massively reduce the time and effort to build data warehouses so as to make them more affordable. This will make BI more pervasive. Making BI more pervasive and more affordable to everyone will create greater value for all because it will drive down the cost of doing business.
SeETL 3.1.01 is now a command line application which has made is faster and easier to use than even the three button application it used to be.
So. For all those of you who would like to reduce the time and cost of building data warehouses? Feel free to download our new GA edition and try it out for yourself. I know those who adopt it and use it properly will cut their ETL development time in about half.
If you want some of my time I bill for my time just like you bill for your time. If you want to hire people to build ETL or Data warehouses who are skilled in SeETL then our german reseller (www.key-work.de ) has about 40 staff that can build anything. They are very good at building data warehouses and BI applications. They can deploy the best of the best BI Developers at normal "European rates".
Thank you for your consideration of our offer. We would like to have lots and lots of people using SeETL so that it improves even further over time and helps us all by driving down the cost of building business intelligence systems.
Best Regards
Peter
Links
Our main web site is here. www.instantbi.com
The video going over the details of the GA package is here.
http://www.youtube.com/watch?v=Z0aDJoD2GJY
The forum entry to all our marketing materials is here.
http://www.instantbi.com/Support/AllForums/tabid/84/forumid/15/threadid/309/scope/posts/Default.aspx
Peter Nolan
- Edited by peternolan9 Thursday, February 7, 2013 9:11 AM
------------------------------------
New Deployment and Installation of Exchange 2010
Hi,
We are going to Deploy Exchange 2010 in our Company. We have not used Exchange before and starting with 2010 version only. I would like suggestion from you to deploy exchange and role planning with high availability.
My Company AD Structured is:
all DCs are on Windows Server 2008 R2 Enterprise with SP1
5 Active Directory Sites
2 DC in 4 sites and Default Site having 3 DC.
Total 11 DC (10 are GC)
Expected Users: 4000
We have decided following roles on Server
Mail01 HT / CAS / MB
Mail02 HT / CAS / MB
Mail3 MB
Mail04 HT / CAS
DAG Mail1 / Mail2 / Mail3
Thanks,
Reply:
Hello,
I think the next step to design your architecture is you need to plan for External/Internal Access:
Where are located your users ? How they will access to your Exchange Infrastructure ?
- DNS Records like SRV Locator for Autodiscover service URL
- Exchange centralized or not
- Urls and Certificates delivery for external and internal Exchange services
- Messaging clients support and compatibility like : Microsoft Office for Windows or Mac OS
- Is your Backup Tools supported by Exchange 2010
And many more it depend your Organization requirements take a look at this web link :
http://technet.microsoft.com/en-us/library/aa995902(v=exchg.141).aspx
Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization
------------------------------------
Reply:
Thanks for the Reply,
We planed for Both Internal and External Access. User will access mail via both Internet and Intranet.
We have planned to deploy Exchange Centrally.
we don't have Mac OS users in environment.
We are going to use Symantec Backup Exec for Backup and Restore.
We have registered domain with godaddy
------------------------------------
Reply:
It can be a bit complex to manage all the planification trough a forum, however you will have to plan the following for the general architecture :
- Each site where you deploy a MBX must have a CAS & HUB
- HA : DAG for MBX HA, CAS Array for CAS HA, HUB loadbalance for all in same site. Both are different in use and req.
- SMTP route (use AD IP cost, or overload it, considering your network path and load), sendconnector configuration
- External Access (OWA, Autodiscovery, ActiveSync, use of reverse proxy)
Each part is very customer specific and may need some reflexion.
------------------------------------
Reply:
Good!
- Exchange Organization
For mail flow do you use Edge server role or an Appliance like anti spam,email inspection to purge emails and protect Servers/Users or you directly send and receive email with Hub servers without security features (I guess that no)?
How many users do you have in your Exchange Organization ? Do they use Outlook 2003 or greater ?
Plan for DAG DBs segmentation,maintenance hours for each DBs (can increase speed of backup process)
- Next step could be to plan for backup and restore process :
Is your mailbox database hosted on DAS or SAN ?
Requirements for BE to work with Exchange 2010 SP2 are meets ?
If SAN is used wich type of vss drivers do you use for backup Hardware or Software?
Do you plan to use archiving and retentions policies that exchange features provide ?
- You could plan for the new security model in Exchange :
RBAC (role based access control) :
Explaination :
http://technet.microsoft.com/en-us/library/dd298183.aspx -> this one is for Ex 2013 but the fundaments are the same.
http://blogs.technet.com/b/exchange/archive/2009/11/16/3408825.aspx -> You will better understand the scope of RBAC with this one
In addition of the default interface,You could also use this tool :
http://blogs.technet.com/b/sjimmie/archive/2012/05/07/rbac-manager-exchange-2010-sp2.aspx
Try to learn more trick and tips with Exchange team blogs and MS Forums for administration purposes :)
Kévin KISOKA - MCTS Exchange Configuring, MCTS Hyper-V Server Virtualization
- Edited by KISOKA Kévin Thursday, February 7, 2013 8:52 AM
------------------------------------
Connect two fact tables
I have two fact tables :
1-Circuit
2-Order
the relation between them M-M ,i created table Circuit-Order which have the surrogate key for both tables .i need to add another dimensions on this fact table 'Circuit-Order' how can i handle this in the star schema and ssas????
Reply:
Hi Soche90,
Refer these links for how to define a many to many dimension and bridge tables ..
http://msdn.microsoft.com/en-us/library/ms345139(v=sql.90).aspx
http://technet.microsoft.com/en-us/library/ms170463(v=sql.90).aspx
Best Regards,
Silna
Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.
------------------------------------
all exe files open with wordpad
Hi sir,
In my windows 7 os all exe files are open with word pad including regedit, anti virus softwares.
Could you give the solution for me?
Reply:
Hi,
Basically you need to restore the default File Associations.
When you double-click an .EXE file, the program may not launch, instead it may open in Notepad (displaying the .exe contents), or may launch in any other application.
http://windowsxp.mvps.org/exeasso.htm
When you run an .exe file on a Windows Vista-based or Windows 7-based computer, the file may start a different program http://support.microsoft.com/kb/950505 Restore the .exe file association in Windows Vista, after incorrectly associating it with another application http://www.winhelponline.com/articles/165/1/Restore-the-exe-file-association-in-Windows-Vista-after-incorrectly-associating-it-with-another-application.html
Restore Default Windows 7 File Extension Type Associations
http://www.sevenforums.com/tutorials/19449-default-file-type-associations-restore.html
How to Set Default Associations for a Program in Windows 7
http://www.sevenforums.com/tutorials/2630-default-programs-set-programs-default-associations.html
How to Unassociate a File Extension Type in Vista and a utility to help (Windows 7 too)
http://www.vistax64.com/tutorials/91920-unassociate-file-extention-type.html
How to Change the Default Program a File Type Opens With in Windows 7
http://www.sevenforums.com/tutorials/12196-open-change-default-program.html
How to Associate a File Type or Protocol Default Program in Window 7
http://www.sevenforums.com/tutorials/9154-default-programs-associate-file-type-protocol.html
How to Hide or Show Known File Type Extensions in Windows 7
http://www.sevenforums.com/tutorials/10570-file-extensions-hide-show.html#post101629
Note: Since the website is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
Hope this helps.
Vincent Wang
TechNet Community Support
------------------------------------
F: Drive. No files, But "Computer is showing there is files.
Ive already went to control panel and applied the option to 'show hidden files', but It still shows 0 Files. How do I find out what is in my F drive, and should i format it, regardless of what is in it? Isnt windows and all system files in the C drive? I need a developer to help me with this, preferably someone who knows how HP builds there stuff. Im using a Windows 7 version on a Computer that was shipped to me back in 2010. I'm concerned it may be system files, but I want to be sure before I format it.
Reply:
Carey Frisch
------------------------------------
Reply:
Hi,
You need to contact HP support about their recovery partition. In addition, you can uncheck "Hide protected operating system files" to check whether any files listed.
Regards,
Vincent Wang
TechNet Community Support
------------------------------------
HELP
- Changed type tracycai Monday, February 11, 2013 8:19 AM
Reply:
Hi,
This forum is for Windows 7 computer users. I suggest you contact your cell phone manufacturer for assistance.
Thanks.
Tracy Cai
TechNet Community Support
------------------------------------
Win 8 and AD, and other BYOD devices
I understand that Win 8 phones (and tablets) can join an AD domain and be controlled by Group Policy. How is authentication\security generally handled for other smartphones\devices in a Windows environment? (I don't think the iPhone understands AD! Does one purchase 3rd party software to integrate it into an AD system? In short, there has to be some way to manage non-Windows BYOD devices in a Windows network.)
TIA,
edm2
- Edited by edm2 Friday, February 1, 2013 4:11 PM
- Changed type Nicholas Li Thursday, February 7, 2013 5:06 AM
Reply:
This is a bit out of Windows 8 General, as you ask for nonMS phones.
IMHO the best path to information is via phone support forum. In addition to this search single sign-on solution that fit with your phone(s). Here is a list of some of them (general purpose):
http://en.wikipedia.org/wiki/List_of_single_sign-on_implementations
Regards
------------------------------------
Reply:
Milos,
Can you be a bit more clear what you meant by "via phone support forum"? Is this a Microsoft forum or were you referring to, say, a third party forum for iPhone, or Android, etc?
TIA,
edm2
------------------------------------
Reply:
Hi,
As this is related to Windows Phone 8, it is recommended that you contact the corresponding support for help:
Windows Phone 8 support
http://www.windowsphone.com/en-us/how-to/wp8/support
Thanks for your understanding and cooperation.
Nicholas Li
TechNet Community Support
------------------------------------
Need help with routing issue on Forefront TMG
I need some help setting up Forefront TMG to allow access to other subnets.
Site 1 Subnet 192.168.100.1 to 192.168.100.254
Site 2 Subnet 10.0.1.1 to 10.0.0.254 and 10.0.1.1 to 10.0.1.254
MPLS connection between Site 1 and Site 2 with static routes for traffic to pass through each other's gateway.
We use Forfront TMG for VPN and to access Internet from both sites. All site 1 internet traffic passes through MPLS and out to Site 2 via a Forefront TMG server.
All computers in site 1 are able to connect to all shares and ping computers in Site 2.
All computers in Site 2 with 10.0.0.1 to 10.0.0.254 IP are able to connect to all shares and ping computers to site 1
All computers in Site 2 with 10.0.1.1 to 10.0.1.254 IP are able to ping any IP in site 1 but are unable to browse folders using windows explorer or access any shares.
Any help in solving this issue is much appreciated.
Thanks in advance.
- Changed type Nick Gu - MSFTModerator Thursday, February 7, 2013 2:20 AM
Reply:
Hi,
Thank you for the post.
"All computers in Site 2 with 10.0.1.1 to 10.0.1.254 IP are able to ping any IP in site 1 but are unable to browse folders using windows explorer or access any shares." – where do you place the TMG server, on site1 or site2? Do you create access rule to allow network share?
Regards,
Nick Gu - MSFT
------------------------------------
Reply:
Nick,
Thanks for the reply.
I had couple of mistakes in my original post. I just want to be sure I gave you the correct information.
Site 1 Subnet 192.168.100.1 to 192.168.100.254 - IP range in Internal
Site 2 Subnet 10.0.0.1 to 10.0.0.254 and 10.0.1.1 to 10.0.1.254 - IP range in Internal
MPLS connection between Site 1 and Site 2 with static routes for traffic to pass through each other's gateway.
We use Forfront TMG for VPN and to access Internet from both sites. All site 1 internet traffic passes through MPLS and out to Site 2 via a Forefront TMG server.
All computers in Site 1 are able to connect to all shares and ping computers in Site 2.
All computers in Site 2 with 10.0.0.1 to 10.0.0.254 IP are able to connect to all shares and ping computers to site 1
All computers in Site 2 with 10.0.1.1 to 10.0.1.254 IP are able to ping any IP in site 1 but are unable to browse folders using windows explorer or access any shares.
TMG is in site 2. I also have a firewall policy that allows all outbound traffic from Internal, VPN Clients and local host to Intenal, VPN Clients and localhost.
Jut in case I'm missing something, can you tell me how to create access rule to allow network share.
Thanks.
------------------------------------
Definitive Technology Sound Cylinder - an abney associates internet technology news
Het speakertje, dat geleverd wordt in een stevige koker die sterk doet denken aan de verpakking van een fles Glenfiddich ("That's no coincidence...," wordt ons verzekerd), is voorzien van twee composiet midrange drivers voor 'high definition clarity' en een side-firing woofer voor rijk, warm geluid. In hoeverre dat klopt, kunnen we helaas niet bevestigen. De iOS-update van de iPad op de stand vertoonde kuren, waardoor er geen muziek afgespeeld kon worden. Het verhinderde bovendien een leuke foto met een playlist of andere schermafbeelding, maar de 'whisky-koker' is wel te zien;
De Sound Cylinder is voorzien van stevige klemmen waar de iPad gemakkelijk tussen te bevestigen is. Tevens is de stevige metalen behuizing voorzien van een 3.5mm audio input jack. Batterijduur is zo'n tien uur, op te laden via USB. De ingebouwde kick-stand tot slot verzorgt de juiste hoek voor het kijken van bijvoorbeeld de series en films die je op je iPad gezet hebt. Prijs en beschikbaarheid in Nederland is ons nog niet bekend, maar op de stand kregen we wel de adviesprijs van 199 dollar mee. Importeur van het merk in ons taal- en valutagebied is Dimex.
WSUS
Reply:
Yep this is doable. Check this page on how to publish third-party updates to WSUS using Local Update Publisher
You can try Solar Winds Patch Manager as well:
------------------------------------
Reply:
You can try Solar Winds Patch Manager as well:
Wow! I wasn't aware that page was still active.
A better link would be http://www.solarwinds.com/patch-manager.aspx.
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
SolarWinds Head Geek
Microsoft MVP - Software Distribution (2005-2013)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.
------------------------------------
Reply:
Am 06.02.2013 schrieb Subodh230123:
Can I use WSUS to deploy 3rd party softwares.I saw it can be done by WSUS API .How does it work.
Local Update Publisher can help you.
http://localupdatepubl.sourceforge.net/ Read the Wiki complete, two
ore three times:
http://sourceforge.net/apps/mediawiki/localupdatepubl/index.php?title=Main_Page
Winfried
http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
http://www.wsuswiki.com/Home
------------------------------------
Request for detailed information on how Windows 8 metro apps work
Everybody has probably come across the metro app crashing issues immediately after execution. I have solved a couple of these issues so far. One issue I solved by adding "ALL APPLICATION PACKAGES" permissions to a registry key ("HKCL\wow6432node\interface", group policy applying and excluding read access for this user), one by adding permissions to "C:\Program Files\WindowsApps" directory (same user), another by adding permissions to "%localappdata%\Packages" (same user again).
The most annoying thing about troubleshooting these issues is that I don't understand the detailed behaviours and workings of how these apps work, and I can't find any documentation on it either. I'm working on using WADK and procmon to gain some knowledge at the moment, but want to get the information faster.
Is there anybody who can step through the registry keys, executables, directories, network addresses metro apps generally use and require for successful execution and the permissions required to access them for troubleshooting purposes?
- Changed type Arthur Xie Monday, January 21, 2013 7:10 AM
Reply:
Hello,
This article lists some of that information
http://support.microsoft.com/kb/2798317/en-US?wa=wsignin1.0
Thanks, Darrell Gorter [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights. VAMT - Volume Activation Management Tool - Download link http://www.microsoft.com/downloads/details.aspx?FamilyID=ec7156d2-2864-49ee-bfcb-777b898ad582&displaylang=en
------------------------------------
Grant Access to Server objects
Hi,
How to grant access to server level objects.
1. If we have server level trigger and user has logged in to particular database on the server
2. We have stored procedure in which trying to enable and disable the server level trigger for some operation in stored procedure.
Getting the below error.
Cannot find the object "Trigger_***" because it does not exist or you do not have permissions.
Please let me know how to resolve this.
Reply:
A statement such as DISABLE TRIGGER SpecialLoginTrigger ON ALL SERVER; should work. From Books Online DISABLE TRIGGER (Transact-SQL):
To disable a DDL trigger with server scope (ON ALL SERVER) or a logon trigger, a user must have CONTROL SERVER permission on the server.
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
------------------------------------
Reply:
As Rick says, you need CONTROL SERVER to disable/enable a server-level trigger.
If you want this stored procedure to be executed by a plain user, this is possible, but it takes a couple of steps to get there. You need to create a certificate in the master database, and create a login from that certificate and grant that login CONTROL SERVER. Then you need to copy the certificate to the user database and sign the procedure with the certificate.
I have an article on my web site where discuss this method in details and with plenty of examples:
http://www.sommarskog.se/grantperm.html
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
------------------------------------
Windows 7 64 bit Fax&Scan not handling multipage TIF's the same way as 32 bit when faxing
Our customers connect via RDP to Windows 2008 R2 servers (Amazon EC2) and use ThinPrint to redirect their local printers so they can print ther various documents. This solution has been working well for us for quite some time as it frees us from having to maintain untold scores of printers drivers on the servers that we would have to have if we used Windows printer redirection.
Some users also use this method to fax from our hosted application, simply selecting their local fax driver instead of their printer, and in most cases it is the default Windows fax client that is used.
This has worked well for our XP clients, Vista (so far as we know, not many of them), and Win7... except for Win7 64 bit, and only then if the document is more than one page (in other words, W7/64, 2+ pages doesn't work).
Faxing a local document with this method works well, a good-looking Group4 fax TIF file is produced and there are no worries, but when we try it from the cloud via ThinPrint the TIF file that results is corrupt or otherwise unreadable. When I use Irfanview to open it ( a program I have used for years to read multipage TIF files) it throws a decode error and says that it is an invalid or unsupported TIF format.
Thinking this might be a ThinPrint problem I tried several other fax methods and the two that I tried will work properly- Ring Central Internet Fax and GFI version 14.3
I have provided workarounds for the affected users (basically print to PDF and then fax that) but I am hoping that someone can help me to make the experience for Win7 64 users the same as the XP/Vista/Win7 32 folk
Thanks
Matt
- Changed type Spencer Xi Friday, February 8, 2013 5:38 AM
Windows 8 sales are massive success story - Official.
Microsoft announced on their blog that sales of Windows 8 licences totalled over 40 million within it's first month alone. This means the new operating system has sold faster than the already successful Windows 7 platform and totally dominates any iOS and MAC release in Apple history.
Microsoft were also pleased to announce that upon the launch date for it's Windows Store there were more apps available to download than any other competitors own app store.
http://blogs.windows.com/windows/b/bloggingwindows/archive/2012/11/27/windows-8-40-million-licenses-sold.aspx
- Edited by ProjectVRD Wednesday, December 19, 2012 2:28 PM
- Moved by Ronnie VernonMVP Wednesday, December 19, 2012 8:03 PM Moved (From:Windows 8 General)
Reply:
------------------------------------
Reply:
Nope, 40 million is 40 million. Windows 7 (which Win 8 haters here love to say is better) had the same OEM route to follow, and also was available as an upgrade through Vista.
Massive... success. But don't worry mate, nobody will look down on you too much for the damage control.
:p
- Edited by ProjectVRD Wednesday, December 19, 2012 2:58 PM
------------------------------------
Reply:
Nope, 40 million is 40 million. Windows 7 (which Win 8 haters here love to say is better) had the same OEM route to follow, and also was available as an upgrade through Vista.
Massive... success. But don't worry mate, nobody will look down on you too much for the damage control.
:p
You are surely joking, right? You're seriously claiming that Windows 8 is more successful that Windows 7?
HAHAHAHAHAHAHAHAHAHAHAHA!!!!!!! Oh wow - that is HILARIOUS! Thanks for the good laugh. :)
------------------------------------
Reply:
Consumer reports is warning people not to upgrade to Windows 8. That is NOT a "massive success".
https://www.tomshardware.com/news/consumer-reports-windows-8-upgrade-donna-tapellini-modern-ui,19878.html
------------------------------------
Reply:
This is not surprising - it goes to show that Microsoft has built up a good name by doing the right things for a long time. New versions of Windows have been getting better and better.
People who don't know what Windows 8 is like because they have not evaluated it for themselves, and either haven't read the reviews or are ignoring them because they can't believe Windows 8 could be worse than its predecessors, are buying on the general principle that it must be good.
And of course people think $39.95 is a great deal. What was a Windows 7 Pro upgrade? $100 more that that?
But we're still seeing no shortage of new users posting online saying "What the...?".
Can't blame Microsoft for using every bit of its accumulated reputation and sales prowess to sell its new product. But what are they doing to themselves for the next time around by releasing a product that does not improve upon its predecessor?
-Noel
| Detailed how-to in my eBooks: | Configure The Windows 7 "To Work" Options |
------------------------------------
Reply:
This is not surprising - it goes to show that Microsoft has built up a good name by doing the right things for a long time. New versions of Windows have been getting better and better.
People who don't know what Windows 8 is like because they have not evaluated it for themselves, and either haven't read the reviews or are ignoring them because they can't believe Windows 8 could be worse than its predecessors, are buying on the general principle that it must be good.
And of course people think $39.95 is a great deal. What was a Windows 7 Pro upgrade? $100 more that that?
But we're still seeing no shortage of new users posting online saying "What the...?".
Can't blame Microsoft for using every bit of its accumulated reputation and sales prowess to sell its new product. But what are they doing to themselves for the next time around by releasing a product that does not improve upon its predecessor?
-Noel
Detailed how-to in my eBooks:
Configure The Windows 7 "To Work" Options
Configure The Windows 8 "To Work" Options
I got Windows 7 for free because I bought a Vista laptop and took advantage of the give away Microsoft offered over a period of about nine months. I have yet to see any valid reasons why Windows 8 is not an improvement, I only see the 'loud minority' effect drowning out the 'quiet majority'. Much like that which happens everywhere else such as people complaining that iOS 5 was bad because it stopped people getting reception, Playstation 3 was bad because it didn't let them play their PS2 games and that the new Ford Focus ST was bad because it had a few horsepower less.
The fact that all of these things added something, and the new Focus ST was in fact a better spec'd car, seemed to have no affect on the 'loud minority'. Windows 8 is an uncontested success no matter what you people on here try saying.
------------------------------------
Reply:
Fine, but what's better about Windows 8? It's a simple question.
What does it do that compels us to upgrade? In my world, nothing. I'm just one person, running a high tech business, and I'll wager I've actually used Windows 8 as much or more than you.
Yes, there are a VERY small number of new features (e.g., Hypervisor) that are extremely useful to a few specific people who need them, but for those who don't... There's a bunch of useful stuff deleted, there's some stuff that's changed for the sake of making it look new and improved (and blocking the option to make it look and work the "old way"), but there's nothing added to offset the deletions. It's just not "gee whiz" new tech that makes life better, like every version (including Vista) was in the past.
And what's worse, the obvious change of direction defining where Microsoft is now going - that of powering consumer toys to the exclusion of serious and business computing - is not inspiring a lot of love from people who still need real computers.
If in your opinion serious, perceptive people who understand what they're looking at are a "loud minority", I won't argue. I don't claim my computing needs are everyone's. But I'm not alone.
It's great that you got a copy of Windows 8 on your new laptop and you're not disappointed with it. Forgive me if I don't jump up and down with joy about how Windows 8 is something we could all live with if we all just suck it up and stop expecting better.
Given that my own quite in-depth Return on Investment analysis turned up negative even if Windows 8 were given to me for free for all my systems, should I be standing on a soapbox anyway and shouting about how wonderful it is that it's only a little worse than its predecessor but I could find a way (by spending more money and time) to live with it anyway?
-Noel
| Detailed how-to in my eBooks: | Configure The Windows 7 "To Work" Options |
------------------------------------
SCCM 2012 SP1 Secondary site
Hi All,
Could you please tell me how to install (SCCM 2012) SP1 on secondary site.
Sengottuvel M
Reply:
Hi,
First check if you need to upgrade the SQL Express installation on the secondary site: From the KB:
"While the RTM version of System Center 2012 Configuration Manager requires Cumulative Update 4 for SQL Server 2008 R2 Service Pack 1, System Center 2012 Configuration Manager SP1 requires Cumulative Update 6 for SQL Server 2008 R2 Service Pack 1 (or SQL Server 2008 R2 SP2)."
http://support.microsoft.com/kb/2688247?wa=wsignin1.0
You initiate the upgrade of the secondary site from the admin console in the Primary site. It is described in Niall's Guide here: http://www.niallbrady.com/2012/06/20/how-can-i-upgrade-system-center-2012-configuration-manager/
regards,
Jörgen
-- My System Center blog ccmexec.com -- Twitter @ccmexec
------------------------------------
No comments:
Post a Comment