One of my client reported an issue where they were running low on free disk space on the drive where they have file-stream files. They are one of a heavy user of filestream feature as compare to any of my previous clients. As per their observation, the filestream disk space was getting released very slow after deleting the records in database tables using this feature.
SQL SERVER – SQL Vulnerability Assessment – Security Analysis
Microsoft has recently announced a very interesting feature for security of your SQL Server. I really loved this new feature – SQL Vulnerability Assessment. Unlike most of the other V1 features which MS releases, this time I really liked this particular feature. This feature not only provides the assessments but also the solutions.
SQL SERVER – How to Restart SQL Azure Database?
I have said this many time earlier at various forums and I can still say that – “with my current consulting work, I am learning at least one new thing every day.” This is one of the reason why I love my work! In this blog I am going to share an interesting fact which was shared with me by my customer – how to restart SQL Azure database?
How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154
Question: How to List Queries With Memory Grant and Execution Plan?
SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint
Earlier I wrote a blog about DBA doing detective work. SQL SERVER – Why We have an Audit, Trace in DATA Folder? What are These Files?. Now today there is another similar situation where the account is added automatically in SQL Server used by SharePoint.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
People generally ask me; how do I manage to find a blog topic for every day blogging? And my answer is – “Connect yourself to the ground, try to help people with the basics, have open eyes & ears and promise yourself to learn one new thing every day”. If one can achieve these, every day blogging is easier. As a part of my consulting, I was helping a client to run some scripts and while testing, I learned something new. In this blog, we would learn about cause and solution of the error, the local device name is already in use.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
While trying to create linked server, sometimes there are errors. One of the error is below which is related to TCP Provider.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.