Microsoft has earlier released SQL Server 2016 Service Pack 1 (SP1). This particular SP1 is one of the kind service pack and I will say it is a milestone move by Microsoft.
Now with this SQL Server 2016 Service Pack 1, Standard Edition will have many of the features which existed in only in Enterprise Edition. In simple words, now SQL Server 2016 Standard Edition will have many of the exclusive features of SQL Server 2016 Enterprise Edition after installation of SQL Server 2016 Service Pack 1.
When it rains, it pours. In the last few days last few contacts from my customers were for cluster related issues. Once again, the SQL Server resource was not coming online in failover cluster manager. I asked them to check if ERRORLOG is being generated and if yes, share the content. SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location. Let us learn how to fix Unable to Bring Resource Online.
SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. Network Performance
Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This blog originates from one of such conversation regarding incorrect syntax.
Question: How to Find Size of All the Indexes on the Database?
There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
When I wrote the blog around Understanding Database Scalability – Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all by itself. There is no one size fits all when it comes to scalability. We need to understand the fine prints and details of how the application needs are, what are the restrictions, user requirements and much more.
One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster. I always use for error messages, but they said that SQL resource goes to online pending state and after some time, it goes to failed state. Let us learn how to fix the error where data source name not found.
The cloud phenomenon is no more a dream for many, but a reality for several customers I have been working with. Many of my customers are looking for guidance and from time to time I get an opportunity to have some deep constructive discussions. These discussions can range from should I be going to cloud or not, is this app cloud ready, can we do a lift-shift of this application directly to some cloud player etc. Though each of these discussions lead from one point to another, there is a lot of profiling I do with customers. In this blog, I want to talk about a conversation I had with one of my customers who was evaluating cloud for one of his applications. Let us see a Cloud Consulting Pre-Engagement Questionnaire.
Almost all the time, whenever there is a wizard, it’s a human habit to go with the defaults and finally click finish. Once of my client sent below email to me. In this blog post we are going to learn about Added New Node in Windows Cluster and AlwaysOn Availability Databases Stopped Working.