Moving to a cloud-based world is inevitable, it is something we need to learn soon. Ever since SQL Server 2014 has been released, the concept of uploading your backups to Blobs with Windows Azure has been around. In reality, performing a backup or restore operations with SQL Server 2012 SP1 CU4 and later requires no additional tools actually, and be done with either T-SQL or SSMS. This blog describes how to perform backup operations with T-SQL. This will be part of a series of blogs to come in the future. Let me walk through the initial steps.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question. He was interested in knowing how we can have…
Read MoreInterview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?
You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at Question:Â What is Included Column Index? Answer:Â In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key…
Read More
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
One of the blog reader sent me the below mail. I always find that using linked server have been of concern and trouble at a number of places. So when the mail landed – well I was not surprised that there was a problem. It is common and hence the…
Read MoreSQL SERVER – What Does WHERE 1=1 Mean in the Code?
One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?” Well. You have seen people using it when they dynamically construct WHERE condition based on the input values. Let us create this dataset CREATE TABLE #t (emp_name VARCHAR(100), experience…
Read MoreSQL SERVER – What is Windows Internal Database Edition?
The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before. This blog post today is something on the similar…
Read MoreSQL SERVER – Fix: SQL Server CPU Schedulers Offline
Performance troubleshooting are some of the most common things I get to see as part this blog. A number of you keep sending me interesting mails that keep me up-to-date on my learnings. Yes, it is tough to know everything, but at the same time, it is almost impossible to…
Read More