I have started blogging on my site long ago and my whole idea was to make script repository so that others can reuse it. Now when I look back, there are many scripts and many solutions which I have written. Personally, I have used many of them. Today I am sharing another script which I have used with one of my clients and it was very useful for me in troubleshooting a strange TempDB log file issue. Let us learn about Monitoring TempDB Space Usage.
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
SQL Server 2016 brought several innovations. One of the most anticipated feature additions was the ability to define foreign keys with InMemory tables. I wrote about this feature earlier on blog at: SQL SERVER 2016 – InMemory OLTP support for Foreign Key.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
Playing around with the new capability of SQL Server 2016 has been a fun journey. Even after a year, the discovery keeps happening every single day that I work with it. When I wrote the post around NULL values getting returned, lesser did I know there have been folks who work on this feature. Let us learn in this blog post about JSON NULL Value Using STRICT Keyword. Do make sure to read the other blog too:
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about the upgrade script mode of SQL Server: SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode
When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107
Question: When was Database Last Backed Up in SQL Server?
SQL SERVER – Understanding JSON Use is Case-Sensitive
The things I get to learn from my daughter is amazing. I think all of us need to constantly explore without any prejudice and set biases. Whenever I get a new toy for some occasion, I see there is at least a half hour of exploration to understand how the toy works and she goes into a whole new world of searching new ways to play. This makes the whole experience worth it. Let us learn about JSON.