Using scripts can be a powerful way to automate things that a GUI will fail in many cases. I was working with a client who wanted to write a PowerShell script that would help him automate his backups. This is a pretty simple requirement that can be easily achieved using SMO as shown below in my scripts. I have been using these scripts for a number of years at various places. Let us see how we can backup every database in SQL Server
MySQL – LEAST and GREATEST Comparison Operators
The biggest challenge which we often face as a database person is to compare the value across multiple columns. Trust me, if there were no comparison operators, we would have never got this task done. MySQL supports many comparison operators like BETWEEN, IN, etc. LEAST and GREATEST is very handy if you want to compare values across many columns.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Just like a week, during a user group meeting I was told to ask questions about why the SELECT 1 /2 gives a different answer then one user is expected. Let us see this question in detail about SELECT One by Two as it can be a great learning for many new beginners.
SQL SERVER – Identifying Page Types
I try to keep the understanding and concepts for learning simple. Because for a strong building one needs to have a solid foundation. The structure’s stability is a function of how well the foundation holds them. Just having a beautiful exterior will not be sufficient. So getting into complex design issues or internals sometimes is not of any use if you didn’t get the basics right. Let us learn about Identifying Page Types in SQL.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server to get the total number of rows affected by the last statement, you can use the system variable @@ROWCOUNT. Similarly, in MySQL you can find it using FOUND_ROWS () function.
SQL SERVER – Backup Randomly Failing with Error 112 (There is not enough space on the disk.)
Solving puzzle is something everyone would love. IHere is the puzzle which they wanted me to solve for Error 112.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
In one of my recent interaction with my client, they were so much impressed with the fact that SQL Server has now introduced the ability to use In Memory OLTP. They said they were interested in implementing the same in their environment for a number of applications. The hardware refresh was due and they were also upgrading a number of their legacy applications which were hosted on SQL Server 2005 to the latest version as that was also due. In this blog post we will learn about InMemory OLTP Migration Assistant.