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.
SQL SERVER – Fix Error Msg 10794, Level 16 – The operation ‘CREATE INDEX’ is not supported with memory optimized tables.
Whenever I write something as a new concept, I do see people reading the blog do give it a try. Many a times I get queries that the script didn’t work for them after they learnt the concepts about memory optimized tables. The blog I wrote on how In Memory OLTP was supporting ColumnStore – read it: SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables
How Many Foreign Key Can You Have on A Single Table? – Interview Question of the Week #096
Question: How Many Foreign Key Can You Have on A Single Table?
I was asked above question in my recent SQLPASS presentations. I quickly answered that it is 253. However, after I returned home when I searched a bit more, I realized that my answer is not complete, hence this blog post.
SQL SERVER – Cannot Show Requested Dialog – Property Size is Not Available for Database
Freelancing gives me a lot of opportunity to see issues which I have not seen earlier. Learning never stops for me and I love sharing what I learn every day. Let us learn about how to fix the error Property Size is Not Available for Database.
SQL SERVER – Unable to Attach Database – File Activation Failure – The Log Cannot be Rebuilt
Once I was in a situation where there was a disaster faced by my client. They lost the drive which was having transaction log file. Since they did not have effective monitoring, they realized that the backup jobs were failing. So essentially they only have MDF files for user databases and they were left with option to rebuild the log. Let us learn about how file activation failure can create an interesting error.
SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables
When SQL Server 2016 was released, there were a number of enhancements that were discussed around how InMemory OLTP removed which were as limitations. I personally saw some real boot to some of the capabilities coming into InMemory OLTP especially around the concept called as Operational Analytics that Microsoft calls in this release. I am going to talk about this concept in my SQLPass session later this month in October but here is a teaser for what I learnt from this concept.
Personal Technology – Expanding to Open Folder Working with Windows 10
We are all hard wired when it comes to doing certain tasks. I have attended tons of sessions at the local SQL Server user group meets and it amazes me every time to what I didn’t know about the tools that I use often. Every time when I attend sessions from my friend Balmukund or others from the community – they show a trick or two using SQL Server Management Studio that makes me rethink how I would be working the very next day using these methods. I think it is part of learning and that is never going to stop. Let us see about tips about Windows 10.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.