Browsing articles tagged with " microsoft"
Mar
5
2012

SQL Azure – What is missing?

I was reading few articles around Microsoft’s cloud database SQL Azure and found an interesting article Five things in SQL Server not in SQL Azure Below are those five features, Data encryption Physical SQL Server used TDE for data encryption, if your application depends on TDE then you need to find a workaround or implement encryption logic within application, else need to wait for Microsoft to include TDE in Azure in future Full-text indexing and […]

Sep
30
2011

SuperSocket info: (SpnRegister): Error 8344 SuperSocket Info: (SPNRegister) : Error 1355 SuperSocket info: SpnUnRegister() : Error 8344

Several times when you open Windows event log you may find some supoer socket related errors for SQL server, you may be amused that everything is working fine then why such errors, microsoft has provided a very good article on such issues, this error occur when you have configured SQL services to run under domain service account. Please find article review below, Error message/Symptoms: When SQL Server starts on a computer that is running Microsoft […]

Aug
16
2011

My first SQL 2008 error encounter – SQL 2008 Cache File Relocation

Today while debugging a C: drive disk space issue found that in certain service account location C:\Users\\AppData\Local\Temp there are several “*.CACHE” files. They come named as follows: “machine-name_instance.SQL-Server-name_{49268954-4FD4-4EB6-AA04-CD59D9BB5714}_#.cache” where: “machine-name” is the server’s Windows computer name; “instance.SQL-Server-name” is the MS SQL Server 2008 server and instance name; “#” is some unique 1-2 digit identifier. these were created by Data collector functionality of SQL server 2008, when you do not specify specified cache file patch in […]

Jul
24
2011

Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed!

While investigating a cluster resource offline issue, came across following three errors in windows system event log, cluster log and SQL error log respectively, Error message 1 Source: ClusSvc Category: Failover Mgr Type: Error Event ID: 1069 User: N/A Computer: < Computer Name > Description: Cluster resource ‘SQL Server ()’ in Resource Group ‘‘ failed. Error message 2 Error in the Cluster log file, SQL Server < SQLServer >: [sqsrvres] Unable to read the ‘VirtualServerName’ […]

Subscribe to this blog via Email

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

Join 34 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: