Sep
18
2015

Outlook360: Lost emails older than 6 months after moving between folders

Faced unique issue when updating my outlook desktop client (Outlook 2013) linked to outlook360 account, issue and fix is as below,   Issue: I created a new temp folder in my inbox and moved all my items including the items older than 6 months from inbox to temp, after 1 day again move them back to inbox, the number of emails remained same. I had to move again for some work but when I moved […]

Aug
24
2015

SQL Server TDE (Transparent Data Encryption) alternatives

TDE (Transparent Data Encryption) is an inbuilt encryption feature of SQL Server Enterprise Edition introduced by Microsoft from SQL server 2008 onwards, this comes in handy when someone has to secure the PII (Personal Identifiable Information) from prying eyes, as it is Enterprise Edition feature only hence comes with a premium price. So while I got a request to analyze implementation of it on more than 200+ SQL standard edition then first thing which has […]

Jul
24
2015

Shrink Data file failed with Error 3140

While shrinking a large (950GB) database file to move data to a secondary NDF, got below 3140 error, it is a normal error occurs while shrinking files of that capacity, please find resolution below,   Error:   Environment: SQL Server 2005 ENT. ed.   Issue: Data file shrink fails for large data file size with Error: 3140   Fix: The following example query truncates the primary data file in the AdventureWorks2008R2 database. The sys.database_files catalog […]

Jul
20
2015

SQL server setup failure – Updating permission setting for file E:\**** failed

While re-installing SQL server, got below error,       To fix this execute below commands with elevated access in command prompt so that permissions get applied to respective path,   Eg: takeown /F c:\Windows\system32\drivers /D y /R    In our scenario commands are provided below:   Here path is “F:” which is a parent folder.   takeown /F F: /D y /R   cacls F: /E /T /C /G “<<<user_AD_account_name>>>“:F

Jun
15
2015

Ten Step Technique to learn

One of best ten step technique for learning,   Link: http://boingboing.net/2015/05/11/the-only-technique-to-learn-so.html  

Jun
10
2015

Virtual Numa Overview – links

Came across following links relevant to Virtual NUMA, read for additional knowledge,     Vmware: https://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.resmgmt.doc%2FGUID-A80A6337-7B99-48C8-B024-EE47E2366C1B.html     Hyper-v https://technet.microsoft.com/en-ca/library/dn282282.aspx

Jun
4
2015

Apr
23
2015

SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]

Error Screenshot:       Resolution: Open command prompt and execute below command,   mofcomp.exe “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”   Note: to cross verify, ensure that sqlmgmproviderxpsp2up.mof exists as above said location, if you are using SQL 2012 or later, go to appropriate shared folder on C: and update the command and execute   This will show results like below,     Now, SQL Server configuration manager should open fine without any issues.   […]

Mar
27
2015

Tools for Analyzing SQL Server trace files

After validating multiple options to analyze SQL server trace files, I found below tools which can help achieve required results, hope it helps someone looking for quick list. There may be multiple other tools available, below are few tested ones from my list.   For basic analysis – Microsoft In-built tool: SQL Server profiler Usage: Login to any server with SQL Server installed, open SSMS and go to Tools > select “SQL Server Profiler” > […]

Dec
29
2014

SQL Server 2005 Reporting Services – Configuration Issues and Fixes

While dealing with a SQL Server 2005 Reporting configuration, faced multiple issues, below is list of issues and applied fixes along with some useful link to redirect in case freshly setting up SSRS.   Main issue which arises is Authentication, SSRS 2005 authentication is handled via IIS manager, and there are multiple options available for e.g. Integrated Windows authentication, Basic authentication, Anonymous Authentication. Based on security requirement one of these can be setup, easiest one […]

Pages:«1234567...16»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: