Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell. Well, actually dbatools is build using PowerShell scripts and runs under the hood script of PowerShell. The biggest advantage of the PowerShell is that it helps us to do multiple operations like finding the maximum memory of the server.
PowerShell – How to Install dbatools?
One of the most popular questions any PowerShell expert would receive is how to install the most popular dbatools based on Powershell scripts?
SQL SERVER – Script – Transaction Log Backups Based on Growth / Size
While doing a comprehensive health check of the SQL Server, one of the things I check is the backup plan for the production databases. Many times, I have run into a situation where a customer says ” Transaction log file of the database has grown more than expected. I want to know the reason why and how to reclaim space and how to avoid such situations”. Let’s break it down into two parts and then
SQL SERVER – Steps to Migrate Cluster Storage from Old Disks to Newly Attached Disks
One of my clients consulted me for the best and easy method for migrating the Cluster Storage from old to newly attached disks. They wanted to move/reconfigure disks mapped to SQL Server, MSDTC, Quorum.
At present, they were using SQL Server 2014 as a mission-critical database server in a cluster environment. Storage being used was IBM DS 8300. They want to migrate the database from current storage i.e. IBM DS 8300 to new storage IBM DS 8870.
SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events
In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features. This feature can be very much handy when we are changing the compatibility of SQL Server and we want to check what are all the deprecated SQL Server features we are still using in our active code.
SQL SERVER – Identify Version of SQL Server from Backup File
One question I always ask all of my customers before I start Comprehensive Database Performance Health Check is that if they have taken backup of their server. The answer to this question honestly does not matter to me during consultancy I never change anything which brings to the situation where they need to restore the database. However, when I asked this question to my client, they said they have an issue to identify a version of SQL Server from the backup file.
SQL SERVER – Creating Temporary and Global Temporary Stored Procedures
During recent Comprehensive Database Performance Health Check, I had a very interesting situation I encountered where we found a stored procedure which was a root cause of the slowness. What we needed to do is to change the code and test if our new stored procedure is better than previous stored procedure or not. One of the options was to create a new stored procedure by renaming the older stored procedure and keep on testing. However, there was a small risk if we forget to drop the newly created stored procedure there will be junk created in the database. Let us see how we can avoid this situation by creating temporary or global Temporary stored procedures.