With schools starting for my daughter, I rarely get involved in her daily routine activity. But there is one thing that I don’t try to miss – the parents-teachers meet. Sometimes it is not about the report card on how my daughter faired against the rest in the class but it is more than that. I am curious to understand how she behaves in the class, how she makes friends in class, how her extra-curricular activities are, is she disciplined overall etc. Those are key attributes and traits I am looking at getting as feedback from the teachers in that hour of interactions. Let us learn about Dormant Sessions in this blog post.
Developer’s Life – Every Developer is a Wonder Woman
We have focused a lot lately on this “superhero series.” I love fantasy books and movies, and I feel like there is a lot to be learned from them. As I am writing this series, though, I have noticed that every super hero I write about is a man. So…
Read MoreMySQL – How to Format Date in MySQL with DATE_FORMAT()
MySQL supports formatting the datetime values into a different formats using DATE_FORMAT() function. This function accepts date/datetime values as a first parameter and returns into a specific format defined as a second parameter. Let us explore this with the following examples which are self-explanatory Define a DATETIME variable SET @date:='2014-06-16…
Read More
SQL SERVER – Free intellisense add-in for SSMS
This article shows how to use ApexSQL Complete, a free intellisense add-in. You can download ApexSQL Complete, and play along through the article.
SQL SERVER – Beginning Contained Databases – Notes from the Field #037
[Note from Pinal]: This is a new episode of Notes from the Fields series. Login and Users are very confused concept. Just yesterday I wrote about a difference between Login and User. In Latest version of SQL Server now we can also have a User without Login. This concept is not…
Read More
SQL SERVER – Difference Between SQL Login and SQL User – SQL in Sixty Seconds #070
“What is the difference between SQL Login and SQL User in SQL Server?”
SQL SERVER – SSMS: Memory Consumption Report
The next in line in this series of reports is the “ Memory Consumption ” Report from SQL Server Management Studio. This is a goldmine of a report in my humble opinion and lesser respected. When I used to be consulted or land into performance tuning exercises for customers in the past, there is one question that gets repeated and echoed every now and then – “My SQL Server is eating away my RAM and it is not releasing it back even in non-peak hours”.
SQL SERVER – SSMS: Scheduler Health Report
Have you ever been to a music concert? It is the most humbling experience one can get as a music lover. The live music with hundreds of musicians in one stage brings goosebumps with the very thought. I have always been fascinated and wanted to experience this once in a…
Read MoreDeveloper’s Life – Every Developer is a Harry Potter
Harry Potter might not be a superhero in the traditional sense, but I believe he still has a lot to teach us and show us about life as a developer. If you have been living under a rock for the last 17 years, you might not know that Harry Potter…
Read MoreMySQL – How INSERT() Function Works for MySQL
You know there is an INSERT statement which is used to add data to a table. But did you know that there is an INSERT function which will replace certain characters within a string? INSERT() function in MySQL is used to insert a substring at the specified position up to…
Read More