(Pinal Dave) 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.

(K. Brian Kelley) I want to get a catalog of all the SQL Server services running on my servers. How might I do this? I don’t want to take a bunch of screenshots of SQL Server Configuration Manager or SQL Server Management Studio. Surely there’s a better way!

(Pinal Dave) The currency symbols like $ and £ are implicitly treated as money value in SQL Server

(Kenneth Fisher) I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column.

(Thomas LaRock) For years I have found myself often needing these three pieces of information with regards to SQL Server:

(Roy Ernest and Surenda Djaoen) Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compar

(Tim Radney) In my previous article on SQL Server Agent Alerts, I provided step-by-step instructions on how to set up and configure SQL Agent alerts for high severity errors 19-25 as well as error 825. In this article, I’m going to discuss these errors in detail, and share what you should do if they

(Nicky van Vroenhoven) Last week I saw Cathrine Wilhelmsen’s (b|t) slides of her session at SQLBits XIV: Tools and Tips: From accidental to efficient DWH developer. If you haven’t watched the session, go scroll through the slide deck at slideshare right away! It was really useful and though I alread

(Chris Webb) This is the first of many posts on the new DAX functions that have appeared in Excel 2016 (for a full list see this post). Today: the ConcatenateX() function.

(Pinal Dave) 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.