Sometimes we need simple query which can do the task, then complicated solution. Here is a simple query which list size of the table in MB with Row Counts. I often run at my customer understand how many different tables they have and what is the row counts as well as the size of the each table.
SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?
Question: How to Find Row Count of Every Table in Database Efficiently?
SQL SERVER – How to Change Database Compatibility Level?
After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
SQL SERVER – How to Protect Your Database from Ransomware?
In the last month, I have received calls from quite a few of my customers about Ransomware. Particularly this weekend it has been very busy with over 8 customers had issues with Ransomware. However, we were lucky enough to have proper database backups and pre-cautions in the place and hence we were able to recover quickly and without downtime. Today, I decided to write up small notes for everyone who wants to protect their database from Ransomware.
SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
Recently I got a message on Skype about SSMS.
Hi Pinal, Need quick suggestion. I am unable to find ssms.exe after installation of SQL Server. Do you know how I can install it?
Initially I thought that since SQL Server 2016 doesn’t come with SQL Server Management Studio, this would be an expected behavior. So, I shared my blog to him.
SQL SERVER – Unable to See Tables (Objects) in SSMS
Once I was thrown into an interesting situation where a client told me that he can see the data from the table but not the table. I asked him to elaborate more and he sent me below screenshots where he was unable to see the table in SSMS.
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will see a powershell script for Removing Old SQL Database Backup Files from Azure Storage.