We are so used to taking backups and it can sometimes give us new experiences. One of the common messages I see are around taking backups on a share. If you have found this blog while searching for error message then you may want to look at below blogs as well if you are NOT dealing with mapped drive.
SQL SERVER – Marking Filegroup as ReadOnly with SQL Server
My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and they wanted to know how this can be done. This blog post is in continuation to…
Read MoreSQL SERVER – Interesting Observation with Currency Symbols
The currency symbols like $ and £ are implicitly treated as money value in SQL Server If you run the following code SELECT $ SELECT £ You can see that both of the above statements return the value 0.00 It is also possible to use them in arithmetic calculations SELECT $+5 returns 5.00…
Read MoreInterview Question of the Week #011 – Script to Convert List to Table and Table to List
Now today’s interview question is really more of daily routine task for many of the developer. 11 years ago, when I went to my very first interview call. My interview was scheduled at 6 PM in one of the very well known corporation. The corporation was known for its first…
Read MoreSQL SERVER – SCRIPT – SQL Listening on Dynamic Port?
With every release of SQL Server, sometimes I need to revisit some of the old blogs to see how they have enhanced. This learning experience is an ongoing process and the best way I learn is by doing a search on the blog from time to time. Long ago I…
Read MoreSQL SERVER – Interesting Function AGENT_DATETIME
One in a while I come across such interesting side of SQL Server that it even surprises me. Just the other day I came across function AGENT_DATETIME. I had never used it before and now I just found usage example of the same. There can be several methods to convert…
Read MoreSQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071
[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…
Read MoreSQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction
In a recent Usergroup meet that I attended someone asked me this simple yet interesting question about how transactions work and is there any concept like nested transactions inside SQL Server. Though I have talked about this in the past, thought it would be worth revisiting this concept to drive…
Read More
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
SQL SERVER – How to Add User Across Databases
In this era of standards, many organizations want to be using some of the cutting edge technologies in their organizations. In many of these interactions I was lucky enough to meet few DBA’s who give me interesting challenges to meet within their organizations. I still vividly remember sharing a script…
Read More