As a DBA/Developer, you must have seen below screen lot of times and most of the time you must have hit No. I know it is one of those moments when you want to leave from work and those annoying popup just stops you for that couple of seconds that you don’t want to waste. In reality, I inadvertently press the space bar and it asks for a location to save. Let us see an interesting blog post about SSMS 2016.
SQL SERVER 2016 – Scroll Bar Enhancement in Management Studio (SSMS 2016)
While I am getting ready to play with SQL Server 2016, I am finding fresh look and feel for SQL Server Management Studio. I heard that its uses latest version of visual studio shell. There are many enhancements which I am seeing in SSMS 2016 and today I would talk about Scroll Bar settings. I am sure you are going to miss some of them considering all these are hidden mostly in some options deep within. Be assured for many more blogs on these topics in future too.
Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122
[Note from Pinal]: This is a 122nd episode of Notes from the Field series. This story about Shepherd DBA, Teacher and Mentor. If you know Mike Walsh, he is an amazing person to meet and know. He is a technical expert, but along with that he is a true life coach. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. In this episode of “Hey DBAs” Mike explains one of the most important things any DBAs should learn, which is to say “I Don’t Know”.
SQL SERVER – Computed Column and Conditions with Case Statement
When I do not find anything on my blog, I write a blog post about it, so next time I do not have to recreate the scripts from the beginning. Just another day, I was doing performance tuning for an organization, I had to create a computed column with CASE statement and I suddenly realize that I do not have such a script on my blog so I decided to write a blog post on this subject.
SQL SERVER – What is WRK file in Log Shipping?
Several customers use log shipping for disaster recovery across a remote data center. If you are reading this blog, I would assume that you already know SQL Server log shipping If you don’t, then please go through online resources to read the basics. Here is an interesting fact which I learned recently about the WRK file in log shipping. I know some of these are around as theory, but there is no concrete way to understand the nuances of what these files actually mean.
SQL SERVER 2016 – Enhancements with AlwaysOn Availability Groups – Notes from the Field #121
[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell talks about his thoughts and observation about SQL Server 2016 and enhancements with AlwaysOn Availability Groups. When AlwaysOn was newly introduced, I was not able to catch up with the feature. I just thought it was just one of the subject which will not be developed by Microsoft, however, as the new versions of the SQL Server are now taking this feature to the next level, I am very delighted that I should have not worried at all. Let us see what Mike says in his own words about Enhancements with AlwaysOn Availability Groups.
SQL SERVER – Drive Space Full Due to MDMP Files
If you are a DBA and if you ever hear about drive space full issues on the SQL Server machine, the first thought to come to your mind would be “huge transaction log file”. Recently I have also fallen into the same trap. One of my clients contacted me and informed that they are running out of drive space on C Drive.