Oct
14
2015

SQL Server to Oracle Linked server error 7303: ORA-12504 listener was not given the service_name in connect_data

101415_1631_SQLServerto1.png

While configuring Linked server to oracle database from SQL server, faced following error,   Error: “ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA” (Microsoft SQL Server Error: 7303)     I did following validation checks to ensure things are in place: Tnsnames.ora – validated that SID is present in tnsnames.ora file which is generally located in C:\Oracle\product\11.2.0\client_1\network\admin\ folder Validate syntax of connection string, it should be in below format, ORA123 = (DESCRIPTION = […]

Sep
18
2015

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

091815_1700_Outlook360L1.png

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

082415_1354_SQLServerTD1.png

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

072415_1344_ShrinkDataf1.png

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

072015_1536_SQLserverse1.png

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

061515_1510_TenStepTech1.png

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

061015_1819_VirtualNuma1.png

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]

042315_1916_SQLServerCo1.png

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

032715_1519_ToolsforAna1.png

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” > […]

Pages:«1234567...15»

Subscribe to this blog via Email

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

Join 457 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2017
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: