I am really having fun working with customers who are pushing the learning barrier in my new consulting role. The more customers I meet; merrier I am because I am getting interesting challenges that push me from the normal comfort zone I am in. Learning is never stopped, but the learning can never be facilitated if we are not in that zone to learn. This customer had a requirement of upgrading to a newer release and in the process was looking at disabling the 15k partitions he had enabled on the DB because this was out-of-box supported in the latest versions. I thought this was important to bring to life am I talking here. In this blog we will learn about Disabling 15000 Partitions.
SQL SERVER – Handling XML Documents – Notes from the Field #125
[Note from Pinal]: This is a 125th episode of Notes from the Field series. Handing XML documents is not an easy task. Trust me till today I see lots of experts struggling when they have to deal with XML. In my early career I used to be scared with the XML as well. Well, now I have proper understanding of the XML documents and I am no longer worried about this subject.
In this episode of the Notes from the Field series database expert Stuart Ainsworth explains about how to work with XML documents.
SQL SERVER – Steps to Migrate Clustered Disk / LUN
This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.
SQL SERVER – Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade
I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes:
PowerShell – Backup SQL Server System Databases
I have been lately writing on powershell and didn’t know there are many more scenarios that can be enabled. I was traveling for a consulting assignment over the weekend for a customer location. Though this exercise was around performance tuning their systems, it was amazing to see that they had some of the basics not done either. In this blog we will be discussing about how to backup SQL Server System Databases.
SQL SERVER – Change Color for System Object Name in Text Editor (SSMS 2016)
You might have seen my earlier posts about SQL Server 2016 management studio. There are a lot of changes which have happened in SSMS area. One of such change which I heard is that SSMS now uses Visual Studio 2015 shell. I am a sort of guy who likes some of the settings to be as they were when I worked with good old SQL 2000 days too. I like the color coding used for ages since I first worked with SQL Server using Enterprise Manager. Here is an example where I personally felt the old style is far more productive than the new default. Let us see how we can change color for the system object name in the text editor.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topic is Tabular Models. I always wanted to learn more and I finally got the opportunity to learn more.
In this episode of the Notes from the Field series I asked SQL Expert Bill Anton a very crucial question – How can we optimize Tabular Models for self service reporting with the help of Summarize By ? Bill was very kind to answer the questions and provides plenty of information about how a novice developer can work with Tabular Models.