Speaking at the SQLServerGeeks Annual Summit 2016

I will speaking at the SQL Server Geeks Annual Summit (#SSGAS2016) which is Asia’s Premier Data & Analytics Conference taking place on 11-13 August in Bangalore, India. SQLServerGeeks Annual Summit 2016 is a full 3-day conference with more than 100 breakout sessions and deep dive pre-con sessions on SQL Server, BI & Analytics, Cloud, Big Data,…

0

Stretch your database onto the cloud

I recently delivered an online webinar on one of the new features of SQL Server 2016 – Stretch Database. This was the first session of the webinar series organized by SQL Server Delhi NCR Community PASS Chapter. There was a good turnout of SQL enthusiasts for the session. This being one of the new features in the…

0

Powershell Script to get the last SQL Server restart Time

I wrote this powershell script to find out the last SQL Server Restart times from a batch of servers in an excel sheet and output the results in an excel. The script also takes care of unreachable servers and prints a message that it could not be connected. Although this is a simple script, the…

2

Certificates not visible in Server Certificates console of IIS 7/IIS 8 Manager

You are planning to deploy SSL certificate for your website. You go ahead and get the required certificates from the Certificate Authority (CA) and install it in the Local Machine store via Certificate Manager. Next, you go to Server Certificate feature to check for the installed certificate before you can bind the certificate with the…

2

Troubleshooting Null Reference Exceptions in live ASP.NET applications

This post is more developer centric than for administrators but as the industry moves towards DevOps both worlds are merging and is becoming seamless hence the information in this blog could be helpful to both sides. In my day to day work, I do a lot of troubleshooting on the IIS Admin side but while…

0

Case of Transaction Log backups not getting restored

I got a call from a DBA late night waking me up from deep slumber. They were restoring a critical database from backup and were getting the below error –   Msg 3013, Level 16, State 1, Line 2 RESTORE LOG is terminating abnormally. Msg 3441, Level 17, State 1, Line 2 During startup of…

0

Files not getting uploaded using Web service

The other day, a web application developer contacted me and said that he was not able to upload files to the web server. He was using a web service to have the files uploaded to the application server and he was getting the below error – The HTTP request was forbidden with client authentication scheme…

0

Oh, not again! SQL Server Service is not starting…

The other day I came across a very common but intriguing scenario of SQL Server service NOT starting. Initially when I came across this issue, I felt that this would not take much of my time but interestingly it did not turn out as I thought! This was actually the SQL Server resource which was…

0