I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me talk about my learning from the recent SQL Server Bangalore UG Meet. I was sitting with my SQL friends and there were topics around what one must try some of the new tooling capabilities that SQL Server 2016 has brought to the table. I am always intrigued by some of these conversations as it gets me a different perspective. This is when I saw my good friend Vinod Kumar (MTC Architect) get on stage to show some cool tips for being productive. Let us learn about Hidden SSMS Gem.
SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?
I answer every email I receive in six hours and that is why sometimes I end up working over 18 hours in a day. However, sometimes I receive emails such that makes me wonder, how come I do not know some very simple stuff. Here is for example – today I received email where user asked how to INSERT or SELECT Copyright Special Characters in SQL Server. Trust me, in my early career, I used to know the answer to this, but I was not able to answer the user immediately. After quick googling, I was able to find out the appropriate character string.
SQL SERVER – How to Increase the SSMS Grid Font Size?
SQL Server Management Studio (SSMS) is part of SQL DBAs life. I use it while doing the presentation. If you are sitting in a big room like below, then the guy sitting in the last row may not be able to see it properly. As a conference speaker and trainer, it is very critical for me to make sure that everyone in the room understand and learn from me. Let us learn in this blog post how to increase the SSMS Grid Font Size?
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
I have been playing around with SQL Server 2016 for a while now and it is interesting how some of the things have changed drastically with this release. One of the key things I felt was the ability to have a different cycle for SQL Server Management Studio (a.k.a SSMS) enhancements. Since this is a client tool, I see that Microsoft has gone ahead with updating the tool almost every month now. Let us learn about SSMS Enhancement.
SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encountered
Here is one of the most popular questions: How to overcome (Error 8134) Divide by Zero Error Encountered in SQL Server?
PowerShell – SQL Server Paging of Memory Identification
In one of my recent consultation visits to a customer, there was deep performance related problems. They were unclear to what was happening and what was the actual problem. But these are some of the challenges that I love to take head-on too. In this quest to learn what the problem would be, I used a number of tools and during that time I figured out it was a memory pressure that was creating the problem. Let us learn about SQL Server Paging of Memory Identification.
SQL SERVER – Creating a Copy of Database in Azure SQL DB
Recently I was about to undertake an interesting assignment for one of my clients who pinged me for Performance Tuning exercise. Since this is something I have been doing full time in the past couple of months, I got into the call immediately. Lesser did I know what I was about to get into actually. Since the problem was about SQL Server query performance, I thought it would be the usual routine. Let us learn about how to create a copy of the database in Azure SQL DB.