High-Safety Mode Session Design Consideration
Hello All,
Please ignore my ignorance regarding this topic as I am absolutely new to SQL Server. So, this is my scenario :We have 2 site, 1 in Bangalore and other in NY. We are providing HA in each site by SQL failover cluster. Now for site resilience, we intend to replicate the data between sites using SQL Mirroring in High-Safety Mode Session without Automatic Failover.
So, wanted to if the above configuration is supported and will it work. Do we not need any witness server in each site or quorum shall suffice. Why should we not use the High Performance mode. Is it good recommendation to use SAN storare replication rather than SQL mirroring.
Please help me with these answers
TA
Reply:
The failover cluster instances should have a quorum witness. However taking a guess one of the sites a DR site. In which case, you should evaluate the votes (or node weight) on the primary and DR site. On such distance Sync Replication is not recommended. Instead of using database mirroring would recommend you consider SQL Server AlwaysOn Availability Group configuration. This will allow you to configure FCI (HA) and AG (DR).
With understanding you can have potentinal for data loss over such distances.
Another option is SAN replication, however I do not have much experience in that. So hopefully someone else can answer for that. If you do consider SAN replication as an option, then you should consider Multi-Site Clustering using FCI.
Mohit K. Gupta --- MCTS, MCITP, MCC2011
------------------------------------
503: System.Data.Services.Client.DataServiceClientException
Hi
When I am running even a simple runbook from command prompt using SCOrchutil command, it is giving the following error:
An error occurred while processing this request.
503: System.Data.Services.Client.DataServiceClientException: <!DOCTYPE HTML PUBL
IC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Service Unavailable</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Service Unavailable</h2>
<hr><p>HTTP Error 503. The service is unavailable.</p>
</BODY></HTML>
at System.Data.Services.Client.QueryResult.Execute()
at System.Data.Services.Client.DataServiceRequest.GetQuerySetCount(DataServic
eContext context)
Please help me in solveing this issue.
Thanks,
Abhi
Reply:
Were you able to resolve the issues? I ran into the same error message after a password change. The resource pool used by Orchestrator WebService was using the same account who's password was changed. After updating the password on the Resource Pool the error message went away.
A bit late... just wanted to post this in case anyone runs into the same problem.
-- Nef
- Edited by Nefus Wednesday, March 27, 2013 2:58 PM
------------------------------------
Reply:
Hi Nefus,
Initially I thought that the issue was same as yours ( password change ).
Still I am getting the same issue.
Re-Installed Orchestrator completely, so solved the issue.
Thanks & Regards,
Abhi
------------------------------------
Reply:
------------------------------------
how to show share see more infomation
hello
in sharepoint I try share with one people but very more name the same and jobtitle the same
who I kown config see more as department please help me
Image Capture Wizard - Error Code 0x0000007F
Hi I could fine capture windows 7 (86 & 64) with
Then I created a new Boot image with Windows ADK 8.0 but still i got the same error?
What have gone wrong? I try to find a log on the mashine c:\windows\system32\ccm* but the folder isnt there??
How do i fix this?
Helpdesk Supporter
- Changed type LongQuo Thursday, June 25, 2015 11:20 AM dobberlt post
Reply:
The client log folder is in c:\windows\ccm. Do you have a C:\_SMSTaskSequence folder? Check those places for smsts.log.
Jeff
------------------------------------
Reply:
I have that _SMSTaskSequence folder but there isnt must to see but this
no log files. do the capture wizard clean it selfup when i press the close button?
IT Adm
------------------------------------
Reply:
this is a dobbelt post. I will be using the other post
https://social.technet.microsoft.com/Forums/en-US/9eb4dcaf-5925-46cf-a0ad-81a9928f1234/ts-error-capture-windows-xp-pro-sp3-image-capture-wizard-sccm2012r2-cu5?forum=configmanagerosd
IT Adm
------------------------------------
How to apply CDC on production server database/tables?
If I apply CDC on production server database and table then will it create all the CT tables in same production database? If so, will it increase the database size drastically? What is the case for Oracle DB and Sql Server DB for CDC on production server?
Will it create any separate copy of db/tables?
- Edited by Ashutosh Atre Thursday, June 25, 2015 7:22 AM
Reply:
Hello Ashutosh - Yes when you enable CDC the associated tables are created within the same database and used to log the changes. This is by design and there is NO way to change this configuration.
At best, you can create separate Filegroup to put your CDC related tables on and you can do this by specifying/ using the @filegroup_name parameter of sys.sp_cdc_enable_table system stored procedure
Full Syntax & Notes here:
https://msdn.microsoft.com/en-us/library/bb522475.aspx?f=255&MSPPError=-2147217396
Hope this helps
Good Luck!
Please Mark This As Answer if it solved your issue.
Please Vote This As Helpful if it helps to solve your issue
------------------------------------
Calling all BizTalk Gurus! May results reminder. Plus last call for June Gurus!
Last week saw the results for May's TechNet Guru competition, and you only have a week left to enter June's Competition!
Here is a reminder of May's winners, below.
The last column being a few of the comments from the judges.
Unfortunately, runners up and their judge feedback comments had to be trimmed from THIS post, to fit into the forum's 60,000 character limit, however the full version is available on TechNet Wiki.
Some articles only just missed out, so we may be returning to discuss those too, in future blogs.
 | BizTalk Technical Guru - May 2015 |
| | Sandro Pereira | BizTalk DevOps: Monitor your BizTalk environment using PowerShell | Ed Price: "BizTalk DevOps! With PowerShell??? Man, talk about a hot topic with valuable content! Fantastic job on this one!" Mandi Ohlinger: "Nice job Sandro. Great solutions using PowerShell. " LG: "It is realy practical and high value article." |
| | Johns-305 | BizTalk: Running Orchestrations in Multiple Hosts On The Same Computer | LG: "It is one of the great finding that requires deep knowledge of a product and still anyway would avoid public." Mandi Ohlinger: "Great idea and great sample. Thank you Boatseller!" Ed Price: "Great job on this hot topic! Great to have the download link and end with a Wiki cross-link!" |
| | Sandro Pereira | BizTalk Server 2013 R2: WCF-SAP Adapter Step-by-Step Installation Guide | Ed Price: "This is such an amazing installation guide! The depth is so spot on!" LG: "Great knowledge gathered in this article." |
| Microsoft Azure Technical Guru - May 2015 |
| | Chervine | Big Data Analytics using Microsoft Azure: Hive | JH: "I love the article from Chervine. Hope to see another one from this series very soon." Ed Price: "Truly magnificent! The depth here is astonishing! Love the diagram. Great code formatting. Thorough References section!" |
| | Ken Cenerelli | Custom Telemetry Events with TrackEvent in Microsoft Application Insights | Alan Carlos: "Wow! I love AppInsights and this article is fantastic! Congrats!" Ed Price: "I love the topic of App Insights! Great formatting throughout this article! The red arrows/callouts in the images help a ton. Great ending with the References and See Also sections!" JH: "Great article about App Insights. Would love to see more detailed ones about it." |
| | Ken Cenerelli | Azure PowerShell cmdlets version updates | JH: "Nice, short and simple. Seems to be the time for me to check my Azure PowerShell version." Ed Price: "Great topic with PowerShell! This is such a beautifully formatted article that's incredibly easy to read and understand. Fantastic job!" |
| Miscellaneous Technical Guru - May 2015 |
| | Carmelo La Monica | Read the temperature with Arduino Uno | Philippe Levesque: "Really refreshing content and well explained" Richard Mueller: "Great images. We need more references." |
| | Danish Islam | Microsoft Office Sway | Richard Mueller: "Good use of Wiki guidelines. I liked the detailed steps to get started and the references." Philippe Levesque: "Good introduction to Sway!" |
| | Pooja Baraskar | Moisture sensor with Windows on Galileo | Philippe Levesque: "Great job on this content" Richard Mueller: "Great images." |
| SharePoint 2010 / 2013 Technical Guru - May 2015 |
| | Dan Christian | SharePoint 2013 External List from Oracle Database | Hezequias Vasconcelos: "It is important to see the integration of SharePoint 2013 with other platforms not Microsoft. This shows the confidence that the business environment has on the product." KB: "Very detailed and a lot of screenshots. Nice work!" TN: "Helpful article to connect SP & Oracle database" Ed Price: "This is fantastic! I love how the three videos walk you through the steps as well!" |
| | Inderjeet Singh Jaggi | What is a Web Application in SharePoint? | Ed Price: "Great description and use of PowerShell commands." |
| | Danish Islam | Excel Services Issue in SharePoint 2013/2010 | Ed Price: "This is very clear, with a helpful solution. A combination of the text of the error message and the image help add the clarity. Great formatting. It could benefit from a See Also section." |
| Small Basic Technical Guru - May 2015 |
| | Ezra94 | Small Basic: Optimization | Michiel Van Hoorn: "This is really usefull and great reading for developers who looking for more complex application and want to avoid pitfall.s" Ed Price: "Ezra and Nonki did an amazing job on this article! I was recently going through these issues with some various users, and this article has helped give us a ton of ideas! Great article! Great formatting on the sections and code snippets, and I love all the resources at the end! That Bill Gates article is a fun one!" RZ: "Very nice! And very engaging. Much more fun than just talking about Optimization. :)" |
| | Nonki Takahashi | Small Basic: Kinect for Small Basic Extension Library | Michiel Van Hoorn: "For those lucky guys with a kinect sensor on their pc: get busy. For others: buy a sensor!" Ed Price: "A reference doc for the Kinect Extension. Great! And I love the picture! Also, good visibility in the See Also to show the other extensions available!" RZ: "Excellent as usual. Yeah, Kinect! What else needs to be said? :)" |
| SQL Server General and Database Engine Technical Guru - May 2015 |
| | Andy ONeill | Developer Friendly XML Extraction From SQL Server | DRC: "Good article for developers to extract the SQL data in XMl format for processing. The SQL Server instance name in the BCp command should be "-S" [Upper case]. Else we encounter the error: C:\temp>bcp.exe "SQLquery" queryout c:\temp\xmlFileName.xml -w -T -s<Hostname\Instancename> bcp.exe: unknown option s We get the below error if we don't specify the servername as it always tries to connect to default instance on the machine on which the command is executed.So "-S" parameter need to be included. bcp "EXEC [AdventureWorks2012].[dbo].[XML_Extract_Employees]" queryout D:\test.xml -w -T C:\temp>bcp "EXEC [AdventureWorks2012].[dbo].[XML_Extract_Employees]" queryout c:\temp\test.xml -w -T SQLState = 08001, NativeError = 2 Error = [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2]. SQLState = 08001, NativeError = 2 So the commandd should be: bcp "EXEC [AdventureWorks2012].[dbo].[XML_Extract_Employees]" queryout D:\test.xml -w -T -S<hostname\Instancename> " Durval Ramos: "An interesting article, but need to add more XML examples and other structures, including attributes and special characters (encoding)" AM: "Great introduction to FOR XML feature." |
| System Center Technical Guru - May 2015 |
| | GerryHampson | Analyse your ConfigMgr data with Microsoft Power BI | Alan Carlos: "Great article and content." Ed Price: "Great job on the detail and some very helpful images! It could benefit from a TOC, section headers, and a See Also section. Great article! Powerful topic!" |
| | Sridhar Vishwanatham | Optimizing rule in scom 2007/2012 | Ed Price: "Good topic with great info. It could benefit from a TOC, bigger section headers, and a See Also section that links to related Wiki articles. Good diagram! It's very easy to follow along through the details!" |
| | MarkusEliasson | Troubleshoot ID 30111 from DPM: VssError: The specified object was not found | Ed Price: "Helpful info! Please check out the article comment from Mike J and update acordingly. Great topic!" MJ: "I Added a comment to make it more complete." |
| Transact-SQL Technical Guru - May 2015 |
| | Ronen Ariely | T-SQL: Sort data by multiple languages | Richard Mueller: "Good explanation. I like the highlighted notes." Durval Ramos: "This article is very interesting, and demonstrates effectively how to work with UNICODE data. Very well detailed article and also have T-SQL script to download on TechNet Gallery." |
| | Saeid Hasani | T-SQL: Make a Read Copy of Database by Using Synonym, Trigger and SQL Agent Job | Durval Ramos: "Very useful, this article is well structured over an interesting scenario. I have read many threads about copy of a database on Forums. Also have T-SQL script to download on TechNet Gallery." Richard Mueller: "We need links/references." |
| Universal Windows Apps Technical Guru - May 2015 |
| | Emiliano Musso | Geolocalize a device and store coordinates on Webserve | Ed Price: "Wow! This is such an amazing article! The detail, images, formatting, and everything are all fantastic! I'd love to see a See Also section and Wiki cross-linking, but this is a fantastic article!" JH: "Location-aware apps are very important nowadays. I like the approach in this article to not use the complete Microsoft stack, instead to use PHP and MySQL. Would be cool to see it with more technologies, such as Node.js." |
| | Lee McPherson | Leverage Continuum feature to change UI for Mouse/Keyboard users using custom StateTrigger | JH: "I like it when an app behaves 'native' on different devices. Hope that the times where I can't use my big fingers are gone." Ed Price: "Great descriptions and execution on formatting each section!" |
| | Pooja Baraskar | Localization in Windows Universal Apps | JH: "Localization and Globalization is something most apps have their problems with. This article shows how easy it can be. Love it!" Ed Price: "As Danish mentions in the article comments, it's very easy to understand! The images are helpful and the explanations are thorough!" |
| Visual Basic Technical Guru - May 2015 |
| | tommytwotrain | VB.Net: High resolution printouts of the Chart control by using a Metafile | MR: "Very helpful article!" Richard Mueller: "Good work. We need links/references." |
| | Emiliano Musso | Sort and Filter CSV files with DataTable and DataView | Richard Mueller: "Good use of TOC." MR: "Great article on intro to Data Tables" |
| Visual C# Technical Guru - May 2015 |
| | .paul. | Multi-page DGV Printing | Carmelo La Monica: "Very great content and detailed in all parts!" Jaliya Udagedara: "It would have been great, if explanations were provided for each method in the provided code." |
| | Yan Grenier | C# : Windows Service in console mode for debug and admin | Jaliya Udagedara: "I really enjoyed reading this article. Well explained with images, code snippets, and the source code is available in MSDN Code Gallery. It's just perfect!" Carmelo La Monica: "I don't know very much about Windows Service, but this article is for me and other users a good starting point, congrats!" |
| | Tom Mohan | Getting Started With WCF | Jaliya Udagedara: "Detailed article about WCF which I am sure beginners will find quite interesting." Carmelo La Monica: "Very helpful article, and great demo for to understand how to use WCF service, congratulations!" |
| Wiki and Portals Technical Guru - May 2015 |
| | Andy ONeill | Why YOU should enter the Technet WIki Guru Competition | PG: "Nice, useful article" Durval Ramos: "This article provides good arguments to encourage our Community to share knowledge. Congrats on your initiative, Andy!!!" Richard Mueller: "Great topic and well written. Good use of guidelines for articles." |
| Windows PowerShell Technical Guru - May 2015 |
| | Arleta Wanat | SharePoint Online content types in Powershell: Add | Richard Mueller: "Well written. Good links. I needed more explanation/examples." Chen V: "Excellent Article! Great Explanation with Related Links! " |
| | sridhar vishwanatham | SCOM 2012: Bulk override creation for monitors and rules using PowerShell | Alan Carlos: "Wow, great tip!!!" Chen V: "Good script to keep SCOM healthy!" Richard Mueller: "Needs links/references." |
| | Arleta Wanat | Manage SharePoint Online Access Requests using Powershell | Richard Mueller: "Interesting." Chen V: "Good Article - Screen shots makes it clear." |
| Windows Presentation Foundation (WPF) Technical Guru - May 2015 |
| | Andy ONeill | Dependency Property Default Double Trouble | KJ: "I love these kind of articles. this has bit me in the past." Ed Price: "Love the end-to-end perspective!" |
| | Tom Mohan | Data Input Validation In WPF : Validation With Exception | Ed Price: "Valuable contribution!" KJ: "short and sweet - nice." |
| | Andy ONeill | Animating a ViewModel | KJ: "neat stuff! very fancy!" Ed Price: "Great topic with powerful depth!" |
| Windows Server Technical Guru - May 2015 |
| | Richard Mueller | Active Directory: Large Integer Attributes | JM: "This is an excellent article, thanks for your continued contributions" Mark Parris: "Excellent insights." Philippe Levesque: "Well written article and well explained !" |
| | Manjunath Sullad | How to Identify "Shared" and "Non-Shared" disks on cluster nodes | Philippe Levesque: "Good technical tip !" JM: "This is a very good article on cluster node HDDs, good job" Mark Parris: "Good tidbit." |
| | Darshana Jayathilake | Useful powershell commands for manage servers & desktops | Mark Parris: "Good knowledge to have." JM: "This article provides a great basis for a topic to which many folks can contribute their favorite PowerShell commands" |
As mentioned above, runners up and comments were removed from this post, to fit into the forum's 60,000 character limit.
You will find the complete post, comments and feedback on the main announcement post.
Please join the discussion, add a comment, or suggest future categories.
If you have not yet contributed an article for this month, and you think you can write a more useful, clever, or better produced wiki article than the winners above, here's your chance! :D
Best regards,
Pete Laker
More about the TechNet Guru Awards:
#PEJL
Got any nice code? If you invest time in coding an elegant, novel or impressive answer on MSDN forums, why not copy it over to TechNet Wiki, for future generations to benefit from! You'll never get archived again, and you could win weekly awards!
Have you got what it takes o become this month's TechNet Technical Guru? Join a long list of well known community big hitters, show your knowledge and prowess in your favoured technologies!
Reply:
Good news, thanks for sharing this information to us.
With regards,
Angie
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
------------------------------------
system uptime - scom
Reply:
Hi
System availability report provide in % value and if you further drill down you can see uptime in HH:MM:SS, units are seconds.
Regards
sridhar v
------------------------------------
Reply:
------------------------------------
ADFS: Issuance Authorization Rule, group membership changes are not reflecting immediately
Hi Experts,
We have an ADFS trust for Box login and we have created a Issuance Authorization Rule, user will be permitted to provide claims if only user is present in one security group.
But we are facing issue with this approach since the group modifications are not reflecting even though the AD is replicating perfectly fine. For example if we remove a user form Box-allowed-group, user is still not able to access BOX for next 1 to 2 hrs. Whenever user is trying to access within this time range we are getting Event ID 325.
Is this is because of any inbuilt cache mechanism for Issuance Authorization Rule?
Is there any way to fix this issue?
Event ID 325:-
The Federation Service could not authorize token issuance for caller 'DOMAIN\XXXX
'. The caller is not authorized to request a token for the relying party 'box.net'. Please see event 501 with the same instance id for caller identity.
Regards, Nidhin.CK
- Changed type Vivian_Wang Thursday, June 25, 2015 5:33 AM
Reply:
Hi,
For this issue, i think you could ask in ADFS forums:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=Geneva
Regards.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com
------------------------------------
Local and Microsoft user accounts
Well I just jumped onto the Windows 10 Preview today so I'm not sure if this is a known thing or not. I came from Windows 8.1 which seemed to have the correct approach on the matter but I can't seem to find what I'm looking for in Windows 10. In my previous install of 8.1, there were options to link a local account to a Microsoft account. So for example, I could have a local user configured as "jdoe" and also at the login screen sign in with my "example@live.com" account.
In windows 10, this appears to be different.. From initial installation, you are asked to login to your Microsoft account. At least to my knowledge I didn't see a way to create a local account, I was however sort of just clicking through it. What this does from the install, is creates a user with the first 5 characters of the Microsoft as if it were a local user on the computer, which personally just seems a bit unprofessional to me. After the Windows 10 install, if I choose to login as a local account ( Settings -> Accounts -> Your account ), it logs you out of the current Microsoft user as expected, but keeps the Microsoft user's profile in tack.
So an example, if I created a local account "jdoe" after having logged into "example@live.com" after install my "jdoe" user is still saving information into the "examp" user profile, instead of a "jdoe" profile directory. This appears to be one of my problems in the matter. Secondly, I'm unable to find a way to keep a local account, but login to my Microsoft account at the login screen like I could in Windows 8.1. So I'm basically looking for some assistance on the matter if available.
Thanks.
- Changed type moom00z Wednesday, June 24, 2015 8:21 PM
Reply:
You can still do what you want to do. You obviously chose the wrong option somewhere.
You can create a local account and have it use its own profile. It appears to me that you have somehow converted your account from one type to the other. I was not aware that you could convert a Microsoft account to a local account. I knew that you can do the opposite ie convert a local account to a Microsoft account.
I certainly have a Windows 10 Preview installation where I have the option to log in to either a local or Microsoft account.
You will automatically be offered the Microsoft account option if you are connected to the Internet when you install the OS.
Bill
------------------------------------
Be our System Center Guru of the month! Let us bestow glory and kudos upon you!
TechNet Gurus... we salute you!
You're awesome, and we know it!
Your knowledge uploads and nifty info nuggets are our life blood at TechNet Wiki.
Every awesome article that gets an award is just the start. We are building up the most sensational collection of gifts of knowledge from eminent community heavy weights and young guns alike. And we plan to promote you and your work wherever we can.
Reputations are being forged.
History is being made.
Generations will know your name.
Your children, grandchildren and great-grandchildren will marvel at your technical prowess.
And now, my mighty code warriors, cool consultants and platform specialists, now your chance is here again.
A new month of possibilities. Another chance to prove YOU are the ONE!
The mighty TechNet Guru medal winner for June!
Take up your mouse and keyboard!
Unleash your mighty words of wisdom and bask in the glory that we bestow upon you!
GO GO Gurus! Give, give, give!
All you have to do is add an article to TechNet Wiki from your own specialist field. Something that fits into one of the categories listed on the submissions page. Copy in your own blog posts, a forum solution, a white paper, or just something you had to solve for your own day's work today.
Drop us some nifty knowledge, or superb snippets, and become MICROSOFT TECHNOLOGY GURU OF THE MONTH!
This is an official Microsoft TechNet recognition, where people such as yourselves can truly get noticed!
HOW TO WIN
1) Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
2) Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed)
3) Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favoured technology will help us learn the active members in each community.
Feel free to ask any questions below.
More about TechNet Guru Awards
Submit now : http://social.technet.microsoft.com/wiki/contents/articles/31200.technet-guru-contributions-june-2015.aspx
#PEJL
Got any nice code? If you invest time in coding an elegant, novel or impressive answer on MSDN forums, why not copy it over to TechNet Wiki, for future generations to benefit from! You'll never get archived again, and you could win weekly awards!
Have you got what it takes o become this month's TechNet Technical Guru? Join a long list of well known community big hitters, show your knowledge and prowess in your favoured technologies!
Reply:
We have no System Center articles yet!
And 7 days to go!
Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Reply:
We have no System Center articles yet!
And 7 days to go!
Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
Got an article done, but very frustrating experience. took a Win7 computer, a Win8 computer, IE, 1 copy of Firefox and 1 copy of Safari on OSX to fully edit and save a wiki article. :( Seems some parts of the wiki work with IE, some with firefox, but the Contributions page would only save if I used Safari on OSX.
but it's done and I'm happy :)
- Edited by Darren Joyce Thursday, June 25, 2015 5:03 AM
------------------------------------
my fix for IE 11 "page cannot be displayed"
- Changed type Deason Wu Thursday, June 25, 2015 4:20 AM not a question
Reply:
Hi Chris,
Glad to hear this issue has been solved. Thanks for sharing. We really appreciate your time and efforts. Hope your experience will help other community members facing similar problems.
Regards,
D. Wu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
------------------------------------
my personal folder dissapered from crome book
Reply:
------------------------------------
Windows 10 and WHS 2011
Hello,
Just wanted to say that after a short test, it seems that Windows 10 TP works OK
as a client in a WHS 2011 network. Did some backups, restored some files,
all went smooth.
Looking forward to the final release.
Per
- Changed type Carey FrischMVP, Moderator Thursday, June 25, 2015 2:23 AM Comment
Reply:
Thank you for sharing this information.
Please try out and test Windows 10 TP and if there was any issue , problem or feedback, report them through feedback form.
------------------------------------
Reply:
Hi, same here installed the connector for WHS 2011 and works as expected with initial Windows 10 release.
However, after installing the latest build (9860) it is not working anymore. The connector always see the server offline and asks me if I want to connect offline. The alert viewer shows an error. I guess it is because the new notification centre, which was not part of first build.
Claude
------------------------------------
Reply:
Raghu
------------------------------------
Reply:
Build 10130: When I install WHS Connector, it works. When I reboot Windows 10, the server is "offline." I've repeated this several times. Kind of a pain to have to uninstall and reinstall it EVERY time the machine is rebooted.Hi, same here installed the connector for WHS 2011 and works as expected with initial Windows 10 release.
However, after installing the latest build (9860) it is not working anymore. The connector always see the server offline and asks me if I want to connect offline. The alert viewer shows an error. I guess it is because the new notification centre, which was not part of first build.
Claude
------------------------------------
A solution for systems management
- Dell KACE K1000 Systems Management and K2000 Systems Deployment Appliances
- LANDESK Management Suite 9.6 SP1
- Microsoft System Center 2012 R2 Configuration Manager (SCCM)
- Symantec Altiris Client Management Suite (CMS) 7.5 SP1
http://en.community.dell.com/techcenter/b/techcenter/archive/2015/03/16/why-do-you-need-a-systems-management-solution-and-which-one-is-the-best-for-you-new-white-paper-from-ema-has-the-answers
In outlook (version 14.0.7151.5001) ,tracking options notifications selected are greyed out in the calendar , how can I remove them ?
Checklist to Validate SQL Replication
Hi Folks,
I'm trying to pull the list of areas or data into a report to validate the replication after SQL or OS patches. Basically I'd like to verfiy the REPL status after patch followed with reboot/restart. We had a few times where the replication couldn't caught due to connectivity issues and didn't resume well. Not sure if anyone of you've faced similar or other issues so, trying to run Pre-Image and Post-Image of sql repl.
My list includes
1. Check the DB status
2. Job Status ( Distribution and Log reader agent )
3. Security settings
4. MSrepl_errors
What are the other items that i should include in the list for lookup? Or any other better approach ?
Please advise.
Thanks
Reply:
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
------------------------------------
Multiple referenced relationships over the same intermediate dimension - generated processing query
Hi, I know the title is a bit confusing so let me try to explain it:
I have added 3 new dimensions do the AdventureWorks cube - RefA, RefB and RefC:
They are all related to the DimReseller table, and finally, to the FactResellerSales table. In the dimension usage chart, you can see that there are 4 referenced relationships using the Reseller dimension as the intermediate dimension. The Geography was the existing one, and the other 3 were added.
Now, if I process a partition from the Reseller Sales measure group, the Profiler catches this generated query on the server:
SELECT [dbo_FactResellerSales].[dbo_FactResellerSalesSalesAmount0_0] AS [dbo_FactResellerSalesSalesAmount0_0] ,[dbo_FactResellerSales].[dbo_FactResellerSalesOrderQuantity0_1] AS [dbo_FactResellerSalesOrderQuantity0_1] ,[dbo_FactResellerSales].[dbo_FactResellerSalesExtendedAmount0_2] AS [dbo_FactResellerSalesExtendedAmount0_2] ,[dbo_FactResellerSales].[dbo_FactResellerSalesTaxAmt0_3] AS [dbo_FactResellerSalesTaxAmt0_3] ,[dbo_FactResellerSales].[dbo_FactResellerSalesFreight0_4] AS [dbo_FactResellerSalesFreight0_4] ,[dbo_FactResellerSales].[dbo_FactResellerSalesDiscountAmount0_5] AS [dbo_FactResellerSalesDiscountAmount0_5] ,[dbo_FactResellerSales].[dbo_FactResellerSalesUnitPrice0_6] AS [dbo_FactResellerSalesUnitPrice0_6] ,[dbo_FactResellerSales].[dbo_FactResellerSalesUnitPriceDiscountPct0_7] AS [dbo_FactResellerSalesUnitPriceDiscountPct0_7] ,[dbo_FactResellerSales].[dbo_FactResellerSalesTotalProductCost0_8] AS [dbo_FactResellerSalesTotalProductCost0_8] ,[dbo_FactResellerSales].[dbo_FactResellerSalesProductStandardCost0_9] AS [dbo_FactResellerSalesProductStandardCost0_9] ,[dbo_FactResellerSales].[dbo_FactResellerSales0_10] AS [dbo_FactResellerSales0_10] ,[dbo_FactResellerSales].[dbo_FactResellerSalesEmployeeKey0_11] AS [dbo_FactResellerSalesEmployeeKey0_11] ,[dbo_FactResellerSales].[dbo_FactResellerSalesPromotionKey0_12] AS [dbo_FactResellerSalesPromotionKey0_12] ,[dbo_FactResellerSales].[dbo_FactResellerSalesSalesTerritoryKey0_13] AS [dbo_FactResellerSalesSalesTerritoryKey0_13] ,[dbo_FactResellerSales].[dbo_FactResellerSalesResellerKey0_14] AS [dbo_FactResellerSalesResellerKey0_14] ,[dbo_FactResellerSales].[dbo_FactResellerSalesProductKey0_15] AS [dbo_FactResellerSalesProductKey0_15] ,[dbo_FactResellerSales].[dbo_FactResellerSalesCurrencyKey0_16] AS [dbo_FactResellerSalesCurrencyKey0_16] ,[dbo_FactResellerSales].[dbo_FactResellerSalesOrderDateKey0_17] AS [dbo_FactResellerSalesOrderDateKey0_17] ,[dbo_FactResellerSales].[dbo_FactResellerSalesShipDateKey0_18] AS [dbo_FactResellerSalesShipDateKey0_18] ,[dbo_FactResellerSales].[dbo_FactResellerSalesDueDateKey0_19] AS [dbo_FactResellerSalesDueDateKey0_19] ,[dbo_DimReseller_6].[GeographyKey] AS [dbo_DimResellerGeographyKey5_0] -- 1 ,[dbo_DimReseller_22].[RefAKey] AS [dbo_DimResellerRefAKey7_0] -- 2 ,[dbo_DimReseller_23].[RefBKey] AS [dbo_DimResellerRefBKey9_0] -- 3 ,[dbo_DimReseller_24].[RefCKey] AS [dbo_DimResellerRefCKey11_0] -- 4 FROM ( SELECT [SalesAmount] AS [dbo_FactResellerSalesSalesAmount0_0] ,[OrderQuantity] AS [dbo_FactResellerSalesOrderQuantity0_1] ,[ExtendedAmount] AS [dbo_FactResellerSalesExtendedAmount0_2] ,[TaxAmt] AS [dbo_FactResellerSalesTaxAmt0_3] ,[Freight] AS [dbo_FactResellerSalesFreight0_4] ,[DiscountAmount] AS [dbo_FactResellerSalesDiscountAmount0_5] ,[UnitPrice] AS [dbo_FactResellerSalesUnitPrice0_6] ,[UnitPriceDiscountPct] AS [dbo_FactResellerSalesUnitPriceDiscountPct0_7] ,[TotalProductCost] AS [dbo_FactResellerSalesTotalProductCost0_8] ,[ProductStandardCost] AS [dbo_FactResellerSalesProductStandardCost0_9] ,1 AS [dbo_FactResellerSales0_10] ,[EmployeeKey] AS [dbo_FactResellerSalesEmployeeKey0_11] ,[PromotionKey] AS [dbo_FactResellerSalesPromotionKey0_12] ,[SalesTerritoryKey] AS [dbo_FactResellerSalesSalesTerritoryKey0_13] ,[ResellerKey] AS [dbo_FactResellerSalesResellerKey0_14] ,[ProductKey] AS [dbo_FactResellerSalesProductKey0_15] ,[CurrencyKey] AS [dbo_FactResellerSalesCurrencyKey0_16] ,[OrderDateKey] AS [dbo_FactResellerSalesOrderDateKey0_17] ,[ShipDateKey] AS [dbo_FactResellerSalesShipDateKey0_18] ,[DueDateKey] AS [dbo_FactResellerSalesDueDateKey0_19] FROM ( SELECT [dbo].[FactResellerSales].[ProductKey] ,[dbo].[FactResellerSales].[OrderDateKey] ,[dbo].[FactResellerSales].[DueDateKey] ,[dbo].[FactResellerSales].[ShipDateKey] ,[dbo].[FactResellerSales].[ResellerKey] ,[dbo].[FactResellerSales].[EmployeeKey] ,[dbo].[FactResellerSales].[PromotionKey] ,[dbo].[FactResellerSales].[CurrencyKey] ,[dbo].[FactResellerSales].[SalesTerritoryKey] ,[dbo].[FactResellerSales].[SalesOrderNumber] ,[dbo].[FactResellerSales].[SalesOrderLineNumber] ,[dbo].[FactResellerSales].[RevisionNumber] ,[dbo].[FactResellerSales].[OrderQuantity] ,[dbo].[FactResellerSales].[UnitPrice] ,[dbo].[FactResellerSales].[ExtendedAmount] ,[dbo].[FactResellerSales].[UnitPriceDiscountPct] ,[dbo].[FactResellerSales].[DiscountAmount] ,[dbo].[FactResellerSales].[ProductStandardCost] ,[dbo].[FactResellerSales].[TotalProductCost] ,[dbo].[FactResellerSales].[SalesAmount] ,[dbo].[FactResellerSales].[TaxAmt] ,[dbo].[FactResellerSales].[Freight] ,[dbo].[FactResellerSales].[CarrierTrackingNumber] ,[dbo].[FactResellerSales].[CustomerPONumber] FROM [dbo].[FactResellerSales] WHERE OrderDateKey >= '20080101' AND OrderDateKey <= '20081231' ) AS [FactResellerSales] ) AS [dbo_FactResellerSales] /*** One JOIN per Referenced Relationship ***/ ,[dbo].[DimReseller] AS [dbo_DimReseller_6] -- 1 ,[dbo].[DimReseller] AS [dbo_DimReseller_22] -- 2 ,[dbo].[DimReseller] AS [dbo_DimReseller_23] -- 3 ,[dbo].[DimReseller] AS [dbo_DimReseller_24] -- 4 WHERE ( ([dbo_FactResellerSales].[dbo_FactResellerSalesResellerKey0_14] = [dbo_DimReseller_6].[ResellerKey]) -- 1 AND ([dbo_FactResellerSales].[dbo_FactResellerSalesResellerKey0_14] = [dbo_DimReseller_22].[ResellerKey]) -- 2 AND ([dbo_FactResellerSales].[dbo_FactResellerSalesResellerKey0_14] = [dbo_DimReseller_23].[ResellerKey]) -- 3 AND ([dbo_FactResellerSales].[dbo_FactResellerSalesResellerKey0_14] = [dbo_DimReseller_24].[ResellerKey]) -- 4 ) As you can see in the comments, the generated query contains 1 join on the referenced table per referenced relationship. This can slow down the processing if both the Fact table and the Referenced Dimension table are big (and they usually are, otherwise the design would be different). The thing is, all 4 tables are filtered in the WHERE clause on the same condition, which makes perfect sense. This leads to the conclusion that all 4 columns could have been read from a single join.
I was quite surprised by this kind of query generation and I can't seem to find a reason why this would be so, or how it could be avoided. Naturally, the RefAKey, RefBKey, RefCKey columns could be added to the Fact table, eliminating the need for referenced relationships, but this would add 3*4 bytes per row to the Fact table. The Fact table in my real example contains around 3 billion rows, so adding extra bytes is painful. (Yes, it's partitioned but still ... )
The referenced relationships could also be "dematerialized" by removing the famous Materialize check in the relationship settings. Then again, this would issue a join to the referenced tables at query time, slowing down the query.
Has anyone been profiling processing queries like this one and stopped to think about it?
Reply:
I'm wondering if this behaviour is by design or there is some bugs involved.
I'll be greatfull if someone shed some light on this issue.
------------------------------------
The Data Received from the server running AD RMS didn't match the expected format.contact your system administrator for further investigation.
Hi All,
We Have implemented AD RMS in our organisation recently.But the Problem we are facing here many users those are Ms office 2013 we will get the error"The Data Received from the server running AD RMS didn't match the expected format.contact your system administrator for further investigation." and those who are in Ms office 2010 Professional it says
"The service is Temporally unavailable.Ensure the you have connectivity to this server.This error could be caused if you are working offline.Proxy setting are preventing your connection or intermittent network issue."
Below are the workaround did,
1.Able to reach to Our pipeline ADRMS cluster.
2.We have a valid Certificate.
3.if we type https://adrms.ourdomain.com its working fine.
4.Manually put the registry setting for effected computers.
5. Applied the Hotfixes:MicrosoftFixit50903,KB2627273.
Kindly help or suggest us to resolve the above issue as many computers in domain are not working with IRM.
Thanks and reqard,
Mohammed Siddiq.
Reply:
------------------------------------
Reply:
Hi Mohammed,
Were you able to fix the issue with CRL disablement?
Did my post help you or make you laugh? Don't forget to click the Helpful vote :) If I answered your question please mark my post as an Answer.
------------------------------------
Reply:
Hello Andrzej;
You right, I don't observe that we have a valid Certificate here.
------------------------------------
Handle Multiple entries in Fact table in Data Cube
EmployeePersonalInfo Table:
EmployeePersonalID Name
E1 Steve(row1)
E2 Mark(row2)
EmployeeDiscipline IncidentInfo Table:
EmployeePersonalID EmployeeDisciplineIncidentID
E1 Dis1(row1)
E2 Dis5(row2)
EmployeeDepartmentInfo Table:
EmployeeDepInfoID EmployeePersonalID
Dep1 E1(row1)
Dep2 E1(row2)
Dep3 E1(row3)
Dep1 E2(row4)
Dep2 E2(row5)
Dep3 E2(row6)
While creating a Fact table with the above entries comes as,
FactDiscipline Table:
EmployeePersonalD EmployeeDepInfoID EmployeeDisciplineIncidentID
E1 Dep1 Dis1(row1)
E1 Dep2 Dis1(row2)
E1 Dep3 Dis1(row3)
E2 Dep1 Dis5(row4)
E2 Dep2 Dis5(row5)
E2 Dep3 Dis5(row6)
Actually Employee E1 in associated with discipline incident Dis1. Since EmployeeDisciplineInfo is joined with it , 3 entries will be there for the same Employee E1. But Employee E1 involved with only one Incident Dis1. In Fact table, it measures the incident count as 3 for Employee E1.
Your help is appreciated!!
Reply:
Hi,
I think this is not the right forum for your question.
Please let us know if you are your SQL Azure service, or SQL server onpremise.
If you are using Azure SQL then you can post your question here : https://social.msdn.microsoft.com/Forums/en-US/home?forum=ssdsgetstarted
else you might want to post your question here: https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlanalysisservices
Regards,
Nithin Rathnakar
------------------------------------
Quartz scheduler not working on cloud service
I had deployed a cloud service in which i has use Quartz scheduler to run a particular task at a particular time (3:00 AM).
But the service does not run the scheduler at that time.
I had debugged it but not able to get the exact solution.
If i deploy the app to local iis and check, it runs fine with the scheduler.
Does the cloud service recycles every 24 hrs, because Quartz scheduler will only hit if the app is running and ping after recycling.
Recycling happens in iis every 24 hrs so we need to hit the app manually for the scheduler to work.
so can you please assist me to get the issue why my scheduler is not working
(Is it because of recycling ?)
Reply:
On Azure, it's best to set up a worker role process for scheduling. Here's an implementation with Quartz.net
http://mattrandle.me/azure-worker-role-and-quartz-net/
------------------------------------
Reply:
Thanks Warren for the link.
In my code i have a web api MVC project and in that i have the scheduler.
Added a web role of this project and deployed the app.
------------------------------------
No comments:
Post a Comment