Recently I was looking around in my virtual machine to find a topic to blog. Within a few minutes, I was having an idea. In this blog we would talk about an interesting feature “Pause SQL Server”. As stated via official Microsoft documentation “Pausing the Database Engine service prevents new users from connecting to the Database Engine, but users who are already connected can continue to work until their connections are broken. Use pauses when you want to wait for users to complete the work before you stop the service. This enables them to complete transactions that are in progress”. Let us learn about how to fix the issue when the new connections are not allowed.
SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?
You already know what UNION and UNION ALL operators do. They combine datasets while UNION keeps the distinct data, UNION ALL will retain all the data. You can read more about that over here: SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison. Let us see why does anyone all work, but union produces error in this puzzle.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
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.
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.