Facing issues with applying SP2/SP3 for SQL 2008 R2 FCI

One of my clients happened to encounter an issue upgrading the SQL server 2008 R2 instance from SP2 to SP3. We were able to pass the major part of the wizard and at the final Installation Progress bar stage we faced issues and the upgrade failed for us with the below error recorded in the…

0

Troubleshooting SQL Server Upgrade Issues

Recently, one of my partners, were facing issues upgrading SQL server 2008 from Service Pack 2 to Service Pack 3.  On checking the summary.txt in the setup bootstrap logs found the following error information : —————— Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log…

0

Installation of SSDT for BI on SQL 2014

A few days back, I was working with one of our partners who had a requirement of installing SQL Server Data Tools (SSDT) for Business Intelligence on their SQL server 2014 instance. When it comes to the same scenario in SQL 2012, the installation of SSDT is a straight forward procedure by selecting it on…

0

How to PREVENT TRUNCATION of TABLES?

One of my clients’ requirement to prevent the TRUNCATION of tables on the database by their applications led me to the research on this topic. We helped them with the information related to the DELETE of records by configuring SQL server audit where we get the data related to the DELETE operation in the Audit…

0

SSL on SQL – Troubleshooting

It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set to 1, for it to be loaded to the SQL server. Due to the glitches during the creation of the certificate there may be scenarios arising where in this value might not be set to 1. If…

0

SSL on SQL – Foundation

A few days back, I was working with one of our partners who had a requirement of creating a SSL self-signed certificate through MMC console. As we are already aware that it is a complex and a tedious procedure, tried developing a script to ease the task for us. Also found that there were a…

0