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.
SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134
[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 topics is DAX Studio. 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 to become a more effective DAX developer with DAX Studio? Bill was very kind to answer the questions and provides plenty of information about how a novice developer can work with DAX Studio.